仓库进销存管理系统(JavaWeb JSP MySQL Servlet SSM SpringBoot Bootstrap)"/>
基于javaweb+jsp的仓库进销存管理系统(JavaWeb JSP MySQL Servlet SSM SpringBoot Bootstrap)
基于javaweb+jsp的仓库进销存管理系统(JavaWeb JSP MySQL Servlet SSM SpringBoot Bootstrap)
JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Bootstrap
基础JSP+Servlet或JSP+SSM(Spring、SpringMVC、MyBatis)框架或JSP+SSM+Maven(pom.xml)框架或SpringBoot…均可
开发工具:eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
<if test ='chukuName != null'>`chuku_name` = #{chukuName},</if><if test ='chukuSuliang != null'>`chuku_suliang` = #{chukuSuliang},</if><if test ='chukuClientname != null'>`chuku_clientname` = #{chukuClientname},</if><if test ='chukuTel != null'>`chuku_tel` = #{chukuTel},</if><if test ='chukuMan != null'>`chuku_man` = #{chukuMan},</if><if test ='chukuText != null'>`chuku_text` = #{chukuText}</if></set>WHERE `id` = #{id}</update><!--获取--><select id="findById" resultMap="BaseResultMap">SELECT <include refid="Base_Column_List" /> FROM `t_chuku` WHERE `id` = #{id}</select><!--列表--><select id="findAllSplit" parameterType="java.util.Map" resultMap="BaseResultMap">SELECT <include refid="Base_Column_List" /> FROM `t_chuku`<where><if test="searchColumn != null and searchColumn != '' and keyword != null and keyword != ''">${searchColumn} LIKE CONCAT('%',#{keyword},'%') AND</if>1=1
<label class="col-sm-3 control-label">货号:</label><div class="col-sm-5"><input type="text" class="form-control" id="rukuNo" name="rukuNo" value="${vo.rukuNo}"></div></div><div class="form-group"><label class="col-sm-3 control-label">采购单号:</label><div class="col-sm-5"><input type="text" class="form-control" id="rukuDingdanhao" name="rukuDingdanhao" value="${vo.rukuDingdanhao}"></div></div><div class="form-group"><label class="col-sm-3 control-label">货物名称:</label><div class="col-sm-5">
import java.io.IOException;
import java.io.Serializable;
import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;@Controller
@RequestMapping
public class ChukuController {@Autowiredprivate ChukuService chukuService;/*** 增加出库** @param response* @param request* @throws IOException
*/
public class Chuku implements Serializable {private Long id;//主键private String chukuHuohao;//货号private String chukuName;//货物名称private String chukuSuliang;//数量private String chukuClientname;//客户名private String chukuTel;//联系方式private String chukuMan;//操作员private String chukuText;//备注public Long getId() {return id;}public void setId(Long id) {this.id = id;
* 根据条件查询入库的列表并跳转回页面** @param response* @param request* @throws IOException*/@RequestMapping("rukuList")public void list(HttpServletResponse response, HttpServletRequest request) throws IOException {this.redirectList(request, response);}/*** 跳转到列表页面** @param request* @param response*/private void redirectList(HttpServletRequest request, HttpServletResponse response) throws IOException {//查询列和关键字String searchColumn = Util.decode(request, "searchColumn");String keyword = Util.decode(request, "keyword");Map<String, Object> params = new HashMap();//用来保存控制层传进来的参数(查询条件)params.put("searchColumn", searchColumn);//要查询的列params.put("keyword", keyword);//查询的关键字Map<String, Object> map = rukuService.list(params);request.getSession().setAttribute("list", map.get("list"));
* 编辑出库** @param response* @param request* @throws IOException*/@RequestMapping("chukuEdit")public void edit(HttpServletResponse response, HttpServletRequest request) throws IOException {Chuku vo = new Chuku();vo.setId(Long.valueOf(Util.decode(request, "id")));vo.setChukuHuohao(Util.decode(request, "chukuHuohao"));vo.setChukuName(Util.decode(request, "chukuName"));vo.setChukuSuliang(Util.decode(request, "chukuSuliang"));vo.setChukuClientname(Util.decode(request, "chukuClientname"));vo.setChukuTel(Util.decode(request, "chukuTel"));vo.setChukuMan(Util.decode(request, "chukuMan"));
</div></div><div class="form-group"><label class="col-sm-3 control-label">操作员:</label><div class="col-sm-5"><input type="text" class="form-control" id="rukuRen" name="rukuRen"></div></div><div class="form-group"><label class="col-sm-3 control-label">备注:</label><div class="col-sm-5"><textarea rows="3" class="form-control" id="rukuText" name="rukuText" placeholder="请输入内容......"></textarea></div></div><div class="form-group">
request.getSession().setAttribute("vo", vo);String to = request.getRequestURI().toLowerCase().contains("get") ? "info" : "edit";//判断是去详情显示页面还是编辑页面response.sendRedirect("ruku_" + to + ".jsp");}/*** 根据条件查询入库的列表并跳转回页面** @param response* @param request* @throws IOException*/@RequestMapping("rukuList")public void list(HttpServletResponse response, HttpServletRequest request) throws IOException {this.redirectList(request, response);}/*** 跳转到列表页面*
alert("采购单号不能为空!");return false;}if (document.getElementById("rukuName").value.trim().length == 0) {alert("货物名称不能为空!");return false;}if (document.getElementById("rukuSuliang").value.trim().length == 0) {alert("数量不能为空!");return false;}if (document.getElementById("rukuTime").value.trim().length == 0) {alert("入库时间不能为空!");return false;}if (document.getElementById("rukuRen").value.trim().length == 0) {alert("操作员不能为空!");return false;}return true;}
</script>
</html>
ImageIO.write(image, "JPEG", os);// 以JPEG格式向客户端发送图形验证码}@RequestMapping("authResetPassword")public void resetPassword(HttpServletResponse response, HttpServletRequest request) throws IOException, ServletException {String msg;User loginUser = (User) request.getSession().getAttribute("loginUser");String oldPassword = Util.decode(request, "oldPassword");if (!loginUser.getPassword().equals(oldPassword)) {msg = "原密码错误!";} else {String newPassword = Util.decode(request, "newPassword");loginUser.setPassword(newPassword);this.userService.update(loginUser);msg = "修改成功!";}request.getSession().setAttribute("alert_msg", msg);request.getRequestDispatcher("reset_password.jsp").forward(request, response);}// 返回一个随机颜色(Color对象)private Color getRandomColor(int minColor, int maxColor) {Random random = new Random();// 保存minColor最大不会超过255
private String servlet;//查询时要请求的接口private String searchColumn;//待模糊查询的列private String keyword;//待模糊查询的关键字//通过pageNum,pageSize,totalRecord计算得来tatalPage和startIndex,构造方法中将pageNum,pageSize,totalRecord获得public PageBean(int pageNum, int totalRecord) {this.pageNum = (pageNum = Math.max(pageNum, 1));this.pageSize = 10;//默认为10this.totalRecord = totalRecord;//totalPage 总页数if (totalRecord % pageSize == 0) {//说明整除,正好每页显示pageSize条数据,没有多余一页要显示少于pageSize条数据的this.totalPage = totalRecord / pageSize;
运行环境
Java≥6、Tomcat≥7.0、MySQL≥5.5
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
技术框架
JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Bootstrap
基础JSP+Servlet或JSP+SSM(Spring、SpringMVC、MyBatis)框架或JSP+SSM+Maven(pom.xml)框架或SpringBoot…均可
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
登录、注册、退出、用户模块、公告模块、出库模块、库存模块、入库模块的增删改查管理
更多推荐
基于javaweb+jsp的仓库进销存管理系统(JavaWeb JSP MySQL Servlet SSM SpringBoot Bootstrap)
发布评论