inboxqsaction.java

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

package com.comingnet.action;
import com.comingnet.intercepter.UserSessionAware;
import com.opensymphony.xwork2.ActionSupport;
import java.util.*;
import com.db.DBUtils;
import java.sql.*;
import com.comingnet.bean.UserInfor;
import com.db.KeyGenerator;
public class inboxQsAction extends ActionSupport implements UserSessionAware{

	private String fwid;
    private String auid;
    private UserInfor userSession=null;
    private String auid_test;
    
	public String getAuid_test() {
		return auid_test;
	}
	public void setAuid_test(String auid_test) {
		this.auid_test = auid_test;
	}
	public UserInfor getUserSession() {
		return userSession;
	}
	public void setUserSession(UserInfor userSession) {
		this.userSession = userSession;
	}
	public String getAuid() {
		return auid;
	}
	public void setAuid(String auid) {
		this.auid = auid;
	}
	public String getFwid() {
		return fwid;
	}
	public void setFwid(String fwid) {
		this.fwid = fwid;
	}
	public String execute()
	{
	    String flag=ERROR;
		Connection conn=null;
	    PreparedStatement stmt=null;
	    
		System.out.println("公文ID："+getFwid());	
	    UserInfor userinfor=getUserSession();
	    try
	    {
	       conn=DBUtils.getConnection();
	       stmt=conn.prepareStatement("insert into m_fwsj(sjid,fwid,sjrid,sjrlb,sjqszt,sjqssj) values(?,?,?,?,'1',getdate())");
	       stmt.setInt(1,KeyGenerator.getInstance().getNextKey("m_fwsj"));
	       stmt.setString(2,getFwid());
	       stmt.setInt(3,userinfor.getUserid());
	       stmt.setString(4,userinfor.getUserclass());
	       stmt.executeUpdate();
	       flag=SUCCESS;
	    }catch(Exception e)
	    {
	    	
	    }finally 
	    {
	    	DBUtils.closeStatement(stmt);
	    	DBUtils.closeConnection(conn);
	    }
	    return flag;
	}
}