zclydel.java

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

package com.comingnet.action;

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

import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;
import com.db.ProxoolAction;
import com.opensymphony.xwork2.ActionSupport;

public class zclydel extends ActionSupport implements UserSessionAware {

	private static final long serialVersionUID = 2105245825848048324L;

	private UserInfor userSession = null;

	private String auid_test = "12";

	private int lyid = 0;

	public String getAuid_test() {
		return auid_test;
	}

	public void setAuid_test(String auid_test) {
		this.auid_test = auid_test;
	}

	public UserInfor getUserSession() {
		return userSession;
	}

	public void setUserSession(UserInfor userSession) {
		this.userSession = userSession;
	}

	public int getLyid() {
		return lyid;
	}

	public void setLyid(int lyid) {
		this.lyid = lyid;
	}

	@Override
	public String execute() throws Exception {

		Connection conn = null;
		PreparedStatement stmt = null;
		try {
			conn = ProxoolAction.getConnection();
			stmt = conn
					.prepareStatement("delete  from assets_ly where ass_ly_id="
							+ lyid);
			stmt.executeUpdate();
		} catch (Exception e) {
			System.out.println(e.toString());
			return ERROR;
		} finally {
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
		return SUCCESS;

	}

}