sendarticleaction.java

功能是公安和学校的管理系统,用struts+hibernate+spring等匡架组成,在eclepse就能编译

package com.comingnet.action;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;
import com.db.ProxoolAction;
import com.opensymphony.xwork2.ActionSupport;

public class sendarticleAction extends ActionSupport implements
		UserSessionAware {

	private static final long serialVersionUID = -378733649024478778L;

	private List<HashMap<String, String>> FirstLmList = null;

	private List<HashMap<String, String>> SecondLmList = null;
	
	private List<HashMap<String, HashMap<String, String>>>  doubleselect=null;

	public List<HashMap<String, String>> getFirstLmList() {
		return FirstLmList;
	}

	public void setFirstLmList(List<HashMap<String, String>> firstLmList) {
		FirstLmList = firstLmList;
	}

	public List<HashMap<String, String>> getSecondLmList() {
		return SecondLmList;
	}

	public void setSecondLmList(List<HashMap<String, String>> secondLmList) {
		SecondLmList = secondLmList;
	}

	private UserInfor userSession = null;
	private String auid_test = "6";

	public String getAuid_test() {
		return auid_test;
	}

	public void setAuid_test(String auid_test) {
		this.auid_test = auid_test;
	}

	public UserInfor getUserSession() {
		return userSession;
	}

	public void setUserSession(UserInfor userSession) {
		this.userSession = userSession;
	}

	@Override
	public String execute() throws Exception {

		Connection conn = null;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		String flag = "";

		try {
			FirstLmList = new ArrayList<HashMap<String, String>>();
			HashMap<String, String> pair = null;
			conn = ProxoolAction.getConnection();
			stmt = conn.prepareStatement("select lmid,lmmc from w_lmb");
			rs = stmt.executeQuery();
			while (rs.next()) {
				pair = new HashMap<String, String>();
				pair.put("lmid", new Integer(rs.getInt(1)).toString());
				pair.put("lmmc", rs.getString(2));
				FirstLmList.add(pair);
			}
			System.out.println(FirstLmList.toString());
			flag = SUCCESS;
		} catch (Exception e) {
			System.out.println(e.toString());
			flag = ERROR;
		}finally{
			ProxoolAction.closeResultSet(rs);
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
		return flag;
	}

	public List<HashMap<String, HashMap<String, String>>> getDoubleselect() {
		return doubleselect;
	}

	public void setDoubleselect(
			List<HashMap<String, HashMap<String, String>>> doubleselect) {
		this.doubleselect = doubleselect;
	}
}