sp; model.put("user",user);
return "edit";
}
上一页 [1] [2] [3] 下一页
public String execute_view()throws Exception{
Map user = null;
String objectid = (String)model.get("objectid");
String sql = "select * from t_user where id='"+objectid+"'";
conn = DBUtil.getConn();
user = DBUtil.queryOne(conn,sql,null);
//sql = "select * from t_user where id=?"
//user = DBUtil.queryOne(conn,sql,new Object[]{objectid});
if(user==null){
return "no_object";
}
model.put("user",user);
return "view";
}
public String execute_update()throws Exception{
String table = "t_user";
String cols = "id,name,hh,ww,birth_day";
int autoPK = 1;//主键是否自增 ，max(id)+1
conn = DBUtil.getConn();
DBUtil.updateRow(conn,table,cols,1,model);
return "!query";
}
public String execute_delete()throws Exception{
String sql = "delete from t_user where id ";
DBUtil.batchDelById(sql,request);
return "!query";
}
private void createTable(){
String 上一页 [1] [2] [3] [4] [5] [6] 下一页
|
