package?org.ebook.connmanager;

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

public?class?ConnManger?{
	private?static?final?String?DRIVER=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	private?static?final?String?URL?=“jdbc:sqlserver://localhost:1433;DatabaseName=EBook“;
	private?static?final?String?USER=“sa“;
	private?static?final?String?PWD=“000000“;
	private?static?ConnManger?connManger=null;
	private?Connection?conn=null;
	
	private?ConnManger（）{
		try?{
			Class.forName（DRIVER）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	
	public?static?ConnManger?getInstance（）{
		if（connManger==null）
		{
			connManger=new?ConnManger（）;
		}
		return?connManger;
	}
	
	public?Connection?getConnection（）{
		try?{
			conn=DriverManager.getConnection（URLUSERPWD）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?conn;
	}
	
	public?static?void?closeAll（Connection?connPreparedStatement?psResultSet?rs）{
		try?{
			if?（rs!=null）{
				rs.close（）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
		try?{
			if?（ps!=null）{
				ps.close（）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		try?{
			if?（conn!=null?&&?!conn.isClosed（））{
				conn.close（）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
}

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

?????文件????????577??2014-11-25?20:51??EBook\EBook\.classpath

?????文件????????288??2015-01-26?19:33??EBook\EBook\.mymetadata

?????文件???????1278??2011-03-01?16:47??EBook\EBook\.project

?????文件????????143??2011-03-12?19:02??EBook\EBook\.settings\com.genuitec.eclipse.core.prefs

?????文件????????330??2011-01-21?19:42??EBook\EBook\.settings\org.eclipse.jdt.core.prefs

?????文件???????1657??2015-01-26?19:34??EBook\EBook\src\org\ebook\connmanager\ConnManger.java

?????文件????????475??2011-03-12?06:00??EBook\EBook\src\org\ebook\dao\BoardDao.java

?????文件????????887??2011-03-01?14:35??EBook\EBook\src\org\ebook\dao\BookInfoDao.java

?????文件????????636??2011-03-11?13:41??EBook\EBook\src\org\ebook\dao\BookrackDao.java

?????文件????????683??2011-03-11?10:30??EBook\EBook\src\org\ebook\dao\BookSectionDao.java

?????文件????????461??2011-03-11?10:28??EBook\EBook\src\org\ebook\dao\BookTypeDao.java

?????文件???????3837??2015-01-26?19:37??EBook\EBook\src\org\ebook\dao\impl\BoardDaoImpl.java

?????文件??????14935??2015-01-26?19:38??EBook\EBook\src\org\ebook\dao\impl\BookinfoDaoImpl.java

?????文件???????5015??2011-03-11?20:50??EBook\EBook\src\org\ebook\dao\impl\BookrackDaoImpl.java

?????文件???????7708??2015-01-26?19:38??EBook\EBook\src\org\ebook\dao\impl\BookSectionDaoImpl.java

?????文件???????4764??2011-03-11?10:28??EBook\EBook\src\org\ebook\dao\impl\BookTypeDaoImpl.java

?????文件???????4128??2015-01-26?19:38??EBook\EBook\src\org\ebook\dao\impl\MassageDaoImpl.java

?????文件???????1274??2014-11-30?20:58??EBook\EBook\src\org\ebook\dao\impl\PageBean.java

?????文件???????6809??2015-01-26?19:39??EBook\EBook\src\org\ebook\dao\impl\ReplyDaoImpl.java

?????文件???????8043??2015-01-26?19:40??EBook\EBook\src\org\ebook\dao\impl\TopicDaoImpl.java

?????文件??????15070??2015-01-26?19:40??EBook\EBook\src\org\ebook\dao\impl\UserDaoImpl.java

?????文件???????1715??2015-01-26?19:40??EBook\EBook\src\org\ebook\dao\impl\UserKindsDaoImpl.java

?????文件???????2027??2015-01-26?19:41??EBook\EBook\src\org\ebook\dao\impl\UserlevelDaoImpl.java

?????文件????????347??2011-03-11?10:14??EBook\EBook\src\org\ebook\dao\MassageDao.java

?????文件???????1114??2015-01-26?19:37??EBook\EBook\src\org\ebook\dao\ReplyDao.java

?????文件???????1124??2015-01-26?19:37??EBook\EBook\src\org\ebook\dao\TopicDao.java

?????文件????????440??2011-03-11?10:12??EBook\EBook\src\org\ebook\dao\UserDao.java

?????文件????????185??2011-03-01?15:23??EBook\EBook\src\org\ebook\dao\UserKindsDao.java

?????文件????????365??2011-03-01?13:54??EBook\EBook\src\org\ebook\dao\UserlevelDao.java

?????文件????????641??2011-02-20?08:47??EBook\EBook\src\org\ebook\entity\Board.java

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