我对MVC的理解
MVC全名是Model View Controller,是模型(model)-视图(view)-控制器(controller)的缩写
- 模型(model):接收信息,进行数据库的存取
- 视图(view):用户看到的界面(如jsp、html等界面)
- 控制器(controller):接收用户需求,调用模型完成用户需求
JDBC的基本操作(实现数据的增删改查)
对Book表中的数据进行增删改查;
Book表:id int,bookName varchar,price int,description varchar
Book类:id int,bookName String ,price int,description String
DBUtil类:创建数据库连接
Book表:原有3条信息
Book类:
public class Book {
private int id;
private String bookName;
private int price;
private String 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 "id:"+id+"bookname:"+bookName+"price:"+price+"description:"+description;
}
}
DBUtil类:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class DBUtil {
static Connection conn = null;
Statement stmt = null;
static String driverClassName="com.mysql.jdbc.Driver";
static String url="jdbc:mysql://localhost:3306/goods";
static String username="root";
static String password="123456";
public static Connection getConn(){
try {
Class.forName(driverClassName);
conn = DriverManager.getConnection(url,username,password);
} catch (Exception e) {
e.printStackTrace();
System.out.println("失败");
}
return conn;
}
}
BookTest类:
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class BookTest {
public static void<