assetsaddaction.java

来自「功能是公安和学校的管理系统,用struts+hibernate+spring等匡」· Java 代码 · 共 218 行

package com.comingnet.action;

import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;
import com.opensymphony.xwork2.ActionSupport;
import com.db.*;
import java.sql.*;
public class AssetsAddAction extends ActionSupport implements UserSessionAware{
	
	
	private String zcmc;
	private int zclb;
	private String zcgg;
	private float zcsl;
	private String jldw;
	private float zcdj;
	private String zcgrr;
	private String zcshr;
	private int zccfd;
	private String grsj;
	private String operateType;
	private UserInfor userSession=null;
	private String auid_test;
    private int zcid;
	
    
	public int getZcid() {
		return zcid;
	}


	public void setZcid(int zcid) {
		this.zcid = zcid;
	}


	public String getOperateType() {
		return operateType;
	}


	public void setOperateType(String operateType) {
		this.operateType = operateType;
	}


	public String getAuid_test() {
		return auid_test;
	}


	public void setAuid_test(String auid_test) {
		this.auid_test = auid_test;
	}


	public String getGrsj() {
		return grsj;
	}


	public void setGrsj(String grsj) {
		this.grsj = grsj;
	}


	public String getJldw() {
		return jldw;
	}


	public void setJldw(String jldw) {
		this.jldw = jldw;
	}


	public UserInfor getUserSession() {
		return userSession;
	}


	public void setUserSession(UserInfor userSession) {
		this.userSession = userSession;
	}


	public int getZccfd() {
		return zccfd;
	}


	public void setZccfd(int zccfd) {
		this.zccfd = zccfd;
	}


	public float getZcdj() {
		return zcdj;
	}


	public void setZcdj(float zcdj) {
		this.zcdj = zcdj;
	}


	public String getZcgg() {
		return zcgg;
	}


	public void setZcgg(String zcgg) {
		this.zcgg = zcgg;
	}


	public String getZcgrr() {
		return zcgrr;
	}


	public void setZcgrr(String zcgrr) {
		this.zcgrr = zcgrr;
	}


	public int getZclb() {
		return zclb;
	}


	public void setZclb(int zclb) {
		this.zclb = zclb;
	}


	public String getZcmc() {
		return zcmc;
	}


	public void setZcmc(String zcmc) {
		this.zcmc = zcmc;
	}


	public String getZcshr() {
		return zcshr;
	}


	public void setZcshr(String zcshr) {
		this.zcshr = zcshr;
	}


	public float getZcsl() {
		return zcsl;
	}


	public void setZcsl(float zcsl) {
		this.zcsl = zcsl;
	}	
		
	public String execute()
	{
	   Connection conn=null;
	   PreparedStatement stmt=null;
	   try
	   {
		   conn=DBUtils.getConnection();
		  if(getOperateType().equals("add"))
		  {
		   stmt=conn.prepareStatement("insert into assets_dz(asset_id,asset_lbid,asset_mc,asset_grsj,asset_gg,asset_jldw,asset_dj,asset_blr,asset_shr,asset_cfd,asset_rksj,asset_sl) values(?,?,?,?,?,?,?,?,?,?,getdate(),?)");
		   stmt.setInt(1,KeyGenerator.getInstance().getNextKey("assets_dz"));
		   stmt.setInt(2,getZclb());
		   stmt.setString(3,getZcmc());
		   stmt.setString(4,getGrsj());
		   stmt.setString(5,getZcgg());
		   stmt.setString(6,getJldw());
		   stmt.setFloat(7,getZcdj());
		   stmt.setString(8,getZcgrr());
		   stmt.setString(9,getZcshr());
		   stmt.setInt(10,getZccfd());
		   stmt.setFloat(11,getZcsl());
		   stmt.executeUpdate();
		  }else if(getOperateType().equals("edit"))
		  {
			System.out.println("修改信息!");
			stmt=conn.prepareStatement("update assets_dz set asset_lbid=?,asset_mc=?,asset_grsj=?,asset_gg=?,asset_jldw=?,asset_dj=?,asset_blr=?,asset_shr=?,asset_cfd=?,asset_sl=? where asset_id=?");
			stmt.setInt(1,getZclb());
			stmt.setString(2,getZcmc());
			stmt.setString(3,getGrsj());
			stmt.setString(4,getZcgg());
			stmt.setString(5,getJldw());
			stmt.setFloat(6,getZcdj());
			stmt.setString(7,getZcgrr());
			stmt.setString(8,getZcshr());
			stmt.setInt(9,getZccfd());
			stmt.setFloat(10,getZcsl());
			stmt.setInt(11,getZcid());
			stmt.executeUpdate();  
		  }
	   }catch(Exception e)
	   {
		 System.out.println(e);   
	   }finally
	   {
		   DBUtils.closeStatement(stmt);
		   DBUtils.closeConnection(conn);
	   }
		
		return SUCCESS;
	}

}