简述MVC 书本数据库增删查改操作

黄瑞生117333440127

1.简述MVC

• M:model （模型）:一个功能，用JavaBean实现
• V：View（视图）：用于展示，以及用户交互，使用html等前端技术实现
• C：Controller（控制器）:接受请求，将请求跳转到模型进行处理，模型处理完毕后，再将处理的结果返回给请求处，一般用Servlet实现控制器

2.掌握JDBC的基本操作

首先在Dos窗口使用命令创建一个book表

然后在eclipse创建一个实体类Book类

package com.hrs.entity;

public class Book {
	private int id;
	private String bookName;
	private int price;
	private String description;
	public String  toString() {
		return "id="+id+"bookName="+bookName+"price="+price+"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 Book(int id, String bookName, int price,String description) {
		super();
		this.id = id;
		this.bookName = bookName;
		this.price = price;
		this.description=description;
	}

	public Book() {
		super();
	}


}

创建方法类

方法类中增加方法

package book.ff;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.hrs.entity.*;
import com.mysql.jdbc.Connection;
public class Add {
			public void login(Book book) {
				
				try {
					Class.forName("com.mysql.jdbc.Driver");
				} catch (ClassNotFoundException e) {
					
					e.printStackTrace();
				}
				try {
					java.sql.Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123456");
					String sql="INSERT INTO book VALUES (?,? ,?,?)";
					PreparedStatement pstmt=connection.prepareStatement(sql);
					pstmt.setInt(1, book.getId());
					pstmt.setString(2, book.getBookName());
					pstmt.setInt(3, book.getPrice());
					pstmt.setString(4, book.getDescription());
					ResultSet rs=pstmt.executeQuery();
					rs.close();
					connection.close();
					pstmt.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				
			}
}

方法类中删方法

package book.ff;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.hrs.entity.*;
import com.mysql.jdbc.Connection;
public class Delete {
			public void login(Book book) {
			
				try {
					Class.forName("com.mysql.jdbc.Driver");
				} catch (ClassNotFoundException e) {
					
					e.printStackTrace();
				}
				try {
					java.sql.Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123456");
					String sql="DELETE FROM book WHERE id = ?";
					PreparedStatement pstmt=connection.prepareStatement(sql);
					pstmt.setInt(1, book.getId());
					ResultSet rs=pstmt.executeQuery();
					rs.close();
					connection.close();
					pstmt.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				
			}
}

方法中查方法

package book.ff;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.hrs.entity.*;
import com.mysql.jdbc.Connection;
public class Find {
			public void login(Book book) {
				
				try {
					Class.forName("com.mysql.jdbc.Driver");
				} catch (ClassNotFoundException e) {
					
					e.printStackTrace();
				}
				try {
					java.sql.Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123456");
					String sql="select * from book where bookNmae=?";
					PreparedStatement pstmt=connection.prepareStatement(sql);
					pstmt.setString(1, book.getBookName());
					ResultSet rs=pstmt.executeQuery();
					rs.close();
					connection.close();
					pstmt.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				
			}
}

方法类中改方法

package book.ff;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.hrs.entity.*;
import com.mysql.jdbc.Connection;
public class Change {
			public void login(Book book) {
				
				try {
					Class.forName("com.mysql.jdbc.Driver");
				} catch (ClassNotFoundException e) {
					
					e.printStackTrace();
				}
				try {
					java.sql.Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123456");
					String sql="UPDATE book SET id = ? and  bookName=? and price=? and description=?";
					PreparedStatement pstmt=connection.prepareStatement(sql);
					pstmt.setInt(1, book.getId());
					pstmt.setString(2, book.getBookName());
					pstmt.setInt(3, book.getPrice());
					pstmt.setString(4, book.getDescription());
					ResultSet rs=pstmt.executeQuery();
					rs.close();
					connection.close();
					pstmt.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				
			}
}

测试类

package com.hrs.TestBook;

import com.hrs.entity.Book;

public class Books {
	Book book=new Book(1, "《你好》", 30,"好书");
	
}