(一)从结果集获取数据的两种方法
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from product");
while(rs.next()) {
//从结果集获取数据的方法 (1)
System.out.println(rs.getInt(1)+","+rs.getString(2)+"."+rs.getString(3));
//方法(2)
System.out.println(rs.getString("product_type"));
}
(二)创建用户名和密码校验的查询方法
public class JDBCDemo01 {
public static void main(String[] args) {
//selectAll();
System.out.println(selectByUsernamePassword("a", "g"));
}
public static boolean selectByUsernamePassword(String username,String password) {
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
try {
Class.forName(&#