package?cn.com.jobedu.blog;

import?java.io.IOException;
import?java.sql.SQLException;
import?javax.naming.Context;
import?javax.naming.InitialContext;
import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;
import?javax.servlet.http.HttpSession;
import?javax.sql.DataSource;
import?org.apache.commons.dbutils.QueryRunner;


public?class?AddBlogServlet?extends?HttpServlet?{
	private?static?final?long?serialVersionUID?=?1L;

	public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{
		doPost（request?response）;
	}

	public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{
		//?解決從JSP頁(yè)面接受中文參數(shù)亂碼
		request.setCharacterEncoding（“UTF-8“）;
		HttpSession?session?=?request.getSession（）;
		User?user=（User）session.getAttribute（“user“）;
		if（user==null）{
			response.sendRedirect（“/blog/admin/login.jsp“）;
		}else{

			//?接受JSP頁(yè)面?zhèn)鬟f過來的，與博文有關(guān)的3個(gè)參數(shù)：主題、內(nèi)容和所屬分類的編號(hào)
			String?title?=?request.getParameter（“title“）;
			String?content?=?request.getParameter（“content“）;
			String?categoryId?=?request.getParameter（“category“）;

			//?數(shù)據(jù)源對(duì)象可以理解為連接池的管理者，通過他可以獲取數(shù)據(jù)庫(kù)的連接
			DataSource?ds?=?null;

			try?{
				//?通過在context.xml文件，設(shè)定的數(shù)據(jù)源對(duì)象的名字，獲取數(shù)據(jù)源對(duì)象
				Context?context?=?new?InitialContext（）;
				ds?=?（DataSource）?context.lookup（“java:/comp/env/jdbc/mysqlds“）;
			}?catch?（Exception?e）?{
				System.out.println（“獲取數(shù)據(jù)源時(shí)出錯(cuò)“）;
			}
			int?result?=?0;
			try?{
				//添加博文的sql語(yǔ)句，now（）生成當(dāng)前系統(tǒng)時(shí)間
				String?sql?=?“insert?into?blog?（titlecontentcategory_idcreatetime）?values?（???now（））“;
				//為sql語(yǔ)句中的？設(shè)定參數(shù)，有幾個(gè)？給幾個(gè)值
				String?params[]?={titlecontentcategoryId};
				//DButils中核心類，生成對(duì)象時(shí)傳遞數(shù)據(jù)源對(duì)象
				QueryRunner?qr?=?new?QueryRunner（ds）;
				//調(diào)用它的update，完成sql的運(yùn)行。其他使用update方法的sql語(yǔ)句，insert?into/update/delete
				result?=?qr.update（sql?params）;
			}catch?（SQLException?e）?{
					e.printStackTrace（）;
				}
				String?message=““;
				if（result==1）{
					message=“添加博文成功“;
				}else{
					message=“添加博文失敗“;
				}
				request.setAttribute（“message“?message）;
				//后面變量message，第一個(gè)傳的參數(shù)的名字，這里我們傳的是message的值
				//“添加博文成功“?“添加博文失敗“;
				request.getRequestDispatcher（“/admin/result.jsp“）
				.forward（request?response）;
		}

		}
	
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????2017??2011-03-29?23:19??blog\.classpath

?????文件????????285??2011-04-04?00:41??blog\.mymetadata

?????文件???????1410??2011-02-24?14:03??blog\.project

?????文件????????406??2011-02-24?13:58??blog\.settings\.jsdtscope

?????文件????????121??2011-02-24?16:03??blog\.settings\com.genuitec.eclipse.core.prefs

?????文件?????????88??2011-02-28?21:44??blog\.settings\org.eclipse.core.resources.prefs

?????文件????????330??2011-02-24?13:58??blog\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2011-02-24?13:58??blog\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-02-24?13:58??blog\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2681??2011-04-06?19:46??blog\context.xml

?????文件???????2892??2011-02-26?22:38??blog\src\cn\com\jobedu\blog\AddBlogServlet.java

?????文件???????2409??2011-02-28?13:24??blog\src\cn\com\jobedu\blog\AdminBlogListServlet.java

?????文件???????1319??2011-02-28?01:17??blog\src\cn\com\jobedu\blog\Blog.java

?????文件????????550??2011-02-25?22:31??blog\src\cn\com\jobedu\blog\Category.java

?????文件???????4680??2011-02-27?14:50??blog\src\cn\com\jobedu\blog\CategoryServlet.java

?????文件????????840??2011-02-27?22:17??blog\src\cn\com\jobedu\blog\Comment.java

?????文件???????4639??2011-02-28?16:16??blog\src\cn\com\jobedu\blog\CommentServlet.java

?????文件????????981??2011-04-06?19:36??blog\src\cn\com\jobedu\blog\DbHelper.java

?????文件???????2188??2011-02-26?22:42??blog\src\cn\com\jobedu\blog\DeleteBlogServlet.java

?????文件???????2276??2011-02-26?14:38??blog\src\cn\com\jobedu\blog\GetBlogServlet.java

?????文件???????4782??2011-04-01?11:24??blog\src\cn\com\jobedu\blog\HomeServlet.java

?????文件???????2102??2011-02-28?13:20??blog\src\cn\com\jobedu\blog\PostEditBlogServlet.java

?????文件???????1470??2011-02-26?22:37??blog\src\cn\com\jobedu\blog\PreAddBlogServlet.java

?????文件???????2645??2011-02-28?01:20??blog\src\cn\com\jobedu\blog\PreEditBlogServlet.java

?????文件????????499??2011-02-26?19:00??blog\src\cn\com\jobedu\blog\User.java

?????文件???????4430??2011-04-05?11:48??blog\src\cn\com\jobedu\blog\UserServlet.java

?????文件????????334??2011-02-28?22:29??blog\src\displaytag.properties

?????文件???????1405??2011-02-28?22:49??blog\src\displaytag_zh_CN.properties

?????文件???????1328??2011-02-26?23:29??blog\WebRoot\admin\addBlog.htm

?????文件???????1411??2011-02-27?00:21??blog\WebRoot\admin\addBlog.jsp

............此處省略637個(gè)文件信息