音乐管理系统

                                          **DBUtil .java**

package Music.ruanjian.util;

import java.sql.*;

public class DBUtil {
public static Connection getconnection() {
Connection connection = null;
try {
Class.forName(“com.mysql.jdbc.Driver”);
connection = DriverManager.getConnection(“jdbc:mysql://127.0.0.1:3306/nbcj?useSSL=true&characterEncoding=utf-8&user=root&password=123456”);
System.out.println("|------------------创建连接成功!------------------|");
} catch (SQLException e) {
e.printStackTrace();
}
return connection;
}

public static void closeAll( PreparedStatement preparedStatement, ResultSet resultSet,Connection connection) {
    if (preparedStatement != null) {
        try {
            preparedStatement.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    if (resultSet != null) {
        try {
            resultSet.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    if (connection != null) {
        try {
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}



                                    **MusicDao.java**

package Music.ruanjian.dao;

import Music.ruanjian.bean.Music;
import Music.ruanjian.util.DBUtil;

import java.net.ConnectException;
import java.security.PublicKey;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

public class MusicDao {
public List findAll() throws SQLException {
List 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;
}

public void add(Music music) throws SQLException {
    Connection connection = DBUtil.getconnection();
    PreparedStatement statement = connection.prepareStatement("insert into music (musicname,author) values (?,?)");
    statement.setString(1, "123");
    statement.setString(2, "123");
    statement.executeUpdate();
}


public void  delete(int id) throws SQLException {
    PreparedStatement statement=null;
    Connection connection=null;
    connection=DBUtil.getconnection();
    int i=0;
    try {
        statement=connection.prepareStatement("delete from music where id=?");
        statement.setInt(1, id);
        i = statement.executeUpdate();
        if (i != 0) {
            System.out.println("|-------------------删除成功!--------------------|");
        } else {
            System.out.println("|-------------------删除失败!--------------------|");
        }
    }catch (SQLException e){
        e.printStackTrace();
    }
}

}