package?com.cqipc.tsj.dao;

import?java.io.FileInputStream;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;
import?java.util.Properties;

import?com.cqipc.tsj.model.Back;
import?com.cqipc.tsj.model.BookInfo;
import?com.cqipc.tsj.model.BookType;
import?com.cqipc.tsj.model.Borrow;
import?com.cqipc.tsj.model.Operator;
import?com.cqipc.tsj.model.Order;
import?com.cqipc.tsj.model.Reader;

public?class?Dao?{

	protected?static?String?dbClassName?=?““;
	protected?static?String?dbUrl?=?““;
	protected?static?String?dbUser?=?““;
	protected?static?String?dbPwd?=?““;
	private?static?Connection?conn?=?null;
	static?{
		Properties?props?=?new?Properties（）;
		try?{
			props.load（new?FileInputStream（“sqlserver.ini“））;
			dbClassName?=?props.getProperty（“driver“）;
			dbUrl?=?props.getProperty（“url“）;
			dbUser?=?props.getProperty（“userName“）;
			dbPwd?=?props.getProperty（“userPwd“）;
		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}

	private?Dao（）?{
		try?{
			if?（conn?==?null）?{
				Class.forName（dbClassName）;
				conn?=?DriverManager.getConnection（dbUrl?dbUser?dbPwd）;
			}
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
			e.printStackTrace（）;
		}
	}

	public?static?ResultSet?executeQuery（String?sql）?{
		try?{
			if?（conn?==?null）
				new?Dao（）;
			return?conn.createStatement（ResultSet.TYPE_SCROLL_SENSITIVE?ResultSet.CONCUR_UPDATABLE）.executeQuery（sql）;
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
			e.printStackTrace（）;
			return?null;
		}?finally?{

		}
	}

	public?static?int?executeUpdate（String?sql）?{
		try?{
			if?（conn?==?null）
				new?Dao（）;
			return?conn.createStatement（）.executeUpdate（sql）;
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
			e.printStackTrace（）;
			return?-1;
		}?finally?{

		}
	}

	public?static?void?close（）?{
		try?{
			conn.close（）;
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
			e.printStackTrace（）;
		}?finally?{
			conn?=?null;
		}
	}

	public?static?Operator?check（String?name?String?password）?{
		Operator?operator?=?new?Operator（）;
		String?sql?=?“select?*?from?tb_operator?where?name?=?‘“?+?name?+?“‘?and?password?=?‘“?+?password
				+?“‘?and?admin=1“;
		ResultSet?rs?=?Dao.executeQuery（sql）;
		try?{
			while?（rs.next（））?{
				operator.setId（rs.getString（“id“））;
				operator.setName（rs.getString（“name“））;
				operator.setGrade（rs.getString（“admin“））;
				operator.setPassword（rs.getString（“password“））;
			}
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
			e.printStackTrace（）;

		}
		Dao.close（）;
		return?operator;
	}

	public?static?List?selectBookCategory（）?{
		//?TODO?Auto-generated?method?stub
		List?list?=?new?ArrayList（）;
		String?sql?=?“select?*?from?tb_bookType“;
		ResultSet?rs?=?executeQuery（sql）;
		try

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????文件?????????430??2017-03-18?19:57??LibraryExample\.classpath
?????文件?????????390??2016-12-13?14:58??LibraryExample\.project
?????目錄???????????0??2018-04-26?09:24??LibraryExample\.settings\
?????文件?????????670??2017-03-10?10:10??LibraryExample\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2018-04-26?09:24??LibraryExample\bin\
?????目錄???????????0??2018-04-26?09:24??LibraryExample\bin\com\
?????目錄???????????0??2018-04-26?09:24??LibraryExample\bin\com\cqipc\
?????目錄???????????0??2018-04-26?09:24??LibraryExample\bin\com\cqipc\tsj\
?????目錄???????????0??2018-04-26?09:24??LibraryExample\bin\com\cqipc\tsj\dao\
?????文件???????18467??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\dao\Dao.class
?????目錄???????????0??2018-04-26?09:24??LibraryExample\bin\com\cqipc\tsj\model\
?????文件????????1788??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\model\Back.class
?????文件????????2068??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\model\BookInfo.class
?????文件????????1085??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\model\BookType.class
?????文件????????1705??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\model\Borrow.class
?????文件????????1133??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\model\Item.class
?????文件????????1094??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\model\Operator.class
?????文件????????1551??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\model\Order.class
?????文件????????2792??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\model\Reader.class
?????目錄???????????0??2018-04-26?09:24??LibraryExample\bin\com\cqipc\tsj\tools\
?????文件?????????943??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\tools\MyDocument.class
?????目錄???????????0??2018-04-26?09:24??LibraryExample\bin\com\cqipc\tsj\ui\
?????文件????????3260??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\ui\BookAddframe$AddBookActionListener.class
?????文件?????????761??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\ui\BookAddframe$CloseActionListener.class
?????文件????????1285??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\ui\BookAddframe$ISBNFocusListener.class
?????文件????????6024??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\ui\BookAddframe.class
?????文件?????????747??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\ui\BookBackiframe$1.class
?????文件????????1566??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\ui\BookBackiframe$TableListener.class
?????文件????????2525??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\ui\BookBackiframe$YesListener.class
?????文件????????6658??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\ui\BookBackiframe.class
?????文件?????????759??2017-04-05?19:04??LibraryExample\bin\com\cqipc\tsj\ui\BookBorrowiframe$1.class
............此處省略135個(gè)文件信息