lmmanageaction.java

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

package com.comingnet.action;

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

import com.db.ProxoolAction;
import com.opensymphony.xwork2.ActionSupport;

public class lmmanageAction extends ActionSupport {

	private static final long serialVersionUID = 0L;

	List<HashMap<String, String>> lmlist = null;

	@Override
	public String execute() throws Exception {
		Connection conn = null;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		String flag = "";
		try {
			conn = ProxoolAction.getConnection();
			stmt = conn.prepareStatement("select lmid,lmmc from w_lmb");
			rs = stmt.executeQuery();

			String name = "";
			String nameStr = "user_xh";
			int j = 0;
			HashMap<String, String> row = null;

			ResultSetMetaData rsmd = rs.getMetaData();
			int columncount = rsmd.getColumnCount();
			lmlist = new ArrayList<HashMap<String, String>>();

			while (rs.next()) {
				j++;
				row = new HashMap<String, String>();
				
				for (int i = 1; i <= columncount; i++) {
					row.put(nameStr, "" + j);
					name = rsmd.getColumnName(i);
					row.put(name.toLowerCase(), rs.getString(i));
				}
				lmlist.add(row);

			}
			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, String>> getLmlist() {
		return lmlist;
	}

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