inboxtjaction.java

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

package com.comingnet.action;

import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;
import com.opensymphony.xwork2.ActionSupport;
import java.sql.*;
import com.db.*;
public class inboxTjAction extends ActionSupport implements UserSessionAware{
	
	private int sjid;    
    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 int getSjid() {
		return sjid;
	}
	public void setSjid(int sjid) {
		this.sjid = sjid;
	}
	public UserInfor getUserSession() {
		return userSession;
	}
	public void setUserSession(UserInfor userSession) {
		this.userSession = userSession;
	}
    
	public String execute()
	{
		Connection conn=null;
		PreparedStatement stmt=null;
		try
		{
		   conn=DBUtils.getConnection();
		   stmt=conn.prepareStatement("update m_fwsj set sjblzt='1' , sjblsj=getdate() where sjid=?");
		   stmt.setInt(1,getSjid());
		   stmt.executeUpdate();
		}catch(Exception e)
		{
			
		}finally
		{
           DBUtils.closeStatement(stmt);
           DBUtils.closeConnection(conn);
		}
		return SUCCESS;
	}

}