实现数据库数据的查询,查询id=3的数据;
查询姓“李”的所有用户;
查询年龄在[20,35]且性别是女的用户;
//创建预编译语句对象
String sql_a = "select * from user where id = ?";
String sql_b = "select * from user where name like ?";
String sql_c = "select * from user where age between ? and ? and sex=?";
PreparedStatement ps_a = conn.prepareStatement(sql_a);
PreparedStatement ps_b = conn.prepareStatement(sql_b);
PreparedStatement ps_c = conn.prepareStatement(sql_c);
//没有占位符需要设置,故直接执行,获得结果集
ps_a.setObject(1,3);
ps_b.setObject(1,"李%");
ps_c.setObject(1,20);
ps_c.setObject(2,35);
ps_c.setObject(3,"女");
ResultSet rs_a = ps_a.executeQuery();
ResultSet rs_b = ps_b.executeQuery();
ResultSet rs_c = ps_c.executeQuery();