用标准Struts2+mvc写的用户管理 - JAVA

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便进入主页面

用标准Struts2+mvc写的用户管理(二)