1、导入mysql的数据驱动包
mysql-connector-java-5.1.7-bin.jar
2、编写jdbc.properties
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/test
user=root
password=123456
编写通用的mysql-JDBCUtils
package com.xypuxing.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
public class JDBCUtils {
/**
* 获取连接
* @return
* @throws Exception
*/
public static Connection getConnection() throws Exception{
Properties props = new Properties();
props.load(JDBCUtils.class.getClassLoader().getResourceAsStream("com/atguigu/jdbc/jdbc.properties"));
String driverClassName = props.getProperty("driverClassName");
String url = props.getProperty("url");
String user = props.getProperty("user");
String password = props.getProperty("password");
//1. 加载驱动
Class.forName(driverClassName);
//2. 获取连接
Connection conn = DriverManager.getConnection(url, user, password);
return conn;
}
/**
* 关闭连接
* @param ps
* @param conn
*/
public static void close(PreparedStatement ps, Connection conn){
if(ps != null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn != null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
/**
* 关闭连接
* @param ps
* @param conn
*/
public static void close(ResultSet rs, PreparedStatement ps, Connection conn){
if(rs != null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(ps != null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn != null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}