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頁面接受中文參數亂碼
		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頁面傳遞過來的，與博文有關的3個參數：主題、內容和所屬分類的編號
			String?title?=?request.getParameter（“title“）;
			String?content?=?request.getParameter（“content“）;
			String?categoryId?=?request.getParameter（“category“）;

			//?數據源對象可以理解為連接池的管理者，通過他可以獲取數據庫的連接
			DataSource?ds?=?null;

			try?{
				//?通過在context.xml文件，設定的數據源對象的名字，獲取數據源對象
				Context?context?=?new?InitialContext（）;
				ds?=?（DataSource）?context.lookup（“java:/comp/env/jdbc/mysqlds“）;
			}?catch?（Exception?e）?{
				System.out.println（“獲取數據源時出錯“）;
			}
			int?result?=?0;

			try?{
				//?添加博文的SQL語句，now（）生成當前系統時間
				String?sql?=?“insert?into?blog?（titlecontentcategory_idcreatedtime）?values?（???now（））“;
				//?為SQL語句中的？設定參數
				String?params[]?=?{?title?content?categoryId?};
				//?DButils中核心類，生成對象時傳遞數據源對象
				QueryRunner?qr?=?new?QueryRunner（ds）;
				//?調用它的update，完成SQL的運行。其他使用update方法的SQL語句：insert
				//?into/update/delete
				result?=?qr.update（sql?params）;?//?query（）
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}

			String?message?=?““;
			if?（result?==?1）?{
				message?=?“添加博文成功！“;
			}?else?{
				message?=?“添加博文失敗！“;
			}

			request.setAttribute（“message“?message）;
			request.getRequestDispatcher（“/admin/result.jsp“）.forward（request
					response）;
		}
	}
}

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

?????文件???????1183??2009-06-02?11:41??blog\.classpath

?????文件????????285??2009-06-04?16:20??blog\.mymetadata

?????文件???????1222??2009-05-20?15:12??blog\.project

?????文件????????151??2009-05-31?08:19??blog\.settings\com.genuitec.eclipse.core.prefs

?????文件????????108??2009-06-01?15:55??blog\.settings\org.eclipse.core.resources.prefs

?????文件???????2765??2009-05-27?14:13??blog\src\cn\com\jobedu\blog\AddBlogServlet.java

?????文件???????1459??2009-06-01?11:25??blog\src\cn\com\jobedu\blog\AdminBlogListServlet.java

?????文件???????1001??2009-05-31?15:07??blog\src\cn\com\jobedu\blog\Blog.java

?????文件????????465??2009-05-25?13:44??blog\src\cn\com\jobedu\blog\Category.java

?????文件???????4824??2009-05-27?14:15??blog\src\cn\com\jobedu\blog\CategoryServlet.java

?????文件????????955??2009-06-01?14:36??blog\src\cn\com\jobedu\blog\Comment.java

?????文件???????4506??2009-06-01?14:39??blog\src\cn\com\jobedu\blog\CommentServlet.java

?????文件????????737??2009-05-25?10:07??blog\src\cn\com\jobedu\blog\DbHelper.java

?????文件???????1509??2009-05-27?14:16??blog\src\cn\com\jobedu\blog\DeleteBlogServlet.java

?????文件???????1594??2009-05-26?11:20??blog\src\cn\com\jobedu\blog\GetBlogServlet.java

?????文件???????3769??2009-06-01?09:46??blog\src\cn\com\jobedu\blog\HomeServlet.java

?????文件???????1992??2009-06-01?11:20??blog\src\cn\com\jobedu\blog\PostEditBlogServlet.java

?????文件???????1487??2009-05-27?11:49??blog\src\cn\com\jobedu\blog\PreAddBlogServlet.java

?????文件???????1572??2009-06-01?11:05??blog\src\cn\com\jobedu\blog\PreEditBlogServlet.java

?????文件????????511??2009-05-27?09:24??blog\src\cn\com\jobedu\blog\User.java

?????文件???????4049??2009-05-31?14:39??blog\src\cn\com\jobedu\blog\UserServlet.java

?????文件????????309??2009-06-01?15:49??blog\src\displaytag.properties

?????文件???????1243??2009-06-01?16:04??blog\src\displaytag_zh.properties

?????文件???????1405??2009-06-01?16:04??blog\src\displaytag_zh_CN.properties

?????文件???????1497??2009-05-27?14:55??blog\WebRoot\admin\addBlog.jsp

?????文件????????782??2009-05-31?08:24??blog\WebRoot\admin\addCategory.jsp

?????文件????????135??2009-05-31?09:23??blog\WebRoot\admin\admin.jsp

?????文件???????1257??2009-06-01?16:19??blog\WebRoot\admin\adminBlogList.jsp

?????文件???????1322??2009-06-01?16:06??blog\WebRoot\admin\adminBlogList.jsp.bak

?????文件???????1314??2009-05-27?15:30??blog\WebRoot\admin\adminCategoryList.jsp

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