java连接数据库及java音乐管理系统

java连接数据库

package com.zhongruan.util;

import java.sql.*;

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 (Exception e) {
e.printStackTrace();
}
return connection;
}

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

}

音乐管理系统

package com.zhongruan.service;

import com.zhongruan.bean.User;
import com.zhongruan.dao.MusicDao;
import com.zhongruan.dao.UserDao;

import java.util.Scanner;
import java.util.TreeMap;

public class MusicService {
public static void main(String[] args) throws Exception {
MusicService musicService = new MusicService();
UserDao userDao = new UserDao();