package?com.yw.servlet;

import?java.io.IOException;
import?java.io.InputStream;
import?java.io.PrintWriter;
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?org.apache.ibatis.io.Resources;
import?org.apache.ibatis.session.SqlSession;
import?org.apache.ibatis.session.SqlSessionFactory;
import?org.apache.ibatis.session.SqlSessionFactoryBuilder;

import?com.yw.test12.Condition;

public?class?StudentServlet?extends?HttpServlet
{

	/**
	?*?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
	{

		doPost（request?response）;
	}

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

	?*?
	?*?This?method?is?called?when?a?form?has?its?tag?value?method?equals?to?post.
	?*?
	?*?@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?doPost（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException
	{

		response.setCharacterEncoding（“utf-8“）;

		

		String?spage?=?request.getParameter（“page“）;
		System.out.println（“spage=“?+?spage）;
		int?page?=?1;
		if?（spage?!=?null）
		{
			try
			{
				page?=?Integer.parseInt（spage）;
				if（page<1）
				{
					throw?new?Exception（）;
				}
					
			}
			catch?（Exception?e）
			{
				request.setAttribute（“error“?“page不合法“）;
				request.getRequestDispatcher（“student.jsp“）.forward（request?response）;

			}
		}

		String?resource?=?“com/yw/test12/mybatis-config.xml“;
		InputStream?inputStream?=?Resources.getResourceAsStream（resource）;
		SqlSessionFactory?sqlSessionFactory?=?new?SqlSessionFactoryBuilder（）.build（inputStream）;

		SqlSession?session?=?sqlSessionFactory.openSession（false）;
		try
		{
			System.out.println（“=====動態(tài)SQL======“）;
			Condition?s1?=?new?Condition（）;
			//?s1.setName（“%a%“）;
			//?s1.setName（““）;
			s1.setStart（（page?-?1）?*?3）;//?/////////////
			s1.setCount（3）;

			List?user?=?session.selectList（“com.yw.test12.StudentMapper.findStudent“?s1）;
			System.out.println（user）;

			//?ArrayList?s=（ArrayList）db.query（“select?*?from?user?limit?“+?（page-1）*3+“3“）;

			System.out.println（“s=“?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-06-17?16:39??jspServletMyBatis\
?????文件????????1093??2016-06-16?16:49??jspServletMyBatis\.classpath
?????文件????????1342??2016-06-17?15:33??jspServletMyBatis\.project
?????目錄???????????0??2016-06-17?16:39??jspServletMyBatis\.settings\
?????文件?????????522??2016-06-16?16:49??jspServletMyBatis\.settings\.jsdtscope
?????文件?????????364??2016-06-16?16:49??jspServletMyBatis\.settings\org.eclipse.jdt.core.prefs
?????文件?????????512??2016-06-16?16:49??jspServletMyBatis\.settings\org.eclipse.wst.common.component
?????文件?????????414??2016-06-16?16:49??jspServletMyBatis\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2016-06-16?16:49??jspServletMyBatis\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-06-16?16:49??jspServletMyBatis\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2016-06-17?16:39??jspServletMyBatis\src\
?????目錄???????????0??2016-06-17?16:39??jspServletMyBatis\src\com\
?????目錄???????????0??2016-06-17?16:39??jspServletMyBatis\src\com\yw\
?????目錄???????????0??2016-06-17?16:39??jspServletMyBatis\src\com\yw\servlet\
?????文件????????3678??2016-06-17?16:34??jspServletMyBatis\src\com\yw\servlet\StudentServlet.java
?????目錄???????????0??2016-06-17?16:39??jspServletMyBatis\src\com\yw\test12\
?????文件?????????583??2016-06-16?15:58??jspServletMyBatis\src\com\yw\test12\Condition.java
?????文件?????????809??2016-06-16?15:39??jspServletMyBatis\src\com\yw\test12\mybatis-config.xml
?????文件?????????748??2016-06-16?15:39??jspServletMyBatis\src\com\yw\test12\Student.java
?????文件?????????581??2016-06-17?16:24??jspServletMyBatis\src\com\yw\test12\StudentMapper.xml
?????文件????????1020??2016-06-16?16:19??jspServletMyBatis\src\com\yw\test12\Test01.java
?????文件??????????96??2016-06-14?17:00??jspServletMyBatis\src\config.properties
?????目錄???????????0??2016-06-17?16:39??jspServletMyBatis\WebRoot\
?????文件?????????829??2016-06-16?16:49??jspServletMyBatis\WebRoot\index.jsp
?????目錄???????????0??2016-06-17?16:39??jspServletMyBatis\WebRoot\meta-INF\
?????文件??????????39??2016-06-16?16:49??jspServletMyBatis\WebRoot\meta-INF\MANIFEST.MF
?????文件????????1741??2016-06-17?16:15??jspServletMyBatis\WebRoot\student.jsp
?????目錄???????????0??2016-06-17?16:39??jspServletMyBatis\WebRoot\WEB-INF\
?????目錄???????????0??2016-06-17?16:39??jspServletMyBatis\WebRoot\WEB-INF\classes\
?????目錄???????????0??2016-06-17?16:39??jspServletMyBatis\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2016-06-17?16:39??jspServletMyBatis\WebRoot\WEB-INF\classes\com\yw\
............此處省略13個文件信息