工具类
自己建一个util(工具)包
package com.gezhi.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* 工具层
* @author X.mr
*
*/
public class JDBCUtil {
public static final String URL = "jdbc:mysql://localhost:3306/tb40";
public static final String USER = "root";
public static final String PASSWORD = "123456";
static {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
* 创建数据库连接
*/
public static Connection getCon() {
Connection conn = null;
try {
conn = DriverManager.getConnection(URL,USER,PASSWORD);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
/**
* 关闭结果集,关闭预处理平台,关闭数据库连接
* @param rs
* @param prepare
* @param conn
*/
public static void closeAll(ResultSet rs,PreparedStatement prepare,Connection conn){
if(rs != null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(prepare != null) {
try {
prepare.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn != null) {
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}