auryaddsubaction.java

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

package com.comingnet.action;
import com.opensymphony.xwork2.ActionSupport;
import com.db.*;
import java.sql.*;
public class AuryAddSubAction extends ActionSupport{
	private String qxmc;
	private int qxid;
	private String rymc;
	private int ryid;
	private String ryclass;
	public int getQxid() {
		return qxid;
	}
	public void setQxid(int qxid) {
		this.qxid = qxid;
	}
	public String getQxmc() {
		return qxmc;
	}
	public void setQxmc(String qxmc) {
		this.qxmc = qxmc;
	}
	public String getRyclass() {
		return ryclass;
	}
	public void setRyclass(String ryclass) {
		this.ryclass = ryclass;
	}
	public int getRyid() {
		return ryid;
	}
	public void setRyid(int ryid) {
		this.ryid = ryid;
	}
	public String getRymc() { 
		return rymc;
	}
	public void setRymc(String rymc) {
		this.rymc = rymc;
	}
	public String execute()
	{
      String flag=ERROR;
	  Connection conn=null;
      PreparedStatement stmt=null;
 	  try
	  {
		conn=DBUtils.getConnection();
		stmt=conn.prepareStatement("insert into auth_list(qx_ry_id,qxid,ryid,ryclass,ryname) values(?,?,?,?,?)");
		stmt.setInt(1,KeyGenerator.getInstance().getNextKey("auth_list"));
		stmt.setInt(2,getQxid());
		stmt.setInt(3,getRyid());
		stmt.setString(4,getRyclass());
		stmt.setString(5,getRymc());
		stmt.executeUpdate();
		flag=SUCCESS;
	  }catch(Exception e)
	  {
			
	  }finally
	  {
		 DBUtils.closeStatement(stmt);
		 DBUtils.closeConnection(conn);
	  }
		
		return flag;
	}

}