SQLÓï¾äÕýÈ·µ«ÊÇRESULTSETÖÐûÓÐÖµ

StringBuffer str = new StringBuffer("select * from menu where parentid=1 and mid <>1 order by parentid");

List list = new ArrayList();
ResultSet rst = null;
DataBaseConnection dbc = null;
PreparedStatement pstm = null;

try {
dbc = new DataBaseConnection();
pstm = dbc.getConnection().prepareStatement(str.toString());

rst = dbc.query(pstm);

while(rst.next()){
System.out.println(rst.getString("name"));
}


RSTÖÐûÓÐÈκÎÖµ

Êý¾Ý¿â ORACLE 10G

---

²»ÖªµÀÄãµÄÊÇÔõô·â×°µÄ²éѯ£¬ÓÐÎÊÌâÒ»¶¨ÊÇdbc.query(pstm)ûÓеõ½ÕýÈ·µÄ½á¹û¼¯
Ϊʲô²»Ö±½Ó²éѯÄØ£¿
try {
dbc = new DataBaseConnection();
pstm = dbc.getConnection().prepareStatement(str.toString());
rst = pstm.executeQuery();
while(rst.next()){
System.out.println(rst.getString("name"));
}

---

public ResultSet query(PreparedStatement pstm) throws SQLException,
Exception {

this.rst = pstm.executeQuery();
return rst;
}

ÕâÊǺǫ́²éѯ

---

·â×°Õâ¸ö·½·¨ºÃÏñûɶÒâÒå°¡
ÄãµÄsqlÔÚ¹¤¾ßÀïÄܲé³ö¶«Î÷Âð£¿
public ResultSet query(PreparedStatement pstm) throws SQLException,
Exception {
    return pstm.executeQuery();
}

---

PLSQL DEVELOPER Äܲé³öÀ´£¬½á¹ûÕýÈ·

---

Ö