package?com.music.dao;

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



//數據訪問的工具類
public?class?DaoUtil?{
	//靜態塊。程序啟動時直接調用
	static?{
		//加載驅動
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	public?static?Connection?getConnetion（）{//static?不需要實體化也可以直接訪問?
		//獲取連接
		Connection?con?=?null;
		try?{
			con?=?DriverManager.getConnection（“jdbc:mysql://127.0.0.1:3306/music““root““123456“）;
			//System.out.println（“連接成功“）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?con;
		
	}
	//關閉jdbc對象
	public?static?void?close（Connection?conPreparedStatement?pstmResultSet?rs）?throws?SQLException{
		if（rs!=null）{
			rs.close（）;
		}
		if（pstm!=null）{
			pstm.close（）;
		}
		if（con!=null）{
			con.close（）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-12-30?00:38??吳鑫\
?????目錄???????????0??2017-12-30?00:38??吳鑫\MusicProject\
?????文件?????????550??2017-12-29?18:46??吳鑫\MusicProject\.classpath
?????目錄???????????0??2017-12-30?00:38??吳鑫\MusicProject\.myeclipse\
?????目錄???????????0??2017-12-30?00:38??吳鑫\MusicProject\.myeclipse\profiler\
?????文件????????1265??2017-12-27?15:43??吳鑫\MusicProject\.myeclipse\profiler\DaoTest.xml
?????文件?????????309??2017-12-29?20:15??吳鑫\MusicProject\.mymetadata
?????文件????????1418??2017-12-28?16:03??吳鑫\MusicProject\.project
?????目錄???????????0??2017-12-30?00:38??吳鑫\MusicProject\.settings\
?????文件?????????500??2017-12-27?08:57??吳鑫\MusicProject\.settings\.jsdtscope
?????文件??????????88??2017-12-28?20:02??吳鑫\MusicProject\.settings\org.eclipse.core.resources.prefs
?????文件?????????330??2017-12-27?08:57??吳鑫\MusicProject\.settings\org.eclipse.jdt.core.prefs
?????文件??????????49??2017-12-27?08:57??吳鑫\MusicProject\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-12-27?08:57??吳鑫\MusicProject\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-12-30?00:38??吳鑫\MusicProject\WebRoot\
?????目錄???????????0??2017-12-30?00:38??吳鑫\MusicProject\WebRoot\meta-INF\
?????文件??????????36??2017-12-27?08:57??吳鑫\MusicProject\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2017-12-30?00:38??吳鑫\MusicProject\WebRoot\WEB-INF\
?????目錄???????????0??2017-12-30?00:38??吳鑫\MusicProject\WebRoot\WEB-INF\classes\
?????目錄???????????0??2017-12-30?00:38??吳鑫\MusicProject\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2017-12-30?00:38??吳鑫\MusicProject\WebRoot\WEB-INF\classes\com\music\
?????目錄???????????0??2017-12-30?00:38??吳鑫\MusicProject\WebRoot\WEB-INF\classes\com\music\dao\
?????文件????????1431??2017-12-29?20:15??吳鑫\MusicProject\WebRoot\WEB-INF\classes\com\music\dao\DaoUtil.class
?????文件????????2681??2017-12-29?20:15??吳鑫\MusicProject\WebRoot\WEB-INF\classes\com\music\dao\MenuDao.class
?????文件????????2847??2017-12-29?20:15??吳鑫\MusicProject\WebRoot\WEB-INF\classes\com\music\dao\MusicDao.class
?????目錄???????????0??2017-12-30?00:38??吳鑫\MusicProject\WebRoot\WEB-INF\classes\com\music\pojo\
?????文件????????1798??2017-12-29?20:15??吳鑫\MusicProject\WebRoot\WEB-INF\classes\com\music\pojo\Menu.class
?????文件????????1513??2017-12-29?20:15??吳鑫\MusicProject\WebRoot\WEB-INF\classes\com\music\pojo\Music.class
?????目錄???????????0??2017-12-30?00:38??吳鑫\MusicProject\WebRoot\WEB-INF\classes\com\music\service\
?????文件????????2082??2017-12-29?20:15??吳鑫\MusicProject\WebRoot\WEB-INF\classes\com\music\service\InitAction.class
?????文件????????1716??2017-12-29?20:15??吳鑫\MusicProject\WebRoot\WEB-INF\classes\com\music\service\LoginServlet.class
............此處省略156個文件信息