zcrkdeleteaction.java

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

package com.comingnet.action;

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

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

public class ZcrkDeleteAction extends ActionSupport {
	
	private static final long serialVersionUID = -948776543807501778L;

	private int zcid = 0;

	public int getZcid() {
		return zcid;
	}

	public void setZcid(int zcid) {
		this.zcid = zcid;
	}

	@Override
	public String execute() throws Exception {
		Connection conn=null;
		PreparedStatement stmt=null;
		try {
			conn=ProxoolAction.getConnection();
			stmt=conn.prepareStatement("delete from assets_dz where asset_id="+zcid);
			stmt.executeUpdate();
		} catch (Exception e) {
			System.out.println(e.toString());
			return ERROR;
		}finally{
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
		return SUCCESS;
	}
}