java测试连接oracle_测试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