www.pudn.com > OA.rar > Send.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.*; 
/** 
 **************************************************** 
 *类名称：	Send
 
 *类功能：	公文发送(附件)
 
 *创建：	白伟明	2004年10月7日
 
 **************************************************** 
 * To change the template for this generated type comment go to 
 * Window>Preferences>Java>Code Generation>Code and Comments 
 */ 
public class Send extends HttpServlet{ 
	private int sign;//0代表已保存，1代表已经发送 
	private int examine;//1代表处理完成，0代表还未处理 
	private int id;//发送人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;//保存SQL语句 
	private String sqli;//保存SQL语句 
	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(); 
		} 
		//查看发送人是否有临时公文 
		sqls="SELECT * FROM bumf WHERE sendter="+id+" AND sign="+0; 
		out.print(sqls+"
"); 
		try{ 
			stmt=db.getStmtread(); 
			rs=stmt.executeQuery(sqls); 
			//如果没有生成一个临时文件 
			if(!rs.next()){ 
				db.close(); 
				sqli="INSERT INTO bumf(sendter,accepter,title,time,content,affix,examine,sign) VALUES("+id+","+id+",'','"+times.getYMDHMS()+"',' ','',1,0)"; 
				stmt=db.getStmt(); 
				stmt.executeUpdate(sqli); 
			} 
			db.close(); 
			//调出临时文件 
			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); 
			 
			 coll=(Collection)request.getAttribute("msg"); 
			if(coll!=null){ 
				Iterator it=coll.iterator(); 
				if(it.hasNext()){ 
					Bumf bumf=(Bumf)it.next(); 
					out.print(bumf.getId());		 
				} 
			} 
 
		}catch(Exception e){ 
			e.printStackTrace(); 
			out.print(e); 
		}finally{ 
			db.close(); 
			RequestDispatcher dispatcher=request.getRequestDispatcher("send.jsp"); 
			dispatcher.forward(request,response); 
		} 
	} 
	public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{ 
		doPost(request,response); 
	} 
}