package?com.soft.dao;

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

import?com.mysql.jdbc.Connection;

public?class?DB?{
	private?final?static?String?driver?=?“com.mysql.jdbc.Driver“;?
	private?final?static?String?dbURL?=?“jdbc:mysql://localhost:3306/PhoneBook“;
	private?final?static?String?username=“root“;
	private?final?static?String?password=““;
//	String?driver?=?“net.sourceforge.jtds.jdbc.Driver“;?
//	String?dbURL?=?“jdbc:jtds:sqlserver://localhost:1433;DatabaseName=test“;	
	
	public?static?Connection?connection（Connection?con）{		
		try?{
			Class.forName（driver）.newInstance（）;
		}?catch?（Exception?e）?{
			System.out.println（“無法加載jdbc程序?。?！“）;		
		}

		try?{
			con=（Connection）?DriverManager.getConnection（dbURLusernamepassword）;
			System.out.println（“連接成功！！！“）;
			return?con;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			System.out.println（“無法連接數(shù)據(jù)庫?。。　埃?
		}
		return?null;
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????678??2014-11-05?21:46??phonebook3\.classpath

?????文件????????302??2014-11-08?16:40??phonebook3\.mymetadata

?????文件???????1228??2014-11-08?16:40??phonebook3\.project

?????文件????????330??2014-11-06?23:10??phonebook3\.settings\org.eclipse.jdt.core.prefs

?????文件????????984??2014-11-04?20:03??phonebook3\src\com\soft\dao\DB.java

?????文件???????8875??2014-11-08?22:36??phonebook3\src\com\soft\dao\PhoneDao.java

?????文件???????3462??2014-11-07?16:13??phonebook3\src\com\soft\dao\UserDao.java

?????文件???????1934??2014-11-08?16:41??phonebook3\src\com\soft\domain\Phone.java

?????文件????????747??2014-11-04?19:53??phonebook3\src\com\soft\domain\User.java

?????文件???????2925??2014-11-08?10:39??phonebook3\src\com\soft\service\AddPhoneServlet.java

?????文件???????1819??2014-11-08?16:28??phonebook3\src\com\soft\service\FindPhoneServlet.java

?????文件????????762??2014-11-08?15:46??phonebook3\src\com\soft\service\ListPageAddServlet.java

?????文件????????762??2014-11-08?15:46??phonebook3\src\com\soft\service\ListPageDesServlet.java

?????文件????????756??2014-11-08?15:45??phonebook3\src\com\soft\service\ListPageServlet.java

?????文件???????2819??2014-11-08?16:16??phonebook3\src\com\soft\service\LoginServlet.java

?????文件???????2144??2014-11-06?10:46??phonebook3\src\com\soft\service\RegisterServlet.java

?????文件???????3365??2014-11-07?16:17??phonebook3\src\com\soft\service\UpdatePhoneServlet.java

?????文件????????207??2014-11-04?20:15??phonebook3\src\com\soft\test\TestDB.java

?????文件???????1313??2014-11-08?22:37??phonebook3\src\com\soft\test\TestPhoneDao.java

?????文件????????925??2014-11-08?10:03??phonebook3\src\com\soft\test\TestUserDao.java

?????文件????????980??2014-11-08?10:37??phonebook3\src\com\soft\web\AddPhoneUI.java

?????文件???????1441??2014-11-07?17:21??phonebook3\src\com\soft\web\DeletePhoneUI.java

?????文件????????660??2014-11-08?10:50??phonebook3\src\com\soft\web\FindPhoneUI.java

?????文件???????2862??2014-11-08?11:07??phonebook3\src\com\soft\web\formbean\PhoneFormBean.java

?????文件???????2848??2014-11-05?23:17??phonebook3\src\com\soft\web\formbean\UserFormBean.java

?????文件????????760??2014-11-07?16:36??phonebook3\src\com\soft\web\LoginOutUI.java

?????文件????????673??2014-11-05?13:42??phonebook3\src\com\soft\web\LoginUI.java

?????文件????????627??2014-11-05?21:58??phonebook3\src\com\soft\web\RegisterUI.java

?????文件???????1165??2014-11-07?15:38??phonebook3\src\com\soft\web\UpdatePhoneUI.java

?????文件???????2358??2014-11-08?21:17??phonebook3\WebRoot\index.jsp

............此處省略73個(gè)文件信息