java如何连接ORACLE数据库

Question

import java.sql.*;
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
String url="jdbc:oracle:thin:@localhost:1521:fan";
String userName="system";
String password="manager";
Connection cn=DriverManager.getConnection(url,userName,password);Statement stmt=con.createStatement();
stmt.executeQuery("select * from emp");

Answer 1

<%
String  DBDriver  = "oracle.jdbc.driver.OracleDriver";  
String  DBLocation  = "jdbc:oracle:thin:@localhost:1521:服务名";  
String  DBUser  =  " ";  
String  DBPwd  =  " ";  

        Class.forName( DBDriver )  ;     
        Connection  sqlCon  =  DriverManager.getConnection( DBLocation,  DBUser,DBPwd);
    java.sql.Statement  sqlStmt  =  sqlCon.createStatement();
    ResultSet  sqlRst  =  null;
ResultSet  sqlRst1  =  null;
        boolean defaultCommit = sqlCon.getAutoCommit();   
%>

Answer 2

http://blog.csdn.net/treeroot/archive/2004/09/24/115372.aspx

Answer 3

String url="jdbc:oracle:thin:@localhost:1521:id";
String userName="system";
String password="manager";
Connection cn=DriverManager.getConnection(url,userName,password);Statement stmt=con.createStatement();
stmt.executeQuery("select * from table");
最好用
try{
}catch(){
}finally{
}
进行异常的catch，并且最后要把连接close