package?com.ningmeng.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;

import?javax.mail.Session;

import?com.ningmeng.model.User;
import?com.ningmeng.util.DbUtil;

public?class?UserDao?{

	public?int?login（String?username?String?password）?throws?Exception?{
		Connection?con?=?（Connection）?DbUtil.getCon（）;
		String?sql?=?“select?*?from?user?where?username=??and?password=?“;
		try{
			PreparedStatement?ps?=?con.prepareStatement（sql）;//
			ps.setString（1?username）;
			ps.setString（2?password）;
			ResultSet?rs?=?ps.executeQuery（）;
			if?（rs.next（））?{
				return?1;//?chenggong
			}
		}catch（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			DbUtil.getClose（con）;
		}
		return?0;

	}

	public?int?register（String?id?String?username?String?password）
			throws?Exception?{
		Connection?con?=?（Connection）?DbUtil.getCon（）;
		String?sql?=?“INSERT?INTO?user（idusernamepassword）VALUES（‘“?+?id
				+?“‘‘“?+?username?+?“‘‘“?+?password?+?“‘）“;
		try{
		PreparedStatement?ps?=?con.prepareStatement（sql）;
		ResultSet?rs?=?ps.executeQuery（“select?username?from?user?“）;
		while?（rs.next（））?{
			if?（username.equals（rs.getString（“username“）））?{
				return?0;
			}
		}
		ps.executeUpdate（sql）;
		}catch（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			DbUtil.getClose（con）;
		}
		return?1;

	}
	
	public?ArrayList?list（String?username）?throws?Exception?{
		
		ArrayList?userlist?=?new?ArrayList（）;
		Connection?con?=?（Connection）?DbUtil.getCon（）;
		String?sql?=?“select?*?from?user?where?username=??“;
		try{
		PreparedStatement?ps?=?con.prepareStatement（sql）;
		ps.setString（1?username）;
		ResultSet?rs?=?ps.executeQuery（）;
		
		if?（rs.next（））?{
			User?user?=?new?User（）;
			user.setId（rs.getInt（“id“））;
			user.setUsername（rs.getString（“username“））;
			user.setPassword（rs.getString（“password“））;
			userlist.add（user）;
			//return?1;//?chenggong	
		}}catch（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			DbUtil.getClose（con）;
		}
		//return?0;
		return?userlist;

	}
	
	/*public?static?void?main（String[]?args）?throws?SQLException?{?UserDao?dao
	??=?new?UserDao（）;?int?i;?try?{?i?=?dao.list（“f“）;
	??System.out.println（i）;?}?catch?（Exception?e）?{?
	??e.printStackTrace（）;?}??}*/
	?
}

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

?????文件????????529??2017-11-19?10:50??User\.classpath

?????文件????????285??2017-11-19?10:50??User\.mymetadata

?????文件???????1747??2017-11-19?11:41??User\.project

?????文件????????500??2017-11-19?10:50??User\.settings\.jsdtscope

?????文件????????395??2017-11-19?10:50??User\.settings\org.eclipse.jdt.core.prefs

?????文件????????450??2017-11-19?10:50??User\.settings\org.eclipse.wst.common.component

?????文件????????252??2017-11-19?10:50??User\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-11-19?10:50??User\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-11-19?10:50??User\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2405??2017-11-29?22:41??User\src\com\ningmeng\dao\UserDao.java

?????文件????????790??2017-11-27?10:55??User\src\com\ningmeng\model\User.java

?????文件???????1224??2017-11-29?22:31??User\src\com\ningmeng\util\DbUtil.java

?????文件???????1177??2017-11-29?20:51??User\src\com\ningmeng\web\ListServlet.java

?????文件???????1226??2017-11-28?16:25??User\src\com\ningmeng\web\LoginServlet.java

?????文件???????1244??2017-11-28?16:34??User\src\com\ningmeng\web\RegisterServlet.java

?????文件????????834??2017-11-19?10:50??User\WebRoot\index.jsp

?????文件????????710??2017-11-28?17:18??User\WebRoot\list.jsp

?????文件????????494??2017-11-28?17:36??User\WebRoot\list_fail.jsp

?????文件????????696??2017-11-29?21:40??User\WebRoot\list_success.jsp

?????文件???????1080??2017-11-28?17:04??User\WebRoot\login.jsp

?????文件????????486??2017-11-28?16:27??User\WebRoot\login_fail.jsp

?????文件????????961??2017-11-28?16:24??User\WebRoot\login_success.jsp

?????文件?????????36??2017-11-19?10:50??User\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1082??2017-11-28?16:44??User\WebRoot\register.jsp

?????文件????????494??2017-11-29?22:42??User\WebRoot\register_fail.jsp

?????文件????????542??2017-11-28?16:47??User\WebRoot\register_success.jsp

?????文件???????3302??2017-11-29?22:41??User\WebRoot\WEB-INF\classes\com\ningmeng\dao\UserDao.class

?????文件????????928??2017-11-27?10:55??User\WebRoot\WEB-INF\classes\com\ningmeng\model\User.class

?????文件???????1306??2017-11-29?22:31??User\WebRoot\WEB-INF\classes\com\ningmeng\util\DbUtil.class

?????文件???????1854??2017-11-29?20:51??User\WebRoot\WEB-INF\classes\com\ningmeng\web\ListServlet.class

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