bfaddaction.java

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

package com.comingnet.action;

import com.comingnet.bean.*;
import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;
import com.opensymphony.xwork2.ActionSupport;
import java.sql.*;
import com.db.ProxoolAction;
public class bfAddAction extends ActionSupport implements UserSessionAware{
	private UserInfor userSession=null;
	private String auid_test="12";
	private String lyid;
	private AssetsBfInfor assbfinfor=null;
	
	
	public AssetsBfInfor getAssbfinfor() {
		return assbfinfor;
	}
	public void setAssbfinfor(AssetsBfInfor assbfinfor) {
		this.assbfinfor = assbfinfor;
	}
	public String getAuid_test() {
		return auid_test;
	}
	public void setAuid_test(String auid_test) {
		this.auid_test = auid_test;
	}
	public String getLyid() {
		return lyid;
	}
	public void setLyid(String lyid) {
		this.lyid = lyid;
	}
	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;
		System.out.println("领用ID："+getLyid());
		assbfinfor=new AssetsBfInfor();
		try
		{
			conn=ProxoolAction.getConnection();
			stmt=conn.prepareStatement("select ass_ly_id,asset_mc,ass_ly_name,ass_ly_sl,ass_cu_sl from assets_ly a,assets_dz b where a.ass_id=b.asset_id and a.ass_ly_id=?");
			stmt.setString(1,getLyid());
			rs=stmt.executeQuery();
			if(rs.next());
			{
				assbfinfor.setZcmc(rs.getString("asset_mc"));      //资产名称
				assbfinfor.setLyr(rs.getString("ass_ly_name"));    //领用人
				assbfinfor.setLysl(rs.getFloat("ass_ly_sl"));      //领用数量
				assbfinfor.setCusl(rs.getFloat("ass_cu_sl"));      //当前数量
				assbfinfor.setLyid(rs.getInt("ass_ly_id"));        //领用ID
				assbfinfor.setZcshr("");
				assbfinfor.setBfyy("");
			}
			setAssbfinfor(assbfinfor);
		}catch(Exception e)
		{
			
		}finally
		{
			
		}
		return SUCCESS;
	}

}