再请问:
一个statement可以打开若干个resultset再关闭吗?
例如: ResultSet rs = null;
String sql = new String();
Statement stmt = conn.conn.createStatement(); //属性1
sql = "SELECT dict_name,dict_no FROM enu_dict where dict_code = 'MP_ATTR'";
rs = stmt.executeQuery(sql);
try {
jCBMpattr.InitArr();
while (rs.next()){
jCBMpattr.addItem(rs.getString("dict_name").trim());
jCBMpattr.additemIntvalue(rs.getInt("dict_no"));
}
jCBMpattr.InitArr();
rs.close();
}
catch(Exception ex) {
ex.printStackTrace();
} //属性2
sql = "SELECT dict_name,dict_no FROM enu_dict where dict_code = 'MP_CLASS'";
rs = stmt.executeQuery(sql);
try {
jCBMpclass.InitArr();
while (rs.next()){
jCBMpclass.addItem(rs.getString("dict_name").trim());
jCBMpclass.additemIntvalue(rs.getInt("dict_no"));
}
jCBMpclass.InitArr();
rs.close();
}
catch(Exception ex) {
ex.printStackTrace();
} //属性3
sql = "SELECT dict_name,dict_no FROM enu_dict where dict_code = 'CT'";
rs = stmt.executeQuery(sql);
try {
jCBMpct.InitArr();
while (rs.next()){
jCBMpct.addItem(rs.getString("dict_name").trim());
jCBMpct.additemIntvalue(rs.getInt("dict_no"));
}
jCBMpct.InitArr();
rs.close();
stmt.close(); --------到这里才关闭可以吗?(至少编译不报错) }
catch(Exception ex) {
ex.printStackTrace();
}请各位高手赐教。
一个statement可以打开若干个resultset再关闭吗?
例如: ResultSet rs = null;
String sql = new String();
Statement stmt = conn.conn.createStatement(); //属性1
sql = "SELECT dict_name,dict_no FROM enu_dict where dict_code = 'MP_ATTR'";
rs = stmt.executeQuery(sql);
try {
jCBMpattr.InitArr();
while (rs.next()){
jCBMpattr.addItem(rs.getString("dict_name").trim());
jCBMpattr.additemIntvalue(rs.getInt("dict_no"));
}
jCBMpattr.InitArr();
rs.close();
}
catch(Exception ex) {
ex.printStackTrace();
} //属性2
sql = "SELECT dict_name,dict_no FROM enu_dict where dict_code = 'MP_CLASS'";
rs = stmt.executeQuery(sql);
try {
jCBMpclass.InitArr();
while (rs.next()){
jCBMpclass.addItem(rs.getString("dict_name").trim());
jCBMpclass.additemIntvalue(rs.getInt("dict_no"));
}
jCBMpclass.InitArr();
rs.close();
}
catch(Exception ex) {
ex.printStackTrace();
} //属性3
sql = "SELECT dict_name,dict_no FROM enu_dict where dict_code = 'CT'";
rs = stmt.executeQuery(sql);
try {
jCBMpct.InitArr();
while (rs.next()){
jCBMpct.addItem(rs.getString("dict_name").trim());
jCBMpct.additemIntvalue(rs.getInt("dict_no"));
}
jCBMpct.InitArr();
rs.close();
stmt.close(); --------到这里才关闭可以吗?(至少编译不报错) }
catch(Exception ex) {
ex.printStackTrace();
}请各位高手赐教。
resultset先关闭
statement再关闭