库存物资管理系统

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="保存">&nbsp;<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>