package com.itaka.conn;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* DBUtils工具类
* @author joy
*
*/
public class DBUtils {
/**
* DRIVER
*/
private static final String DRIVER = "com.mysql.jdbc.Driver";
/**
* URL
*/
private static final String URL = "jdbc:mysql://127.0.0.1:3306/数据库名称";
/**
* 用户名
*/
private static final String USER = "root";
/**
* 密码
*/
private static final String PASSWORD = "123456";
/**
* 连接对象
*/
private static Connection conn = null;
/**
* 获取连接对象
* @return Connection
*/
public static Connection getConnection(){
try {
//加载驱动
Class.forName(DRIVER);
//获取连接
conn = DriverManager.getConnection(URL, USER, PASSWORD);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
/**
*
* 关闭资源
* @param conn
* @param pstmt
* @param rs
*
*/
public static void close(Connection conn ,Statement stmt ,ResultSet rs){
try {
if(rs != null){
rs.close();
}
if(stmt != null){
stmt.close();
}
if(conn != null){
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
*
* 关闭资源
* @param conn
* @param pstmt
*
*/
public static void close(Connection conn ,PreparedStatement pstmt){
try {
if(pstmt != null){
pstmt.close();
}
if(conn != null){
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
DBUtils工具类
最新推荐文章于 2024-04-15 11:25:32 发布