www.pudn.com > OA.rar > Accept.java

/* 
 * Created on 2004-9-24 
 * 
 * To change the template for this generated file go to 
 * Window>Preferences>Java>Code Generation>Code and Comments 
 */ 
package com.bumf; 
 
import oa.data.Bumf; 
import oa.sys.*; 
import oa.sys.Time; 
import java.io.*; 
import java.sql.*; 
import java.util.*; 
import javax.servlet.*; 
import javax.servlet.http.*; 
/** 
 **************************************************** 
 *类名称：	Accept
 
 *类功能：	公文接收(附件)
 
 *创建：	白伟明	2004年10月9日
 
 **************************************************** 
 * To change the template for this generated type comment go to 
 * Window>Preferences>Java>Code Generation>Code and Comments 
 */ 
public class Accept extends HttpServlet{ 
	private int count; 
	private int sign; 
	private int examine; 
	private int id; 
	private int accepter; 
	private int sendter; 
	private int bumfid; 
	private String axffix; 
	private String content; 
	private String title; 
	private String time; 
	private String sqls; 
	private String sqli; 
	private String submit; 
	private String bumf; 
	private HttpSession session=null; 
	private ResultSet rs=null; 
	private Statement stmt=null; 
	 
	public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{ 
		request.setCharacterEncoding("gb2312"); 
		response.setContentType("text/html; charset=gb2312"); 
		PrintWriter out=response.getWriter(); 
		session=request.getSession(); 
		Str str=new Str(); 
		Db db=new Db(); 
		Time times=new Time(); 
		Collection coll=new ArrayList(); 
		//获取发送人id 
		try{ 
			id=Integer.parseInt((String)session.getAttribute("id")); 
		}catch(Exception e){ 
		//	e.printStackTrace(); 
			request.setAttribute("msg","您的网页已过期请重新登录"); 
			id=0; 
		} 
		//查看接受人是否有新的公文 
		count=db.getRowCount("bumf WHERE accepter="+id+" AND sign="+1+" AND examine="+0); 
		if(count>0){ 
			request.setAttribute("count",new Integer(count).toString()); 
		} 
		sqls="SELECT * FROM bumf WHERE accepter="+id+" AND sign="+1+" AND examine="+0+" ORDER BY bumfid"; 
		try{ 
			stmt=db.getStmtread(); 
			rs=stmt.executeQuery(sqls); 
			if(rs.next()){ 
				bumfid=rs.getInt(1); 
				sendter=rs.getInt(2); 
				accepter=rs.getInt(3); 
				title=rs.getString(4); 
				time=rs.getString(5); 
				content=rs.getString(6); 
				axffix=rs.getString(7); 
				examine=rs.getInt(8); 
				sign=rs.getInt(9); 
				content=str.outStr(content); 
				axffix=str.outStr(axffix); 
				Bumf bumf=new Bumf(); 
				bumf.setId(bumfid); 
				bumf.setSendter(sendter); 
				bumf.setAccepter(accepter); 
				bumf.setTitle(title); 
				bumf.setTime(time); 
				bumf.setContent(content); 
				bumf.setExamine(examine); 
				bumf.setSign(sign); 
				bumf.setAffix(axffix); 
				coll.add(bumf); 
			} 
			request.setAttribute("msg",coll); 
		}catch(Exception e){ 
			e.printStackTrace(); 
		}finally{ 
			db.close(); 
			RequestDispatcher dispatcher=request.getRequestDispatcher("accept.jsp"); 
			dispatcher.forward(request,response); 
		} 
	} 
	public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{ 
		doPost(request,response); 
	} 
}