库存物资管理系统
package Bin; public class User { private int id; private String name; private String factory; private String xinghao; private String rank; private String number; private String time; private String address; private String people; 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 getFactory() { return factory; } public void setFactory(String factory) { this.factory = factory; } public String getXinghao() { return xinghao; } public void setXinghao(String xinghao) { this.xinghao = xinghao; } public String getRank() { return rank; } public void setRank(String rank) { this.rank = rank; } public String getNumber() { return number; } public void setNumber(String number) { this.number = number; } public String getTime() { return time; } public void setTime(String time) { this.time = time; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public String getPeople() { return people; } public void setPeople(String people) { this.people = people; } }
package Dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import DBUtil.Util; import Bin.User; public class KuDao { /** * 增加 */ public void add(User user) { Connection connection = Util.getConnection(); String sql = "insert into wuzikucun(name,factory,xinghao,rank,number,time,address,people) values (?,?,?,?,?,?,?,?)";//sql语句 PreparedStatement preparedStatement = null; try { preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, user.getName()); preparedStatement.setString(2, user.getFactory()); preparedStatement.setString(3, user.getXinghao()); preparedStatement.setString(4, user.getRank()); preparedStatement.setString(5, user.getNumber()); preparedStatement.setString(6, user.getTime()); preparedStatement.setString(7, user.getAddress()); preparedStatement.setString(8, user.getPeople()); preparedStatement.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } finally { Util.close(preparedStatement); Util.close(connection); } } /** * 删除 */ public void delete (int id) { Connection connection = Util.getConnection(); String sql = "delete from wuzikucun where id = ?"; PreparedStatement preparedStatement = null; try { preparedStatement = connection.prepareStatement(sql); preparedStatement.setInt(1, id); preparedStatement.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); }finally { Util.close(preparedStatement); Util.close(connection); } } /** * 修改 */ public void update(User user,int id) { Connection connection = Util.getConnection(); PreparedStatement preparedStatement = null; String sql = "update wuzikucun set name=?,factory=?,xinghao=?,rank=?,number=?,time=?,address=?,people=? where id = ?"; try { preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, user.getName()); preparedStatement.setString(2, user.getFactory()); preparedStatement.setString(3, user.getXinghao()); preparedStatement.setString(4,user.getRank()); preparedStatement.setString(5, user.getNumber()); preparedStatement.setString(6, user.getTime()); preparedStatement.setString(7, user.getAddress()); preparedStatement.setString(8, user.getPeople()); preparedStatement.setInt(9, id); preparedStatement.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); }finally { Util.close(preparedStatement); Util.close(connection); } } /** * 名称查询 */ public List<User> loadspell(String name) {//根据课程查询信息 Connection connection = Util.getConnection(); String sql = "select * from wuzikucun where name = ?"; PreparedStatement preparedStatement = null; ResultSet resultSet = null; List<User> users = new ArrayList<User>(); User user = null; try { preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, name); resultSet = preparedStatement.executeQuery(); while(resultSet.next()) { user = new User(); user.setName(resultSet.getString("name")); user.setFactory(resultSet.getString("factory")); user.setXinghao(resultSet.getString("xinghao")); user.setRank(resultSet.getString("rank")); user.setNumber(resultSet.getString("number")); user.setTime(resultSet.getString("time")); user.setAddress(resultSet.getString("address")); user.setPeople(resultSet.getString("people")); users.add(user); } } catch (SQLException e) { e.printStackTrace(); }finally { Util.close(resultSet); Util.close(preparedStatement); Util.close(connection); } return users; } /** * 日期 */ public List<User> loadspell1(String time) {//根据课程查询信息 Connection connection = Util.getConnection(); String sql = "select * from kucunwuzi where time = ?"; PreparedStatement preparedStatement = null; ResultSet resultSet = null; List<User> users = new ArrayList<User>(); User user = null; try { preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, time); resultSet = preparedStatement.executeQuery(); while(resultSet.next()) { user = new User(); user.setName(resultSet.getString("name")); user.setFactory(resultSet.getString("factory")); user.setXinghao(resultSet.getString("xinghao")); user.setRank(resultSet.getString("rank")); user.setNumber(resultSet.getString("number")); user.setTime(resultSet.getString("time")); user.setAddress(resultSet.getString("address")); user.setPeople(resultSet.getString("people")); users.add(user); } } catch (SQLException e) { e.printStackTrace(); }finally { Util.close(resultSet); Util.close(preparedStatement); Util.close(connection); } return users; } /** * 全部数据 */ public List<User> load() { Connection connection = Util.getConnection(); String sql = "select * from wuzikucun"; PreparedStatement preparedStatement = null; ResultSet resultSet = null; List<User> users = new ArrayList<User>(); User user = null; try { preparedStatement = connection.prepareStatement(sql); resultSet = preparedStatement.executeQuery(); while(resultSet.next()) { user = new User(); user.setName(resultSet.getString("name")); user.setFactory(resultSet.getString("factory")); user.setXinghao(resultSet.getString("xinghao")); user.setRank(resultSet.getString("rank")); user.setNumber(resultSet.getString("number")); user.setTime(resultSet.getString("time")); user.setAddress(resultSet.getString("address")); user.setPeople(resultSet.getString("people")); user.setId(resultSet.getInt("id")); users.add(user); } } catch (SQLException e) { e.printStackTrace(); }finally { Util.close(resultSet); Util.close(preparedStatement); Util.close(connection); } return users; } }
package DBUtil; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.PreparedStatement; /** * 数据库连接工具 * @author YP */ public class Util { public static String url = "jdbc:mysql://localhost:3306/test"; public static String user = "root"; public static String password = "yuanpeng0"; public static Connection getConnection() { Connection connection = null; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) { e.printStackTrace(); } try { connection = DriverManager.getConnection(url,user,password); //System.out.println("连接成功"); } catch (SQLException e) { e.printStackTrace(); } return connection; } public static void close(Connection connection ) { try { if (connection != null) { connection.close(); } } catch (SQLException e) { e.printStackTrace(); } } public static void close(PreparedStatement preparedStatement ) { try { if (preparedStatement != null) { preparedStatement.close(); } } catch (SQLException e) { e.printStackTrace(); } } public static void close(ResultSet resultSet ) { try { if (resultSet != null) { resultSet.close(); } } catch (SQLException e) { e.printStackTrace(); } } public static void main(String[] args) throws SQLException { Connection conn = getConnection(); PreparedStatement pstmt = null; ResultSet rs = null; String sql ="select * from course"; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); if(rs.next()){ System.out.println("连接成功!"); }else{ System.out.println("不空"); } } }
<%@page import="Bin.User"%> <%@page import="Dao.KuDao"%> <%@ 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>添加</title> </head> <body> <%//接收从客户端传递过来的参数 request.setCharacterEncoding("UTF-8"); String name=request.getParameter("name"); String factory=request.getParameter("factory"); String xinghao=request.getParameter("xinghao"); String rank=request.getParameter("rank"); String number=request.getParameter("number"); String time=request.getParameter("time"); String address=request.getParameter("address"); String people=request.getParameter("people"); if(request.getParameter("id")!=null){ int id=Integer.parseInt(request.getParameter("id")); } //创建数组,存取接收到的值 User user=new User(); user.setName(name); user.setFactory(factory); user.setXinghao(xinghao); user.setRank(rank); user.setNumber(number); user.setTime(time); user.setAddress(address); user.setPeople(people); //调用增加的数据库函数 KuDao dao=new KuDao(); try{ dao.add(user); } catch(Exception e){ } response.sendRedirect("index.jsp"); %> </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>添加界面</title> </head> <body> <div align="center"> <h1 style="color: black;">商品入库</h1> <a href="index.jsp">返回主页</a> <form action="add.jsp" method="post" onsubmit="return check()"> <div align="center"> 名称<input type="text" id="name" name="name"> </div> <div align="center"> 厂家<input type="text" id="factory" name="factory"> </div> <div align="center"> 型号<input type="text" id="xinghao" name="xinghao"> </div> <div align="center"> 规格<input type="text" id="rank" name="rank"> </div> <div align="center"> 数量<input type="text" id="number" name="number"> </div> <div align="center"> 日期<input type="text" id="time" name="time"> </div> <div align="center"> 单位<input type="text" id="address" name="address"> </div> <div align="center"> 姓名<input type="text" id="people" name="people"> </div> <table align="center"> <tr><td><input type="submit" value="提交"></td></tr> </table> </form> </div> <script type="text/javascript"> function check() { var name = document.getElementById("name"); var factory = document.getElementById("factory"); var xinghao = document.getElementById("xinghao"); var rank = document.getElementById("rank"); var number = document.getElementById("number"); var time = document.getElementById("time"); var address = document.getElementById("address"); var people = document.getElementById("people"); //非空 if(name.value == '') { alert('名称为空'); name.focus(); return false; } if(factory.value == '') { alert('厂家为空'); factory.focus(); return false; } if(xinghao.value == '') { alert('型号为空'); xinghao.focus(); return false; } if(rank.value == '') { alert('规格为空'); rank.focus(); return false; } if(number.value == '') { alert('数量为空'); number.focus(); return false; } if(time.value == '') { alert('日期为空'); time.focus(); return false; } if(address.value == '') { alert('单位为空'); address.focus(); return false; } if(people.value == '') { alert('姓名为空'); people.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>添加界面</title> </head> <body> <script> alert("操作成功!"); </script> </body> </html>
<%@page import="Dao.KuDao"%> <%@ 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>删除</title> </head> <body> <%request.setCharacterEncoding("UTF-8"); int id=Integer.parseInt(request.getParameter("id")); System.out.print(id); KuDao dao=new KuDao(); dao.delete(id); response.sendRedirect("index.jsp"); %> </body> </html>
<%@page import="Dao.KuDao"%> <%@ 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>删除</title> </head> <body> <%request.setCharacterEncoding("UTF-8"); int id=Integer.parseInt(request.getParameter("id")); System.out.print(id); KuDao dao=new KuDao(); dao.delete(id); response.sendRedirect("index.jsp"); %> </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>主界面</title>
</head>
<body>
<h1 align="center" style="font-family:宋体;font-size:2em;">库存物资管理系统</h1>
<div align="center">
<a href="addlist.jsp">入库单据</a>
</div>
<div align="center">
<a href="deletelist.jsp">删除单据</a>
</div>
<div align="center">
<a href="updateinput.jsp" >修改单据</a>
</div>
<div align="center">
<a href="searchlist.jsp">出库单据</a>
</div>
</body>
</html>
<%@page import="Bin.User"%> <%@page import="java.util.List"%> <%@page import="Dao.KuDao"%> <%@ 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>查询</title> </head> <body> <% request.setCharacterEncoding("UTF-8"); String name=request.getParameter("name"); KuDao dao=new KuDao(); List<User> users=dao.loadspell(name); for(User user1:users) { %> <div align="center"> <h1 style="color: black;">出库单据</h1> <a href="index.jsp">返回主页</a> <table> <tr> <td>名称</td> <td><input type="text" name="name" value="<%=user1.getName()%>"></td> </tr> <tr> <td>厂家</td> <td><input type="text" name="factory" value=<%=user1.getFactory()%>></td> </tr> <tr> <td>型号</td> <td><input type="text" name="xinghao" value=<%=user1.getXinghao()%>></td> </tr> <tr> <td>规格</td> <td><input type="text" name="rank" value=<%=user1.getRank()%>></td> </tr> <tr> <td>数量</td> <td><input type="text" name="number" value=<%=user1.getNumber()%>></td> </tr> <tr> <td>日期</td> <td><input type="text" name="time" value=<%=user1.getTime()%>></td> </tr> <tr> <td>单位</td> <td><input type="text" name="address" value=<%=user1.getAddress()%>></td> </tr> <tr> <td>姓名</td> <td><input type="text" name="people" value=<%=user1.getPeople()%>></td> </tr> </table> </div> <%}%> </body> </html>
<%@page import="Bin.User"%> <%@page import="java.util.List"%> <%@page import="Dao.KuDao"%> <%@ 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>查询</title> </head> <body> <% request.setCharacterEncoding("UTF-8"); String time=request.getParameter("time"); KuDao dao=new KuDao(); List<User> users=dao.loadspell(time); for(User user1:users) { %> <table> <tr> <td>名称</td> <td><input type="text" name="name" value="<%=user1.getName()%>"></td> </tr> <tr> <td>厂家</td> <td><input type="text" name="factory" value=<%=user1.getFactory()%>></td> </tr> <tr> <td>型号</td> <td><input type="text" name="xinghao" value=<%=user1.getXinghao()%>></td> </tr> <tr> <td>规格</td> <td><input type="text" name="rank" value=<%=user1.getRank()%>></td> </tr> <tr> <td>数量</td> <td><input type="text" name="number" value=<%=user1.getNumber()%>></td> </tr> <tr> <td>日期</td> <td><input type="text" name="time" value=<%=user1.getTime()%>></td> </tr> <tr> <td>单位</td> <td><input type="text" name="address" value=<%=user1.getAddress()%>></td> </tr> <tr> <td>姓名</td> <td><input type="text" name="people" value=<%=user1.getPeople()%>></td> </tr> </table> <%} %> </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>查询界面</title>
</head>
<body>
<div align="center">
<h1 style="color: black;">出库单据</h1>
<a href="index.jsp">返回主页</a>
<form action="search.jsp" method="post" action="search.jsp" method="post">
<table>
<tr>
<td>商品名称</td>
<td><input type="text" name="name"></td>
</tr>
<!-- <tr>
<td>商品日期</td>
<td><input type="text" name="time"></td>
</tr> -->
</table>
<input type="submit" value="提交">
</form>
</div>
</body>
</html>
<%@page import="Dao.KuDao"%> <%@page import="Bin.User"%> <%@ 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>修改</title> </head> <body> <%//接收从客户端传递过来的参数 request.setCharacterEncoding("UTF-8"); String name=request.getParameter("name"); String factory=request.getParameter("factory"); String xinghao=request.getParameter("xinghao"); String number=request.getParameter("number"); String rank=request.getParameter("rank"); String time=request.getParameter("time"); String address=request.getParameter("address"); String people=request.getParameter("people"); int id=Integer.parseInt(request.getParameter("id")); //创建数组,存取接收到的值 User user=new User(); user.setName(name); user.setFactory(factory); user.setXinghao(xinghao); user.setRank(rank); user.setNumber(number); user.setTime(time); user.setAddress(address); user.setPeople(people); //调用增加的数据库函数 KuDao dao=new KuDao(); try{ dao.update(user, id); }catch(Exception e){ } response.sendRedirect("index.jsp"); %> </body> </html>
<%@page import="java.util.ArrayList"%> <%@page import="Bin.User"%> <%@page import="java.util.List"%> <%@page import="Dao.KuDao"%> <%@ 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>修改查询</title> </head> <body> <div align="center"> <h1 style="color: black;">修改单据</h1> <a href="index.jsp">返回主页</a> <%KuDao dao=new KuDao(); List<User> user=new ArrayList(); user=dao.load(); for(User user1 : user) { %> <table width="800" border="1" align="center"> <tr> <td><input type="text" size="10" value="<%=user1.getName() %>"></td> <td><input type="text" size="10" value="<%=user1.getFactory() %>"></td> <td><input type="text" size="10" value="<%=user1.getXinghao()%>"></td> <td><input type="text" size="10" value="<%=user1.getRank() %>"></td> <td><input type="text" size="10" value="<%=user1.getNumber() %>"></td> <td><input type="text" size="10" value="<%=user1.getTime() %>"></td> <td><input type="text" size="10" value="<%=user1.getAddress() %>"></td> <td><input type="text" size="10" value="<%=user1.getPeople() %>"></td> <td><a href="updatelist.jsp?id=<%=user1.getId()%>" >修改</a></td> </tr> </table> <% } %> </div> </body> </html>
<%@page import="Dao.KuDao"%> <%@ 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>修改界面</title> </head> <body> <% request.setCharacterEncoding("UTF-8"); int id=Integer.parseInt(request.getParameter("id")); KuDao dao=new KuDao(); %> <div align="center"> <h1 style="color: black;">修改界面</h1> <a href="index.jsp">返回主页</a> <form action="update.jsp" method="post" onsubmit="return check()"> <table> <tr> <td><input type="hidden" size="20" name="id" value=<%=id%>></td> </tr> <tr> <td>名称</td> <td><input type="text" id="name" name="name"></td> </tr> <tr> <td>厂家</td> <td><input type="text" id="factory" name="factory"></td> </tr> <tr> <td>型号</td> <td><input type="text" id="xinghao" name="xinghao"></td> </tr> <tr> <td>规格</td> <td><input type="text" id="rank" name="rank"></td> </tr> <tr> <td>数量</td> <td><input type="text" id="number" name="number"></td> </tr> <tr> <td>日期</td> <td><input type="text" id="time" name="time"></td> </tr> <tr> <td>单位</td> <td><input type="text" id="address" name="address"></td> </tr> <tr> <td>姓名</td> <td><input type="text" id="people" name="people"></td> </tr> </table> <input type="submit" value="保存"> <input type="reset" value="重置"> </form> </div> <script type="text/javascript"> function check() { var name = document.getElementById("name"); var factory = document.getElementById("factory"); var xinghao = document.getElementById("xinghao"); var rank = document.getElementById("rank"); var number = document.getElementById("number"); var time = document.getElementById("time"); var address = document.getElementById("address"); var people = document.getElementById("people"); //非空 if(name.value == '') { alert('名称为空'); name.focus(); return false; } if(factory.value == '') { alert('厂家为空'); factory.focus(); return false; } if(xinghao.value == '') { alert('型号为空'); xinghao.focus(); return false; } if(rank.value == '') { alert('规格为空'); rank.focus(); return false; } if(number.value == '') { alert('数量为空'); number.focus(); return false; } if(time.value == '') { alert('日期为空'); time.focus(); return false; } if(address.value == '') { alert('单位为空'); address.focus(); return false; } if(people.value == '') { alert('姓名为空'); people.focus(); return false; } } </script> </body> </html>