先说一下我的思路，创建两个数据库表，一个用来记录出库入库情况，另一个用来记录仓库中所有商品的信息，其中包括数量信息，再通过dao层，数据库连接层，Javabean，servlet，以及服务层service完成简单的对商品的增删改查，然后再出库的时候需要检查记录所有商品信息的数据表，检查能否出库，并且出库入库后，记录所有商品信息的数据表中的对应商品的数量也会随之发生改变。
下面是代码：
package connection; import java.sql.*; public class DBUtil { public static String db_url = "jdbc:mysql://localhost:3306/stu?useSSL=false"; 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;//返回了产生的Connection对象 } /** * 关闭连接 * @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(); } } } }
package dao; import connection.*; import sp.*; import xinxi.*; import java.sql.*; import java.util.ArrayList; import java.util.List; public class daop { public static boolean add(xin x) { String s = String.valueOf(x.gete()); String sql = "insert into ku(shangpin,changjia,xinghao,guige,shuliang,riqi,shijian,danwei,xingming,type) values('" + x.geta() + "','" + x.getb() + "','" + x.getc() + "','" + x.getd() +"','" + s +"','" + x.getf() +"','" + x.getg() +"','" + x.geth() +"','" + x.geti() + "','" + x.gettype() +"')"; Connection conn = DBUtil.getConn(); Statement state = null; boolean f = false; int a = 0; try { state = conn.createStatement(); a = state.executeUpdate(sql); } catch (Exception e) { e.printStackTrace(); } finally { DBUtil.close(state, conn); } if (a > 0) { f = true; } return f; } /* * 用商品名称查询 */ public static xin cha1(String name) { xin x=null; String sql = "select * from ku where shangpin ='" + name + "'"; Connection conn = DBUtil.getConn(); Statement state = null; ResultSet rs = null; try { state = conn.createStatement(); rs = state.executeQuery(sql); while (rs.next()) { String a = rs.getString("shangpin"); String b = rs.getString("changjia"); String c = rs.getString("xinghao"); String d = rs.getString("guige"); int e = rs.getInt("shuliang"); String f = rs.getString("riqi"); String g = rs.getString("shijian"); String h = rs.getString("danwei"); String i = rs.getString("xingming"); String type = rs.getString("type"); x=new xin(a,b,c,d,e,f,g,h,i,type); } } catch (Exception e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return x; } /* * 用出入库日期进行查询 */ public static xin cha2(String time) { xin x=null; String sql = "select * from ku where riqi ='" + time + "'"; Connection conn = DBUtil.getConn(); Statement state = null; ResultSet rs = null; try { state = conn.createStatement(); rs = state.executeQuery(sql); while (rs.next()) { String a = rs.getString("shangpin"); String b = rs.getString("changjia"); String c = rs.getString("xinghao"); String d = rs.getString("guige"); int e = rs.getInt("shuliang"); String f = rs.getString("riqi"); String g = rs.getString("shijian"); String h = rs.getString("danwei"); String i = rs.getString("xingming"); String type = rs.getString("type"); x=new xin(a,b,c,d,e,f,g,h,i,type); } } catch (Exception e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return x; } /* * 查询是否有商品 */ public static boolean name(String name) { boolean flag = false; String sql = "select shangpin from liang where shangpin = '" + 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; } /** * 添加 * @param course * @return */ public static boolean add(sp s) { String sql = "insert into liang(shangpin,changjia,xinghao,guige) values('" + s.getming() + "','" + s.getsheng() + "','" + s.getxing() + "','" + s.getgui() + "')"; Connection conn = DBUtil.getConn();//创建connection对象，用来初始化statement对象 Statement state = null;//创建statement对象，用来执行静态sql语句 boolean f = false; int a = 0; try { state = conn.createStatement();//利用connection的creatstatement方法初始化statement对象 a = state.executeUpdate(sql);//执行sql语句，并且返回执行sql语句成功的次数 } catch (Exception e) { e.printStackTrace(); } finally { DBUtil.close(state, conn); } if (a > 0) { f = true; } return f; } /** * 通过name得到Course * @param name * @return */ public static sp findbyname(String name) { String sql = "select * from liang where shangpin ='" + name + "'"; Connection conn = DBUtil.getConn(); Statement state = null; ResultSet rs = null; sp s = null; try { state = conn.createStatement(); rs = state.executeQuery(sql); while (rs.next()) { String a = rs.getString("shangpin"); String b = rs.getString("changjia"); String c = rs.getString("xinghao"); String d = rs.getString("guige"); s=new sp(a,b,c,d); } } catch (Exception e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return s; } /* * 修改 */ public static boolean update(String name,sp s) { String sql = "update liang set shangpin='" + s.getming() + "', changjia='" + s.getsheng() + "', xinghao='" + s.getxing()+ "', guige='" +s.getgui() + "' where shangpin='" + name + "'"; Connection conn = DBUtil.getConn(); Statement state = null; boolean f = false; int a = 0; try { state = conn.createStatement(); a = state.executeUpdate(sql);//执行sql语句，并返回执行成功sql语句条数 } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.close(state, conn); } if (a > 0) { f = true; } return f; } /* * 删除 */ public static boolean delete (String name) { boolean f = false; String sql = "delete from liang where shangpin='" + name + "'"; 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; } /* * 模糊查询 */ public static List<sp> find(String a, String b, String c,String d) { String sql = "select * from classes where "; if (a != "") { sql += "shangpin like '%" + a + "%'"; } if (b != "") { sql += "changjia like '%" + b + "%'"; } if (c != "") { sql += "xinghao like '%" + c + "%'"; } if (d != "") { sql += "guige like '%" + d + "%'"; } List<sp> list = new ArrayList<>(); Connection conn = DBUtil.getConn(); Statement state = null; ResultSet rs = null; try { state = conn.createStatement(); rs = state.executeQuery(sql); sp bean = null; while (rs.next()) { String a1 = rs.getString("shangpin"); String b1 = rs.getString("changjia"); String c1 = rs.getString("xinghao"); String d1 = rs.getString("guige"); bean = new sp(a1,b1,c1,d1); list.add(bean); } } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return list; } }
package ser; import dao.daop; import xinxi.xin; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; @WebServlet("/servlet") public class servlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); String method = req.getParameter("method"); if ("chu".equals(method)) { chu(req, resp); } else if("cha1".equals(method)) { cha1(req,resp); } else if("ru".equals(method)) { ru(req,resp); } else if("cha2".equals(method)) { cha2(req,resp); } } private void chu(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException { req.setCharacterEncoding("utf-8"); String a = req.getParameter("a"); String b = req.getParameter("b"); String c = req.getParameter("c"); String d = req.getParameter("d"); int e=Integer.valueOf(req.getParameter("e")).intValue(); String f = req.getParameter("f"); String g = req.getParameter("g"); String h = req.getParameter("h"); String i = req.getParameter("i"); String type="出库"; xin x=new xin(a,b,c,d,e,f,g,h,i,type); if(daop.name(a)) { daop.add(x); req.setAttribute("message", "出库成功"); req.getRequestDispatcher("chu.jsp").forward(req,resp); } else { req.setAttribute("message", "未查询到该商品"); req.getRequestDispatcher("chu.jsp").forward(req,resp); } } private void ru(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException { req.setCharacterEncoding("utf-8"); String a = req.getParameter("a"); String b = req.getParameter("b"); String c = req.getParameter("c"); String d = req.getParameter("d"); int e=Integer.valueOf(req.getParameter("e")).intValue(); String f = req.getParameter("f"); String g = req.getParameter("g"); String h = req.getParameter("h"); String i = req.getParameter("i"); String type="入库"; xin x=new xin(a,b,c,d,e,f,g,h,i,type); if(daop.name(a)) { daop.add(x); req.setAttribute("message", "入库成功"); req.getRequestDispatcher("ru.jsp").forward(req,resp); } else { req.setAttribute("message", "未查询到该商品"); req.getRequestDispatcher("ru.jsp").forward(req,resp); } } private void cha1(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException { String name=req.getParameter("a"); xin x=daop.cha1(name); if(x==null) { req.setAttribute("message", "未查询到该商品有出入库信息"); req.getRequestDispatcher("shangpin.jsp").forward(req,resp); } else{ req.setAttribute("x", x); req.getRequestDispatcher("show.jsp").forward(req,resp); } } /* * */ private void cha2(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException { String time=req.getParameter("a"); xin x=daop.cha1(time); if(x==null) { req.setAttribute("message", "未查询到该日期有商品出入库信息"); req.getRequestDispatcher("riqi.jsp").forward(req,resp); } else { req.setAttribute("x", x); req.getRequestDispatcher("show.jsp").forward(req,resp); } } }
package Service; import sp.*; import java.util.List; import dao.*; public class service { /* * 添加 */ public boolean add(sp s) { boolean f = false; if(!daop.name(s.getming())) { f=daop.add(s); } return f; } /* * 通过名字进行查找 */ public sp findbyname(String name) { return daop.findbyname(name); } /* * 修改 */ public boolean update(String name,sp s) { return daop.update(name,s); } /* * 删除 */ public void delete(String name) { daop.delete(name); } /* * 模糊查询 */ public List<sp> find(String a,String b,String c,String d) { return daop.find(a,b,c,d); } }
package servlet; import Service.*; import java.io.IOException; import java.util.List; import sp.*; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; @WebServlet("/servlet1") public class servlet1 extends HttpServlet { private static final long serialVersionUID = 1L; protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { // TODO Auto-generated method stub req.setCharacterEncoding("utf-8"); String method = req.getParameter("method"); if ("add".equals(method)) { add(req, resp); } else if("findbynameupdate".equals(method)) { findbynameupdate(req,resp); } else if("findbynamedelete".equals(method)) { findbynamedelete(req,resp); } else if("update".equals(method)) { update(req,resp); } else if("delete".equals(method)) { delete(req,resp); } else if("find".equals(method)) { find(req,resp); } } /* * 下面扩充几个方法 */ /** * 添加 * @param req * @param resp * @throws IOException * @throws ServletException */ private void add(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException { req.setCharacterEncoding("utf-8"); service Service=new service(); String a = req.getParameter("a"); String b = req.getParameter("b"); String c = req.getParameter("c"); String d = req.getParameter("d"); sp s=new sp(a,b,c,d); //添加后消息显示 if(Service.add(s)) { req.setAttribute("message", "添加成功");//setAttribute方法用于将内容保存在对象中，传到下一个页面中 req.getRequestDispatcher("zs.jsp").forward(req,resp);//getRequestDispatcher方法用于进入下一个页面 } else { req.setAttribute("message", "商品名称重复，请重新录入"); req.getRequestDispatcher("zs.jsp").forward(req,resp); } } /** * 通过名字查找 * @param req * @param resp * @throws IOException * @throws ServletException */ private void findbynameupdate(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException{ req.setCharacterEncoding("utf-8"); service Service=new service(); String name = req.getParameter("name"); sp s = Service.findbyname(name); if(s == null) { req.setAttribute("message", "查无此商品！"); req.getRequestDispatcher("gs.jsp").forward(req,resp); } else { req.setAttribute("s", s); req.getRequestDispatcher("gs2.jsp").forward(req,resp); } } private void findbynamedelete(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException{ req.setCharacterEncoding("utf-8"); service Service=new service(); String name = req.getParameter("name"); sp s = Service.findbyname(name); if( s == null) { req.setAttribute("message", "查无此课程！"); req.getRequestDispatcher("ss.jsp").forward(req,resp); } else { req.setAttribute("s", s); req.getRequestDispatcher("ss2.jsp").forward(req,resp); } } /* * 通过课程名称与新得到的课程进行修改课程信息 */ private void update(HttpServletRequest req, HttpServletResponse resp)throws IOException, ServletException{ req.setCharacterEncoding("utf-8"); service Service=new service(); String a = req.getParameter("a"); String b = req.getParameter("b"); String c = req.getParameter("c"); String d = req.getParameter("d"); String name1=req.getParameter("name1"); sp s=new sp(a,b,c,d); if(Service.update(name1, s)){ req.setAttribute("message", "课程信息修改成功"); req.getRequestDispatcher("gs.jsp").forward(req,resp); } else{ req.setAttribute("message", "课程信息修改失败"); req.getRequestDispatcher("gs.jsp").forward(req,resp); } } /* * 通过课程名称删除课程信息 */ private void delete(HttpServletRequest req, HttpServletResponse resp)throws IOException, ServletException{ req.setCharacterEncoding("utf-8"); service Service=new service(); String name = req.getParameter("name"); Service.delete(name); req.setAttribute("message", "课程信息删除成功"); req.getRequestDispatcher("ss.jsp").forward(req,resp); } /* * 模糊查找 */ private void find(HttpServletRequest req, HttpServletResponse resp)throws IOException, ServletException{ req.setCharacterEncoding("utf-8"); service Service=new service(); String a = req.getParameter("a"); String b = req.getParameter("b"); String c = req.getParameter("c"); String d = req.getParameter("d"); List<sp> courses = Service.find(a,b,c,d); req.setAttribute("courses", courses); req.getRequestDispatcher("cs2.jsp").forward(req,resp); } }
package sp; public class sp { String ming; String sheng; String xing; String gui; public String getming() { return ming; } public String getsheng() { return sheng; } public String getxing() { return xing; } public String getgui() { return gui; } public sp(String a,String b,String c,String d) { ming=a; sheng=b; xing=c; gui=d; } }
package xinxi; public class xin { String a; String b; String c; String d; int e; String f; String g; String h; String i; String type; public xin(int e) { this.e=e; } public String geta() { return a; } public String getb() { return b; } public String getc() { return c; } public String getd() { return d; } public int gete() { return e; } public String getf() { return f; } public String getg() { return g; } public String geth() { return h; } public String geti() { return i; } public String gettype() { return type; } public xin(String a,String b,String c,String d,int e,String f,String g,String h,String i,String type) { this.a=a; this.b=b; this.c=c; this.d=d; this.e=e; this.f=f; this.g=g; this.h=h; this.i=i; this.type=type; } }
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<h2>请选择查询方式</h2>
<a href=shangpin.jsp>按照商品名称查询</a>
<a href=riqi.jsp>按照出入库日期查询</a>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Insert title here</title> </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="main.jsp">返回主页</a> <form action="servlet?method=chu" method="post"> <div class="a"> 商品<input type="text" name="a"/> </div> <div class="a"> 厂家<input type="text" name="b" /> </div> <div class="a"> 型号<input type="text" name="c" /> </div> <div class="a"> 规格<input type="text" name="d" /> </div> <div class="a"> 数量<input type="text" name="e" /> </div> <div class="a"> 日期<input type="text" name="f" /> </div> <div class="a"> 时间<input type="text" name="g" /> </div> <div class="a"> 单位<input type="text" name="h" /> </div> <div class="a"> 姓名<input type="text" name="i" /> </div> <div class="a"> <button type="submit" class="b">保 存</button> </div> </form> </div> </body> </html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Insert title here</title> </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="main.jsp">返回主页</a> <form action="stuservlet?method=find" method="post" > <div class="a"> 商品名称<input type="text" name="a"/> </div> <div class="a"> 生产厂家<input type="text" name="b" /> </div> <div class="a"> 型号<input type="text" name="c" /> </div> <div class="a"> 规格<input type="text" name="d" /> </div> <div class="a"> <button type="submit" class="b">查 询</button> </div> </form> </div> </body> </html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Insert title here</title> </head> <body> <% Object message = request.getAttribute("message"); if(message!=null && !"".equals(message)){ %> <script type="text/javascript"> alert("<%=request.getAttribute("message")%>"); </script> <%} %> <h2>修改商品信息</h2> <form action="servlet1?method=findbynameupdate" method="post" onsubmit="return check()"> <a href="main.jsp">返回主页</a> <div class="a"> 商品名称<input type="text" id="name" name="name"/> </div> <div class="a"> <button type="submit" class="b">查 询</button> </div> </form> <script type="text/javascript"> function check() { var name = document.getElementById("name");; //非空 if(name.value == '') { alert('请输入数据'); name.focus();//focus()方法是将输入焦点移至对象上 return false; } } </script> </body>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Insert title here</title> </head> <body> <h3>原商品信息</h3> <form> 商品名称: ${s.ming}<br> 生产厂家:${s.sheng}<br> 型号:${s.xing}<br> 规格:${s.gui}<br> </form> <h3>请输入新的商品信息进行修改</h3> <form action="servlet1?method=update&name1=${s.ming}" method="post" onsubmit="return check()"> <div class="a"> 商品名称<input type="text" id="name" name="a"/> </div> <div class="a"> 生产厂家<input type="text" id="changjia" name="b" /> </div> <div class="a"> 型号<input type="text" id="classroom" name="c" /> </div> <div class="a"> 规格<input type="text" id="classroom1" name="d" /> </div> <div class="a"> <button type="submit" class="b">修 改</button> </div> </form> <script type="text/javascript"> function check() { var name = document.getElementById("name");; var teacher = document.getElementById("teacher"); var classroom = document.getElementById("classroom");//document.getElementById("")用于通过id获取表单中客户输入的值 var classroom1 = document.getElementById("classroom1") //非空 if(name.value == '') { alert('商品名称为空'); name.focus();//focus()方法是将输入焦点移至对象上 return false; } if(teacher.value == '') { alert('生产厂家为空'); teacher.focus(); return false; } if(classroom.value == '') { alert('型号为空'); classroom.focus(); return false; } if(classroom1.value == '') { alert('规格为空'); classroom.focus(); return false; } } </script> </body> </html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<h2>请选择出库，入库或查询记录</h2>
<a href=zs.jsp>增加商品</a><br>
<a href=ss.jsp>删除商品</a><br>
<a href=cs.jsp>查询商品</a><br>
<a href=xs.jsp>修改商品</a><br>
<a href=chu.jsp>出库</a><br>
<a href=ru.jsp>入库</a><br>
<a href=cha.jsp>查询出库入库信息</a><br>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Insert title here</title> </head> <body> <% Object message = request.getAttribute("message"); if(message!=null && !"".equals(message)){ %> <script type="text/javascript"> alert("<%=request.getAttribute("message")%>"); </script> <%} %> <h2>请输入出入库日期进行查询</h2> <form action="servlet?method=cha2" method="post" > <div class="a"> 日期：<input type="text" name="a"/> </div> <div class="a"> <button type="submit" class="b">查 询</button> </div> </form> </body> </html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Insert title here</title> </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="main.jsp">返回主页</a> <form action="servlet?method=chu" method="post" onsubmit="return check()"> <div class="a"> 商品<input type="text" name="a"/> </div> <div class="a"> 厂家<input type="text" name="b" /> </div> <div class="a"> 型号<input type="text" name="c" /> </div> <div class="a"> 规格<input type="text" name="d" /> </div> <div class="a"> 数量<input type="text" name="e" /> </div> <div class="a"> 日期<input type="text" name="f" /> </div> <div class="a"> 时间<input type="text" name="g" /> </div> <div class="a"> 单位<input type="text" name="h" /> </div> <div class="a"> 姓名<input type="text" name="i" /> </div> <div class="a"> <button type="submit" class="b">保 存</button> </div> </form> </div> </body> </html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Insert title here</title> </head> <body> <% Object message = request.getAttribute("message"); if(message!=null && !"".equals(message)){ %> <script type="text/javascript"> alert("<%=request.getAttribute("message")%>"); </script> <%} %> <h2>请输入商品名称进行查询</h2> <form action="servlet?method=cha1" method="post"> <div class="a"> 商品名称：<input type="text" name="a"/> </div> <div class="a"> <button type="submit" class="b">查 询</button> </div> </form> </body> </html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Insert title here</title> </head> <body> <h3>出入库信息</h3> <form> 商品:${x.a}<br> 厂家:${x.b}<br> 型号:${x.c}<br> 规格:${x.d}<br> 数量:${x.e}<br> 日期:${x.f}<br> 时间:${x.g}<br> 单位:${x.h}<br> 姓名:${x.i}<br> 出库与入库：${x.type}<br> </form> </body> </html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Insert title here</title> </head> <body> <% Object message = request.getAttribute("message"); if(message!=null && !"".equals(message)){ %> <script type="text/javascript"> alert("<%=request.getAttribute("message")%>"); </script> <%} %> <h2>请输入课程名称进行删除</h2> <form action="servlet1?method=findbynamedelete" method="post" onsubmit="return check()"> <a href="main.jsp">返回主页</a> <div class="a"> 商品名称<input type="text" id="name" name="name"/> </div> <div class="a"> <button type="submit" class="b">查 询</button> </div> </form> <script type="text/javascript"> function check() { var name = document.getElementById("name");; //非空 if(name.value == '') { alert('请输入数据'); name.focus();//focus()方法是将输入焦点移至对象上 return false; } } </script> </body> </html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Insert title here</title> </head> <body> <h3>原商品信息</h3> <form> 商品名称: ${s.ming}<br> 生产厂家:${s.sheng}<br> 型号:${s.xing}<br> 规格:${s.gui}<br> </form> <a onclick="return check()" href="servlet1?method=delete&name=${s.ming}">删 除</a> <script type="text/javascript"> function check() { if (confirm("真的要删除吗？")){ return true; }else{ return false; } } </script> </body> </html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Insert title here</title> </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="main.jsp">返回主页</a> <form action="servlet1?method=add" method="post"> <div class="a"> 名称<input type="text" name="a"/> </div> <div class="a"> 厂家<input type="text" name="b" /> </div> <div class="a"> 型号<input type="text" name="c" /> </div> <div class="a"> 规格<input type="text" name="d" /> </div> <div class="a"> <button type="submit" class="b">保 存</button> </div> </form> </div> </body> </html>
代码原创，还有很多地方需要完善