quanxianupdate.java

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

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 QuanxianUpdate extends ActionSupport {
	private int qxid;

	private String qxmc;

	private String qxlb;

	private String qxms;

	private static final long serialVersionUID = -474288677280030220L;

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

	public int getQxid() {
		return qxid;
	}

	public void setQxid(int qxid) {
		this.qxid = qxid;
	}

	public String execute() throws Exception {
		Connection conn = null;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		try {
			conn = ProxoolAction.getConnection();
			stmt = conn
					.prepareStatement("select qxlb,qxmc,qxms from systemauth where qxid="
							+ qxid);
			rs = stmt.executeQuery();
			while (rs.next()) {
				qxlb = rs.getString(1);
				qxmc = rs.getString(2);
				qxms = 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;
	}
}