schooldelaction.java

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

package com.comingnet.action;
import com.opensymphony.xwork2.ActionSupport;
import com.db.DBUtils;
import java.sql.*;
public class schoolDelAction extends ActionSupport{
	private String sid;
    private String pageno;
    private String auid;
    
	public String getAuid() {
		return auid;
	}
	public void setAuid(String auid) {
		this.auid = auid;
	}

	public String getPageno() {
		return pageno;
	}

	public void setPageno(String pageno) {
		this.pageno = pageno;
	}

	public String getSid() {
		return sid;
	}  

	public void setSid(String sid) {
		this.sid = sid;
	}
 
	public String execute()
	{
		String flag=ERROR;
		Connection conn=null;
		PreparedStatement stmt=null;
		try
		{
			conn=DBUtils.getConnection();
			stmt=conn.prepareStatement("delete from ms_school where ms_xxid=?");
			stmt.setString(1,getSid());
			stmt.executeUpdate();
			DBUtils.closeStatement(stmt);
			setPageno(getPageno());
			flag=SUCCESS; 
		}catch(Exception e)
		{
			flag=ERROR;
		}finally
		{
			DBUtils.closeStatement(stmt);
			DBUtils.closeConnection(conn);
		}
       return flag;
	}

}