来自尚硅谷,通用的jdbc工具类
然后使用jdbc工具类写了通用的增删改方法和查方法
mysql驱动
mysql-connector-java-5.1.7-bin.jar
https://download.csdn.net/download/yougcave/19752818
数据库
CREATE TABLE `customers` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(15) DEFAULT NULL,
`email` varchar(20) DEFAULT NULL,
`birth` date DEFAULT NULL,
`photo` mediumblob,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=gb2312;
jdbc.properties
url=jdbc:mysql://localhost:3306/test
user=root
password=333
driverClass=com.mysql.jdbc.Driver
JDBCUtils
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class JDBCUtils {
public static Connection getConnection() throws Exception{
//读取配置文件
InputStream in = ClassLoader.getSystemClassLoader().getResourceAsStream("jdbc.properties");
Properties pp = new Properties();
pp.load(in);
String url = pp.getProperty("url");
String user = pp.getProperty("user");
String password = pp.getProperty("password");
String driverClass = pp.getProperty("driverClass");
//加载数据库驱动
Class.forName(driverClass);
//获取连接
java.sql.Connection conn = DriverManager.getConnection(url, user, password);
return conn;
}
public static void closeResource(Connection conn, Statement ps){
try {
if (ps != null){
ps.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (conn != null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void closeResource(Connection conn, Statement ps, ResultSet rs){
try {
if (ps != null){
ps.close();