ResultSet rs = null;
Statement stmt = null;
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:sxt", "scott", "tiger");
stmt = conn.createStatement();
//rs = stmt.executeQuery("select * from dept");
rs = stmt.executeQuery("select * from person");
while(rs.next()) {
System.out.println(rs.getString("id"));
//System.out.println(rs.getInt("deptno"));
用scott帐户里的dept表就可以取出,自己建立的person表就打印不出,person表的字段都有数据,表结构如:person(userid, name, password)