java jdbc 封装类_jdbc封装的类

JDBCUtil，java

package cn.qst.util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class JDBCUtil {

private static final String DBDRIVER = "com.mysql.jdbc.Driver";

private static final String DBURL = "jdbc:mysql://localhost:3306/studyweb?useUnicode=true&characterEncoding=utf-8&useSSL=false";

private static final String DBUSER = "root";

private static final String DBPASSWORD = "root";

/**

* 获取数据库连接

* @return

*/

public static Connection getConnection() {

Connection conn = null;

try {

//加载驱动

Class.forName(DBDRIVER);

//创建数据库连接

conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);

} catch (SQLException e) {

e.printStackTrace();

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

return conn;

}

/**

* 关闭数据连接类

* 连接 预编译命令 、 执行命令 执行结果集

*/

public static void closeAll(Connection conn,PreparedStatement pstmt,Statement stmt,ResultSet rs){

try {

if(rs!=null){

rs.close();

}

if(stmt!=null){

stmt.close();

}

if(pstmt!=null){

pstmt.close();

}

if(conn!=null){

conn.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}