package?control;

import?java.util.*;
import?java.sql.*;

public?class?DatabaseConnector{
?
	private?String?url?=?null;
	private?Properties?info?=?null;
	?/**********************
	??*?使用proxool數據庫連接池
	??*?
	??****************/
	public?DatabaseConnector（）?{
	???info?=?new?Properties（）;
	???info.setProperty（“proxool.maximum-connection-count“?“20“）;
	???info.setProperty（“proxool.house-keeping-test-sql“?“select?CURRENT_DATE“）;
	???info.setProperty（“user“?“music“）;
	???info.setProperty（“password“?“music“）;
	???String?alias?=?“db“;
	???String?driverClass?=?“com.microsoft.jdbc.sqlserver.SQLServerDriver“;
	???String?driverUrl?=?“jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=PowerMusic“;
	???url?=?“proxool.“?+?alias?+?“:“?+?driverClass?+?“:“?+?driverUrl;
	???try?{
	???????Class.forName（“org.logicalcobwebs.proxool.ProxoolDriver“）;
	???}?catch（Exception?e）?{}
	
	???}	
	public?Connection?getConnection（）?{
	????Connection?conn?=?null;
	????try{
	????????conn?=?DriverManager.getConnection（url?info）;
	????}?catch（Exception?e）?{}
	????return?conn;
	}
}

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

?????文件??????44544??2006-01-11?01:48??項目文檔\音樂網站用戶需求說明書.doc

?????文件?????261120??2005-12-06?18:58??項目文檔\音樂網站項目計劃書.doc

?????文件??????57856??2005-12-23?00:16??項目文檔\ER圖.doc

?????目錄??????????0??2006-01-11?12:12??項目文檔

?????文件???????4630??2006-01-11?01:03??數據庫\CreateTable.sql

?????文件???????1070??2006-01-11?01:02??數據庫\installPowerMusic.sql

?????目錄??????????0??2006-01-11?12:12??數據庫

?????文件???????1350??2006-01-04?08:16??code\PowerMusic\.project

?????文件????????849??2006-01-10?18:43??code\PowerMusic\.classpath

?????文件????????304??2006-01-05?14:46??code\PowerMusic\.mymetadata

?????文件??????37746??2006-01-10?23:32??code\PowerMusic\PowerMusic_UML.umr

?????文件??????16462??2006-01-10?22:18??code\PowerMusic\WebRoot\index.jsp

?????文件???????3287??2006-01-05?21:08??code\PowerMusic\WebRoot\register.jsp

?????文件???????4580??2006-01-10?01:35??code\PowerMusic\WebRoot\regpage.jsp

?????文件????????431??2006-01-12?13:45??code\PowerMusic\WebRoot\errorpage.jsp

?????文件???????2047??2006-01-09?18:46??code\PowerMusic\WebRoot\upload.jsp

?????文件??????10320??2006-01-10?19:40??code\PowerMusic\WebRoot\admin\music.jsp

?????文件???????2735??2006-01-07?01:53??code\PowerMusic\WebRoot\admin\login.jsp

?????文件???????5749??2006-01-10?19:40??code\PowerMusic\WebRoot\admin\index.jsp

?????文件??????12363??2006-01-10?19:40??code\PowerMusic\WebRoot\admin\user.jsp

?????文件??????12240??2006-01-10?19:41??code\PowerMusic\WebRoot\admin\admin.jsp

?????文件??????12355??2006-01-10?21:31??code\PowerMusic\WebRoot\admin\news.jsp

?????文件???????8059??2006-01-09?14:49??code\PowerMusic\WebRoot\admin\.admin.html

?????文件??????11128??2006-01-10?21:17??code\PowerMusic\WebRoot\admin\guestbook.jsp

?????文件???????8173??2006-01-10?19:03??code\PowerMusic\WebRoot\admin\.guestbook.html

?????目錄??????????0??2006-01-11?12:12??code\PowerMusic\WebRoot\admin

?????文件?????????92??2006-01-04?08:16??code\PowerMusic\WebRoot\images\middle-shu.gif

?????文件??????68644??2006-01-04?08:16??code\PowerMusic\WebRoot\images\top01.jpg

?????文件?????????64??2006-01-04?08:16??code\PowerMusic\WebRoot\images\botton.gif

?????文件?????????92??2006-01-04?08:16??code\PowerMusic\WebRoot\images\right-shu.gif

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