/*
?*?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.affice;

import?oa.sys.*;
import?oa.sys.Time;

import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.*;
import?javax.servlet.*;
import?javax.servlet.http.*;
/**
?****************************************************
?*類名稱：	Add

?*類功能：	增加公告信息

?*創建：	白偉明	2004年10月5日

?****************************************************
?*?To?change?the?template?for?this?generated?type?comment?go?to
?*?Window>Preferences>Java>Code?Generation>Code?and?Comments
?*/
public?class?Add?extends?HttpServlet{
	private?HttpSession?session=null;
	private?ResultSet?rs=null;
	private?Statement?stmt=null;
	private?String?titlecontentsqlisqls;
	private?int?temp=0id;
	
	public?void?doPost（HttpServletRequest?requestHttpServletResponse?response）?throws?ServletException?IOException{
		request.setCharacterEncoding（“gb2312“）;
		response.setContentType（“text/html;?charset=gb2312“）;
		Str?str=new?Str（）;
		Db?db=new?Db（）;
		Time?time=new?Time（）;
		PrintWriter?out=response.getWriter（）;
		session=request.getSession（）;
		id=Integer.parseInt（（String）session.getAttribute（“id“））;
		title=request.getParameter（“title“）;
		content=request.getParameter（“content“）;
		title=str.inStr（title）;
		content=str.inStr（content）;
		sqli=“INSERT?INTO?affice（titletimeemployeeidcontent）?VALUES（‘“+title+“‘‘“+time.getYMD（）+“‘“+id+“‘“+content+“‘）“;
		sqls=“SELECT?*?FROM?affice?WHERE?time=‘“+time.getYMD（）+“‘“;
		try?{
			stmt=db.getStmtread（）;
			rs=stmt.executeQuery（sqls）;
			if（!rs.next（））{
				db.close（）;
				stmt=db.getStmt（）;
				temp=stmt.executeUpdate（sqli）;
				if（temp>0）{
					request.setAttribute（“msg““發布成功“）;
				}else{
					request.setAttribute（“msg““發布失敗“）;
				}
			}else{
				request.setAttribute（“msg““今日已經發布公告，不能再發布“）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			db.close（）;
			RequestDispatcher?dispatcher=request.getRequestDispatcher（“add.jsp“）;
			dispatcher.forward（requestresponse）;
		}
	}
	public?void?doGet（HttpServletRequest?requestHttpServletResponse?response）?throws?ServletException?IOException{
		doPost（requestresponse）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1752??2004-10-12?17:17??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\affice\add.jsp

?????文件????????686??2004-10-06?09:14??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\affice\affice.htm

?????文件???????1953??2004-11-06?15:58??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\affice\view.jsp

?????文件????????576??2004-09-22?13:03??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\black.htm

?????文件???????2512??2005-01-21?13:45??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\bumf\accept.jsp

?????文件????????963??2004-10-11?09:33??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\bumf\bumf.htm

?????文件???????1616??2005-01-21?17:11??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\bumf\see.jsp

?????文件???????2352??2004-10-15?16:03??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\bumf\send.jsp

?????文件????????267??2004-11-15?08:09??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\bumf\upload.jsp

?????文件????????611??2004-10-12?15:28??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\css\word.css

?????文件????????627??2004-09-25?13:51??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\css\work.css

?????文件???????1776??2004-10-12?17:17??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\department\add.jsp

?????文件???????3315??2004-10-15?16:06??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\department\change.jsp

?????文件???????2491??2005-01-21?20:23??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\department\del.jsp

?????文件????????842??2004-10-04?09:28??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\department\department.htm

?????文件????????718??2005-01-20?13:03??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\department\departmentinfo.htm

?????文件???????1684??2004-10-15?16:05??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\department\view.jsp

?????文件???????4194??2004-10-15?16:07??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\em\add.jsp

?????文件???????5253??2004-10-15?16:07??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\em\change.jsp

?????文件???????1055??2005-01-22?08:51??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\em\em.htm

?????文件???????3496??2004-11-08?20:21??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\em\select.jsp

?????文件???????2205??2004-10-15?16:07??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\em\view.jsp

?????文件???????1575??2004-10-12?17:16??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\emex\add.jsp

?????文件????????687??2004-10-06?10:41??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\emex\emex.htm

?????文件???????2058??2004-11-06?16:20??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\emex\view.jsp

?????文件???????1809??2004-10-12?17:16??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\emstate\add.jsp

?????文件???????3345??2004-10-15?16:15??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\emstate\change.jsp

?????文件???????2403??2005-01-21?20:23??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\emstate\del.jsp

?????文件????????851??2004-10-04?09:29??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\emstate\emstate.htm

?????文件???????1704??2004-10-15?16:16??11004java網上oa辦公系統原碼\java網上oa辦公系統原碼\emstate\view.jsp

............此處省略268個文件信息