请问大家怎样利用这段代码从192.168.8.32/mmsstat数据库中列出表student中的name字段?(其中user 和 password为正确的),请大家给出一些代码!
String dbstr = "jdbc:mysql://192.168.8.32/mmsstat?user=mmsstat&password=mmsstat&useUnicode=true&characterEncoding=GBK";
DBPool pool = new DBPool("mms", "com.mysql.jdbc.Driver", dbstr);
Connection con = pool.getCon();
logger.info("con:"+con);
con.close();
logger.info("test");
String dbstr = "jdbc:mysql://192.168.8.32/mmsstat?user=mmsstat&password=mmsstat&useUnicode=true&characterEncoding=GBK";
DBPool pool = new DBPool("mms", "com.mysql.jdbc.Driver", dbstr);
Connection con = pool.getCon();
logger.info("con:"+con);
con.close();
logger.info("test");
String sql="select name from students";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getString("name"));
}
rs.close();