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