package?real.action.dao;

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

import?real.action.sql.ConnectionFactory;

public?class?LoginDao?{
	public?static?boolean?isLogin（String?uname?String?passwd）?{
		Connection?conn?=?null;
		PreparedStatement?stm?=?null;
		ResultSet?rs?=?null;
		String?sql?=?“select?*?from?users?where?u_name=??and?u_password=?“;
		try?{
			conn?=?ConnectionFactory.getConnection（）;
			stm?=?conn.prepareStatement（sql）;
			stm.setString（1?uname）;
			stm.setString（2?passwd）;
			rs?=?stm.executeQuery（）;
			if?（rs.next（））
				return?true;
			else
				return?false;
		}?catch?（Exception?e）?{
			//?因為使用ConnectionFactory工廠類維護一個線程安全的connection?執行完成或發生異常時并不需要關閉conn!
			e.printStackTrace（）;
			return?false;
		}?finally?{
			try?{
				rs.close（）;
				stm.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-11-10?09:40??WMS-master\
?????目錄???????????0??2012-11-10?09:40??WMS-master\CRM\
?????文件?????????385??2012-11-10?09:40??WMS-master\CRM\.classpath
?????文件?????????379??2012-11-10?09:40??WMS-master\CRM\.project
?????目錄???????????0??2012-11-10?09:40??WMS-master\CRM\.settings\
?????文件??????????88??2012-11-10?09:40??WMS-master\CRM\.settings\org.eclipse.core.resources.prefs
?????文件?????????137??2012-11-10?09:40??WMS-master\CRM\.settings\org.eclipse.ltk.core.refactoring.prefs
?????目錄???????????0??2012-11-10?09:40??WMS-master\CRM\bin\
?????目錄???????????0??2012-11-10?09:40??WMS-master\CRM\bin\bin\
?????文件??????493105??2012-11-10?09:40??WMS-master\CRM\bin\bin\mysql-connector-java-5.0.3-bin.jar
?????目錄???????????0??2012-11-10?09:40??WMS-master\CRM\bin\real\
?????目錄???????????0??2012-11-10?09:40??WMS-master\CRM\bin\real\action\
?????目錄???????????0??2012-11-10?09:40??WMS-master\CRM\bin\real\action\MD5\
?????文件????????1219??2012-11-10?09:40??WMS-master\CRM\bin\real\action\MD5\MD5.class
?????目錄???????????0??2012-11-10?09:40??WMS-master\CRM\bin\real\action\dao\
?????文件????????1406??2012-11-10?09:40??WMS-master\CRM\bin\real\action\dao\LoginDao.class
?????文件????????5995??2012-11-10?09:40??WMS-master\CRM\bin\real\action\dao\ProductDao.class
?????文件????????6295??2012-11-10?09:40??WMS-master\CRM\bin\real\action\dao\SupplierDao.class
?????文件????????2837??2012-11-10?09:40??WMS-master\CRM\bin\real\action\dao\UserDao.class
?????目錄???????????0??2012-11-10?09:40??WMS-master\CRM\bin\real\action\data\
?????文件????????3910??2012-11-10?09:40??WMS-master\CRM\bin\real\action\data\MyTable.class
?????文件????????2202??2012-11-10?09:40??WMS-master\CRM\bin\real\action\data\ProductData.class
?????文件????????2350??2012-11-10?09:40??WMS-master\CRM\bin\real\action\data\SupplierData.class
?????文件?????????889??2012-11-10?09:40??WMS-master\CRM\bin\real\action\data\UserData.class
?????目錄???????????0??2012-11-10?09:40??WMS-master\CRM\bin\real\action\internalframe\
?????文件????????4866??2012-11-10?09:40??WMS-master\CRM\bin\real\action\internalframe\CheckProductPanel.class
?????文件????????2819??2012-11-10?09:40??WMS-master\CRM\bin\real\action\internalframe\CheckSupplierPanel.class
?????文件????????2235??2012-11-10?09:40??WMS-master\CRM\bin\real\action\internalframe\ExportSearchResult.class
?????文件????????3236??2012-11-10?09:40??WMS-master\CRM\bin\real\action\internalframe\ImportProductPanel.class
?????文件?????????662??2012-11-10?09:40??WMS-master\CRM\bin\real\action\internalframe\ModifyUserPassword.class
?????文件????????3184??2012-11-10?09:40??WMS-master\CRM\bin\real\action\internalframe\ModifyUserPasswordPanel.class
............此處省略121個文件信息