第四次作业JDBC基本操作与MVC的理解

我对MVC的理解

Book类

package Model;

public class Book {
	
	private int id;
	private String bookName;
	private int price;
	private String description;
	
//	public Book(int id,String bookName,int price,String description){
//		this.id = id;
//		this.bookName = bookName;
//		this.price = price;
//		this.description = description;
//	}
	
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getBookName() {
		return bookName;
	}
	public void setBookName(String bookName) {
		this.bookName = bookName;
	}
	public int getPrice() {
		return price;
	}
	public void setPrice(int price) {
		this.price = price;
	}
	public String getDescription() {
		return description;
	}
	public void setDescription(String description) {
		this.description = description;
	}
	
	
	public String toString() {
		return "Product [id=" + id + ", name=" + bookName + ", price=" + price + ", description:"+ description+"]";
	}
	

}

测试类

package Servlet;

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

import Dao.BookDao;
import Model.Book;
import common.DButil;

public class BookTest {
	//添加书本
	public static void addBook(Book book){
		Connection conn = DButil.getConn();
		Book bk = new Book();
		String sql = "INSERT INTO `book`(`id`,`bookname`,`price`,`description`) VALUES (?,?,?,?)";
		try{
			if(conn == null){
				System.out.println("add conn is null");
				}
			
				PreparedStatement ps = conn.prepareStatement(sql);
				ps.setLong(1, book.getId());
				ps.setString(2,book.getBookName());
				ps.setLong(3,book.getPrice());
				ps.setString(4, book.getDescription());
				int add =	ps.executeUpdate();
				if(add>0){	
					System.out.println(add);
				}
				else{
					System.out.println(add+"添加失败");
				}
			}
			catch(SQLException e){
				e.printStackTrace();
				System.out.println("添加数据库异常");
				
			}finally{
				DButil.closeConn();
			}
	}
	//通过id删除书本
	public static void Delete(Book book){
		Connection conn = DButil.getConn();
		String sql = "delete from book where id = ?";
		try{
			if(conn == null){
				System.out.println("del conn is null");
			}
			
			PreparedStatement ps = conn.prepareStatement(sql);
			ps.setLong(1, book.getId());
			int del = ps.executeUpdate();
			if(del>0){	
				System.out.println(del);
				}else{
					System.out.println("滴滴删除数据库异常");
				}
			}catch(SQLException e){
				e.printStackTrace();
				System.out.println("数据库操作异常，请稍后重试!");
			}finally{
				DButil.closeConn();
			}	
			
		}
	
	//根据书名查找书本信息
		public static void QueryBook(Book book){
			Connection conn = DButil.getConn();
			String sql = "select * from book where bookname=?";
			Book bk = new Book();
			try{
				if(conn == null){
					System.out.println("sel conn is null");
				}
				PreparedStatement ps = conn.prepareStatement(sql);
				ps.setString(1, book.getBookName());
				ResultSet rs = ps.executeQuery();
				if(rs.next()){
					bk.setId(rs.getInt("id"));
	                bk.setBookName(rs.getString("bookname"));
	                bk.setPrice(rs.getInt("price"));
	                bk.setDescription(rs.getString("description"));
					System.out.println(bk);
				}else{
				}
				}catch(SQLException e){
					e.printStackTrace();
				}finally{
					DButil.closeConn();
				}		
		}
		
		//修改
		public static void UpdateBook(Book book){
			Connection conn = DButil.getConn();
			String sql = "update book set bookname=?,price=?,description=? where id = ?";
			try{
				if(conn == null){
					System.out.println("update conn is null");
				}
					PreparedStatement ps = conn.prepareStatement(sql);
					ps.setLong(4, book.getId());
					ps.setString(1, book.getBookName());
					ps.setLong(2, book.getPrice());
					ps.setString(3, book.getDescription());
					int up = ps.executeUpdate();
					if(up>0){
						System.out.println(up);
						}else{
							System.out.println("滴滴修改数据库异常");
						}
				}catch(SQLException e){
					e.printStackTrace();
				}finally{
					DButil.closeConn();
				}
			}
	
	

	public static void main(String[] args) {
		// TODO 自动生成的方法存根
		Book bk = new Book();
		Book bk2 = new Book();
		bk2.setBookName("数据结构");
		Book bk3 = new Book();
		bk3.setId(7);
		Book bk4 = new Book();
		String eml = "发送时延=数据长度/信道带宽";
		bk4.setId(8);
		bk4.setBookName("计算机网络");
		bk4.setPrice(56);
		bk4.setDescription(eml);
//		Book bk2 = new Book(2,"C++", 48, "我太难了");
//		Book bk3 = new Book(3,"Phyon", 58, "给我爬");
//		Book bk4 = new Book(4,"PHP", 68, "从入门到放弃");
//		Book bk5 = new Book(5,"脱发防治", 88, "从入门到放弃");
		bk.setBookName("火影忍者");
		bk.setId(6);
		bk.setDescription("没有什么是一颗螺旋丸解决不了的，如果有，那就搓一颗更大的！");
		bk.setPrice(66);
		
	//	QueryBook(bk2);
	//	addBook(bk);
	//	Delete(bk3);
		QueryBook(bk2);
		UpdateBook(bk4);
		
		
		
	}

}

表