import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/*
* admin:lisong
*/
public class OracleConnectionMgr {
public static Connection getConnection() {
Connection con = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String username = "scott";
String password = "tiger";
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
con = DriverManager.getConnection(url, username, password);
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
public static void closeResource(Connection con, Statement sm, ResultSet rs) {
try {
if (rs != null) {
rs.close();
}
if (sm != null) {
sm.close(); }
if (con != null) {
con.close();
}
} catch (SQLException se) {
se.printStackTrace();
}
}
}
//复制过去 把类名,userName,password,url 就可以了....
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/*
* admin:lisong
*/
public class OracleConnectionMgr {
public static Connection getConnection() {
Connection con = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String username = "scott";
String password = "tiger";
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
con = DriverManager.getConnection(url, username, password);
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
public static void closeResource(Connection con, Statement sm, ResultSet rs) {
try {
if (rs != null) {
rs.close();
}
if (sm != null) {
sm.close(); }
if (con != null) {
con.close();
}
} catch (SQLException se) {
se.printStackTrace();
}
}
}
//复制过去 把类名,userName,password,url 就可以了....