想要遍历一个结果集中的每一行,包括每一列,但不知道有多少列及每列的类型?
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCExample {
public static void main(String[] args) {
try {
//System.setProperty("jdbc.drivers","oracle.jdbc.driver.OracleDriver");
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
Connection conn = DriverManager.getConnection(url,"scott","123");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from dept");
while (rs.next()){//假如这里不知道列有多少,及每一列的字体类型?
System.out.print("DeptNo:" + rs.getInt(1));
System.out.print("\tDeptName:" + rs.getString(2));
System.out.println("\tLOC:" + rs.getString(3));
}
rs.close();
stmt.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}
}
}