package?dao;
import?java.sql.*;
import?java.util.*;

import?vo.Book;
import?vo.User;
import?dbc.JdbcUtil;
public?class?UserDao?{

	public?int?add（User?user）?throws?Exception?{
		Connection?con?=?null;
		PreparedStatement?ps?=?null;
		
		try?{
			con?=?JdbcUtil.getConnection（）;
			String?sql?=?“insert?into?login（userNameuserPwdrealNamesexemail）?values（?????）“;
			ps?=?con.prepareStatement（sql）;
			ps.setString（1user.getUserName（））;
			ps.setString（2user.getUserPwd（））;
			ps.setString（3user.getRealName（））;
			ps.setString（4user.getSex（））;
			ps.setString（5user.getEmail（））;
			int?i?=ps.executeUpdate（）;
			return?i;
		}?finally?{?JdbcUtil.free（nullpscon）;}
	}
	
	public?boolean?login（User?user）?throws?Exception?{
			Connection?con?=?null;
			PreparedStatement?ps?=?null;
			ResultSet?rs?=?null;
			try?{
		????con?=?JdbcUtil.getConnection（）;
		????boolean?i?=?false;
		????String?sql?=?“select?*?from?login?where?userName=??and?userPwd=?“;
		??
		????ps?=?con.prepareStatement（sql）;
		????ps.setString（1user.getUserName（））;
		????ps.setString（2user.getUserPwd（））;
		??
		????rs?=?ps.executeQuery（）;
		????if?（rs.next（））?{
		????	user.setId（rs.getInt（“id“））;
		????	i?=?true;
		???}?else?{
			???i?=?false?;
		???}
		???return?i;
		}?finally?{?JdbcUtil.free（rspscon）;}
	}
	
	//按姓名查找自動登錄帳號的id
		public?User?Lookup（String?Cname）?throws?Exception?{
			
			Connection?conn?=?null;
			PreparedStatement?ps?=?null;
			ResultSet?rs?=?null;
			User?user?=?null;?
			try?{
				conn?=?JdbcUtil.getConnection（）;
				String?s?=?“‘“+“%“?+?Cname?+?“%“?+?“‘“;
				String?sql=“select?id?from?login?where?userName?like?“?+?s;
				ps?=?conn.prepareStatement（sql）;
				rs?=?ps.executeQuery（）;
				if（rs.next（））?{
					user?=?new?User（）;
					user.setId（rs.getInt（“id“））;
				}
			}?finally?{
				JdbcUtil.free（rspsconn）;
			}
			return?user;
		}
}?

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

?????文件???????1202??2015-11-19?23:47??friends\.classpath

?????文件????????294??2015-11-19?18:21??friends\.mymetadata

?????文件???????1750??2015-11-12?18:08??friends\.project

?????文件????????500??2015-11-12?17:54??friends\.settings\.jsdtscope

?????文件????????247??2015-11-19?23:47??friends\.settings\com.genuitec.eclipse.migration.prefs

?????文件????????364??2015-11-12?17:54??friends\.settings\org.eclipse.jdt.core.prefs

?????文件????????547??2015-11-19?23:47??friends\.settings\org.eclipse.wst.common.component

?????文件????????359??2015-11-19?23:47??friends\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-11-12?17:54??friends\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-11-12?17:54??friends\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1940??2015-11-23?22:17??friends\src\dao\UserDao.java

?????文件???????7316??2015-11-23?10:35??friends\src\dao\User_Book.java

?????文件????????139??2015-11-12?18:23??friends\src\db.properties

?????文件???????1213??2015-11-12?18:05??friends\src\dbc\JdbcUtil.java

?????文件?????????25??2015-11-19?23:47??friends\src\meta-INF\MANIFEST.MF

?????文件???????1816??2015-11-23?09:49??friends\src\servlets\Add.java

?????文件???????1798??2015-11-23?21:36??friends\src\servlets\LoginCheck.java

?????文件???????1765??2015-11-16?23:22??friends\src\servlets\RegisterCheck.java

?????文件???????1637??2015-11-16?23:29??friends\src\servlets\Update.java

?????文件???????1397??2015-11-23?09:14??friends\src\vo\Book.java

?????文件????????913??2015-11-12?18:02??friends\src\vo\User.java

?????文件???????1506??2015-11-14?09:32??friends\WebRoot\add.jsp

?????文件????????924??2015-11-23?11:07??friends\WebRoot\delete.jsp

?????文件???????3638??2015-12-07?18:25??friends\WebRoot\find.jsp

?????文件???????3830??2015-11-23?22:15??friends\WebRoot\find_update.jsp

?????文件???????3207??2015-11-27?09:35??friends\WebRoot\index.jsp

?????文件???????1289??2015-11-18?23:38??friends\WebRoot\login\cookies_fail.jsp

?????文件????????321??2015-11-22?11:01??friends\WebRoot\login\leave.jsp

?????文件???????2273??2015-11-23?11:21??friends\WebRoot\login\Login.jsp

?????文件????????964??2015-11-10?09:33??friends\WebRoot\login\Login_failure.jsp

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