java连接数据库demo

package databaseDB_connection;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/*
* 创建连接数据库（需要数据库服务保持运行状态，需要ojdbc6.jar包）
* */
public class util {
public static Connection getConnection() {
Connection conn = null;
try {
// 加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@172.22.0.84:1521:devdb", "sywj", "sywj");
} catch (Exception e) { // jdbc:oracle:thin:@172.22.0.84:1521:devdb
// TODO: handle exception
e.printStackTrace();
}
return conn;

}

// 关闭数据库
public void closeDB(ResultSet rs, Statement smt, Connection conn) {
try {
if (rs != null) {
rs.close();
}
if (smt != null) {
smt.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println("关闭数据库连接失败！");
e.printStackTrace();
}
}
//测试连接是否成功
public static void main(String[] args) {
System.out.println(util.getConnection());
//打印oracle.jdbc.driver.T4CConnection@2d2c6ed8 则连接数据库成功
}
}