javaweb入门之图书管理系统

目标

图书管理系统
1.增删改查
2.设计数据库
3.使用servlet+jdbc+el+jstl+jsp

1）设计数据库
id bname author price author date
2）创建web工程，导入相关jar包
3）编写servlet类 并且在web.xml文件中取配置
4）使用jdbc工具类 连接数据库 并且要查询数据库里面的数据 显示在列表界面上
5）完成添加功能 点击添加按钮 去往添加界面 提交数据 保存到数据库 并且显示出来

Book .java

package com.bky.dto;

public class Book {
   

    private Integer bid;

    private String bname;

    private double price;

    private String author;

    private String date;


    public Book(Integer bid, String bname, double price, String author, String date) {
   
        this.bid = bid;
        this.bname = bname;
        this.price = price;
        this.author = author;
        this.date = date;
    }

    public Book() {
   
    }

    public Integer getBid() {
   
        return bid;
    }

    public void setBid(int bid) {
   
        this.bid = bid;
    }

    public String getBname() {
   
        return bname;
    }

    public void setBname(String bname) {
   
        this.bname = bname;
    }

    public double getPrice() {
   
        return price;
    }

    public void setPrice(double price) {
   
        this.price = price;
    }

    public String getAuthor() {
   
        return author;
    }

    public void setAuthor(String author) {
   
        this.author = author;
    }

    public String getDate() {
   
        return date;
    }

    public void setDate(String date) {
   
        this.date = date;
    }

    @Override
    public String toString() {
   
        return "Book{" +
                "bid=" + bid +
                ", bname='" + bname + '\'' +
                ", price=" + price +
                ", author='" + author + '\'' +
                ", date='" + date + '\'' +
                '}';
    }
}

User.java

package com.bky.dto;

public class User {
   

    private Integer id;

    private String userName;

    private String passWord;

    public User(Integer id, String userName, String passWord) {
   
        this.id = id;
        this.userName = userName;
        this.passWord = passWord;
    }

    public User() {
   
    }

    public Integer getId() {
   
        return id;
    }

    public void setId(Integer id) {
   
        this.id = id;
    }

    public String getUserName() {
   
        return userName;
    }

    public void setUserName(String userName) {
   
        this.userName = userName;
    }

    public String getPassWord() {
   
        return passWord;
    }

    public void setPassWord(String passWord) {
   
        this.passWord = passWord;
    }

    @Override
    public String toString() {
   
        return "User{" +
                "id=" + id +
                ", userName='" + userName + '\'' +
                ", passWord='" + passWord + '\'' +
                '}';
    }
}

BooksServlet .java

package com.bky.servlet;

import com.bky.dto.Book;
import com.bky.dto.User;
import com.bky.utils.JDBCUtils;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;

public class BooksServlet extends HttpServlet {
   
    public  ArrayList<Book>  getJDBC(){
   
        Connection connection=null;
        PreparedStatement preparedStatement=null;
        ResultSet resultSet=null;
        ArrayList<Book> books = new ArrayList<Book>();
        try {
   
            //获取数据库连接对象
            connection = JDBCUtils.getConnection();
            System.out.println(connection);
            //获取数据库操作对象 ,预编译sql
            String sql="select  *from t_book";
            preparedStatement = connection.prepareStatement(sql);
            resultSet = preparedStatement.executeQuery();
            while(resultSet!=null&&resultSet.next()){
   

                int bid = resultSet.getInt("id");
                String bname = resultSet.getString("bname");
                Double price = resultSet.getDouble("price");
                String author = resultSet.getString("author");
                String bdate = resultSet.getString("bdate");

                Book book = new Book();
                book.setBid(bid);
                book.setBname(bname);
                book.setPrice(price);
                book.setAuthor(author);
                book.setDate(bdate);

                books.add(book);
            }
        } catch (Exception e) {
   
            e.printStackTrace()