java连接ORACLE问题
import java.sql.*;
public class ConnOracle{
public static void main(String[] args) {
try{
Connection conn=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@LJ-C-GE.lijia.veolia-es.cn:1521:SCHOOL", "system", "Ilyvm1122");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select DEPNAME,ADDRESS from system.DEPARTMENT");
// System.out.println("good");
while(rs.next())
{
System.out.print(rs.getString(1)+" ");
System.out.println(rs.getString(2));
System.out.println("-----------------------------");
}
}catch(Exception e){
e.printStackTrace();
}
}
}
用pl/sql developer能查到表中的数据,上面代码不打印任何东西,也不报错,只有press any key continue