frupdateaction.java

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

package com.comingnet.action;

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

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

public class frupdateaction extends ActionSupport {

	private int frid;

	private String ljmc;

	private String ljdz;

	private String ljbz;

	private static final long serialVersionUID = 3416190646793131002L;

	public int getFrid() {
		return frid;
	}

	public void setFrid(int frid) {
		this.frid = frid;
	}

	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;
		try {
			conn = ProxoolAction.getConnection();
			stmt = conn
					.prepareStatement("update frlist set frmc=?,frdz=?,frbz=? where frid="
							+ frid);
			stmt.setString(1, ljmc);
			stmt.setString(2, ljdz);
			stmt.setString(3, ljbz);
			int i = stmt.executeUpdate();
		} catch (Exception e) {
			System.out.println(e.getLocalizedMessage());
			return ERROR;
		} finally {
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
		return SUCCESS;
	}
}