package?com.nantian.dao;

import?java.sql.*;

public?class?DBDao?{
????private?static?String?USER?=?“root“;
????private?static?String?PASSWORD?=?“123456“;
????private?static?String?DB_URL?=?“jdbc:mysql://localhost:3306/login“;
????private?static?String?DB_DRIVER?=?“com.mysql.jdbc.Driver“;
????private?static?Connection?connection?=?null;

????//連接數(shù)據(jù)庫
????public?static?Connection?getConnection（）{

????????try?{
????????????Class.forName（DB_DRIVER）;
????????????connection?=?DriverManager.getConnection（DB_URL?USER?PASSWORD）;
????????}?catch?（Exception?e）?{
????????????System.out.println（“數(shù)據(jù)庫連接異常“）;
????????????e.printStackTrace（）;
????????}
????????return?connection;
????}
????public??static?void?closeConnection（Connection?connection）{

????????????????????if（connection?!=?null）{
????????????????????????try?{
????????????????????????????connection.close（）;?//?關閉數(shù)據(jù)庫連接
????????????????????????}?catch?（SQLException?e）?{
????????????????????????????e.printStackTrace（）;
????????????????????????}
????????????????????}
????????????????}
????}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-07-04?17:11??kechengsheji\
?????文件????????1187??2018-06-22?14:14??kechengsheji\.classpath
?????文件????????1062??2018-06-22?13:45??kechengsheji\.project
?????目錄???????????0??2018-07-04?17:11??kechengsheji\.settings\
?????文件?????????564??2018-06-22?13:45??kechengsheji\.settings\.jsdtscope
?????文件??????????74??2018-06-27?12:11??kechengsheji\.settings\com.genuitec.eclipse.core.prefs
?????文件??????????66??2018-06-22?15:14??kechengsheji\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2018-06-22?13:45??kechengsheji\.settings\org.eclipse.jdt.core.prefs
?????文件?????????495??2018-06-22?13:45??kechengsheji\.settings\org.eclipse.wst.common.component
?????文件?????????414??2018-06-22?13:45??kechengsheji\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-06-22?13:45??kechengsheji\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-06-22?13:45??kechengsheji\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-07-04?17:11??kechengsheji\WebRoot\
?????目錄???????????0??2018-07-04?17:11??kechengsheji\WebRoot\Imgs\
?????文件????????1530??2018-06-25?14:53??kechengsheji\WebRoot\Imgs\shiliang.jpg
?????目錄???????????0??2018-07-04?17:11??kechengsheji\WebRoot\meta-INF\
?????文件??????????39??2018-06-22?13:45??kechengsheji\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2018-07-04?17:11??kechengsheji\WebRoot\WEB-INF\
?????目錄???????????0??2018-07-04?17:11??kechengsheji\WebRoot\WEB-INF\classes\
?????目錄???????????0??2018-07-04?17:11??kechengsheji\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2018-07-04?17:11??kechengsheji\WebRoot\WEB-INF\classes\com\nantian\
?????目錄???????????0??2018-07-04?17:11??kechengsheji\WebRoot\WEB-INF\classes\com\nantian\dao\
?????文件????????1548??2018-06-22?23:50??kechengsheji\WebRoot\WEB-INF\classes\com\nantian\dao\DBDao.class
?????文件????????2369??2018-06-23?00:03??kechengsheji\WebRoot\WEB-INF\classes\com\nantian\dao\UserDao.class
?????目錄???????????0??2018-07-04?17:11??kechengsheji\WebRoot\WEB-INF\classes\com\nantian\login\
?????目錄???????????0??2018-07-04?17:11??kechengsheji\WebRoot\WEB-INF\classes\com\nantian\login\servlet\
?????文件????????1767??2018-06-23?20:40??kechengsheji\WebRoot\WEB-INF\classes\com\nantian\login\servlet\LoginServlet.class
?????目錄???????????0??2018-07-04?17:11??kechengsheji\WebRoot\WEB-INF\classes\com\nantian\register\
?????目錄???????????0??2018-07-04?17:11??kechengsheji\WebRoot\WEB-INF\classes\com\nantian\register\servlet\
?????文件????????1814??2018-06-23?00:04??kechengsheji\WebRoot\WEB-INF\classes\com\nantian\register\servlet\RegisterServlet.class
?????目錄???????????0??2018-07-04?17:11??kechengsheji\WebRoot\WEB-INF\classes\com\nantian\user\
............此處省略936個文件信息