音乐播放器带数据库语句

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.myeclipseprofiler
     文件        1265  2017-12-27 15:43  吴鑫MusicProject.myeclipseprofilerDaoTest.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.settingsorg.eclipse.core.resources.prefs
     文件         330  2017-12-27 08:57  吴鑫MusicProject.settingsorg.eclipse.jdt.core.prefs
     文件          49  2017-12-27 08:57  吴鑫MusicProject.settingsorg.eclipse.wst.jsdt.ui.superType.container
     文件           6  2017-12-27 08:57  吴鑫MusicProject.settingsorg.eclipse.wst.jsdt.ui.superType.name
     目录           0  2017-12-30 00:38  吴鑫MusicProjectWebRoot
     目录           0  2017-12-30 00:38  吴鑫MusicProjectWebRootmeta-INF
     文件          36  2017-12-27 08:57  吴鑫MusicProjectWebRootmeta-INFMANIFEST.MF
     目录           0  2017-12-30 00:38  吴鑫MusicProjectWebRootWEB-INF
     目录           0  2017-12-30 00:38  吴鑫MusicProjectWebRootWEB-INFclasses
     目录           0  2017-12-30 00:38  吴鑫MusicProjectWebRootWEB-INFclassescom
     目录           0  2017-12-30 00:38  吴鑫MusicProjectWebRootWEB-INFclassescommusic
     目录           0  2017-12-30 00:38  吴鑫MusicProjectWebRootWEB-INFclassescommusicdao
     文件        1431  2017-12-29 20:15  吴鑫MusicProjectWebRootWEB-INFclassescommusicdaoDaoUtil.class
     文件        2681  2017-12-29 20:15  吴鑫MusicProjectWebRootWEB-INFclassescommusicdaoMenuDao.class
     文件        2847  2017-12-29 20:15  吴鑫MusicProjectWebRootWEB-INFclassescommusicdaoMusicDao.class
     目录           0  2017-12-30 00:38  吴鑫MusicProjectWebRootWEB-INFclassescommusicpojo
     文件        1798  2017-12-29 20:15  吴鑫MusicProjectWebRootWEB-INFclassescommusicpojoMenu.class
     文件        1513  2017-12-29 20:15  吴鑫MusicProjectWebRootWEB-INFclassescommusicpojoMusic.class
     目录           0  2017-12-30 00:38  吴鑫MusicProjectWebRootWEB-INFclassescommusicservice
     文件        2082  2017-12-29 20:15  吴鑫MusicProjectWebRootWEB-INFclassescommusicserviceInitAction.class
     文件        1716  2017-12-29 20:15  吴鑫MusicProjectWebRootWEB-INFclassescommusicserviceLoginServlet.class
............此处省略156个文件信息