package?com.softeem.xianyu.dao;

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

import?com.softeem.xianyu.db.DBUtil;
import?com.softeem.xianyu.dto.Admin;
import?com.softeem.xianyu.dto.HeadIcon;

/**
?*?Data?Access?object
?*?數據訪問層
?*?@author?Administrator
?*/
public?class?AdminDAO?{

	public?boolean?insert（）{
		
		return?false;
	}
	
	public?boolean?update（）{
		
		return?false;
	}
	
	public?ArrayList?findAll（）{
		
		return?null;
	}
	
	public?Admin?findByProperty（String?pnameobject?value）{
		String?sql?=?“select?*?from?tbadmin?where?“+pname+“=?“;
		try?{
			//獲取連接
			Connection?conn?=?DBUtil.getConn（）;
			//獲取處理命令
			PreparedStatement?ps?=?conn.prepareStatement（sql）;
			ps.setobject（1?value）;
			//執行查詢
			ResultSet?rs?=?ps.executeQuery（）;
			if（rs.next（））{
				//創建管理員，將從數據庫查詢到的數據裝入對象
				Admin?admin?=?new?Admin（）;
				admin.setId（rs.getInt（“id“））;
				admin.setUsername（rs.getString（“username“））;
				admin.setPassword（rs.getString（“password“））;
				admin.setPhone（rs.getString（“phone“））;
				//根據hid獲取頭像對象
				HeadIcon?icon?=?new?HeadIconDAO（）.findByHid（rs.getInt（“hid“））;
				admin.setIcon（icon）;
				return?admin;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?null;
	}
	
}

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

?????文件????????727??2017-06-26?15:09??xianyu\.classpath

?????文件???????1490??2017-06-24?14:43??xianyu\.project

?????文件????????503??2017-06-23?09:31??xianyu\.settings\.jsdtscope

?????文件???????1680??2017-06-29?08:25??xianyu\.settings\.svn\entries

?????文件?????????53??2017-06-29?08:25??xianyu\.settings\.svn\prop-base\org.eclipse.jpt.entitygen.new-mysql.database.svn-base

?????文件????????503??2017-06-29?08:25??xianyu\.settings\.svn\text-base\.jsdtscope.svn-base

?????文件????????115??2017-06-29?08:25??xianyu\.settings\.svn\text-base\org.eclipse.core.resources.prefs.svn-base

?????文件????????364??2017-06-29?08:25??xianyu\.settings\.svn\text-base\org.eclipse.jdt.core.prefs.svn-base

?????文件????????130??2017-06-29?08:25??xianyu\.settings\.svn\text-base\org.eclipse.jpt.core.prefs.svn-base

?????文件???????2301??2017-06-29?08:25??xianyu\.settings\.svn\text-base\org.eclipse.jpt.entitygen.new-mysql.database.svn-base

?????文件????????472??2017-06-29?08:25??xianyu\.settings\.svn\text-base\org.eclipse.wst.common.component.svn-base

?????文件????????305??2017-06-29?08:25??xianyu\.settings\.svn\text-base\org.eclipse.wst.common.project.facet.core.xml.svn-base

?????文件?????????49??2017-06-29?08:25??xianyu\.settings\.svn\text-base\org.eclipse.wst.jsdt.ui.superType.container.svn-base

?????文件??????????6??2017-06-29?08:25??xianyu\.settings\.svn\text-base\org.eclipse.wst.jsdt.ui.superType.name.svn-base

?????文件????????115??2017-06-23?09:43??xianyu\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2017-06-23?09:31??xianyu\.settings\org.eclipse.jdt.core.prefs

?????文件????????130??2017-06-26?14:30??xianyu\.settings\org.eclipse.jpt.core.prefs

?????文件???????2301??2017-06-26?14:32??xianyu\.settings\org.eclipse.jpt.entitygen.new-mysql.database

?????文件????????472??2017-06-23?09:31??xianyu\.settings\org.eclipse.wst.common.component

?????文件????????305??2017-06-26?14:53??xianyu\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-06-23?09:31??xianyu\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-06-23?09:31??xianyu\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????163??2017-06-29?08:25??xianyu\build\.svn\entries

?????文件????????157??2017-06-29?08:26??xianyu\build\classes\.svn\entries

?????文件???????2433??2017-06-30?09:26??xianyu\build\classes\com\softeem\xianyu\dao\AdminDAO.class

?????文件???????1535??2017-06-30?09:26??xianyu\build\classes\com\softeem\xianyu\dao\HeadIconDAO$1.class

?????文件???????1514??2017-06-30?09:26??xianyu\build\classes\com\softeem\xianyu\dao\HeadIconDAO$2.class

?????文件???????1519??2017-06-30?09:26??xianyu\build\classes\com\softeem\xianyu\dao\HeadIconDAO$3.class

?????文件???????1270??2017-06-30?09:26??xianyu\build\classes\com\softeem\xianyu\dao\HeadIconDAO$4.class

?????文件???????2485??2017-06-30?09:26??xianyu\build\classes\com\softeem\xianyu\dao\HeadIconDAO.class

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