练习题

1.使用自己的话表述MVC。
MVC模式是软件工程中的一种软件架构模式，把软件系统分为三个基本部分：
模型、视图和控制器）。
2.掌握JDBC的基本操作。
对book表中的数据进行增删改查；
book表：id int，bookName varchar,price int,description varchar
Book类：id int，bookName String ，price int，description String
提示：创建数据库连接工具类DBUtil类。
Test类
package com.util;

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

public class DBUtil {
static {
try {
Class.forName(“com.mysql.jdbc.Driver”);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}

public static Connection getConnection() {
	String url = "jdbc:mysql://localhost:3306/test2";
	Connection conn = null;
	try {
		conn = DriverManager.getConnection(url,"root","123456");
	} catch (SQLException e) {
		e.printStackTrace();
	}
	return conn;
}

public static void close(Connection conn) {
	try {
		conn.close();
	} catch (SQLException e) {
		e.printStackTrace();
	}
}

public static void close(PreparedStatement ps) {
	try {
		ps.close();
	} catch (SQLException e) {
		e.printStackTrace();
	}
}

public static void close(ResultSet rs) {
	try {
		rs.close();
	} catch (SQLException e) {
		e.printStackTrace();
	}
}

}

Fruit类
package com.test;

public class Fruit {
private int id;
private String fruitName;
private int price;
private String description;
public Fruit() {

}
public Fruit(int id, String fruitName, int price, String description) {
	super();
	this.id = id;
	this.fruitName = fruitName;
	this.price = price;
	this.description = description;
}
public int getId() {
	return id;
}
public void setId(int id) {
	this.id = id;
}
public String getFruitName() {
	return fruitName;
}
public void setFruitName(String fruitName) {
	this.fruitName = fruitName;
}
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;
}
@Override
public String toString() {
	return "Fruit [id=" + id + ", fruitName=" + fruitName + ", price=" + price + ", description=" + description + "]";
}

}

DBUtil类
package com.test;

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

public class DBUtil {
static {
try {
Class.forName(“com.mysql.jdbc.Driver”);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}

public static Connection getConnection() {
	String url = "jdbc:mysql://localhost:3306/test2";
	Connection conn = null;
	try {
		conn = DriverManager.getConnection(url,"root","123456");
	} catch (SQLException e) {
		e.printStackTrace();
	}
	return conn;
}

public static void close(Connection conn) {
	try {
		conn.close();
	} catch (SQLException e) {
		e.printStackTrace();
	}
}

public static void close(PreparedStatement ps) {
	try {
		ps.close();
	} catch (SQLException e) {
		e.printStackTrace();
	}
}

public static void close(ResultSet rs) {
	try {
		rs.close();
	} catch (SQLException e) {
		e.printStackTrace();
	}
}

}