package?dao;

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

import?pojo.Administrators;
import?java.sql.Connection;
import?java.util.ArrayList;

public?class?AdminDao?{
	public?Administrators?checkLogin（String?aIDcardno?String?apassword）?{
		Connection?con?=?null;
		Administrators?ad?=?new?Administrators（）;
		try?{

			Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
			String?url?=?“jdbc:sqlserver://127.0.0.1:1433;DatabaseName=wb“;
			con?=?DriverManager.getConnection（url?“sa“?“331796768“）;

			String?sql?=?“select?top?1?aidanameatelaadrressaQQaIDcardnoapassword?from?administrator?where?aIDcardno=??and?apassword=?“;
			PreparedStatement?pre?=?con.prepareStatement（sql）;
			pre.setString（1?aIDcardno）;
			pre.setString（2?apassword）;

			ResultSet?rs?=?pre.executeQuery（）;
			if?（rs.next（））?{
				ad.setAid（rs.getInt（1））;
				ad.setAname（rs.getString（2））;
				ad.setAtel（rs.getString（3））;
				ad.setAadrress（rs.getString（4））;
				ad.setaQQ（rs.getString（5））;
				ad.setaIDcardno（rs.getString（6））;
				ad.setApassword（rs.getString（7））;
			}
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?ad;
	}

	//?得到所有的部門

	public?ArrayList?getAllAdministrators（）?{
		ArrayList?list?=?new?ArrayList（）;
		Connection?con?=?null;
		try?{

			Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
			String?url?=?“jdbc:sqlserver://127.0.0.1:1433;DatabaseName=wb“;
			con?=?DriverManager.getConnection（url?“sa“?“331796768“）;
			String?sql?=?“select?aidanameaQQ?from?administrator“;
			PreparedStatement?pre?=?con.prepareStatement（sql）;
			ResultSet?rs?=?pre.executeQuery（）;
			while?（rs.next（））?{
				Administrators?ad?=?new?Administrators（）;
				ad.setAid（rs.getInt（1））;
				ad.setAname（rs.getString（2））;
				ad.setaQQ（rs.getString（3））;
				list.add（ad）;
			}
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?finally?{
			try?{
				con.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		return?list;
	}

	public?int?addAdmin（String?aname?String?atel?String?aadr?String?aqq
			String?aIDc?String?apassword）?{
		int?n?=?0;
		Connection?con?=?null;
		try?{
			Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
			String?url?=?“jdbc:sqlserver://127.0.0.1:1433;DatabaseName=wb“;
			con?=?DriverManager.getConnection（url?“sa“?“331796768“）;

			String?sql1?=?“insert?into?administrator（anameatelaadrressaQQaIDcardnoapassword）?values（??????）“;

			PreparedStatement

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

?????文件????????529??2016-11-26?14:22??wangb\.classpath

?????文件????????806??2017-03-18?10:39??wangb\.myeclipse\profiler\view.xml

?????文件????????288??2016-11-26?14:22??wangb\.mymetadata

?????文件???????1748??2016-11-26?20:40??wangb\.project

?????文件????????500??2016-11-26?14:22??wangb\.settings\.jsdtscope

?????文件????????364??2016-11-26?14:22??wangb\.settings\org.eclipse.jdt.core.prefs

?????文件????????453??2016-11-26?14:22??wangb\.settings\org.eclipse.wst.common.component

?????文件????????252??2016-11-26?14:22??wangb\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2016-11-26?14:22??wangb\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2016-11-26?14:22??wangb\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2555??2016-11-26?19:57??wangb\SQLQuery1.sql

?????文件???????6801??2016-12-16?21:40??wangb\src\dao\AdminDao.java

?????文件???????2272??2017-01-08?11:17??wangb\src\dao\CMDdao.java

?????文件???????4029??2017-01-15?21:51??wangb\src\dao\RechargeDao.java

?????文件???????2396??2017-01-15?21:02??wangb\src\dao\SXJDao.java

?????文件???????4771??2017-01-10?14:59??wangb\src\dao\UserDao.java

?????文件???????6109??2017-01-11?17:30??wangb\src\dao\VipDao.java

?????文件???????2548??2017-01-12?17:01??wangb\src\dao\VOMDao.java

?????文件???????5436??2017-01-12?14:53??wangb\src\dao\XiaJiDao.java

?????文件??????86739??2017-01-08?17:14??wangb\src\image\1.jpg

?????文件??????70442??2017-01-08?16:41??wangb\src\image\1.png

?????文件??????70442??2017-01-08?16:41??wangb\src\image\2.png

?????文件??????70442??2017-01-08?16:41??wangb\src\image\3.png

?????文件??????70442??2017-01-08?16:41??wangb\src\image\4.png

?????文件??????70442??2017-01-08?16:41??wangb\src\image\5.png

?????文件?????970991??2017-01-08?18:20??wangb\src\image\6.png

?????文件???????6722??2017-01-17?08:32??wangb\src\image\7.jpg

?????文件??????59512??2017-01-17?08:50??wangb\src\image\8.png

?????文件????1515552??2017-01-16?20:14??wangb\src\image\w7.png

?????文件??????19569??2016-12-17?21:14??wangb\src\image\主界面按鈕1.jpg

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