测试Java连接Oracle 11g

测试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