package?com.action;

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

import?javax.servlet.RequestDispatcher;
import?javax.servlet.ServletConfig;
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.Tgoods;
import?com.service.liuService;


public?class?goods_servlet?extends?HttpServlet
{
	public?void?service（HttpServletRequest?reqHttpServletResponse?res）throws?ServletException?IOException?
	{
????????String?type=req.getParameter（“type“）;
		
		if（type.endsWith（“goodsAdd“））
		{
			goodsAdd（req?res）;
		}
		if（type.endsWith（“goodsMana“））
		{
			goodsMana（req?res）;
		}
		if（type.endsWith（“goodsDel“））
		{
			goodsDel（req?res）;
		}
		if（type.endsWith（“goodsDetailHou“））
		{
			goodsDetailHou（req?res）;
		}
		
		if（type.endsWith（“goodsAll“））
		{
			goodsAll（req?res）;
		}
		if（type.endsWith（“goodsDetailQian“））
		{
			goodsDetailQian（req?res）;
		}
	}
	
	public?void?goodsAdd（HttpServletRequest?reqHttpServletResponse?res）
	{
		String?id=String.valueOf（new?Date（）.getTime（））;
		String?mingcheng=req.getParameter（“mingcheng“）;
		String?jieshao=req.getParameter（“jieshao“）;
		String?fujian=req.getParameter（“fujian“）;

		String?del=“no“;
		
		String?sql=“insert?into?t_goods（idmingchengjieshaofujiandel）?“?+
				???“values（?????）“;
		object[]?params={idmingchengjieshaofujiandel};
		DB?mydb=new?DB（）;
		mydb.doPstm（sql?params）;
		mydb.closed（）;
		
		req.setAttribute（“msg“?“操作成功“）;
		String?targetURL?=?“/common/msg.jsp“;
		dispatch（targetURL?req?res）;
	}
	
	
	public?void?goodsMana（HttpServletRequest?reqHttpServletResponse?res）?throws?ServletException?IOException
	{
		List?goodsList=new?ArrayList（）;
		String?sql=“select?*?from?t_goods?where?del=‘no‘“;
		object[]?params={};
		DB?mydb=new?DB（）;
		try
		{
			mydb.doPstm（sql?params）;
			ResultSet?rs=mydb.getRs（）;
			while（rs.next（））
			{
				Tgoods?goods=new?Tgoods（）;
				
				goods.setId（rs.getString（“id“））;
				goods.setMingcheng（rs.getString（“mingcheng“））;
				goods.setJieshao（rs.getString（“jieshao“））;
				goods.setFujian（rs.getString（“fujian“））;
				
				goods.setDel（rs.getString（“del“））;
				
				goodsList.add（goods）;
		????}
			rs.close（）;
		}
		catch（Exception?e）
		{
			e.printStackTrace（）;
		}
		mydb.closed（）;
		
		req.setAttribute（“goodsList“?goodsList）;
		req.getRequestDispatcher（“admin/goods/goodsMana.jsp“）.forward（req?res）;
	}
	
	
	
	public?void?goodsDel（HttpServletRequest?reqHttpServletResponse?res）
	{
		String?id=req.getParameter（“id“）;
		String?sql=“update?t_goods?set?del=‘yes‘?where?id=“+id;
		object[]?params={};
		DB?mydb=new?DB（）;
		mydb.doPstm（sql?params）;
		mydb.closed（）;
		
		req.setAttribute（“msg“?“操作成功“）;
		String?targetUR

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

?????文件???????6338??2018-06-04?01:01??JSP養老院系統\db_yyxt.sql

?????文件????????529??2018-06-09?02:58??JSP養老院系統\yyxt\.classpath

?????文件????????552??2018-06-06?20:04??JSP養老院系統\yyxt\.externalToolBuilders\org.eclipse.wst.common.project.facet.core.builder.launch

?????文件????????548??2018-06-03?09:03??JSP養老院系統\yyxt\.externalToolBuilders\org.eclipse.wst.jsdt.core.javascriptValidator.launch

?????文件????????285??2018-06-05?04:43??JSP養老院系統\yyxt\.mymetadata

?????文件???????2209??2018-06-06?23:50??JSP養老院系統\yyxt\.project

?????文件????????500??2018-06-06?08:53??JSP養老院系統\yyxt\.settings\.jsdtscope

?????文件????????325??2018-06-06?07:41??JSP養老院系統\yyxt\.settings\org.eclipse.core.resources.prefs

?????文件????????395??2018-06-01?12:51??JSP養老院系統\yyxt\.settings\org.eclipse.jdt.core.prefs

?????文件????????450??2018-06-04?00:19??JSP養老院系統\yyxt\.settings\org.eclipse.wst.common.component

?????文件????????252??2018-06-02?00:03??JSP養老院系統\yyxt\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-06-10?05:04??JSP養老院系統\yyxt\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-06-10?00:29??JSP養老院系統\yyxt\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???10791384??2018-06-05?04:38??JSP養老院系統\yyxt\JSP養老院系統錄像.exe

?????文件???????5174??2018-06-02?08:39??JSP養老院系統\yyxt\src\com\action\goods_servlet.java

?????文件???????3527??2018-06-06?07:04??JSP養老院系統\yyxt\src\com\action\tupian_servlet.java

?????文件???????2145??2018-06-06?01:05??JSP養老院系統\yyxt\src\com\dao\DB.java

?????文件????????523??2018-06-03?04:11??JSP養老院系統\yyxt\src\com\orm\TAdmin.java

?????文件????????715??2018-06-05?02:15??JSP養老院系統\yyxt\src\com\orm\TTupian.java

?????文件???????4958??2018-06-10?01:46??JSP養老院系統\yyxt\src\com\service\liuService.java

?????文件???????1216??2018-06-05?11:53??JSP養老院系統\yyxt\src\com\util\EncodingFilter.java

?????文件????????737??2018-06-05?11:37??JSP養老院系統\yyxt\WebRoot\admin\bottom.jsp

?????文件???????1408??2018-06-06?07:45??JSP養老院系統\yyxt\WebRoot\admin\index.jsp

?????文件???????5667??2018-06-03?00:59??JSP養老院系統\yyxt\WebRoot\admin\left.jsp

?????文件???????3066??2018-06-04?20:17??JSP養老院系統\yyxt\WebRoot\admin\lianjie\lianjieAdd.jsp

?????文件???????2763??2018-06-09?12:06??JSP養老院系統\yyxt\WebRoot\admin\lianjie\lianjieMana.jsp

?????文件???????2643??2018-06-02?06:06??JSP養老院系統\yyxt\WebRoot\admin\liuyan\liuyanHuifu.jsp

?????文件???????3158??2018-06-09?00:03??JSP養老院系統\yyxt\WebRoot\admin\liuyan\liuyanMana.jsp

?????文件????????732??2018-06-08?06:00??JSP養老院系統\yyxt\WebRoot\admin\right.jsp

?????文件???????2432??2018-06-07?18:14??JSP養老院系統\yyxt\WebRoot\admin\scroll.jsp

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