javaweb中為mysql的curd多個值的語句

標籤：sel   int   pre   string   動態   values   statement   str   date()   

更新語句

String sql = "update student set num=?,name=?,birthday=?,score=?,password=? where id=?";
ps = conn.prepareStatement(sql);
ps.setString(1, student.getNum());
ps.setString(2, student.getName());
ps.setString(3, student.getBirthday2());
ps.setDouble(4, student.getScore());
ps.setString(5, student.getPassword());
ps.setInt(6, id);

刪除

String sql="delete from student where id=?";
ps=conn.prepareStatement(sql);
ps.setInt(1, id);
ps.executeUpdate();

插入

String sql = "insert into student(num,name,birthday,score,password) values(?,?,?,?,?)";
ps = conn.prepareStatement(sql);
ps.setString(1, student.getNum());
ps.setString(2, student.getName());
ps.setDouble(4, student.getScore());
ps.setString(5, student.getPassword());
ps.setString(3, student.getBirthday2());

查詢

String sql = "select * from student where num=? and password=?";
// 擷取DB操作對象
ps = conn.prepareStatement(sql);
// 為動態參數賦值
ps.setString(1, num);
ps.setString(2, password);

javaweb中為mysql的curd多個值的語句