frinsert.java

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

package com.comingnet.action;

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

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

public class frinsert extends ActionSupport {

	private static final long serialVersionUID = 700246082086007533L;

	private String ljmc;

	private String ljdz;

	private String ljbz;

	public String getLjmc() {
		return ljmc;
	}

	public void setLjmc(String ljmc) {
		this.ljmc = ljmc;
	}

	public String getLjdz() {
		return ljdz;
	}

	public void setLjdz(String ljdz) {
		this.ljdz = ljdz;
	}

	public String getLjbz() {
		return ljbz;
	}

	public void setLjbz(String ljbz) {
		this.ljbz = ljbz;
	}

	@Override
	public String execute() throws Exception {
		Connection conn = null;
		PreparedStatement stmt = null;
		conn = ProxoolAction.getConnection();
		int frid = KeyGenerator.getInstance().getNextKey("frlist");
		stmt = conn
				.prepareStatement("insert into frlist (frid,frmc,frdz,frbz) values(?,?,?,?)");
		stmt.setInt(1, frid);
		stmt.setString(2, ljmc);
		stmt.setString(3, ljdz);
		stmt.setString(4, ljbz);
		int i = stmt.executeUpdate();
		ProxoolAction.closeStatement(stmt);
		ProxoolAction.closeConnection(conn);
		if (i == 1)
			return SUCCESS;
		else
			return ERROR;
	}

}