BigDecimal id=null;
String name=null;
String address=null;
while(rs.next()){
id=rs.getBigDecimal("ID");
name=rs.getString("NAME");
address=rs.getString("ADDRESS");
System.out.println(" name: "+name+" address: "+address);
}
String name=null;
String address=null;
while(rs.next()){
id=rs.getBigDecimal("ID");
name=rs.getString("NAME");
address=rs.getString("ADDRESS");
System.out.println(" name: "+name+" address: "+address);
}
import java.sql.*;
import java.math.BigDecimal;
public class Untitled1 {
public static void main(String args[]){
try{
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Connection conn=DriverManager.getConnection
("jdbc:oracle:thin:@c-y:1521:cy","system","manager");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from SYS.STUDENT");
while(rs.next){
BigDecimal id=rs.getBigDecimal("ID");
String name=rs.getString("NAME");
String address=rs.getString("ADDRESS");
System.out.println(" name: "+name+" address: "+address);
}
}
catch (Exception ex) {
ex.printStackTrace();
}可是这样也是一样。
不是rs.next啊你的程序用rs.next编译通过的咩?
import java.sql.*;
import java.math.BigDecimal;
public class Untitled1 {
public static void main(String args[]){
try{
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Connection conn=DriverManager.getConnection
("jdbc:oracle:thin:@c-y:1521:cy","system","manager");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from SYS.STUDENT");
while(rs.next()){
//BigDecimal id=rs.getBigDecimal("ID");
String name=rs.getString("NAME");
String address=rs.getString("ADDRESS");
System.out.println(" name: "+name+" address: "+address);
}
}catch (SQLException e){
System.out.println(e.getMessage());
}catch (ClassNotFoundException e){
System.out.println(e.getMessage());
}catch (Exception e){
System.out.println(e.getMessage());
}
}
}
看看提示什么错误