zclyinsert.java

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

package com.comingnet.action;

import java.sql.Connection;
import java.sql.PreparedStatement;


import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;
import com.db.KeyGenerator;
import com.db.ProxoolAction;
import com.opensymphony.xwork2.ActionSupport;

public class zclyinsert extends ActionSupport implements UserSessionAware {
	private static final long serialVersionUID = -458348625733395046L;

	private UserInfor userSession = null;

	private String auid_test = "12";

	private int zcmc;

	private int zcsl;

	private String lyr;

	private String shrxm = "0";

	private String yt;

	private String lysj;

	public String getAuid_test() {
		return auid_test;
	}

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

	public String getLyr() {
		return lyr;
	}

	public void setLyr(String lyr) {
		this.lyr = lyr;
	}

	public String getLysj() {
		return lysj;
	}

	public void setLysj(String lysj) {
		this.lysj = lysj;
	}

	public UserInfor getUserSession() {
		return userSession;
	}

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

	public String getYt() {
		return yt;
	}

	public void setYt(String yt) {
		this.yt = yt;
	}

	public int getZcmc() {
		return zcmc;
	}

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

	public int getZcsl() {
		return zcsl;
	}

	public void setZcsl(int zcsl) {
		this.zcsl = zcsl;
	}

	@Override
	public String execute() throws Exception {

		Connection conn = null;
		PreparedStatement stmt = null;
		String userxm = userSession.getUserxm();

		System.out.println(userxm);
		int ass_ly_id = KeyGenerator.getInstance().getNextKey("assets_ly");
		try {
			conn = ProxoolAction.getConnection();
			stmt = conn
					.prepareStatement("insert into assets_ly(ass_ly_id,ass_id,ass_ly_name,ass_ly_shr,ass_ly_lrr,ass_ly_sl,ass_ly_lrsj,ass_ly_sj,ass_ly_yt,ass_cu_sl) values(?,?,?,?,?,?,getDate(),?,?,?)");
			stmt.setInt(1, ass_ly_id);
			stmt.setInt(2, zcmc);
			stmt.setString(3, lyr);
			stmt.setString(4, getShrxm());
			stmt.setString(5, userxm);
			stmt.setInt(6, zcsl);
			stmt.setString(7, lysj);
			stmt.setString(8, yt);
			stmt.setInt(9,zcsl);
			stmt.executeUpdate();
		} catch (Exception e) {
			System.out.println(e.toString());
			return ERROR;
		} finally {
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
		return SUCCESS;
	}
	public String getShrxm() {
		return shrxm;
	}

	public void setShrxm(String shrxm) {
		this.shrxm = shrxm;
	}

}