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）;
				}
				
			}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-12-14?17:28??flows\
?????文件????????5810??2015-12-28?12:32??flowshop.sql
?????文件?????????607??2015-12-14?18:10??flows\.classpath
?????目錄???????????0??2015-12-14?17:28??flows\.myeclipse\
?????文件?????????288??2015-12-14?17:28??flows\.mymetadata
?????文件????????1748??2015-12-14?18:49??flows\.project
?????目錄???????????0??2015-12-15?18:25??flows\.settings\
?????文件?????????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
?????目錄???????????0??2015-12-14?17:51??flows\src\
?????文件?????????526??2015-12-14?18:13??flows\src\c3p0-config.xml
?????目錄???????????0??2015-12-14?18:09??flows\src\ljh\
?????目錄???????????0??2015-12-14?17:53??flows\src\ljh\flows\
?????目錄???????????0??2015-12-24?14:44??flows\src\ljh\flows\dao\
?????文件????????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
?????目錄???????????0??2015-12-24?14:42??flows\src\ljh\flows\entity\
?????文件?????????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
............此處省略251個文件信息