一、创建一个属性文件jdbc.properties
username =
password =
url =jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST =)(PORT = )))(CONNECT_DATA=(SERVICE_NAME=)(SERVER=DEDICATED)))
driverClassName =oracle.jdbc.driver.OracleDriver
连接参数写自己要连接的数据库
二、创建一个Java对象,字段是属性文件的各个属性参数
package com.yolanda.fun.db;
public class DataProperty {
private String driverClassName;
private String url;
private String username;
private String password;
public String getDriverClassName() {
return driverClassName;
}
public void setDriverClassName(String driverClassName) {
this.driverClassName = driverClassName;
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
三、数据库连接类
package com.yolanda.fun.db;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
public class DbConnection {
private String driverClassName;
private String url;
private String username;
private String password;
private Connection connection = null;
public Connection connDb() {
DataProperty dataProperty = getProperties();
this.driverClassName = dataProperty.getDriverClassName();
this.url = dataProperty.getUrl();
this.username = dataProperty.getUsername();
this.password = dataProperty.getPassword();
try {
//反射oracle数据库驱动类
Class.forName(this.driverClassName);
//获取数据库连接
this.connection = DriverManager.getConnection(this.url, this.username, this.password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return this.connection;
}
public static void main(String[] args) {
DbConnection dbConnection = new DbConnection();
dbConnection.connDb();
}
/**
* 获取数据库连接属性
* @return
*/
public DataProperty getProperties() {
DataProperty dp = new DataProperty();
try {
//从配置文件里读取数据库驱动,连接,用户名,密码
Properties properties = new Properties();
InputStream inputStream = DbConnection.class.getResourceAsStream("jdbc.properties");
properties.load(inputStream);
dp.setDriverClassName("driverClassName");
dp.setPassword("password");
dp.setUrl("url");
dp.setUsername("username");
} catch (IOException e) {
e.printStackTrace();
}
return dp;
}
}
四、pom文件里加个驱动
<dependency>
<groupId>oracle.jdbc</groupId>
<artifactId>ojdbc14</artifactId>
<version>10.2.0.5.0</version>
</dependency>
版本可以去自己的maven库里找个,没有的来这个下个
http://download.csdn.net/detail/yolanda_nuonuo/9641315