frupdate.java

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

package com.comingnet.action;

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

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

public class frUpdate extends ActionSupport {
	private int frid;

	private String ljmc;

	private String ljdz;

	private String ljbz;

	private static final long serialVersionUID = -474288677280030220L;

	
	public String execute() throws Exception {
		Connection conn = null;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		try {
			conn = ProxoolAction.getConnection();
			stmt = conn
					.prepareStatement("select frmc,frdz,frbz from frlist where frid="
							+ frid);
			rs = stmt.executeQuery();
			while (rs.next()) {
				ljmc = rs.getString(1);
				ljdz = rs.getString(2);
				ljbz = rs.getString(3);
			}
		} catch (Exception e) {
			System.out.println(e.toString());
			return ERROR;
		} finally {
			ProxoolAction.closeResultSet(rs);
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
		return SUCCESS;
	}

	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;
	}

}