quanxianinsertaction.java

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

package com.comingnet.action;

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

import com.db.KeyGenerator;
import com.db.ProxoolAction;
import com.opensymphony.xwork2.ActionSupport;

public class Quanxianinsertaction extends ActionSupport {

	private static final long serialVersionUID = 5218534142992016008L;

	private String qxmc;

	private String qxlb;

	private String qxms;

	public String getQxlb() {
		return qxlb;
	}

	public void setQxlb(String qxlb) {
		this.qxlb = qxlb;
	}

	public String getQxmc() {
		return qxmc;
	}

	public void setQxmc(String qxmc) {
		this.qxmc = qxmc;
	}

	public String getQxms() {
		return qxms;
	}

	public void setQxms(String qxms) {
		this.qxms = qxms;
	}

	@Override
	public String execute() throws Exception {
		Connection conn = null;
		PreparedStatement stmt = null;
		conn = ProxoolAction.getConnection();
		int qxid = KeyGenerator.getInstance().getNextKey("systemauth");
		stmt = conn
				.prepareStatement("insert into systemauth (qxid,qxlb,qxmc,qxms) values(?,?,?,?)");
		stmt.setInt(1, qxid);
		stmt.setString(2, qxlb);
		stmt.setString(3, qxmc);
		stmt.setString(4, qxms);
		int i = stmt.executeUpdate();
		ProxoolAction.closeStatement(stmt);
		ProxoolAction.closeConnection(conn);
		if (i == 1)
			return SUCCESS;
		else
			return ERROR;
	}

}