仓库物资管理系统
.java文件
CourseDao.java
package com.hjf.dao; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.hjf.entity.Course; import com.hjf.util.DBUtil; public class CourseDao { /** * 添加 * @param course * @return */ public boolean add(Course kucun) { String sql = "insert into kucun(name, changjia,xinghao,guige,shuliang,riqi,shijian,rukuname,songhuoren) values('" + kucun.getName() + "','" + kucun.getChangjia() + "','" + kucun.getXinghao() + "','" + kucun.getGuige() + "','" + kucun.getShuliang() + "','" + kucun.getRiqi() + "','" + kucun.getShijian() + "','" + kucun.getRukuname() + "','" + kucun.getChukuname() + "''" + kucun.getSonghuoren() + "''" + kucun.getTihuoren() + "')"; Connection conn = DBUtil.getConn(); Statement state = null; boolean f = false; int a = 0; try { state = conn.createStatement(); state.executeUpdate(sql); } catch (Exception e) { e.printStackTrace(); } finally { DBUtil.close(state, conn); } if (a > 0) { f = true; } return f; } /** * 删除 * * @param id * @return */ public boolean delete (int id) { boolean f = false; String sql = "delete from kucun where id='" + id + "'"; Connection conn = DBUtil.getConn(); Statement state = null; int a = 0; try { state = conn.createStatement(); a = state.executeUpdate(sql); } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.close(state, conn); } if (a > 0) { f = true; } return f; } /** * 修改 * @param name * @param pass */ public boolean update(Course kucun) { String sql = "update kucun set name='" + kucun.getName() + "', changjia='" + kucun.getChangjia() + "', xinghao='" + kucun.getXinghao() + "', xinghao='" + kucun.getXinghao() + "', guige='" + kucun.getGuige() + "', shuliang='" + kucun.getShuliang() + "', riqi='" + kucun.getRiqi() + "', shijian='" + kucun.getShijian() + "', rukuname='" + kucun.getRukuname() + "', chukuname='" + kucun.getChukuname() + "', songhuoren='" + kucun.getSonghuoren() + "', tihuoren='" + kucun.getTihuoren() + "' where id='" + kucun.getId() + "'"; Connection conn = DBUtil.getConn(); Statement state = null; boolean f = false; int a = 0; try { state = conn.createStatement(); a = state.executeUpdate(sql); } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.close(state, conn); } if (a > 0) { f = true; } return f; } /** * 验证课程名称是否唯一 * true --- 不唯一 * @param name * @return */ public boolean name(String name) { boolean flag = false; String sql = "select name from kucun where name = '" + name + "'"; Connection conn = DBUtil.getConn(); Statement state = null; ResultSet rs = null; try { state = conn.createStatement(); rs = state.executeQuery(sql); while (rs.next()) { flag = true; } } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return flag; } /** * 通过ID得到类 * @param id * @return */ public Course getCourseById(int id) { String sql = "select * from kucun where id ='" + id + "'"; Connection conn = DBUtil.getConn(); Statement state = null; ResultSet rs = null; Course kucun = null; try { state = conn.createStatement(); rs = state.executeQuery(sql); while (rs.next()) { String name = rs.getString("name"); String changjia = rs.getString("changjia"); String xinghao = rs.getString("xinghao"); String guige = rs.getString("guige"); String shuliang = rs.getString("shuliang"); String riqi = rs.getString("riqi"); String shijian = rs.getString("shijian"); String rukuname = rs.getString("rukuname"); String chukuname = rs.getString("chukuname"); String songhuoren = rs.getString("songhuoren"); String tihuoren = rs.getString("tihuoren"); kucun = new Course(id, name, changjia, xinghao,guige,shuliang,riqi,shijian,rukuname,chukuname,songhuoren,tihuoren); } } catch (Exception e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return kucun; } /** * 通过name得到Course * @param name * @return */ public Course getCourseByName(String name) { String sql = "select * from kucun where name ='" + name + "'"; Connection conn = DBUtil.getConn(); Statement state = null; ResultSet rs = null; Course kucun = null; try { state = conn.createStatement(); rs = state.executeQuery(sql); while (rs.next()) { int id = rs.getInt("id"); String changjia = rs.getString("changjia"); String xinghao = rs.getString("xinghao"); String guige = rs.getString("guige"); String shuliang = rs.getString("shuliang"); String riqi = rs.getString("riqi"); String shijian = rs.getString("shijian"); String rukuname = rs.getString("rukuname"); String chukuname = rs.getString("chukuname"); String songhuoren = rs.getString("songhuoren"); String tihuoren = rs.getString("tihuoren"); kucun = new Course(id, name, changjia, xinghao,guige,shuliang,riqi,shijian,rukuname,chukuname,songhuoren,tihuoren); } } catch (Exception e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return kucun; } /** * 查找 * @param name * @param teacher * @param classroom * @return */ public List<Course> search(String name,String changjia,String xinghao,String guige, String shuliang, String riqi, String shijian, String rukuname, String chukuname, String songhuoren, String tihuoren) { String sql = "select * from kucun where "; if (name != "") { sql += "name like '%" + name + "%'"; } if (changjia != "") { sql += "changjia like '%" + changjia + "%'"; } if (xinghao != "") { sql += "xinghao like '%" + xinghao + "%'"; } if (guige != "") { sql += "guige like '%" + guige + "%'"; } if (shuliang != "") { sql += "shuliang like '%" + shuliang + "%'"; } if (riqi != "") { sql += "riqi like '%" + riqi + "%'"; } if (shijian != "") { sql += "shijian like '%" + shijian + "%'"; } if (rukuname != "") { sql += "rukuname like '%" + rukuname + "%'"; } if (chukuname != "") { sql += "chukuname like '%" + chukuname + "%'"; } if (songhuoren != "") { sql += "songhuoren like '%" + songhuoren + "%'"; } if (tihuoren != "") { sql += "tihuoren like '%" + tihuoren + "%'"; } List<Course> list = new ArrayList<>(); Connection conn = DBUtil.getConn(); Statement state = null; ResultSet rs = null; try { state = conn.createStatement(); rs = state.executeQuery(sql); Course bean = null; while (rs.next()) { int id = rs.getInt("id"); String name2 = rs.getString("name"); String changjia2 = rs.getString("changjia"); String xinghao2 = rs.getString("xinghao"); String guige2 = rs.getString("guige"); String shuliang2 = rs.getString("shuliang"); String riqi2 = rs.getString("riqi"); String shijian2 = rs.getString("shijian"); String rukuname2 = rs.getString("rukuname"); String chukuname2 = rs.getString("chukuname"); String songhuoren2 = rs.getString("songhuoren"); String tihuoren2 = rs.getString("tihuoren"); bean = new Course(id, name2, changjia2, xinghao2,guige2,shuliang2,riqi2,shijian2,rukuname2,chukuname2,songhuoren2,tihuoren2); list.add(bean); } } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return list; } /** * 全部数据 * @param name * @param teacher * @param classroom * @return */ public List<Course> list() { String sql = "select * from kucun"; List<Course> list = new ArrayList<>(); Connection conn = DBUtil.getConn(); Statement state = null; ResultSet rs = null; try { state = conn.createStatement(); rs = state.executeQuery(sql); Course bean = null; while (rs.next()) { int id = rs.getInt("id"); String name2 = rs.getString("name"); String changjia2 = rs.getString("changjia"); String xinghao2 = rs.getString("xinghao"); String guige2 = rs.getString("guige"); String shuliang2 = rs.getString("shuliang"); String riqi2 = rs.getString("riqi"); String shijian2 = rs.getString("shijian"); String rukuname2 = rs.getString("rukuname"); String chukuname2 = rs.getString("chukuname"); String songhuoren2 = rs.getString("songhuoren"); String tihuoren2 = rs.getString("tihuoren"); bean = new Course(id, name2, changjia2, xinghao2,guige2,shuliang2,riqi2,shijian2,rukuname2,chukuname2,songhuoren2,tihuoren2); list.add(bean); } } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return list; } }
Course.java
package com.hjf.entity; public class Course { private int id; private String name; private String changjia; private String xinghao; private String guige; private String shuliang; private String riqi; private String shijian; private String rukuname; private String chukuname; private String songhuoren; private String tihuoren; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getChangjia() { return changjia; } public void setChangjia(String changjia) { this.changjia = changjia; } public String getXinghao() { return xinghao; } public void setXinghao(String xinghao) { this.xinghao = xinghao; } public String getGuige() { return guige; } public void setGuige(String guige) { this.guige = guige; } public String getShuliang() { return shuliang; } public void setShuliang(String shuliang) { this.shuliang = shuliang; } public String getRiqi() { return riqi; } public void setRiqi(String riqi) { this.riqi = riqi; } public String getShijian() { return shijian; } public void setShijian(String shijian) { this.shijian = shijian; } public String getRukuname() { return rukuname; } public void setRukuname(String rukuname) { this.rukuname = rukuname; } public String getChukuname() { return chukuname; } public void setChukuname(String chukuname) { this.chukuname = chukuname; } public String getSonghuoren() { return songhuoren; } public void setSonghuoren(String songhuoren) { this.songhuoren = songhuoren; } public String getTihuoren() { return tihuoren; } public void setTihuoren(String tihuoren) { this.tihuoren = tihuoren; } public Course() {} public Course(int id, String name,String changjia,String xinghao,String guige, String shuliang, String riqi, String shijian, String rukuname, String chukuname, String songhuoren, String tihuoren) { this.id = id; this.name = name; this.changjia = changjia; this.xinghao = xinghao; this.guige = guige; this.shuliang = shuliang; this.riqi = riqi; this.shijian = shijian; this.rukuname = rukuname; this.chukuname = chukuname; this.songhuoren = songhuoren; this.tihuoren = tihuoren; } public Course(String name,String changjia,String xinghao, String guige,String shuliang, String riqi, String shijian, String rukuname, String chukuname, String songhuoren, String tihuoren) { this.name = name; this.changjia = changjia; this.xinghao = xinghao; this.guige = guige; this.shuliang = shuliang; this.riqi = riqi; this.shijian = shijian; this.rukuname = rukuname; this.chukuname = chukuname; this.songhuoren = songhuoren; this.tihuoren = tihuoren; } }
CourseService.java
package com.hjf.service; import java.util.List; import com.hjf.dao.CourseDao; import com.hjf.entity.Course; /** * CourseService * 服务层 * */ public class CourseService { CourseDao cDao = new CourseDao(); /** * 添加 * @param kucun * @return */ public boolean add(Course kucun) { boolean f = false; if(!cDao.name(kucun.getName())) { cDao.add(kucun); f = true; } return f; } /** * 删除 */ public void del(int id) { cDao.delete(id); } /** * 修改 * @return */ public void update(Course kucun) { cDao.update(kucun); } /** * 通过ID得到一个Course * @return */ public Course getCourseById(int id) { return cDao.getCourseById(id); } /** * 通过Name得到一个Course * @return */ public Course getCourseByName(String name) { return cDao.getCourseByName(name); } /** * 查找 * @return */ public List<Course> search(String name,String changjia,String xinghao,String guige, String shuliang, String riqi, String shijian, String rukuname, String chukuname, String songhuoren, String tihuoren) { return cDao.search(name, changjia, xinghao,guige,shuliang,riqi,shijian,rukuname,chukuname,songhuoren,tihuoren); } /** * 全部数据 * @return */ public List<Course> list() { return cDao.list(); } }
CourseServlet.java
package com.hjf.servlet; import java.io.IOException; import java.util.List; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.hjf.entity.Course; import com.hjf.service.CourseService; @WebServlet("/CourseServlet") public class CourseServlet extends HttpServlet { private static final long serialVersionUID = 1L; CourseService service = new CourseService(); /** * 方法选择 */ protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); String method = req.getParameter("method"); if ("add".equals(method)) { add(req, resp); } else if ("del".equals(method)) { del(req, resp); } else if ("update".equals(method)) { update(req, resp); } else if ("search".equals(method)) { search(req, resp); } else if ("getcoursebyid".equals(method)) { getCourseById(req, resp); } else if ("getcoursebyname".equals(method)) { getCourseByName(req, resp); } else if ("list".equals(method)) { list(req, resp); } } /** * 添加 * @param req * @param resp * @throws IOException * @throws ServletException */ private void add(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException { req.setCharacterEncoding("utf-8"); String name = req.getParameter("name"); String changjia = req.getParameter("changjia"); String xinghao = req.getParameter("xinghao"); String guige = req.getParameter("guige"); String shuliang = req.getParameter("shuliang"); String riqi = req.getParameter("riqi"); String shijian = req.getParameter("shijian"); String rukuname = req.getParameter("rukuname"); String chukuname = req.getParameter("chukuname"); String songhuoren = req.getParameter("songhuoren"); String tihuoren = req.getParameter("tihuoren"); Course kucun = new Course(name, changjia, xinghao,guige,shuliang,riqi,shijian,rukuname,chukuname,songhuoren,tihuoren); //添加后消息显示 if(service.add(kucun)) { req.setAttribute("message", "添加成功"); req.getRequestDispatcher("add.jsp").forward(req,resp); } else { req.setAttribute("message", "货物名称重复，请重新录入"); req.getRequestDispatcher("add.jsp").forward(req,resp); } } /** * 全部 * @param req * @param resp * @throws ServletException */ private void list(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException{ req.setCharacterEncoding("utf-8"); List<Course> kucuns = service.list(); req.setAttribute("kucuns", kucuns); req.getRequestDispatcher("list.jsp").forward(req,resp); } /** * 通过ID得到Course * @param req * @param resp * @throws ServletException */ private void getCourseById(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException{ req.setCharacterEncoding("utf-8"); int id = Integer.parseInt(req.getParameter("id")); Course kucun = service.getCourseById(id); req.setAttribute("kucun", kucun); req.getRequestDispatcher("detail2.jsp").forward(req,resp); } /** * 通过名字查找 * 跳转至删除 * @param req * @param resp * @throws IOException * @throws ServletException */ private void getCourseByName(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException{ req.setCharacterEncoding("utf-8"); String name = req.getParameter("name"); Course kucun = service.getCourseByName(name); if(kucun == null) { req.setAttribute("message", "查无此货物！"); req.getRequestDispatcher("del.jsp").forward(req,resp); } else { req.setAttribute("kucun", kucun); req.getRequestDispatcher("detail.jsp").forward(req,resp); } } /** * 删除 * @param req * @param resp * @throws IOException * @throws ServletException */ private void del(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException{ req.setCharacterEncoding("utf-8"); int id = Integer.parseInt(req.getParameter("id")); service.del(id); req.setAttribute("message", "删除成功！"); req.getRequestDispatcher("del.jsp").forward(req,resp); } /** * 修改 * @param req * @param resp * @throws IOException * @throws ServletException */ private void update(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException{ req.setCharacterEncoding("utf-8"); @SuppressWarnings("unused") int id = Integer.parseInt(req.getParameter("id")); String name = req.getParameter("name"); String changjia = req.getParameter("changjia"); String xinghao = req.getParameter("xinghao"); String guige = req.getParameter("guige"); String shuliang = req.getParameter("shuliang"); String riqi = req.getParameter("riqi"); String shijian = req.getParameter("shijian"); String rukuname = req.getParameter("rukuname"); String chukuname = req.getParameter("chukuname"); String songhuoren = req.getParameter("songhuoren"); String tihuoren = req.getParameter("tihuoren"); Course kucun = new Course(name, changjia, xinghao,guige,shuliang,riqi,shijian,rukuname,chukuname,songhuoren,tihuoren); service.update(kucun); req.setAttribute("message", "修改成功"); req.getRequestDispatcher("CourseServlet?method=list").forward(req,resp); } /** * 查找 * @param req * @param resp * @throws ServletException */ private void search(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException{ req.setCharacterEncoding("utf-8"); String name = req.getParameter("name"); String changjia = req.getParameter("changjia"); String xinghao = req.getParameter("xinghao"); String guige = req.getParameter("guige"); String shuliang = req.getParameter("shuliang"); String riqi = req.getParameter("riqi"); String shijian = req.getParameter("shijian"); String rukuname = req.getParameter("rukuname"); String chukuname = req.getParameter("chukuname"); String songhuoren = req.getParameter("songhuoren"); String tihuoren = req.getParameter("tihuoren"); List<Course> kucuns = service.search(name, changjia, xinghao,guige,shuliang,riqi,shijian,rukuname,chukuname,songhuoren,tihuoren); req.setAttribute("kucuns", kucuns); req.getRequestDispatcher("searchlist.jsp").forward(req,resp); } }
DBUtil.java
package com.hjf.util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; /** * 数据库连接工具 * */ public class DBUtil { public static String db_url = "jdbc:mysql://localhost:3306/kucun?serverTimezone=UTC"; public static String db_user = "root"; public static String db_pass = "123456"; public static Connection getConn () { Connection conn = null; try { Class.forName("com.mysql.jdbc.Driver");//加载驱动 conn = DriverManager.getConnection(db_url, db_user, db_pass); } catch (Exception e) { e.printStackTrace(); } return conn; } /** * 关闭连接 * @param state * @param conn */ public static void close (Statement state, Connection conn) { if (state != null) { try { state.close(); } catch (SQLException e) { e.printStackTrace(); } } if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } public static void close (ResultSet rs, Statement state, Connection conn) { if (rs != null) { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } if (state != null) { try { state.close(); } catch (SQLException e) { e.printStackTrace(); } } if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } }
.jsp文件
add.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>填写入库单据</title> <style> .a{ margin-top: 20px; } .b{ font-size: 20px; width: 160px; color: white; background-color: greenyellow; } </style> </head> <body> <% Object message = request.getAttribute("message"); if(message!=null && !"".equals(message)){ %> <script type="text/javascript"> alert("<%=request.getAttribute("message")%>"); </script> <%} %> <div align="center"> <h1 style="color: red;">填写入库单据</h1> <a href="index.jsp">返回主页</a> <form action="CourseServlet?method=add" method="post" onsubmit="return check()"> <div class="a"> 商品名称<input type="text" id="name" name="name"/> </div> <div class="a"> 生产厂家<input type="text" id="changjia" name="changjia" /> </div> <div class="a"> 型号<input type="text" id="xinghao" name="xinghao" /> </div> <div class="a"> 规格<input type="text" id="guige" name="guige" /> </div> <div class="a"> 数量<input type="text" id="shuliang" name="shuliang" /> </div> <div class="a"> 日期<input type="text" id="riqi" name="riqi" /> </div> <div class="a"> 时间<input type="text" id="shijian" name="shijian" /> </div> <div class="a"> 入库单位名称<input type="text" id="rukuname" name="rukuname" /> </div> <div class="a"> 送货人<input type="text" id="songhuoren" name="songhuoren" /> </div> <div class="a"> <button type="submit" class="b">保 存</button> </div> </form> </div> <script type="text/javascript"> function check() { var name = document.getElementById("name");; var changjia = document.getElementById("changjia"); var xinghao = document.getElementById("xinghao"); var guige = document.getElementById("guige"); var shuliang = document.getElementById("shuliang"); var riqi = document.getElementById("riqi"); var shijian = document.getElementById("shijian"); var guige = document.getElementById("guige"); var rukuname = document.getElementById("rukuname"); // var chukuname = document.getElementById("chukuname"); var songhuoren = document.getElementById("songhuoren"); // var tihuoren = document.getElementById("tihuoren"); //非空 if(name.value == '') { alert('商品名称为空'); name.focus(); return false; } if(changjia.value == '') { alert('生产厂家为空'); changjia.focus(); return false; } if(xinghao.value == '') { alert('型号为空'); xinghao.focus(); return false; } if(guige.value == '') { alert('规格为空'); guige.focus(); return false; } if(shuliang.value == '') { alert('数量为空'); shuliang.focus(); return false; } if(riqi.value == '') { alert('日期为空'); riqi.focus(); return false; } if(shijian.value == '') { alert('时间为空'); shijian.focus(); return false; } if(rukuname.value == '') { alert('入库单位名称为空'); rukuname.focus(); return false; } if(songhuoren.value == '') { alert('送货人为空'); songhuoren.focus(); return false; } }
del.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> .a{ margin-top: 20px; } .b{ font-size: 20px; width: 160px; color: white; background-color: greenyellow; } </style> </head> <body> <% Object message = request.getAttribute("message"); if(message!=null && !"".equals(message)){ %> <script type="text/javascript"> alert("<%=request.getAttribute("message")%>"); </script> <%} %> <div align="center"> <h1 style="color: red;">填写出库数据</h1> <a href="index.jsp">返回主页</a> <form action="CourseServlet?method=getcoursebyname" method="post" onsubmit="return check()"> <div class="a"> 商品名称<input type="text" id="name" name="name"/> </div> <div class="a"> 生产厂家<input type="text" id="changjia" name="changjia" /> </div> <div class="a"> 型号<input type="text" id="xinghao" name="xinghao" /> </div> <div class="a"> 规格<input type="text" id="guige" name="guige" /> </div> <div class="a"> 数量<input type="text" id="shuliang" name="shuliang" /> </div> <div class="a"> 日期<input type="text" id="riqi" name="riqi" /> </div> <div class="a"> 时间<input type="text" id="shijian" name="shijian" /> </div> <div class="a"> 出库单位名称<input type="text" id="chukuname" name="chukuname" /> </div> <div class="a"> 提货人<input type="text" id="tihuoren" name="tihuoren" /> </div> <div class="a"> <button type="submit" class="b">查 找</button> </div> </form> </div> <script type="text/javascript"> function check() { var name = document.getElementById("name");; //非空 if(name.value == '') { alert('商品名称为空'); name.focus(); return false; } } </script> </body> </html>
detail.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> .a{ margin-top: 20px; } .b{ font-size: 20px; width: 160px; color: white; background-color: greenyellow; } .tb, td { border: 1px solid black; font-size: 22px; } </style> </head> <body> <div align="center"> <h1 style="color: red;">商品出库</h1> <a href="index.jsp">返回主页</a> <table class="tb"> <tr> <td>商品名称</td> <td>${course.name}</td> </tr> <tr> <td>生产厂家</td> <td>${course.changjia}</td> </tr> <tr> <td>型号</td> <td>${course.xinghao}</td> </tr> <tr> <td>规格</td> <td>${course.guige}</td> </tr> <tr> <td>数量</td> <td>${course.shuliang}</td> </tr> <tr> <td>日期</td> <td>${course.riqi}</td> </tr> <tr> <td>时间</td> <td>${course.shijian}</td> </tr> <tr> <td>入库单位名称</td> <td>${course.rukuname}</td> </tr> <tr> <td>出库单位名称</td> <td>${course.chukuname}</td> </tr> <tr> <td>送货人</td> <td>${course.songhuoren}</td> </tr> <tr> <td>提货人</td> <td>${course.tihuoren}</td> </tr> </table> <div class="a"> <a onclick="return check()" href="CourseServlet?method=del&id=${kucun.id}">出 库</a> </div> </div> <script type="text/javascript"> function check() { if (confirm("真的要出库吗？")){ return true; }else{ return false; } } </script> </body> </html>
detail2.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> .a{ margin-top: 20px; } .b{ font-size: 20px; width: 160px; color: white; background-color: greenyellow; } </style> </head> <body> <% Object message = request.getAttribute("message"); if(message!=null && !"".equals(message)){ %> <script type="text/javascript"> alert("<%=request.getAttribute("message")%>"); </script> <%} %> <div align="center"> <h1 style="color: red;">商品信息修改</h1> <a href="index.jsp">返回主页</a> <form action="CourseServlet?method=update" method="post" onsubmit="return check()"> <div class="a"> 商品名称<input type="text" id="name" name="name"/> </div> <div class="a"> 生产厂家<input type="text" id="changjia" name="changjia" /> </div> <div class="a"> 型号<input type="text" id="xinghao" name="xinghao" /> </div> <div class="a"> 规格<input type="text" id="guige" name="guige" /> </div> <div class="a"> 数量<input type="text" id="shuliang" name="shuliang" /> </div> <div class="a"> 日期<input type="text" id="riqi" name="riqi" /> </div> <div class="a"> 时间<input type="text" id="shijian" name="shijian" /> </div> <div class="a"> 入库单位名称<input type="text" id="rukuname" name="rukuname" /> </div> <div class="a"> 送货人<input type="text" id="songhuoren" name="songhuoren" /> </div> <input type="hidden" id="id" name="id" value="${course.id}"/> <div class="a"> <button type="submit" class="b">修 改</button> </div> </form> </div> <script type="text/javascript"> function check() { var name = document.getElementById("name");; var changjia = document.getElementById("changjia"); var xinghao = document.getElementById("xinghao"); var guige = document.getElementById("guige"); var shuliang = document.getElementById("shuliang"); var riqi = document.getElementById("riqi"); var shijian = document.getElementById("shijian"); var guige = document.getElementById("guige"); var rukuname = document.getElementById("rukuname"); // var chukuname = document.getElementById("chukuname"); var songhuoren = document.getElementById("songhuoren"); // var tihuoren = document.getElementById("tihuoren"); //非空 if(name.value == '') { alert('商品名称为空'); name.focus(); return false; } if(changjia.value == '') { alert('生产厂家为空'); changjia.focus(); return false; } if(xinghao.value == '') { alert('型号为空'); xinghao.focus(); return false; } if(guige.value == '') { alert('规格为空'); guige.focus(); return false; } if(shuliang.value == '') { alert('数量为空'); shuliang.focus(); return false; } if(riqi.value == '') { alert('日期为空'); riqi.focus(); return false; } if(shijian.value == '') { alert('时间为空'); shijian.focus(); return false; } if(rukuname.value == '') { alert('入库单位名称为空'); rukuname.focus(); return false; } if(songhuoren.value == '') { alert('送货人为空'); songhuoren.focus(); return false; } } }
index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>首页</title> <style> .a{ font-size: 26px; margin-top: 20px; } </style> </head> <body> <div align="center"> <h1 style="color: red;">库存物资管理系统</h1> <div class="a"> <a href="add.jsp">货物入库</a> </div> <div class="a"> <a href="CourseServlet?method=list">货物信息查询修改</a> </div> <div class="a"> <a href="del.jsp">货物出库</a> </div> <div class="a"> <a href="search.jsp">货物信息查询</a> </div> </div> </body> </html>
list.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> .a{ margin-top: 20px; } .b{ font-size: 20px; width: 160px; color: white; background-color: greenyellow; } .tb, td { border: 1px solid black; font-size: 22px; } </style> </head> <body> <% Object message = request.getAttribute("message"); if(message!=null && !"".equals(message)){ %> <script type="text/javascript"> alert("<%=request.getAttribute("message")%>"); </script> <%} %> <div align="center"> <h1 style="color: red;">商品信息列表</h1> <a href="index.jsp">返回主页</a> <table class="tb"> <tr> <td>id</td> <td>商品名称</td> <td>生产厂家</td> <td>型号</td> <td>规格</td> <td>数量</td> <td>日期</td> <td>时间</td> <td>入库单位名称</td> <td>出库单位名称</td> <td>送货人</td> <td>提货人</td> <td align="center" colspan="2">操作</td> </tr> <c:forEach items="${kucuns}" var="item"> <tr> <td>${item.id}</td> <td><a>${item.name}</a></td> <td>${item.changjia}</td> <td>${item.xinghao}</td> <td>${item.guige}</td> <td>${item.shuliang}</td> <td>${item.riqi}</td> <td>${item.shijian}</td> <td>${item.rukuname}</td> <td>${item.chukuname}</td> <td>${item.songhuoren}</td> <td>${item.tihuoren}</td> <td><a href="CourseServlet?method=getcoursebyid&id=${item.id}">修改</a></td> </tr> </c:forEach> </table> </div> </body> </html>
search.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> .a{ margin-top: 20px; } .b{ font-size: 20px; width: 160px; color: white; background-color: greenyellow; } </style> </head> <body> <div align="center"> <h1 style="color: red;">查询</h1> <a href="index.jsp">返回主页</a> <form action="CourseServlet?method=search" method="post" onsubmit="return check()"> <div class="a"> 商品名称<input type="text" id="name" name="name"/> </div> <div class="a"> 日期<input type="text" id="riqi" name="riqi" /> </div> <div class="a"> <button type="submit" class="b">查 询</button> </div> </form> </div> <script type="text/javascript"> function check() { var name = document.getElementById("name"); var riqi = document.getElementById("riqi"); //非空 if(name.value == '' && riqi.value == '') { alert('请填写一个条件'); return false; } } </script> </body> </html>
searchlist.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>查询</title> <style> .a{ margin-top: 20px; } .b{ font-size: 20px; width: 160px; color: white; background-color: greenyellow; } .tb, td { border: 1px solid black; font-size: 22px; } </style> </head> <body> <div align="center"> <h1 style="color: red;">商品信息列表</h1> <a href="index.jsp">返回主页</a> <table class="tb"> <tr> <td>id</td> <td>商品名称</td> <td>生产厂家</td> <td>型号</td> <td>规格</td> <td>数量</td> <td>日期</td> <td>时间</td> <td>入库单位名称</td> <td>出库单位名称</td> <td>送货人</td> <td>提货人</td> </tr> <!-- forEach遍历出adminBeans --> <c:forEach items="${kucuns}" var="item" varStatus="status"> <tr> <td>${item.id}</td> <td>${item.name}</td> <td>${item.changjia}</td> <td>${item.xinghao}</td> <td>${item.guige}</td> <td>${item.shuliang}</td> <td>${item.riqi}</td> <td>${item.shijian}</td> <td>${item.rukuname}</td> <td>${item.chukuname}</td> <td>${item.songhuoren}</td> <td>${item.tihuoren}</td> </tr> </c:forEach> </table> </div> </body> </html>
