怎么连接Oracle数据库是这样的呀?
private static Connection conn;
public static Connection getConnection(){
try{
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
conn = DriverManager.getConnection("proxool.Develop");
}catch(Exception e){
System.err.println("数据库连接出错!");
e.printStackTrace();
}
return conn;
private static Connection conn;
public static Connection getConnection(){
try{
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
conn = DriverManager.getConnection("proxool.Develop");
}catch(Exception e){
System.err.println("数据库连接出错!");
e.printStackTrace();
}
return conn;
解决方案 »
- jsp页面的跳转问题 急~!~!
- 求助!!关于JSTREE只读效果
- hibernate当hql返回了inner join里面的数据的时候其它的类和hbm.xml是否需要改呢
- 采用什么技术进行分页显示数据好?请高手出招!
- struts 标签 求助
- JSP中sql语句的使用问题请教:(在线等待,谢谢!)
- 如何处理才可以提高JSP文件第一次执行的速度?
- !!!!!!用oracle9i自带的jdk1.3来配Tomcat4.1会有问题!!!!!!!!!!!!!!!
- jbuilder6开发jsp遇到的问题,请高手帮忙!
- 如何在tomcat中使用,javax.transaction.TransactionManager
- Myeclipse 8.5部署Struts 1.2 struts-config.xml文件经常出错?
- 请教aspectj.jar包的问题
Class.forName("oracle.jdbc.driver.OracleDriver");
// 获得数据库连接
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "root", "root");
标准的JDBC代码如下:public class TestDBOracle {
public static void main(String[] args)
throws ClassNotFoundException, SQLException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
//
// or
// DriverManager.registerDriver
// (new oracle.jdbc.driver.OracleDriver());
String url = "jdbc:oracle:thin:@//server.local:1521/prod";
// jdbc:oracle:thin:@//host:port/service
// or
// String url = "jdbc:oracle:thin:@server.local:1521:prodsid";
// jdbc:oracle:thin:@host:port:SID
Connection conn =
DriverManager.getConnection(url,"scott", "tiger");
conn.setAutoCommit(false);
Statement stmt = conn.createStatement();
ResultSet rset =
stmt.executeQuery("select yyyyyfrom xxxx");
while (rset.next()) {
System.out.println (rset.getString(1));
}
stmt.close();
System.out.println ("Ok.");
}
}
private String dbDriver = "oracle.jdbc.driver.OracleDriver"; // 数据库的驱动
private String url = "jdbc:oracle:thin:@KURUMI-SERVER2:1521:ORAKRM"; // 本地
public Connection connection = null; public JDBConnection() {
try {
Class.forName(dbDriver).newInstance(); // 加载数据库驱动
connection = DriverManager.getConnection(url, "用户名", "密码"); // KRM 加载数据库
} catch (Exception ex) {
System.out.println("数据库加载失败");
System.out.println(url);
ex.printStackTrace();
}
}
标准的JDBC连接!!!