//使用PreparedStatement
PreparedStatement ps=conn.prepareStatement("update userLogin set password=?,state=? where email=? );
ps.setString(1,"abc123");
ps.setString(2,1);
ps.setString(3,"zhangsan@qq.com");
ps.executeQuery();
//使用Statement
Statement stat = con.createStatement();
String sql = "update userLogin set password='abc123',state=-1 where email='zhangsan@qq.com'";
stat.executeUpdate(sql);
4、将userLogin表的所有数据读取出来,并按顺序打印到控制台上,将打印结果粘贴到实验报告中。
PreparedStatement ps=conn.prepareStatement("select * from userLogin");
rs=ps.executeQuery();
ResultSet rs = statement.executeQuery(sql);
while(rs.next()){
int id = rs.getInt("id");
String email = rs.getString("email");
String password = rs.getString("password");
int state = rs.getInt("state");
System.out.print(id+" ");
System.out.print(name+" ");
System.out.print(email+" ");
System.out.println(birth);
}