import java.sql.*;
public class Test { Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null; public ResultSet select(){
String d = "oracle.jdbc.driver.OracleDriver";
try {
Class.forName(d);
conn = DriverManager.getConnection("jdbc:oracle:thin:" +
"@192.168.0.254:1521:open","root","1123");
String sql = "select * from t_user";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
return rs;
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} public void list(){
Test t = new Test();
t.select();
while(rs.next()){
System.out.println(rs.getString(4));
}
} }
(*************************
为什么一定要返回那个rs???
它们在内存中怎么分配的??
public class Test { Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null; public ResultSet select(){
String d = "oracle.jdbc.driver.OracleDriver";
try {
Class.forName(d);
conn = DriverManager.getConnection("jdbc:oracle:thin:" +
"@192.168.0.254:1521:open","root","1123");
String sql = "select * from t_user";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
return rs;
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} public void list(){
Test t = new Test();
t.select();
while(rs.next()){
System.out.println(rs.getString(4));
}
} }
(*************************
为什么一定要返回那个rs???
它们在内存中怎么分配的??
楼主【dp1123】截止到2008-07-15 07:18:42的历史汇总数据(不包括此帖):
发帖的总数量:2 发帖的总分数:50 每贴平均分数:25
回帖的总数量:2 得分贴总数量:0 回帖的得分率:0%
结贴的总数量:0 结贴的总分数:0
无满意结贴数:0 无满意结贴分:0
未结的帖子数:2 未结的总分数:50
结贴的百分比:0.00 % 结分的百分比:0.00 %
无满意结贴率:---------------------无满意结分率:---------------------
如何结贴请参考这里:http://topic.csdn.net/u/20080501/09/ef7ba1b3-6466-49f6-9d92-36fe6d471dd1.html
因为这人所以返回RS...
你要是问到点为什么的话,请查JDK英文原稿