package?com.yly.dao;



import?java.sql.ResultSet;
import?java.sql.SQLException;

import?com.mysql.jdbc.Connection;
import?com.mysql.jdbc.PreparedStatement;
import?com.yly.DB.DBconn;
import?com.yly.util.User;

public?class?UserDao?{
	public?User?login（String?usernameString?password）?{
		User?u=null;
		Connection?conn=null;
		PreparedStatement?ps=null;
		ResultSet?rs=null;
		try?{
			conn=DBconn.getconnection（）;
			String?sql=“select*from?user?where?username=??and?password=?“;
			ps=（PreparedStatement）?conn.prepareStatement（sql）;
			ps.setString（1?username）;
			ps.setString（2?password）;
			rs=ps.executeQuery（）;
			if（rs.next（））?{
				u=new?User（）;
				u.setName（rs.getString（“username“））;
				u.setPassword（rs.getString（“password“））;
				System.out.println（“登錄成功！“）;
			}
		}catch（Exception?e）?{
			e.printStackTrace（）;
		}finally?{
			DBconn.closeConn（conn）;
		}
		
		
		return?u;
	}
	
	
	
?????public?void?addUser（User?user）?{
????	?Connection?conn=null;
????	?PreparedStatement?ps=null;
????	?try?{
????	???conn=DBconn.getconnection（）;
????	???String?sql=“insert?into?user（usernamepassword）?values（??）“;
????	???ps=（PreparedStatement）?conn.prepareStatement（sql）;
????	???ps.setString（1user.getName（））;
????	???ps.setString（2?user.getPassword（））;
????	???ps.executeUpdate（）;
????	?}catch（SQLException?e）{
????		?e.printStackTrace（）;
????	?}finally?{
			DBconn.closeConn（conn）;
		}
?????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????939??2019-10-10?14:22??demo\.classpath
?????文件?????????904??2019-10-10?14:22??demo\.project
?????目錄???????????0??2019-10-14?09:07??demo\.settings\
?????文件?????????567??2019-10-10?14:22??demo\.settings\.jsdtscope
?????文件?????????364??2019-10-10?14:22??demo\.settings\org.eclipse.jdt.core.prefs
?????文件?????????464??2019-10-10?14:22??demo\.settings\org.eclipse.wst.common.component
?????文件?????????345??2019-10-10?14:22??demo\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2019-10-10?14:22??demo\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2019-10-10?14:22??demo\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2019-10-14?09:07??demo\build\
?????目錄???????????0??2019-10-14?09:07??demo\build\classes\
?????目錄???????????0??2019-10-14?09:07??demo\build\classes\com\
?????目錄???????????0??2019-10-14?09:07??demo\build\classes\com\yly\
?????目錄???????????0??2019-10-14?09:07??demo\build\classes\com\yly\dao\
?????文件????????2415??2019-10-10?17:37??demo\build\classes\com\yly\dao\UserDao.class
?????目錄???????????0??2019-10-14?09:07??demo\build\classes\com\yly\DB\
?????文件????????1265??2019-10-10?17:02??demo\build\classes\com\yly\DB\DBconn.class
?????目錄???????????0??2019-10-14?09:07??demo\build\classes\com\yly\servlet\
?????文件????????1939??2019-10-10?17:23??demo\build\classes\com\yly\servlet\addservlet.class
?????文件????????1695??2019-10-10?17:20??demo\build\classes\com\yly\servlet\LoginServlet.class
?????目錄???????????0??2019-10-14?09:07??demo\build\classes\com\yly\util\
?????文件?????????707??2019-10-10?14:43??demo\build\classes\com\yly\util\User.class
?????目錄???????????0??2019-10-14?09:07??demo\src\
?????目錄???????????0??2019-10-14?09:07??demo\src\com\
?????目錄???????????0??2019-10-14?09:07??demo\src\com\yly\
?????目錄???????????0??2019-10-14?09:07??demo\src\com\yly\dao\
?????文件????????1471??2019-10-10?17:37??demo\src\com\yly\dao\UserDao.java
?????目錄???????????0??2019-10-14?09:07??demo\src\com\yly\DB\
?????文件?????????664??2019-10-10?17:02??demo\src\com\yly\DB\DBconn.java
?????目錄???????????0??2019-10-14?09:07??demo\src\com\yly\servlet\
?????文件????????1238??2019-10-10?17:23??demo\src\com\yly\servlet\addservlet.java
............此處省略15個文件信息