JDBC实现（1）

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();
}
}
}
}