java操作mysql数据表

注：以下Java语句进行MySQL数据库增删改查操作
用到了jdbc和javabean知识

1. 增 String sql = “INSERT INTO table1(id,user,password,age) VALUES (?,?,?,?)”;
   // 预处理sql语句
   PreparedStatement presta = conn.prepareStatement(sql);
   // 设置sql语句中的values值
   presta.setInt(1, newuser.id);
   presta.setString(2, newuser.user);
   presta.setString(3, newuser.password);
   presta.setInt(4, newuser.age);
   // 执行SQL语句，实现数据添加
   presta.execute();
2. 删 //String sql = “INSERT INTO table1(id,user,password,age) VALUES (?,?,?,?)”;
   //String sql = “Update table1 set user=?,password=?,age=? where id=?”;
   String sql = “delete from table1 where id=?”;
   // 预处理sql语句
   PreparedStatement presta = conn.prepareStatement(sql);
   // 设置sql语句中的values值
   presta.setInt(1,id);
   // 执行SQL语句，实现数据添加
   presta.execute();
3. 改 //String sql = “INSERT INTO table1(id,user,password,age) VALUES (?,?,?,?)”;
   String sql = “Update table1 set user=?,password=?,age=? where id=?”;
   // 预处理sql语句
   PreparedStatement presta = conn.prepareStatement(sql);
   // 设置sql语句中的values值
   presta.setString(1, newuser.user);
   presta.setString(2, newuser.password);
   presta.setInt(3, newuser.age);
   presta.setInt(4, newuser.id);
4. 查 PreparedStatement ps = null;
   ResultSet rs = null;
   String sql = “SELECT * FROM bank WHERE id=?”;
   ps = conn.prepareStatement(sql);
   ps.setInt(1, id);
   rs = ps.executeQuery(); //执行数据库查询的方法，放到rs中
   while (rs.next()) {
   bankm = new BankModel();
   bankm.setId(rs.getInt(“id”));
   bankm.setUsers(rs.getString(“users”));
   bankm.setMoney(rs.getString(“money”));
   bankm.setTelephone(rs.getString(“telephone”));
   bankm.setCardno(rs.getInt(“cardno”));
   //bankm.setAddress(rs.getString(“address”));
   //bankm.setRemark(rs.getString(“remark”));
   bankm.setIsok(rs.getInt(“password”));}