package?ljh.flows.dao;

import?java.sql.SQLException;

import?ljh.flows.entity.Admin;
import?ljh.tools.jdbc.TxQueryRunner;

import?org.apache.commons.dbutils.QueryRunner;
import?org.apache.commons.dbutils.handlers.BeanHandler;

/**
?*?
?*?@author?ljh
?*?@date?2015-12-15?下午3:52:32
?*?@Description:?admin層的邏輯層
?*/
public?class?Admindao?{
????QueryRunner?qr?=?new?TxQueryRunner（）;?
	
	/**
??????*?按照用戶名查詢用戶
??????*/
	public?Admin?findByName（String?a_username）{
		String?sql?=?“SELECT?*?FROM?admin?WHERE?a_username=?“;
		try?{
			return?qr.query（sqlnew?BeanHandler（Admin.class）a_username）;
		}?catch?（SQLException?e）?{
			throw?new?RuntimeException（e）;
		}
	}

	/**
	?*?添加管理員
	?*/
			public?void?add（Admin?admin）{
				String?sql?=?“INSERT?INTO?admin?VALUES（???）“;
				object[]?param?=?{admin.getA_id（）admin.getA_username（）admin.getA_password（）};
				try?{
					qr.update（sql?param）;
				}?catch?（SQLException?e）?{
				throw?new?RuntimeException（e）;
				}
				
			}
}

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

?????文件????????607??2015-12-14?18:10??flows\.classpath

?????文件????????288??2015-12-14?17:28??flows\.mymetadata

?????文件???????1748??2015-12-14?18:49??flows\.project

?????文件????????500??2015-12-14?17:28??flows\.settings\.jsdtscope

?????文件????????152??2015-12-24?09:53??flows\.settings\com.genuitec.eclipse.core.prefs

?????文件????????122??2015-12-19?15:18??flows\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2015-12-14?17:28??flows\.settings\org.eclipse.jdt.core.prefs

?????文件????????453??2015-12-14?17:28??flows\.settings\org.eclipse.wst.common.component

?????文件????????252??2015-12-14?17:28??flows\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-12-14?17:28??flows\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-12-14?17:28??flows\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????526??2015-12-14?18:13??flows\src\c3p0-config.xml

?????文件???????1044??2015-12-15?17:01??flows\src\ljh\flows\dao\Admindao.java

?????文件???????1105??2015-12-14?19:07??flows\src\ljh\flows\dao\Ecoding.java

?????文件???????2661??2015-12-25?09:44??flows\src\ljh\flows\dao\Flowdao.java

?????文件???????1880??2015-12-14?19:07??flows\src\ljh\flows\dao\GetRequest.java

?????文件????????976??2015-12-24?15:06??flows\src\ljh\flows\dao\Orderdao.java

?????文件???????2046??2015-12-17?15:58??flows\src\ljh\flows\dao\Typedao.java

?????文件???????3913??2015-12-24?16:07??flows\src\ljh\flows\dao\Userdao.java

?????文件????????525??2015-12-15?15:51??flows\src\ljh\flows\entity\Admin.java

?????文件????????768??2015-12-16?14:07??flows\src\ljh\flows\entity\CartItem.java

?????文件???????1119??2015-12-16?10:15??flows\src\ljh\flows\entity\Flow.java

?????文件???????1417??2015-12-24?14:43??flows\src\ljh\flows\entity\Order.java

?????文件????????785??2015-12-24?14:43??flows\src\ljh\flows\entity\OrderItem.java

?????文件???????1416??2015-12-17?09:04??flows\src\ljh\flows\entity\ShopCart.java

?????文件????????407??2015-12-16?10:00??flows\src\ljh\flows\entity\Types.java

?????文件???????2284??2015-12-24?15:32??flows\src\ljh\flows\entity\User.java

?????文件???????1488??2015-12-15?17:31??flows\src\ljh\flows\service\AdminService.java

?????文件????????821??2015-12-25?09:45??flows\src\ljh\flows\service\FlowService.java

?????文件????????742??2015-12-14?18:32??flows\src\ljh\flows\service\MyException.java

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