fwsjdeleteaction.java

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

package com.comingnet.action;

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

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

public class FwsjDeleteAction extends ActionSupport {

	private static final long serialVersionUID = 3937626992733592865L;
	private int fwid=0;

	public int getFwid() {
		return fwid;
	}

	public void setFwid(int fwid) {
		this.fwid = fwid;
	}

	@Override
	public String execute() throws Exception {
		Connection conn = null;
		PreparedStatement stmt = null;
		System.out.println(fwid+"fwid");

		try {
			conn = ProxoolAction.getConnection();
			System.out.println(conn.toString());
			stmt = conn.prepareStatement("delete from m_fwsj where fwid="
					+ fwid);
			stmt.executeUpdate();
			
			System.out.println("文件已经删除");
		} catch (Exception e) {
			System.out.println(e.toString()+"错误");
			return ERROR;
		} finally {
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
		return SUCCESS;
	}
}