package?com.action;

import?java.io.IOException;
import?java.sql.ResultSet;
import?java.text.SimpleDateFormat;
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?javax.servlet.http.HttpSession;

import?com.dao.DB;
import?com.orm.TAdmin;
import?com.orm.Tchushou;
import?com.orm.Tgonggao;
import?com.orm.Tqiugou;
import?com.orm.Tuser;
import?com.service.liuService;

public?class?qiugou_servlet?extends?HttpServlet
{
	public?void?service（HttpServletRequest?reqHttpServletResponse?res）throws?ServletException?IOException?
	{
????????String?type=req.getParameter（“type“）;
		
		
		if（type.endsWith（“qiugouAdd“））
		{
			qiugouAdd（req?res）;
		}
		if（type.endsWith（“qiugouMana“））
		{
			qiugouMana（req?res）;
		}
		if（type.endsWith（“qiugouDel“））
		{
			qiugouDel（req?res）;
		}
		
		if（type.endsWith（“qiugouAll“））
		{
			qiugouAll（req?res）;
		}
		if（type.endsWith（“qiugouDetailQian“））
		{
			qiugouDetailQian（req?res）;
		}
		
		if（type.endsWith（“qiugouMana_admin“））
		{
			qiugouMana_admin（req?res）;
		}
	}
	
	
	public?void?qiugouAdd（HttpServletRequest?reqHttpServletResponse?res）
	{
		HttpSession?session=req.getSession（）;
		Tuser?user=（Tuser）session.getAttribute（“user“）;
		
		String?id=String.valueOf（new?Date（）.getTime（））;
		String?bianhao=req.getParameter（“bianhao“）;
		String?mingcheng=req.getParameter（“mingcheng“）;
		String?leixing=req.getParameter（“leixing“）;
		
		Float?jiage=Float.parseFloat（req.getParameter（“jiage“））;
		String?shengchandi=req.getParameter（“shengchandi“）;
		String?shuoming=req.getParameter（“shuoming“）;
		String?fujian=req.getParameter（“fujian“）;
		
		String?lianxiren=req.getParameter（“lianxiren“）;
		String?lianxihua=req.getParameter（“lianxihua“）;
		String?fabushi=new?SimpleDateFormat（“yyyy-MM-dd?HH:mm“）.format（new?Date（））;
		String?user_id=user.getId（）;
		
		String?sql=“insert?into?t_qiugou?values（????????????）“;
		object[]?params={idbianhaomingchengleixingjiageshengchandishuomingfujianlianxirenlianxihuafabushiuser_id};
		DB?mydb=new?DB（）;
		mydb.doPstm（sql?params）;
		mydb.closed（）;
		
		req.setAttribute（“msg“?“求購信息發布完畢“）;
????????String?targetURL?=?“/common/msg.jsp“;
		dispatch（targetURL?req?res）;
????????
	}
	
	
	public?void?qiugouMana（HttpServletRequest?reqHttpServletResponse?res）?throws?ServletException?IOException
	{
		HttpSession?session=req.getSession（）;
		Tuser?user=（Tuser）session.getAttribute（“user“）;
		
		List?qiugouList=new?ArrayList（）;
		String?sql=“select?*?from?t_qiugou?where?user_id=?“;
		object[]?params={user.getId（）};
		DB?mydb=new?DB（）;
		try
		{
			mydb.doPstm（sql?params）;
			ResultSet?rs=mydb.getRs（）;
			while（rs.nex

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

?????文件????1048576??2013-05-01?21:56??JAVA?JSP農產品系統\351JSP農產品系統\db_ncp_Data.MDF

?????文件????1048576??2013-05-01?21:56??JAVA?JSP農產品系統\351JSP農產品系統\db_ncp_Log.LDF

?????文件????6016507??2013-01-31?16:48??JAVA?JSP農產品系統\351JSP農產品系統\JSP農產品系統luxaing.exe

?????文件???????1487??2013-01-30?17:13??JAVA?JSP農產品系統\351JSP農產品系統\ncp\.classpath

?????文件????????282??2013-01-30?17:13??JAVA?JSP農產品系統\351JSP農產品系統\ncp\.mymetadata

?????文件???????1221??2013-01-30?17:13??JAVA?JSP農產品系統\351JSP農產品系統\ncp\.project

?????文件???????7784??2013-01-30?23:21??JAVA?JSP農產品系統\351JSP農產品系統\ncp\src\com\action\qiugou_servlet.java

?????文件???????2116??2013-01-30?17:15??JAVA?JSP農產品系統\351JSP農產品系統\ncp\src\com\dao\DB.java

?????文件???????1052??2013-01-30?17:30??JAVA?JSP農產品系統\351JSP農產品系統\ncp\src\com\orm\Tuser.java

?????文件???????3740??2013-01-30?22:20??JAVA?JSP農產品系統\351JSP農產品系統\ncp\src\com\service\liuService.java

?????文件???????1216??2013-01-30?17:13??JAVA?JSP農產品系統\351JSP農產品系統\ncp\src\com\util\EncodingFilter.java

?????文件???????1358??2013-01-30?17:13??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\admin\center.jsp

?????文件???????1551??2013-01-30?17:23??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\admin\down.jsp

?????文件?????????61??2014-02-27?17:03??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\admin\index.jsp

?????文件???????7555??2013-01-30?23:22??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\admin\left.jsp

?????文件?????????88??2013-03-29?12:10??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\admin\login.jsp

?????文件???????2496??2013-01-30?17:13??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\admin\middel.jsp

?????文件???????3514??2013-01-30?17:23??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\admin\top.jsp

?????文件???????2655??2013-01-30?17:52??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\admin\user\userMana.jsp

?????文件???????3720??2013-01-30?17:13??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\admin\userinfo\userPw.jsp

?????文件???????1358??2013-01-30?18:32??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\auser\center.jsp

?????文件???????7612??2013-01-30?20:40??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\auser\chushou\chushouAdd.jsp

?????文件???????4656??2013-01-30?21:58??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\auser\chushou\chushouMana.jsp

?????文件???????1551??2013-01-30?17:23??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\auser\down.jsp

?????文件??????????0??2013-01-30?17:13??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\auser\index\sysPro.jsp

?????文件???????1017??2013-01-30?18:32??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\auser\index.jsp

?????文件???????5764??2013-01-30?22:32??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\auser\left.jsp

?????文件???????2496??2013-01-30?18:32??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\auser\middel.jsp

?????文件???????7610??2013-01-30?21:54??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\auser\qiugou\qiugouAdd.jsp

?????文件???????4635??2013-01-30?21:58??JAVA?JSP農產品系統\351JSP農產品系統\ncp\WebRoot\auser\qiugou\qiugouMana.jsp

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