frdel.java

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

package com.comingnet.action;

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

import com.db.ProxoolAction;
import com.opensymphony.xwork2.ActionSupport;

public class frDel extends ActionSupport {
	int frid;

	private static final long serialVersionUID = 2667942412700110352L;

	public int getFrid() {
		return frid;
	}

	public void setFrid(int frid) {
		this.frid = frid;
	}

	@Override
	public String execute() throws Exception {

		Connection conn = null;
		PreparedStatement stmt = null;

		conn = ProxoolAction.getConnection();
		stmt = conn.prepareStatement("delete from frlist where frid=" + frid);
		int i = stmt.executeUpdate();

		ProxoolAction.closeStatement(stmt);
		ProxoolAction.closeConnection(conn);
		if (i == 1)
			return SUCCESS;
		else
			return ERROR;

	}

}