JDBC,结果集的应用。

[size=large]import java.sql.*;
public class jdbc5{
public static void main(String[]args){
Connection con=null;
Statement stm = null;
ResultSet rs=null;
try{
String driverName="oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
String url="jdbc:oracle:thin:@192.168.7.88:1521:tarena";
String username="liucy";
String pwd="liucy";
con=DriverManager.getConnection(url,username,pwd);
stm=con.createStatement();
System.out.println("stm->"+stm);
String sql ="select name,id from student";
try{
rs=stm.executeQuery(sql);//对于查询语句的处理。
System.out.println(rs);
}catch(Exception el){
el.printStackTrace();
}
StringBuffer sb = new StringBuffer();
while(rs.next()){ //结果集的遍历。
sb.append("name:"+rs.getString(1)+" ");
sb.append("id:"+rs.getInt(2)+"\n");
}
System.out.println(sb);
}catch(Exception e){

}finally{
try{
rs.close();
}catch(Exception ee){
ee.printStackTrace();
}
try{
stm.close();
}catch(Exception ee){
ee.printStackTrace();
}
try{
con.close();
}catch(Exception ee){
ee.printStackTrace();
}

}
}
}[/size]