仓库物资管理系统

.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">保&nbsp;&nbsp;&nbsp;存</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">查&nbsp;&nbsp;&nbsp;找</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}">出&nbsp;&nbsp;&nbsp;库</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">修&nbsp;&nbsp;&nbsp;改</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">查&nbsp;&nbsp;&nbsp;询</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>