操作步骤：
1.注册数据库驱动程序
2.获取数据库连接对象
3.建立数据库操作语句
4.执行并返回结果
5.释放连接
CODE
1. 配置peoperties属性文件
DRIVERS=oracle.jdbc.driver.OracleDriver
URL=jdbc：oracle：thin：@localhost：1521：orcl
USERNAME=user
PASSWORD=password
2. 解析配置文件属性
package com.jdbc; import java.io.IOException;
import java.io.InputStream;
import java.util.Properties; public class DBConfig extends Properties{
private static final long serialVersionUID = 6988299229093520679L;
private static DBConfig dbConfig = null;
private DBConfig() {
try{
InputStream inStream = DBConfig.class.getResourceAsStream("/dbConfig.properties");
this.load(inStream);
}catch (IOException e) {
e.printStackTrace();
}
}
public static DBConfig getInstance() {
if(dbConfig == null){
synchronized (DBConfig.class) {
if(dbConfig == null){
dbConfig = new DBConfig();
}
}
}
return dbConfig;
}
} |
3. 加载驱动获取连接操作
package com.jdbc; import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement; public class DBUtils { private static String DB_DRIVERS;
private static String DB_URL;
private static String DB_USER;
private static String DB_PASSWORD;
static {
DBConfig config = DBConfig.getInstance();
DB_DRIVERS = config.getProperty(DBConstant.DB_DRIVERS);
DB_URL = config.getProperty(DBConstant.DB_URL);
DB_USER = config.getProperty(DBConstant.DB_USERNAME);
DB_PASSWORD = config.getProperty(DBConstant.DB_PASSWORD);
}
/**
* 获取数据库连接
* @return conn 数据库连接
* @throws ClassNotFoundException if the class cannot be located
* @throws SQLException if a database access error occurs
*/
public static Connection getConnection() throws ClassNotFoundException, SQLException{
Connection conn = null;
try {
// 1.注册数据库驱动程序
Class.forName(DB_DRIVERS);
// 2.获取数据库连接对象
conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
} catch (ClassNotFoundException e) {
throw new ClassNotFoundException("数据库驱动注册失败" + e.getMessage());
}catch (SQLException e) {
throw new SQLException("获取数据库连接对象失败" + e.getMessage());
}
return conn;
}
/**
* 释放数据库连接
*/
public static void release(ResultSet rs, Statement stmt, Connection conn) {
try {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
} } |
