连接mysql时候却可以全部循环
Statement statement = null;
ResultSet rs = null;
Connection conn = null;
String sql = "select * from dept";
try {
conn = JdbcUtils.conn(url, driver_class, username, password);
statement = conn.createStatement();
rs = statement.executeQuery(sql);
while(rs.next())
{
.......
}
} catch (Exception e) {
e.printStackTrace();
}finally{
JdbcUtils.close(rs, statement, conn);
}
没分了,还望那位不吝赐教!
conn = JdbcUtils.conn(url, driver_class, username, password);
statement = conn.createStatement();
这两句没有问题,能正常连到数据库的
|