package?com.DAO;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

public?class?UserDao?{

	public?static?String?url=“jdbc:mysql://localhost:3306/servlet?user=root&password=123“
			+?“&useUnicode=true&characterEncoding=utf8“;
	
	public?boolean?login（String?userString?pwdint?role）?{
		boolean?flag=false;
		try?{
			//加載JDBC驅動
			Class.forName（“com.mysql.jdbc.Driver“）;
			
			//建立連接
			Connection?connection=DriverManager.getConnection（url）;
			
			//創建Statement
			String?sql=“select?*?from?login?where?username=??and?password=??and?sort=?“;
			
			PreparedStatement?stmtPreparedStatement=connection.prepareStatement（sql）;
			
			//填充占位符
			stmtPreparedStatement.setobject（1?user）;
			stmtPreparedStatement.setobject（2?pwd）;
			stmtPreparedStatement.setobject（3?role）;
			
			ResultSet?rs=stmtPreparedStatement.executeQuery（）;
			
			if（rs.next（））
			{
				flag=true;
			}
			rs.close（）;
			stmtPreparedStatement.close（）;
			connection.close（）;
						
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
			System.out.println（“登錄異常為:“+e.getMessage（））;
		}
		return?flag;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-06-18?20:13??Servlet\
?????文件????????1187??2017-06-14?20:23??Servlet\.classpath
?????文件????????1057??2017-06-13?15:31??Servlet\.project
?????目錄???????????0??2017-06-18?20:13??Servlet\.settings\
?????文件?????????564??2017-06-13?15:31??Servlet\.settings\.jsdtscope
?????文件??????????66??2017-06-13?15:54??Servlet\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2017-06-13?15:31??Servlet\.settings\org.eclipse.jdt.core.prefs
?????文件?????????480??2017-06-13?15:31??Servlet\.settings\org.eclipse.wst.common.component
?????文件?????????414??2017-06-13?15:31??Servlet\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-06-13?15:31??Servlet\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-06-13?15:31??Servlet\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-06-18?20:14??Servlet\WebRoot\
?????目錄???????????0??2017-06-18?20:14??Servlet\WebRoot\meta-INF\
?????文件??????????39??2017-06-13?15:31??Servlet\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2017-06-18?20:13??Servlet\WebRoot\WEB-INF\
?????目錄???????????0??2017-06-18?20:13??Servlet\WebRoot\WEB-INF\classes\
?????目錄???????????0??2017-06-18?20:13??Servlet\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2017-06-18?20:14??Servlet\WebRoot\WEB-INF\classes\com\DAO\
?????文件????????2174??2017-06-18?10:36??Servlet\WebRoot\WEB-INF\classes\com\DAO\UserDao.class
?????目錄???????????0??2017-06-18?20:14??Servlet\WebRoot\WEB-INF\classes\com\Servlet\
?????文件????????3716??2017-06-18?18:30??Servlet\WebRoot\WEB-INF\classes\com\Servlet\DownLoadServlet.class
?????文件????????2703??2017-06-18?18:34??Servlet\WebRoot\WEB-INF\classes\com\Servlet\ListFileServlet.class
?????文件????????1225??2017-06-18?20:00??Servlet\WebRoot\WEB-INF\classes\com\Servlet\UploadHandleServlet$1.class
?????文件????????6686??2017-06-18?20:00??Servlet\WebRoot\WEB-INF\classes\com\Servlet\UploadHandleServlet.class
?????文件????????2631??2017-06-18?10:36??Servlet\WebRoot\WEB-INF\classes\com\Servlet\UserServlet.class
?????目錄???????????0??2017-06-18?20:14??Servlet\WebRoot\WEB-INF\lib\
?????文件???????57779??2017-06-18?09:41??Servlet\WebRoot\WEB-INF\lib\commons-fileupload-1.2.1.jar
?????文件???????87776??2017-06-18?09:41??Servlet\WebRoot\WEB-INF\lib\commons-io-1.3.2.jar
?????文件??????832960??2015-04-22?12:54??Servlet\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.22-bin.jar
?????文件?????????832??2017-06-14?20:42??Servlet\WebRoot\index.jsp
?????文件?????????653??2017-06-18?20:04??Servlet\WebRoot\listfile.jsp
............此處省略11個文件信息