JDBC之修改数据

JDBC之修改数据

public static void main(String[] args){
//输入lastbame
String lastname = JOptionPane.showInputDialog("请输入lastname:");
//输入firstname
String firstname= JOptionPane.showInputDialog("请输入firstname:");
//输入id的值
String sid= JOptionPane.showInputDialog("请输入id:");
//字符串转整形
int id = Integer.parseInt(sid);
try{
   Class.forName("com.mysql.jdbc.Driver");
   Driver d = new Driver();
   //注册驱动
   DriverManager,registerDriver(d);
   //建立连接
   Connection conn = DriverManger.getConneection();
   String sql = "update user1 set firstname = ?, lastName = ? where id =?"
   //获取预处理对象
   PrepareStament ps = conn.prepareStament(sql);
   //设置lastname的值
   ps.setOdject(1,firstname);
   //设置firsrname的值
   ps.setOdject(2,lastname);
   //设置id的值
   ps.setOdject(1,id);
   //执行sql
   int result = ps.excecuteUpdate();//返回受影响的数量
   if(result > 0){
      JOptionPane.showMessageDialog(null,"修改成功");
   }
 }catch(Exception e){
   e.printStackTrace()
}
}