useraction.java

使用ajaxanywhere的一个小的demo,个人感觉很不错,大家可以研究一下

/**
 * 
 */
package com.test.action;

import java.sql.Connection;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.DynaActionForm;
import org.apache.struts.actions.DispatchAction;

import com.dbconn.bean.Conn;
import com.dbconn.bean.UserBean;

/**
 * @author shk
 *
 */
public class UserAction extends DispatchAction {

	Conn test = new Conn();
	
	/**
	 * 添加用户
	 */
	public ActionForward addUser(ActionMapping mapping, ActionForm actionForm,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		DynaActionForm form = (DynaActionForm)actionForm;
		
		Connection conn = test.getConn();
		
		java.sql.Statement stmt = conn.createStatement();
		
		stmt.executeUpdate("INSERT INTO users (`NAME`, `PASSWORD`) VALUES ('"+(String)form.get("name")+"', '"+(String)form.get("password")+"')");
		
		stmt.close();
		
		conn.close();
		
		return mapping.findForward("test");
	}
	
	/**
	 * 用户列表
	 */
	public ActionForward userList(ActionMapping mapping, ActionForm actionForm,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		
		DynaActionForm form = (DynaActionForm)actionForm;
		
		//Conn test = new Conn();
		
		Connection conn = test.getConn();
		
		java.sql.Statement stmt = conn.createStatement();
		
		java.sql.ResultSet rs = stmt.executeQuery("select * from users");
		
		List<UserBean> result = new ArrayList<UserBean>();
		
		try {
			if (rs != null) {
				while (rs.next()) {
					UserBean userBean = new UserBean();
					
					userBean.setId(rs.getLong("id"));
					userBean.setName(rs.getString("name"));
					userBean.setPassword(rs.getString("password"));
					
					result.add(userBean);
				}
			}
		} catch (java.sql.SQLException e) {
			e.printStackTrace();
		} finally {
			rs.close();
			
			stmt.close();
			
			conn.close();
		}
		
		// 返回查询结果
		form.set("result", result);
		return mapping.findForward("userList");
	}

}