第一种:
package com.dr.common;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBHelper{
/**
* 新创建一个数据库连接
* @return
*/
public static Connection getConn() {
String url="jdbc:oracle:thin:@121.52.216.217:1521:orcl";
String username ="itmms";
String password ="itmms";
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url, username, password);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
/**
* 执行增加删除和修改的方法
*
* @param sql
* @param condition
*/
public static void execSql(Connection con, String sql, Object[] condition) {
PreparedStatement ps = null;
try {
ps = con.prepareStatement(sql);
if (condition!= null && condition.length > 0) {
for (int i = 0; i < condition.length; i++) {
ps.setObject(i + 1, condition[i]);
}
}
ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}finally{
closeAll(null, ps);
}
}
/**
* 关闭�?��连接
*
* @param rs
* @param ps
* @param con
*/
public static void closeAll(ResultSet rs, PreparedStatement ps,Connection con) {
try {
if (rs != null)
rs.close();
if (ps != null)
ps.close();
if(con !=null)con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void closeAll(ResultSet rs, PreparedStatement ps) {
try {
if (rs != null)
rs.close();
if (ps != null)
ps.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void closeConn(Connection con) {
try {
if (con != null) {
con.close();
con = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
第二种,在配置文件中 配置相关信息
public Connection openConnection(){
String driver = "";
String url = "";
String user = "";
String password = "";
Properties prop = new Properties();
Connection conn = null;
try {
//加载属�?文件
prop.load(this.getClass().getClassLoader().getResourceAsStream("DBConfig.properties"));
driver = prop.getProperty("driver");
url = prop.getProperty("url");
user = prop.getProperty("user");
password = prop.getProperty("password");
//Class.forName加载驱动
Class.forName(driver);
//DriverManager获得连接
conn = DriverManager.getConnection(url,user,password);
return conn;
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
在配置文件中DBConfig.properties
driver=com.mysql.jdbc.Driver
url=jdbc\:mysql\://localhost\:3306/shopping
user=root
password=1234