更新语句
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);
版权声明:本站所有资料均为网友推荐收集整理而来,仅供学习和研究交流使用。
工作时间:8:00-18:00
客服电话
电子邮件
admin@qq.com
扫码二维码
获取最新动态