java怎样删除列表中一条记录

来源:百度知道 编辑:UC知道 时间:2024/05/29 10:18:03
怎样写删除,修改方法,freemarker如何显示,帮忙改写一下,谢谢啦!
//只写了关键部分,能成功显示出数据库中用户列表,但是如何点击链接删除,修改用户信息.帮忙修改下!
谢谢~~!

//删除用户
public String delete(int id){
try{
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=denglu";
String userName = "han"; String userPwd = "123"; Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
stml=dbConn.createStatement();
stml.executeUpdate("delete from test where id=''+id");//数据库里删除没问题了,就是怎么用freemarker <a href="delete.do?id= ">del,这里的id=应该怎么写,我已经用list显示出来数据库里内容了,望指点!
// }
}catch(Exception e){
e.printStackTrace();
}
return "success";

//删除用户
public String delete(id){
try{
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=denglu";
String userName = "han"; String userPwd = "123"; Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
stml=dbConn.createStatement();
stml.executeUpdate("delete from test where id='" + id +"'");

}catch(Exception e){
e.printStackTrace();
}
return "success";
}
// 修改用户操作
public String modify(id){

try{
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=denglu";