jdbc连接

ResultSet rs=null;
        PreparedStatement stmt=null;
        java.sql.Driver  driver=new com.mysql.jdbc.Driver();
        DriverManager.registerDriver(driver);
        //2.获取数据库连接
        String url="jdbc:mysql://localhost:3306/JDBC?characterEncoding=utf8";
        String user="root";
        String password="123456";
        Connection conn= (Connection) DriverManager.getConnection(url,user,password);

      String sql = "select  name,shenghui FROM  province where id=?";
      stmt = conn.prepareStatement(sql);
      stmt.setInt(1, id);
      //执行sql
      rs = (ResultSet) stmt.executeQuery();
   while（rs.next()）{
    rs.getString
}