package?com.admin.dao;

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

import?com.admin.vo.Admin;
import?com.wht.page.PageBean;
import?com.wht.user.util.DBUtil;
import?com.wht.user.util.StringUtil;

public?class?AdminDao?{

	public?Admin?Login（String?aname?String?apwd）?{
		Admin?admin?=null;
		Connection?connection?=?null;
		PreparedStatement?pst?=?null;
		ResultSet?rest?=?null;
		String?sql?=?“SELECT?*?FROM?admin?WHERE?ANAME?=???AND?APWD?=??“;
		try?{
			connection?=?DBUtil.getConnection（）;
			pst??=?DBUtil.getPstmt（connection?sql）;
			pst.setString（1aname）;
			pst.setString（2apwd）;
			rest?=?pst.executeQuery（）;
			if（rest.next（））{
				admin?=?new?Admin（）;
				admin.setAid（rest.getInt（“aid“））;
				admin.setAname（rest.getString（“aname“））;
				admin.setApwd（rest.getString（“apwd“））;
			}?
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
			DBUtil.closeAll（connection?pst?rest）;
		}
		return?admin;
	}

	public?ResultSet?adminlist（Connection?con?PageBean?pagebean?Admin?admin）?throws?Exception?{
		StringBuffer?sql?=?new?StringBuffer（“select?*?from?admin“）;
		if（StringUtil.isEmpty（admin.getAname（）））{
			sql.append（“?and?uname?like‘%“+admin.getAname（）+“%‘“）;
		}
		if（pagebean!=null）{
			sql.append（“?limit?“+pagebean.getStart（）+““+pagebean.getRows（））;
		}
		PreparedStatement?pst?=?con.prepareStatement（sql.toString（）.replaceFirst（“and““where“））;	
		return?pst.executeQuery（）;
	}

	public?int?getadmin（Connection?con?Admin?admin）?{
		try?{
			StringBuffer?sql?=?new?StringBuffer（“?select?count（*）?as?total?from?admin“）;
			if（StringUtil.isNotEmpty（admin.getAname（）））{
				sql.append（“?and?uname?like?‘%“?+?admin.getAname（）+“%‘“）;
			}
			PreparedStatement?pst?=?con.prepareStatement（sql.toString（）.replaceFirst（“and“?“where“））;
			ResultSet?rs?=?pst.executeQuery（）;
			if（rs.next（））{
				return?rs.getInt（“total“）;
			}else{
				return?0;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?0;
	}
	}

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

?????文件???????1093??2017-11-21?20:38??wht_studentsystems\.classpath

?????文件?????????66??2018-02-21?21:17??wht_studentsystems\.myumldata

?????文件???????1343??2017-11-23?18:58??wht_studentsystems\.project

?????文件????????522??2017-11-21?20:38??wht_studentsystems\.settings\.jsdtscope

?????文件?????????80??2018-02-22?17:12??wht_studentsystems\.settings\com.genuitec.eclipse.core.prefs

?????文件???????1009??2018-03-30?18:27??wht_studentsystems\.settings\com.genuitec.eclipse.j2eedt.core.prefs

?????文件????????177??2018-05-15?11:45??wht_studentsystems\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2017-11-21?20:38??wht_studentsystems\.settings\org.eclipse.jdt.core.prefs

?????文件????????499??2018-03-30?18:27??wht_studentsystems\.settings\org.eclipse.wst.common.component

?????文件????????414??2017-11-21?20:38??wht_studentsystems\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-11-21?20:38??wht_studentsystems\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-11-21?20:38??wht_studentsystems\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????568??2018-02-22?10:42??wht_studentsystems\.settings\org.eclipse.wst.validation.prefs

?????文件?????????87??2018-02-22?10:42??wht_studentsystems\.settings\org.eclipse.wst.ws.service.policy.prefs

?????文件????????232??2018-02-22?10:42??wht_studentsystems\.settings\org.eclipse.wst.xsl.core.prefs

?????文件???????2183??2018-05-15?21:56??wht_studentsystems\src\com\admin\dao\AdminDao.java

?????文件???????1683??2018-05-15?21:59??wht_studentsystems\src\com\admin\service\AdminList.java

?????文件???????1439??2018-05-15?18:15??wht_studentsystems\src\com\admin\service\AdminLoginServlet.java

?????文件????????811??2018-05-15?19:28??wht_studentsystems\src\com\admin\util\LoginoutUtil.java

?????文件????????448??2018-05-15?11:39??wht_studentsystems\src\com\admin\vo\Admin.java

?????文件???????1045??2018-05-16?16:36??wht_studentsystems\src\com\teacher\vo\Teacher.java

?????文件???????2510??2018-03-07?17:19??wht_studentsystems\src\com\wht\course\dao\CourseDao.java

?????文件???????1167??2018-03-06?15:54??wht_studentsystems\src\com\wht\course\vo\Course.java

?????文件???????1725??2018-03-05?19:58??wht_studentsystems\src\com\wht\course\web\CourseListServlet.java

?????文件???????1779??2018-03-07?16:01??wht_studentsystems\src\com\wht\course\web\CourseSave.java

?????文件???????1436??2018-03-05?18:59??wht_studentsystems\src\com\wht\course\web\DeleteCourseServlet.java

?????文件????????763??2018-03-07?17:09??wht_studentsystems\src\com\wht\page\PageBean.java

?????文件???????3344??2018-03-07?16:40??wht_studentsystems\src\com\wht\user\dao\UserDao.java

?????文件???????1471??2018-03-07?16:15??wht_studentsystems\src\com\wht\user\service\DeleteUser.java

?????文件???????1465??2018-05-15?10:33??wht_studentsystems\src\com\wht\user\service\UserLoginServlet.java

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