package?com.lyq.bean;

import?java.io.IOException;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
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;

/**
?*?Servlet?implementation?class?CWFindServlet
?*/

public?class?ZLFindServlet?extends?HttpServlet?{
	private?static?final?long?serialVersionUID?=?1L;

	protected?void?doGet（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException?{
		//?TODO?Auto-generated?method?stub
		try?{
			//?錕斤拷錕斤拷錕斤拷錕捷匡拷錕斤拷錕斤拷錕斤拷注錕結(jié)到錕斤拷錕斤拷錕斤拷錕斤拷錕斤拷
			Class.forName（“com.mysql.jdbc.Driver“）;
			//?錕斤拷錕捷匡拷錕斤拷錕斤拷錕街鳳拷錕斤拷
			String?url?=?“jdbc:mysql://localhost:3306/mysql“;
			//?錕斤拷錕捷匡拷錕矯伙拷錕斤拷
			String?username?=?“root“;
			//?錕斤拷錕捷匡拷錕斤拷錕斤拷
			String?password?=?“123“;
			//?錕斤拷錕斤拷Connection錕斤拷錕斤拷
			Connection?conn?=?DriverManager.getConnection（urlusernamepassword）;
			//?錕斤拷取Statement
			Statement?stmt?=?conn.createStatement（）;
			//?錕斤拷錕酵鹼拷錕斤拷錕較拷錕絊QL錕斤拷錕?
			String?sql?=?“select?*?from?zl_info“;
			//?執(zhí)錕叫詫拷詢
			ResultSet?rs?=?stmt.executeQuery（sql）;
			//?實(shí)錕斤拷錕斤拷List錕斤拷錕斤拷
			List?list?=?new?ArrayList（）;
			//?錕叫斷癸拷錕斤拷錕斤拷錕狡訛拷錕斤拷錕斤拷錕叫訛拷錕角鳳拷錕斤拷效
			while（rs.next（））{
				//?實(shí)錕斤拷錕斤拷Book錕斤拷錕斤拷name		
				
				ZL_Data?book?=?new?ZL_Data（）;
				//?錕斤拷id錕斤拷錕皆革拷值
				book.setId（rs.getString（“id“））;
				
				book.setModules（rs.getString（“modules“））;
				//?錕斤拷price錕斤拷錕皆革拷值
				book.setCategory（rs.getString（“category“））;
				//?錕斤拷bookCount錕斤拷錕皆革拷值
				
				list.add（book）;
			}
			//?錕斤拷圖錕介集錕較鳳拷錕矯碉拷request之錕斤拷
			request.setAttribute（“l(fā)ist“?list）;
			rs.close（）;		//?錕截憋拷ResultSet
			stmt.close（）;	//?錕截憋拷Statement
			conn.close（）;	//?錕截憋拷Connection
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		//?錕斤拷錕斤拷轉(zhuǎn)錕斤拷錕斤拷book_list.jsp
		//request.getRequestDispatcher（“l(fā)bcx.jsp“）.forward（request?response）;
		request.getRequestDispatcher（“index.jsp“）.forward（request?response）;
	}

	

}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????1025??2017-12-20?18:39??index.jsp

?????文件????????538??2017-11-13?21:35??ZL_Data.java

?????文件???????2564??2017-11-13?21:37??ZLFindServlet.java

-----------?---------??----------?-----??----

?????????????????4127????????????????????3