面试问题，寻找高手解答

try {
Connection conn = …;
Statement stmt = …;

ResultSet rs = stmt.executeQuery("select * from table1");

while(rs.next()) {

}
} catch(Exception ex) {
}

这段代码有什么不足之处?

finally语句。应该要关闭相关的东东。如conn,stmt,rs。否则耗资源。