aurydeleteaction.java

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

package com.comingnet.action;

import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;
import com.opensymphony.xwork2.ActionSupport;
import com.db.DBUtils;
import java.sql.*;
public class AuryDeleteAction extends ActionSupport implements UserSessionAware{
	private UserInfor userSession=null;
	private String auid_test;
	private String qxryid;
	private String qxid;
	
	public String getQxid() { 
		return qxid;
	}
	public void setQxid(String qxid) {
		this.qxid = qxid;
	}
	public String getQxryid() {
		return qxryid;
	}
	public void setQxryid(String qxryid) {
		this.qxryid = qxryid;
	}
	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 String execute()
	{
		Connection conn=null;
		PreparedStatement stmt=null;
		String flag=ERROR;
		try
		{
		   conn=DBUtils.getConnection();
		   stmt=conn.prepareStatement("delete from auth_list where qx_ry_id=?");
		   stmt.setString(1,getQxryid());
		   stmt.executeUpdate();
		   flag=SUCCESS;
		}catch(Exception e)
		{
			System.out.println(e);
		}finally
		{
			DBUtils.closeStatement(stmt);
			DBUtils.closeConnection(conn);
		}
		
		return flag;
	}

}