图书管理系统

图书管理系统

BaseDao.java

package com.dao;

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

public class BaseDao {
    
    
    private final String URL = "jdbc:mysql://localhost:3306/bookmanage";
    private final String USERNAME = "root";
    private final String PASSWORD = "root";
    
    //数据库连接字符串
    public Connection connection() {
        Connection conn = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }catch (Exception e) {
            e.printStackTrace();
        }
        return conn;
    }
    
    //ͨ通用增删改操�?
    public int updatesql(String sql,Object[] parm){
        int rowcont = -1;
        PreparedStatement pstmt = null;
        Connection conn = null;
        try {
            conn = this.connection();
            pstmt = conn.prepareStatement(sql);
            int parm1 = parm.length;
            if(parm!=null) {
                for (int i = 0; i < parm1; i++) {
                    pstmt.setObject(i+1, parm[i]);
                }
            }
            rowcont = pstmt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }catch (Exception e) {
            e.printStackTrace();
        }finally {
            this.closeConn(conn, pstmt, null);
        }
        return rowcont;
    }
    
    //关闭服务
    public void closeConn(Connection conn,PreparedStatement pstmt , ResultSet rs) {
        try {
            if(rs != null)rs.close();
            if(pstmt != null)pstmt.close();
            if(conn != null)conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }catch (Exception e) {
            e.printStackTrace();
        }
    }
    
    //ͨ查询封装
    public ResultSet executeQuery(String sql, Object[] parms) {
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {
            conn = this.connection();
            pstmt = conn.prepareStatement(sql);
            if(parms!=null) {
                for (int i = 0; i < parms.length; i++) {
                    pstmt.setObject(i+1, parms[i]);
                }
            }
            rs = pstmt.executeQuery();
        } catch (SQLException e) {
            e.printStackTrace();
        }catch (Exception e) {
            e.printStackTrace();
        }
        return rs;
    }
  
}

BookMannageDao.java

package com.dao;

import java.util.List;

import com.entity.BookManage;

public interface BookManageDao {

    public List<BookManage> selectBookAll();

    public int insertBook(BookManage bm);

    public int deleteBook(int id);
}

BookManageDaolmpl.java

package com.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.entity.BookManage;

public class BookManageDaoImpl extends BaseDao implements BookManageDao{

    @Override
    public List<BookManage> selectBookAll() {
        List<BookManage> list = new ArrayList<BookManage>();
        ResultSet rs = null ; 
        try {
            String sql  = "SELECT b_id,b_name,b_author,b_time,b_type FROM bookmanage";
            rs = this.executeQuery(sql, null);
            while(rs.next()) {
                BookManage bookm = new  BookManage(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getInt(5));
                list.add(bookm);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            this.closeConn(null, null, rs);
        }
        return list;
    }

    @Override
    public int insertBook(BookManage bm) {
        String sql = "INSERT INTO bookmanage(b_name,b_author,b_time,b_type) VALUES(?,?,?,?)";
        Object[] parm = {bm.getName(),bm.getAuthor(),bm.getTime(),bm.getType()};
        return this.updatesql(sql, parm);
    }

    @Override
    public int deleteBook(int id) {
        String sql = "DELETE FROM bookmanage WHERE b_id=?";
        Object[] parm = {id};
        return this.updatesql(sql, parm);
    }

}

BookManage.java

package com.entity;

public class BookManage {
    private int id;
    private String name;
    private String author;
    private String time;
    private int type;
    public BookManage() {
        
    }
    
    public BookManage(String name,String author,String time,int type) {
        this.name = name;
        this.author = author;
        this.time = time ;
        this.type = type;
    }
    
    public BookManage(int id,String name,String author,String time,int type) {
        this.id = id;
        this.name = name;
        this.author = author;
        this.time = time ;
        this.type = type;
    }
    
    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 getAuthor() {
        return author;
    }
    public void setAuthor(String author) {
        this.author = author;
    }
    public String getTime() {
        return time;
    }
    public void setTime(String time) {
        this.time = time;
    }
    public int getType() {
        return type;
    }
    public void setType(int type) {
        this.type = type;
    }
}

BookManageService.java

package com.service;

import java.util.List;

import com.entity.BookManage;

public interface BookManageService {
    
    /**
     * 查询说有图书信息
     * @return
     */
    public List<BookManage> finSelectBookAll();
    
    /**
     * 增加图书信息
     * @param bm
     * @return    true增加成功    false 增加失败
     */
    public boolean finInsertBook(BookManage bm);
    
    /**
     * 删除指定的图书信�?
     * @param id
     * @return    true删除成功    false 删除失败
     */
    public boolean finDeleteBook(int id);
}

InsertServlet.java

package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;

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.entity.BookManage;
import com.service.BookManageService;
import com.service.BookManageServiceImpl;

@WebServlet("/InsertServlet")
public class InsertServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        
        BookManageService bms = new BookManageServiceImpl();
        String name = request.getParameter("name");
        String author = request.getParameter("author");
        String time = request.getParameter("time");
        int type = Integer.parseInt(request.getParameter("type"));
        System.out.println(type);
        BookManage bm = new BookManage(name,author,time,type);
        boolean row = bms.finInsertBook(bm);
        PrintWriter out = response.getWriter();
        if(row == true) {
            out.print("true");
        }else {
            out.print("false");
        }
        out.flush();
        out.close();
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

}

index.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>
<script type="text/javascript" src="js/jquery-1.12.4.js"></script>
<style>
        table,
        table tr th,
        table tr td {
            border: 1px solid #cccccc;
            border-collapse: collapse; 
        }
        table{
             100%;
        }
        .ddd{
        padding-left: 10%;
        padding-right: 10%;    
        height: 600px;
    }
    td{
        padding-left: 60px;
        padding-right: 60px;
    }
    </style>
</head>
<body>
    <div class="ddd">
        <table border="1" id="table">
            <tr>
                <th colspan="6">图书信息</th>
            </tr>
            <tr>
                <th>图书名称</th>
                <th>图书作者</th>
                <th>购买时间</th>
                <th>图书分类</th>
                <th>操作</th>
            </tr>
            <c:forEach var="i" items="${requestScope.bookmanage }">
                <tr>
                    <td hidden id="id2">${i.id }</td>
                    <td>${i.name }</td>
                    <td>${i.author }</td>
                    <td>${i.time }</td>
                    <td>
                    <c:if test="${i.type eq 1 }">计算机/软件</c:if>
                    <c:if test="${i.type eq 2 }">小说/文摘</c:if>
                    <c:if test="${i.type eq 3 }">杂项</c:if>
                    </td>
                    <td><a href="UpdateServlet?bid=${i.id }">删除</a></td>
                </tr>
            </c:forEach>
        </table>
        <h2><a href="insert.jsp">新增图书信息</a></h2>
    </div>
</body>
<script type="text/javascript">
    $(document).ready(function () {
        $("#table tr:even").not("tr:first").css("background","#007FFF");
        $("#table tr:eq(0)").css("background","#007FFF");
        $("#table tr:eq(1)").css("background","#C0C0C0");
    })
    
    $(".shanchu").click(function(){
        event.preventDefault();
        conn = confirm("是否删除");
        if(conn == true){
            var id2 = $("#id2").val();
            $.ajax({
                url:"UpdateServlet",
                type:"post",
                data:{"bid":id2},
                success:function(result){
                    if(result == "true"){
                        alert("删除成功!");
                    }
                }
            })
        }
        
    })
</script>
</html>

insert.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>增加图书信息</title>
<script type="text/javascript" src="js/jquery-1.12.4.js"></script>
<style type="text/css">
        table,
        table tr th,
        table tr td {
            border: 1px solid #cccccc;
            border-collapse: collapse; 
        }
        div{
             300px;
            margin-left: 40%;
        }
        table{
             100%;
        }
        
        #tijiao{
            margin-left: 20%;
        }
</style>
</head>
<body>
<div>
    <form action="UpdateServlet2" method="post" id="form1">
        <table id="table">
            <tr>
                <th colspan="2">会员信息</th>
            </tr>
            <tr id="main">
                <td>图书名称</td>
                <td><input type="text" name="name"/></td>
            </tr>
            <tr>
                <td>图书作者</td>
                <td><input type="text" name="author"/></td>
            </tr>
            <tr>
                <td>购买日期</td>
                <td><input type="text" name="time"/></td>
            </tr>
            <tr>
                <td>图书类别</td>
                <td>
                    <select name="type">
                        <option value="0">选择所属分类</option>
                        <option value="1">计算机/软件</option>
                        <option value="2">小说/文摘</option>
                        <option value="3">杂项</option>
                    </select>
                </td>
            </tr>
            <tr>
                <td colspan="2">
                    <input type="button" value="增加图书" onclick="red()" id="tijiao"/>
                </td>
            </tr>
        </table>
    </form>
</div>
<script type="text/javascript">
    function red(){
        $.ajax({
            url: "InsertServlet",
            type: "post",
            data: $("#form1").serialize(),
            success:function(rasult){
                if("true"==rasult){
                    alert("添加成功！");
                    window.location.href="http://localhost:8080/BookManage";
                }else{
                    alert("添加失败!请重试！");
                }
            }
        })
    }
</script>

</body>
</html>