增加:int a=sm.executeUpdate("use spdb;insert into users values('"+name+"','"+passwd+"','"+email+"','"+grade+"')");
删除:int a=sm.executeUpdate("use spdb;delete from users where userId='"+id+"'");
修改:int a=sm.executeUpdate("use spdb;update users set username='"+name+"',passwd='"+passwd+"',email='"+email+"',grade='"+grade+"' where userId='"+userId+"'");
- 1
- 2
前往页