求java连接oracle 11g数据库的实例

package test.oracle;
import java.sql.*;//project 中添加ojdbc6_g.jar

public class OJ {
    public static void main(String args[]){
    String url = "jdbc:oracle:thin:@localhost:1521:orcl11";
    try{
        Class.forName("oracle.jdbc.driver.OracleDriver"); //建表后先commit才能在其它端中调用
   
    Connection conn =  DriverManager.getConnection(url,"system","bbroot");
    Statement stmt=conn.createStatement(); //建表时的插入语句记得为' ',而不是" "
    String strSql="SELECT * FROM Test_JC";//将sql中将;去掉
    ResultSet rs=stmt.executeQuery(strSql);
    while(rs.next()){
        System.out.println("TestID:"+rs.getString(1));
        System.out.println("Describe:"+rs.getString(2));
        }
    }
    catch(Exception e){
        e.printStackTrace();
    }
    System.exit(0);
}
}

输出：
TestID:001
Describe:ILOVEYOU
TestID:002
Describe:JAVA
TestID:003
Describe:Oracle

答案来自网上。

java连oracle11g
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.*;

public class HelloWorld{
// 程序的入口
public static void main(String[] args) {
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.150:1521:MYBOSS","ibmp_dba","123456");
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select * from ibmp_user");
while (rset.next()) {
System.out.println ("col1 : " + rset.getInt(1));
System.out.println ("col2 : " + rset.getString(2));
}
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}