package?com.ershouche.buy;

import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

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

import?com.ershouche.domain.Car;

public?class?CarListServlet?extends?HttpServlet?{
	static?Connection?conn;
	static?String?driverName=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	/*
	?*?sa身份連接提供user?password
	?*?混合身份連接直接添加integratedSecurity=true;*/
	static?String?url=“jdbc:sqlserver://127.0.0.1:1433;user=sa;password=12345679;DatabaseName=ErShouChe“;
//	String?url=“jdbc:sqlserver://127.0.0.1:1433;IntegratedSecurity=false;DatabaseName=ErShouChe“;
	PreparedStatement?statement;
	ResultSet?result;
	List?carlist;
	/**
	?*?Constructor?of?the?object.
	?*/
	public?CarListServlet（）?{
		super（）;
	}
	/**
	?*?Initialization?of?the?servlet.?

	?*
	?*?@throws?ServletException?if?an?error?occurs
	?*/
	public?void?init（）?throws?ServletException?{
		//?Put?your?code?here
		try?{
			Class.forName（driverName）;
			conn=DriverManager.getConnection（url）;
			carlist=new?ArrayList（）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	/**
	?*?Destruction?of?the?servlet.?

	?*/
	public?void?destroy（）?{
		try?{
			conn.close（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}

	/**
	?*?The?doGet?method?of?the?servlet.?

	?*
	?*?This?method?is?called?when?a?form?has?its?tag?value?method?equals?to?get.
	?*?
	?*?@param?request?the?request?send?by?the?client?to?the?server
	?*?@param?response?the?response?send?by?the?server?to?the?client
	?*?@throws?ServletException?if?an?error?occurred
	?*?@throws?IOException?if?an?error?occurred
	?*/
	public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{
		String?hint=request.getParameter（“hint“）;
		if（hint!=null?&&?hint.equals（“true“））{????//處理提示請求
			String?sql=request.getParameter（“sql“）;
			System.out.println（“hint“+sql）;
???????????	try?{
				statement=conn.prepareStatement（sql）;
				result=statement.executeQuery（）;
				StringBuilder?builder=new?StringBuilder（）;
				while（result.next（））{
					builder.append（result.getString（1））.append（“;“）;
				}
				request.setAttribute（“json“?builder.toString（））;
????????????	System.out.println（builder.toString（））;
????????????	request.getRequestDispatcher（“/sendjsonback.jsp“）.forward（request?response）;??
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				

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

?????文件????????599??2015-03-27?15:37??安卓app實現前后臺通信案例（二手車交易）\ceshi\.classpath

?????文件????????288??2015-03-07?19:42??安卓app實現前后臺通信案例（二手車交易）\ceshi\.mymetadata

?????文件???????1411??2015-03-07?19:42??安卓app實現前后臺通信案例（二手車交易）\ceshi\.project

?????文件????????500??2015-03-07?19:42??安卓app實現前后臺通信案例（二手車交易）\ceshi\.settings\.jsdtscope

?????文件????????330??2015-03-07?19:42??安卓app實現前后臺通信案例（二手車交易）\ceshi\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2015-03-07?19:42??安卓app實現前后臺通信案例（二手車交易）\ceshi\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-03-07?19:42??安卓app實現前后臺通信案例（二手車交易）\ceshi\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????6521??2015-05-03?16:21??安卓app實現前后臺通信案例（二手車交易）\ceshi\src\com\ershouche\buy\CarListServlet.java

?????文件???????3588??2015-04-15?18:55??安卓app實現前后臺通信案例（二手車交易）\ceshi\src\com\ershouche\buy\CollectServlet.java

?????文件???????1436??2015-04-15?22:28??安卓app實現前后臺通信案例（二手車交易）\ceshi\src\com\ershouche\domain\Car.java

?????文件??????16950??2015-04-17?14:23??安卓app實現前后臺通信案例（二手車交易）\ceshi\src\com\ershouche\domain\ManageServlet.java

?????文件???????1812??2015-03-27?16:05??安卓app實現前后臺通信案例（二手車交易）\ceshi\src\com\ershouche\filter\EncodingFilter.java

?????文件???????4842??2015-04-13?20:44??安卓app實現前后臺通信案例（二手車交易）\ceshi\src\com\ershouche\sell\LoginServlet.java

?????文件???????6426??2015-04-14?20:58??安卓app實現前后臺通信案例（二手車交易）\ceshi\src\com\ershouche\sell\ReceiveUploadServlet.java

?????文件???????7813??2015-04-14?22:45??安卓app實現前后臺通信案例（二手車交易）\ceshi\src\com\ershouche\user\InitSelfServlet.java

?????文件????????494??2015-03-27?16:08??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\index.jsp

?????文件???????3840??2015-04-17?13:21??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\manage.jsp

?????文件?????????36??2015-03-07?19:42??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\meta-INF\MANIFEST.MF

?????文件?????????96??2015-03-25?15:44??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\sendjsonback.jsp

?????文件???????1215??2015-04-13?22:28??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\uploadfile.jsp

?????文件???????5165??2015-05-03?16:21??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\WEB-INF\classes\com\ershouche\buy\CarListServlet.class

?????文件???????3257??2015-04-15?18:55??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\WEB-INF\classes\com\ershouche\buy\CollectServlet.class

?????文件???????1457??2015-04-15?22:28??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\WEB-INF\classes\com\ershouche\domain\Car.class

?????文件????????577??2015-04-17?14:23??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\WEB-INF\classes\com\ershouche\domain\ManageServlet$Remeber.class

?????文件??????10949??2015-04-17?14:23??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\WEB-INF\classes\com\ershouche\domain\ManageServlet.class

?????文件???????1625??2015-03-27?16:05??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\WEB-INF\classes\com\ershouche\filter\EncodingFilter.class

?????文件???????1051??2015-03-27?16:05??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\WEB-INF\classes\com\ershouche\filter\EncodingServletRequestWrapper.class

?????文件???????4092??2015-04-13?20:44??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\WEB-INF\classes\com\ershouche\sell\LoginServlet.class

?????文件???????6593??2015-04-14?20:58??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\WEB-INF\classes\com\ershouche\sell\ReceiveUploadServlet.class

?????文件???????6004??2015-04-14?22:45??安卓app實現前后臺通信案例（二手車交易）\ceshi\WebRoot\WEB-INF\classes\com\ershouche\user\InitSelfServlet.class

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