基于图书管理系统的增

系统功能：主要实现图书的增删改查，我建了四层，如下图所示：

 菜单：

添加图书信息：

管理图书信息：

 

今天主要完成图书信息的添加功能

entity层：

package entity;

public class Book {
    private int id;
    private String bianhao;
    private String bname;
    private String wname;
    private String bhome;
    private int num;
    public void setId(int id) {
        this.id=id;
    }
    public void setBianhao(String bianhao) {
        this.bianhao=bianhao;
    }
    public void setBname(String bname) {
        this.bname=bname;
    }
    public void setWname(String wname) {
        this.wname=wname;
    }
    public void setBhome(String bhome) {
        this.bhome=bhome;
    }
    public void setNum(int num) {
        this.num=num;
    }
    public int getId() {
        return this.id;
    }
    public String getBianhao() {
        return this.bianhao;
    }
    public String getBname() {
        return this.bname;
    }
    public String getWname() {
        return this.wname;
    }
    public String getBhome() {
        return this.bhome;
    }
    public int getNum() {
        return this.num;
    }
    public Book() {}
    public Book(int id,String bianhao,String bname,String wname,String bhome,int num) {
        this.id=id;
        this.bianhao=bianhao;
        this.bname=bname;
        this.wname=wname;
        this.bhome=bhome;
        this.num=num;
    }
    public Book(String bianhao,String bname,String wname,String bhome,int num) {
        this.bianhao=bianhao;
        this.bname=bname;
        this.wname=wname;
        this.bhome=bhome;
        this.num=num;
    }
}

DBUtil层：

package DBUtil;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBUtil {
    
    public static String db_url = "jdbc:mysql://localhost:3306/xuanke?serverTimezone=GMT%2B8&useSSL=false";
    public static String db_user = "root";
    public static String db_pass = "0424wyhhxx";
    
    public static Connection getConn () {
        Connection conn = null;
        
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            conn = DriverManager.getConnection(db_url, db_user, db_pass);
        } catch (Exception e) {
            e.printStackTrace();
        }
        
        return 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();
            }
        }
    }

    public static void main(String[] args) throws SQLException {
        Connection conn = getConn();
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        String sql ="select * from xuanke";
        pstmt = conn.prepareStatement(sql);
        rs = pstmt.executeQuery();
        if(rs.next()){
            System.out.println("成功");
        }else{
            System.out.println("失败");
        }
    }
}

dao层：

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import DBUtil.DBUtil;
import entity.Book;
//添加新书信息
    public boolean addBook(Book stu) {
        Connection conn = DBUtil.getConn();
        PreparedStatement pstmt = null;
        boolean f = false;
        int a = 0;
        try {
            String sql = "insert into Book(bianhao,bname,wname,bhome,num) value(?,?,?,?,?)";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, stu.getBianhao());
            pstmt.setString(2, stu.getBname());
            pstmt.setString(3, stu.getWname());
            pstmt.setString(4, stu.getBhome());
            pstmt.setLong(5, stu.getNum());
            a = pstmt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(pstmt, conn);
        }
        if (a > 0)
            f = true;

        return f;
    }
}

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 dao.Dao;
import entity.Book;

@WebServlet("/Servlet")
public class Servlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
    Dao dao = new Dao();

    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        String method = req.getParameter("method");
        if ("addBook".equals(method)) {
            addBook(req, resp);
        }
    }
private void addBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        String bianhao = req.getParameter("bianhao");
        String bname = req.getParameter("bname");
        String wname = req.getParameter("wname");
        String bhome = req.getParameter("bhome");
        int num = Integer.parseInt(req.getParameter("num"));
        Book book = new Book(bianhao, bname, wname, bhome, num);
        if (dao.addBook(book)) {
            req.setAttribute("book", book);
            req.setAttribute("message", "添加成功");
            req.getRequestDispatcher("addBook.jsp").forward(req, resp);
        } else {
            req.setAttribute("message", "书籍信息重复，请重新输入");
            req.getRequestDispatcher("addBook.jsp").forward(req, resp);
        }
    }
}

添加图书的JSP：

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>添加图书信息</title>
<script>
</script>
</head>
<body>
<%
         Object message = request.getAttribute("message");
         if(message!=null && !"".equals(message)){
     
    %>
         <script type="text/javascript">
              alert("<%=request.getAttribute("message")%>");
         </script>
    <%} %>
  <table align="center" border="0px" cellpadding="10px" cellspacing="10px">
  <form action="Servlet?method=addBook"  method="post"  onsubmit="return check()">
  <tr>
  <td><a href="guanli.jsp">返回菜单</a></td>
  </tr>
   <tr>
    <td>图书编号:</td>
    <td><input type="text" name="bianhao" id="bianhao"></td>
   </tr>
   <tr>
   <td>书名：</td>
   <td><input type="text" name="bname" id="bname"></td>
   </tr>
 
   <tr>
   <td>作者名：</td>
   <td><input type="text" name="wname" id="wname"></td>
   </tr>
    <tr>
     <tr>
   <td>出版社名称：</td>
   <td><input type="text" name="bhome" id="bhome"></td>
   </tr>
    <tr>
     <tr>
   <td>可借阅数量：</td>
   <td><input type="text" name="num" id="num"></td>
   </tr>
    <tr>
    <tr align="center">
    <th colspan="2">
    <input type="submit" value="提交">
    </th>
    </tr>
    </form>
</table>
</body>
</html>

添加图书信息：

数据库添加成功：