myschoollistaction.java

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

package com.comingnet.action;
import java.util.*;
import com.opensymphony.xwork2.ActionSupport;
import com.db.DBUtils;
import java.sql.*;
import com.db.page;
import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;

public class MySchoolListAction extends ActionSupport implements UserSessionAware{

List schoollist=null; 
 
private UserInfor userSession=null;  //用户 类

public static String auid_test="3";

public String  getAuid_test()
{
	return auid_test;
}
public UserInfor getUserSession() {
	return userSession;
}
public void setUserSession(UserInfor userSession) {
	this.userSession = userSession;
}
  
public List getSchoollist() {
	return schoollist;
}
public void setSchoollist(List schoollist) {
	this.schoollist = schoollist;
}

 
public String execute()
{
	UserInfor userinfor=getUserSession();
	System.out.println("在MySchoolListAction中得到登录用户名:"+userinfor.getUserxm());		               	 
	
	String flag;
	List newlist=new ArrayList();
	Connection conn=null;
	ResultSet rs=null;
	PreparedStatement stmt=null;

	  try
	  {
		conn=DBUtils.getConnection();
		stmt=conn.prepareStatement("select * from ms_school where ms_xxid="+userinfor.getUserxxbh());	 
		rs=stmt.executeQuery(); 
		String name="";
		String nameStr="user_xh";
		int j=0;
		
		HashMap row=null;
		ResultSetMetaData rsmd=rs.getMetaData();
        int columnCount=rsmd.getColumnCount();	
        while(rs.next())
   	     {
              j++;
        	  row=new HashMap();
          	  for(int i=1;i<=columnCount;i++)
          	   {
                   name=rsmd.getColumnName(i);
                   row.put(nameStr,""+j);
                   row.put(name.toLowerCase(),rs.getString(i));
                }
          	  
          newlist.add(row);
          System.out.println("ddddddddddddddddd:"+newlist);
         }
        setSchoollist(newlist);   
		flag=SUCCESS;
	  }catch(Exception e)
	  {
		  System.out.println(e);
		  flag=ERROR;
      }finally
	  {
    	  DBUtils.closeResultSet(rs);
    	  DBUtils.closeStatement(stmt);
    	  DBUtils.closeConnection(conn);
	  }
   return flag;
 }
}