onlineuserinforaction.java

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

package com.comingnet.action;

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

public class onlineUserInforAction extends ActionSupport implements UserSessionAware{
	private UserInfor userSession=null;
	private String auid_test="5";
	private OnlineUserInfor onlineUserInfor=null;
	private int zxid;
	private String userclass;
	
	
	public String getUserclass() {
		return userclass;
	}
	public void setUserclass(String userclass) {
		this.userclass = userclass;
	}
	public int getZxid() {
		return zxid;
	}
	public void setZxid(int zxid) {
		this.zxid = zxid;
	}
	public OnlineUserInfor getOnlineUserInfor() {
		return onlineUserInfor;
	}
	public void setOnlineUserInfor(OnlineUserInfor onlineUserInfor) {
		this.onlineUserInfor = onlineUserInfor;
	}
	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 String execute()
   {
	   Connection conn=null;
	   PreparedStatement stmt=null;
	   ResultSet rs=null;
	   onlineUserInfor=new OnlineUserInfor();
	   try
	   {
		   conn=ProxoolAction.getConnection();
		   String sqlStr="";
		   if(getUserclass().equals("1"))
			   sqlStr="select jsjtzz,CONVERT(varchar(20),zxcssj,120) as zxcssj,userclass,userip,jssjhm,jsxb,jsxm,ms_xxmc from xtzxb a,m_teacher b,ms_school c where a.zxzh=b.jszh and a.zxid=? and b.xxbh=c.ms_xxid;";
		   else if(getUserclass().equals("2"))
			   sqlStr="select xsjtdz,CONVERT(varchar(20),zxcssj,120) as zxcssj,userclass,userip,xsdh,xsxb,xsxm,ms_xxmc from xtzxb a,m_student b,ms_school c where a.zxzh=b.xszh and a.zxid=? and b.xxbh=c.ms_xxid";
		   stmt=conn.prepareStatement(sqlStr);
		   stmt.setInt(1,getZxid());
		   rs=stmt.executeQuery();
		   if(rs.next())
		   {
			   onlineUserInfor.setJtdz(rs.getString(1));
			   onlineUserInfor.setSxsj(rs.getString(2));
			   onlineUserInfor.setUserclass(rs.getString(3));
			   onlineUserInfor.setUserip(rs.getString(4));
			   onlineUserInfor.setUsermobile(rs.getString(5));
			   onlineUserInfor.setUserxb(rs.getString(6));
			   onlineUserInfor.setUserxm(rs.getString(7));
			   onlineUserInfor.setXxmc(rs.getString(8));
		   }
		   setOnlineUserInfor(onlineUserInfor);
	   }catch(Exception e)
	   {
		   System.out.println(e);
	   }finally
	   {
		   ProxoolAction.closeResultSet(rs);
		   ProxoolAction.closeStatement(stmt);
		   ProxoolAction.closeConnection(conn);
	   }
	   return SUCCESS;
   }
}