一、完善了音乐管理系统界面
1.查询音乐
public static List <Music> findAll() throws SQLException {
List <Music> musics = new ArrayList <>();
Connection connection = DBUtil.getConnection();
PreparedStatement statement = connection.prepareStatement("SELECT * FROM music");
ResultSet resultSet = statement.executeQuery();
while (resultSet.next()){
int id = resultSet.getInt(1);
String musicname = resultSet.getString(2);
String author = resultSet.getString(3);
Music music = new Music();
music.setId(id);
music.setMusicname(musicname);
music.setAuthor(author);
musics.add(music);
}
return musics;
}
2.添加音乐