bfaddsubaction.java

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

package com.comingnet.action;

import com.comingnet.bean.AssetsBfInfor;
import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;
import com.opensymphony.xwork2.ActionSupport;
import com.db.*;
import java.sql.*;
public class bfAddSubAction extends ActionSupport implements UserSessionAware{
	private UserInfor userSession=null;
	private String auid_test="12";
	private AssetsBfInfor assbfinfor=null;
	private String errormsg="";
	
	
	
	public String getErrormsg() {
		return errormsg;
	}
	public void setErrormsg(String errormsg) {
		this.errormsg = errormsg;
	}
	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 UserInfor getUserSession() {
		return userSession;
	}
	public void setUserSession(UserInfor userSession) {
		this.userSession = userSession;
	}
	
	public String execute()
	{
        if(assbfinfor.getCusl()<assbfinfor.getBfsl())
        {
        	errormsg="报废数量超出了当前剩余数量!";
        	setErrormsg(errormsg);
        	setAssbfinfor(assbfinfor);
        	return ERROR;
        }
        if(assbfinfor.getZcshr()==null||assbfinfor.getZcshr().equals(""))
        {
        	errormsg="请输入审核人姓名";
        	return ERROR;
        }
		Connection conn=null;
		PreparedStatement stmt=null;
        try
        {
        	conn=ProxoolAction.getConnection();
        	stmt=conn.prepareStatement("insert into assets_bf(bf_id,ass_ly_id,bf_sl,bf_shr,bf_sj,bf_yy) values(?,?,?,?,getdate(),?)");
        	stmt.setInt(1,KeyGenerator.getInstance().getNextKey("assets_bf"));
        	stmt.setInt(2, assbfinfor.getLyid());
        	stmt.setFloat(3, assbfinfor.getBfsl());
        	stmt.setString(4, assbfinfor.getZcshr());
        	stmt.setString(5,assbfinfor.getBfyy());
            int i=stmt.executeUpdate();
            if(i>0)
            {
            	ProxoolAction.closeStatement(stmt);
            	stmt=conn.prepareStatement("update assets_ly set ass_cu_sl=? where ass_ly_id=?");
            	stmt.setFloat(1, assbfinfor.getCusl()-assbfinfor.getBfsl());
            	stmt.setInt(2,assbfinfor.getLyid());
            	stmt.executeUpdate();
            }
        }catch(Exception e)
        {
        	System.out.println(e);
        }finally
        {
           DBUtils.closeStatement(stmt);
           DBUtils.closeConnection(conn);	
        }
		return SUCCESS;
	}

}