d edit(int id,String username,String password){ try { sql="update user set username='"+username+"', password='"+password+"' where id='"+id+"'"; stmt.executeUpdate(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }
下面是一个Action类UserAction.java，struts都是用action处理的
import java.util.ArrayList;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts2.ServletActionContext;
import com.opensymphony.xwork2.ActionSupport;
public class UserAction extends ActionSupport{
int id;
String username;
String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String queryAll(){
QueryUpdate qu=new QueryUpdate();
ArrayList
users=new ArrayList
(); users=qu.queryAll(); HttpServletRequest request=ServletActionContext.getRequest(); request.setAttribute("all", users); return "success"; } public String queryUserById(){ QueryUpdate qu=new QueryUpdate(); User user=new User(); user=qu.queryUserById(this.getId()); HttpServletRequest request=ServletActionContext.getRequest(); request.setAttribute("user", user); return "success"; } public String delete(){ QueryUpdate qu=new QueryUpdate(); qu.delete(this.getId()); return "success"; } public String insert(){ QueryUpdate qu=new QueryUpdate(); qu.insert(this.getUsername(), this.getPassword()); return "success"; } public String edit(){ QueryUpdate qu=new QueryUpdate(); qu.edit(this.getId(),this.getUsername(),this.getPassword()); return "success"; } }
表现层
index.jsp
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib prefix="s" uri="/struts-tags" %>
My JSP 'index.jsp' starting page
添加新用户
编辑更新信息edit.jsp。神了，用struts标签写的不知道为什么编译不过去，后来听同学的改用普通的jsp就可以了
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page isELIgnored="false"%>
My JSP 'edit.jsp' starting page
编号设为只读也可以用disabled="true",差别就是用disabled界面是灰色的看不太清id值；用readonly虽然看起来和username、password差不多，如果想删除id，程序会跳回index.jsp,da
添加新用户insert.java
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib prefix="s" uri="/struts-tags" %>
My JSP 'http://blog.csdn.net/lindonglian/article/details/insert.jsp' starting page
在浏览器输入地址http://localhost:8080/struts2_mvc/queryAll.action便进入主页面
