连接数据库实现图书管理系统

使用JDBC连接MYSQL数据库，实现对图书的浏览，添加，修改，删除功能

index.jsp 浏览图书所有信息，并提供添加，修改和删除图书的超级链接

add.html 添加图书信息的表单页面，表单提交到add.jsp页面

add.jsp 添加图书信息的处理页面，将添加的图书信息插入到数据库，处理完成后提示信息并跳转到index.jsp页面

edit.jsp 修改图书信息的表单页面，该页面显示预修改的图书信息，表单提交到edit_do.jsp页面

edit_do.jsp 修改图书信息的处理页面，将修改的图书信息更新到数据库，处理完成后提示信息并跳转到index.jsp页面

del.jsp 删除图书信息的处理页面，从数据库中删除图书信息，处理完成后提示信息并跳转到index.jsp页面

index.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" import="java.sql.*" %>

  
    
  
  
  
图书管理系统
  
添加图书信息
  
    <%
      Connection connection = null;
      PreparedStatement preparedStatement =null;
      ResultSet resultSet =null;
      try {
        connection = Jdbcutils.getConnection();
        String sql="select * from bookinfo";
        preparedStatement = connection.prepareStatement(sql);
        resultSet = preparedStatement.executeQuery();
        while(resultSet.next()){
          int id=resultSet.getInt(1);


    %>
    
    <%
      }
      } catch (SQLException throwables) {
        throwables.printStackTrace();
      }finally {
        Jdbcutils.close(resultSet,preparedStatement,connection);
      }
    %>
  

  

    
书名
    
作者
    
出版社
    
价格
    
管理
  

      
<%=resultSet.getString("bookname")%>
      
<%=resultSet.getString("author")%>
      
<%=resultSet.getString("press")%>
      
<%=resultSet.getString("price")%>
      

        ">修改 
        ">删除
      
    
  

 add.html

    
    




添加图书信息


    

        
书名：
        

    
    

        
作者：
        

    
    

        
出版社：
        

    
    

        
价格：
        

    
    

        

            
            
        
    

    

add.jsp

<%@ page contentType="text/html;charset=utf-8" language="java" %>


    


<%
    request.setCharacterEncoding("utf-8");
    String bookname=request.getParameter("bookname");
    String author=request.getParameter("author");
    String press=request.getParameter("press");
    String price=request.getParameter("price");
    Connection connection = Jdbcutils.getConnection();
    String sql="insert into bookinfo values(null,?,?,?,?)";
    PreparedStatement preparedStatement = connection.prepareStatement(sql);
    preparedStatement.setString(1,bookname);
    preparedStatement.setString(2,author);
    preparedStatement.setString(3,press);
    preparedStatement.setFloat(4, Float.parseFloat(price));
    int i = preparedStatement.executeUpdate();
    String msg="添加失败，单击确定跳转到图书列表页";
    if(i==1)
        msg="添加成功，单击确定跳转到图书列表页";
    Jdbcutils.close(null,preparedStatement,connection);
%>

<%
    response.setHeader("Refresh","1;url=index.jsp");
%>

edit.jsp

<%@ page contentType="text/html;charset=utf-8" language="java" %>


    



<%
    request.setCharacterEncoding("utf-8");
    String id=request.getParameter("id");
    Connection connection = null;
    PreparedStatement preparedStatement =null;
    ResultSet resultSet =null;
    try {
        connection = Jdbcutils.getConnection();
        String sql="select * from bookinfo where id=?";
        preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setInt(1,Integer.parseInt(id));
        resultSet = preparedStatement.executeQuery();
        if(resultSet.next())
        {
            String bookname=resultSet.getString("bookname");
            String author=resultSet.getString("author");
            String press=resultSet.getString("press");
            float price=resultSet.getFloat("price");

%>
    
修改图书信息
    

        
        

            

                

                    书名：
                
                

                    
                
            
            

                

                    作者：
                
                

                    
                
            
            

                

                    出版社：
                
                

                    
                
            
            

                

                    价格：
                
                

                    
                
            
            

                

                    
                    
                
            

        
    

<%
        }
    } catch (SQLException throwables) {
        throwables.printStackTrace();
    }finally {
        Jdbcutils.close(resultSet,preparedStatement,connection);
    }
%>

edit_do.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    


<%
    request.setCharacterEncoding("utf-8");
    String id=request.getParameter("id");
    String bookname=request.getParameter("bookname");
    String author=request.getParameter("author");
    String press=request.getParameter("press");
    String price=request.getParameter("price");
    
    Connection   connection = Jdbcutils.getConnection();
    String sql="update bookinfo set bookname=?,author=?,press=?,price=? where id=?";
    PreparedStatement preparedStatement = connection.prepareStatement(sql);
    preparedStatement.setString(1,bookname);
    preparedStatement.setString(2,author);
    preparedStatement.setString(3,press);
    preparedStatement.setFloat(4, Float.parseFloat(price));
    preparedStatement.setInt(5,Integer.parseInt(id));
    int i = preparedStatement.executeUpdate();
    String msg="修改失败，单击确定跳转到图书列表页";
    if(i==1)
        msg="修改成功，单击确定跳转到图书列表页";
    Jdbcutils.close(null, preparedStatement, connection);
%>

<%
    response.setHeader("Refresh","1;url=index.jsp");
%>

 del.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    


<%
    String id=request.getParameter("id");
    Connection connection = Jdbcutils.getConnection();
    String sql="delete from bookinfo where id=?";
    PreparedStatement preparedStatement = connection.prepareStatement(sql);
    preparedStatement.setInt(1,Integer.parseInt(id));
    int i = preparedStatement.executeUpdate();
    String msg="删除失败，单击确定跳转到图书列表页";
    if(i==1)
        msg="删除成功，单击确定跳转到图书列表页";
%>
<%
    Jdbcutils.close(null,preparedStatement,connection);
%>

<%
    response.setHeader("Refresh","1;url=index.jsp");
%>