zclyaddaction.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.TreeMap;
import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;
import com.db.ProxoolAction;
import com.opensymphony.xwork2.ActionSupport;

public class zclyaddaction extends ActionSupport implements UserSessionAware {

	private static final long serialVersionUID = 3595307384629960378L;

	private UserInfor userSession = null;

	private String auid_test = "12";

	private ArrayList<TreeMap<String, String>> zcmclist = null;

	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;
	}

	public ArrayList<TreeMap<String, String>> getZcmclist() {
		return zcmclist;
	}

	public void setZcmclist(ArrayList<TreeMap<String, String>> zcmclist) {
		this.zcmclist = zcmclist;
	}

	@Override
	public String execute() throws Exception {

		Connection conn = null;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		zcmclist=new ArrayList<TreeMap<String,String>>();
		try {
			conn = ProxoolAction.getConnection();
			stmt = conn
					.prepareStatement("select asset_id,asset_mc from assets_dz ");
			rs = stmt.executeQuery();
			while (rs.next()) {
				TreeMap<String, String> zcmcelement = new TreeMap<String, String>();
				zcmcelement.put("id", new Integer(rs.getInt(1)).toString());
				zcmcelement.put("mc", rs.getString(2));		
				zcmclist.add(zcmcelement);
			}
		} catch (Exception e) {
			System.out.println(e.getMessage() + "取得资产名称列表错误");
			return ERROR;
		} finally {
			ProxoolAction.closeResultSet(rs);
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
		return SUCCESS;
	}
}