package?com.action;

import?java.io.IOException;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?java.util.List;

import?javax.servlet.RequestDispatcher;
import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?com.dao.DB;
import?com.orm.TFenlei;

public?class?fenlei_servlet?extends?HttpServlet{
	public?void?service（HttpServletRequest?reqHttpServletResponse?res）throws?ServletException?IOException?
	{
????????String?type=req.getParameter（“type“）;
????????if（type.endsWith（“fenleiAdd“））
????????{
????????	fenleiAdd（req?res）;
????????}
????????if（type.endsWith（“fenleiEdit“））
????????{
????????	fenleiEdit（req?res）;
????????}
????????if（type.endsWith（“fenleiDel“））
????????{
????????	fenleiDel（req?res）;
????????}????????
		if（type.endsWith（“fenleiMana“））
		{
			fenleiMana（req?res）;
		}
	}
	
	public?void?fenleiMana（HttpServletRequest?reqHttpServletResponse?res）throws?ServletException?IOException
	{
		List?fenleiList?=?new?ArrayList（）;
		
		String?sql?=?“select?idmingcheng?from?t_fenlei?where?del=‘no‘“;
		object[]?params={};
		DB?mydb=new?DB（）;
		try
		{
			mydb.doPstm（sql?params）;
			ResultSet?rs=mydb.getRs（）;
			while（rs.next（））
			{
				TFenlei?fenlei?=?new?TFenlei（）;
				fenlei.setId（rs.getInt（“id“））;
				fenlei.setMingcheng（rs.getString（“mingcheng“））;
				
				fenleiList.add（fenlei）;
		????}
			rs.close（）;
		}
		catch（Exception?e）
		{
			e.printStackTrace（）;
		}
		mydb.closed（）;
		
		req.setAttribute（“fenleiList“?fenleiList）;
		req.getRequestDispatcher（“/admin/fenlei/fenleiMana.jsp“）.forward（req?res）;
	}
	
	public?void?fenleiAdd（HttpServletRequest?reqHttpServletResponse?res）
	{
		String?mingcheng?=?req.getParameter（“mingcheng“）;
		String?del?=?“no“;
		
		String?sql?=?“insert?into?t_fenlei?（mingchengdel）?values?（??）“;
		object[]?params={mingchengdel};
		DB?mydb=new?DB（）;
		mydb.doPstm（sql?params）;
		mydb.closed（）;
		
		req.setAttribute（“message“?“操作成功“）;
		req.setAttribute（“path“?“fenlei?type=fenleiMana“）;
		
		String?targetURL?=?“/common/success.jsp“;
		dispatch（targetURL?req?res）;
	}
	public?void?fenleiEdit（HttpServletRequest?reqHttpServletResponse?res）
	{
		int?id?=?Integer.parseInt（req.getParameter（“id“））;
		String?mingcheng?=?req.getParameter（“mingcheng“）;
		
		String?sql?=?“update?t_fenlei?set?mingcheng?=???where?id?=??“;
		object[]?params={mingchengid};
		DB?mydb=new?DB（）;
		mydb.doPstm（sql?params）;
		mydb.closed（）;
		
		req.setAttribute（“message“?“操作成功“）;
		req.setAttribute（“path“?“fenlei?type=fenleiMana“）;
		
		String?targetURL?=?“/common/success.jsp“;
		dispatch（targetURL?req?res）;
	}
	public?void?fenleiDel（HttpServletRequest?reqHttpServletResponse?res）
	{
		int?id?=?Integer.parseInt（req.getParameter（“id“））;
		
		String?sql?=?“update?t_fenlei?set?del?=?‘yes‘?where?id?=??“;

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

?????文件????2668163??2012-05-05?19:29??350JSP日程管理系統\JSP日程管理系統錄像.exe

?????文件????????820??2012-05-11?01:39??350JSP日程管理系統\richeng\.classpath

?????文件????????294??2012-05-11?01:39??350JSP日程管理系統\richeng\.mymetadata

?????文件???????1225??2012-05-05?14:08??350JSP日程管理系統\richeng\.project

?????文件????????330??2012-05-05?13:59??350JSP日程管理系統\richeng\.settings\org.eclipse.jdt.core.prefs

?????文件???????3712??2012-05-05?14:19??350JSP日程管理系統\richeng\src\com\action\fenlei_servlet.java

?????文件???????2872??2012-05-02?14:59??350JSP日程管理系統\richeng\src\com\dao\DB.java

?????文件????????524??2012-04-01?23:34??350JSP日程管理系統\richeng\src\com\orm\TAdmin.java

?????文件???????1060??2012-04-28?15:59??350JSP日程管理系統\richeng\src\com\util\DateUtils.java

?????文件?????????74??2012-05-11?01:39??350JSP日程管理系統\richeng\src\dbInfo.properties

?????文件???????2567??2012-04-17?18:09??350JSP日程管理系統\richeng\WebRoot\admin\index\sysPro.jsp

?????文件?????????61??2014-02-27?17:03??350JSP日程管理系統\richeng\WebRoot\admin\index.jsp

?????文件?????????88??2013-03-29?12:10??350JSP日程管理系統\richeng\WebRoot\admin\login.jsp

?????文件???????4854??2012-05-05?19:04??350JSP日程管理系統\richeng\WebRoot\admin\menu.jsp

?????文件??????10691??2012-05-11?01:48??350JSP日程管理系統\richeng\WebRoot\admin\top.jsp

?????文件????????797??2012-04-01?23:34??350JSP日程管理系統\richeng\WebRoot\common\success.jsp

?????文件???????5008??2012-04-01?23:34??350JSP日程管理系統\richeng\WebRoot\css\base.css

?????文件????????795??2012-04-01?23:34??350JSP日程管理系統\richeng\WebRoot\css\dtree.css

?????文件???????1669??2012-04-01?23:34??350JSP日程管理系統\richeng\WebRoot\css\front1.css

?????文件???????6520??2012-04-01?23:34??350JSP日程管理系統\richeng\WebRoot\css\layout.css

?????文件???????1168??2012-04-01?23:34??350JSP日程管理系統\richeng\WebRoot\css\main.css

?????文件????????638??2012-04-01?23:34??350JSP日程管理系統\richeng\WebRoot\css\whole.css

?????文件???????2684??2012-04-01?23:34??350JSP日程管理系統\richeng\WebRoot\css\woncore.css

?????文件????????236??2012-04-01?23:47??350JSP日程管理系統\richeng\WebRoot\fckeditor\editor\css\behaviors\disablehandles.htc

?????文件????????822??2012-04-01?23:47??350JSP日程管理系統\richeng\WebRoot\fckeditor\editor\css\behaviors\showtableborders.htc

?????文件???????2648??2012-04-01?23:47??350JSP日程管理系統\richeng\WebRoot\fckeditor\editor\css\fck_editorarea.css

?????文件???????4088??2012-04-01?23:47??350JSP日程管理系統\richeng\WebRoot\fckeditor\editor\css\fck_internal.css

?????文件???????1696??2012-04-01?23:47??350JSP日程管理系統\richeng\WebRoot\fckeditor\editor\css\fck_showtableborders_gecko.css

?????文件????????288??2012-04-01?23:47??350JSP日程管理系統\richeng\WebRoot\fckeditor\editor\css\images\block_address.png

?????文件????????293??2012-04-01?23:47??350JSP日程管理系統\richeng\WebRoot\fckeditor\editor\css\images\block_blockquote.png

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