quanxiandel.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 QuanxianDel extends ActionSupport {

	private static final long serialVersionUID = -3905389302646518039L;

	private int qxid;

	public int getQxid() {
		return qxid;
	}

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

	@Override
	public String execute() throws Exception {
		System.out.println("权限ID" + qxid);
		Connection conn = null;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		try{
		conn = ProxoolAction.getConnection();
		stmt = conn.prepareStatement("select * from auth_list where qxid="
				+ qxid);
		rs = stmt.executeQuery();
		while (rs.next())
			return SUCCESS;
		}catch(Exception e)
		{
			System.out.println(e.toString());
			return ERROR;
		}finally{
			ProxoolAction.closeResultSet(rs);
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
	
		conn=ProxoolAction.getConnection();
		stmt = conn.prepareStatement("delete from systemauth where qxid="
				+ qxid);
		int i = stmt.executeUpdate();
		System.out.println("i的值" + i);
		ProxoolAction.closeStatement(stmt);
		ProxoolAction.closeConnection(conn);
		if (i == 1)
			return SUCCESS;
		else
			return ERROR;

	}

}