sublmdetailaction.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 sublmdetailAction extends ActionSupport {

	
	private static final long serialVersionUID = -3624155170890676471L;
	
	private int lmid=0;
	
	private List<HashMap<String, String>> sublmlist=null;

	public int getLmid() {
		return lmid;
	}

	public void setLmid(int lmid) {
		this.lmid = lmid;
	}
	
	

	public List<HashMap<String, String>> getSublmlist() {
		return sublmlist;
	}

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

	@Override
	public String execute() throws Exception {
		
		String flag="";
		
		Connection conn=null;
		PreparedStatement stmt=null;
		ResultSet rs=null;
		
		try{
			conn=ProxoolAction.getConnection();
			stmt=conn.prepareStatement("select slmid,slmmc from w_sublmb where sjlmid="+lmid);
			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();
			sublmlist = 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));
				}
				sublmlist.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;
	}
}