1、首先将mysql-connector-java-5.0.8-bin.jar包复制到工程目录,然后右键-》Build Path-》增加到项目中。
2、直接上代码
package com.cheng.utils;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;
/**
* JDBC工具类
* 用于获取数据库链接和关闭相应资源
* @author ChengAcer
*
*/
public class JDBCUtils {
// 数据库驱动
private static final String DRIVERCLASS;
// 数据库链接url
private static final String URL;
// 用户名
private static final String USER;
// 密码
private static final String PWD;
// 从配置文件初始化参数,类加载时首先执行
static {
ResourceBundle bundle = ResourceBundle.getBundle("dbconfig");
DRIVERCLASS = bundle.getString("DRIVERCLASS");
URL = bundle.getString("URL");
USER = bundle.getString("USER");
PWD = bundle.getString("PWD");
}
/**
* 建立并返回链接
*
* @return 数据库链接
* @throws ClassNotFoundException
* @throws SQLException
*/
public static Connection getConnection() throws ClassNotFoundException,
SQLException {
// 加载驱动
loadDriver();
// 返回数据库链接
return DriverManager.getConnection(URL, USER, PWD);
}
// 装载驱动
private static void loadDriver() throws ClassNotFoundException {
// 利用反射,避免二次加载驱动
Class.forName(DRIVERCLASS);
}
/**
*
* 释放资源
*
* @param rs
* 需要关闭的ResultSet
* @param stmt
* 需要关闭的Statement
* @param conn
* 需要关闭的Connection
*/
public static void release(ResultSet rs, Statement stmt, Connection conn) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
rs = null;
}
release(stmt, conn);
}
/**
* 释放资源
*
* @param stmt
* 需要关闭的Statement
* @param conn
* 需要关闭的Connection
*/
public static void release(Statement stmt, Connection conn) {
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
stmt = null;
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
conn = null;
}
}
}
配置文件dbconfig.properties的内容:
DRIVERCLASS=com.mysql.jdbc.Driver
URL=jdbc\:mysql\:///im_cheng
USER=root
PWD=
#DRIVERCLASS=oracle.jdbc.driver.OracleDriver
#URL=jdbc:oracle:thin:@localhost:1521:xe
#USER=system
#PWD=123