package?dao;

import?java.sql.*;

public?class?ConnectionManager?
{
	public?static?Connection?getConnection（）
	{
		Connection?conn=null;
		try
		{
			
			Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
			conn=DriverManager.getConnection（“jdbc:sqlserver://localhost:1433;databaseName=bbs“?“sa“?“123“）;
			System.out.println（“suc“）;
		}
		catch（Exception?ee）
		{
			System.out.println（ee.toString（））;
		}
		return?conn;
	}
	
????public?void?closeAll（?Connection?conn
????					PreparedStatement?pstmt
????					ResultSet?rs?）?
????{
????????/*??如果rs不空，關閉rs??*/
????????if（rs?!=?null）
????????{
????????????try?{?rs.close（）;}?catch?（SQLException?e）?{e.printStackTrace（）;}
????????}
????????/*??如果pstmt不空，關閉pstmt??*/
????????if（pstmt?!=?null）
????????{
????????????try?{?pstmt.close（）;}?catch?（SQLException?e）?{e.printStackTrace（）;}
????????}
????????/*??如果conn不空，關閉conn??*/
????????if（conn?!=?null）
????????{
????????????try?{?conn.close（）;}?catch?（SQLException?e）?{e.printStackTrace（）;}
????????}
????}
	
	public?static?void?main（String?[]?aa）
	{
		ConnectionManager.getConnection（）;
	}

}

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

?????文件??????36864??2009-02-11?11:28??BBS校園論壇\bbs技術論壇項目需求.doc

?????文件????1179648??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\bbs_Data.MDF

?????文件????1048576??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\bbs_Log.LDF

?????文件????????448??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\PagesControl\.classpath

?????文件????????309??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\PagesControl\.mymetadata

?????文件???????1230??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\PagesControl\.project

?????文件???????1177??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\PagesControl\src\dao\ConnectionManager.java

?????文件???????2227??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\PagesControl\src\dao\ReplyDAO.java

?????文件???????1113??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\PagesControl\src\entity\Reply.java

?????文件????????217??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\PagesControl\WebRoot\css\mycss.css

?????文件???????2350??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\PagesControl\WebRoot\index.jsp

?????文件?????????39??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\PagesControl\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1761??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\PagesControl\WebRoot\WEB-INF\classes\dao\ConnectionManager.class

?????文件???????2995??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\PagesControl\WebRoot\WEB-INF\classes\dao\ReplyDAO.class

?????文件???????1679??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\PagesControl\WebRoot\WEB-INF\classes\entity\Reply.class

?????文件????????286??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\PagesControl\WebRoot\WEB-INF\web.xml

?????文件????????270??2008-02-14?10:12??BBS校園論壇\JSP分頁案例\分頁的SQL語句.txt

?????文件????????421??2009-02-16?12:04??BBS校園論壇\JzaccpBBS\.classpath

?????文件????????300??2009-02-16?03:26??BBS校園論壇\JzaccpBBS\.mymetadata

?????文件???????1227??2009-02-14?03:04??BBS校園論壇\JzaccpBBS\.project

?????文件?????583286??2009-02-11?15:38??BBS校園論壇\JzaccpBBS\sqljdbc.jar

?????文件???????8752??2009-02-15?09:07??BBS校園論壇\JzaccpBBS\src\biz\OperationBiz.java

?????文件???????2912??2009-02-12?09:20??BBS校園論壇\JzaccpBBS\src\dao\AdminDao.java

?????文件???????2084??2009-02-12?09:26??BBS校園論壇\JzaccpBBS\src\dao\baseDao.java

?????文件???????2954??2009-02-12?09:28??BBS校園論壇\JzaccpBBS\src\dao\BoardDao.java

?????文件???????5961??2009-02-16?23:09??BBS校園論壇\JzaccpBBS\src\dao\HostCardDao.java

?????文件???????6503??2009-02-16?23:33??BBS校園論壇\JzaccpBBS\src\dao\RevertCardDao.java

?????文件???????5390??2009-02-15?11:02??BBS校園論壇\JzaccpBBS\src\dao\SonBoardDao.java

?????文件???????4122??2009-02-15?18:03??BBS校園論壇\JzaccpBBS\src\dao\UserAdminDao.java

?????文件???????1616??2009-02-11?16:50??BBS校園論壇\JzaccpBBS\src\entity\Admin.java

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