音乐管理系统搭建

import java.sql.SQLException;
import java.util.List;
import java.util.Scanner;

public class MusicService {
    public static void main(String[] args) throws SQLException {
        UserDao userDao = new UserDao();
        while (true) {
            System.out.println("请输入用户名：");
            Scanner input = new Scanner(System.in);
            String username = input.next();
            System.out.println("请输入密码");
            String password = input.next();
            System.out.println(username + password);

            boolean flag = userDao.login(username, password);
            if (flag) {
                System.out.println("登入成功");
                System.out.println("欢迎来到音乐管理系统");
                System.out.println("\t1.音乐管理\t2.用户管理");
                int j = input.nextInt();
                if (j == 1) {
                    System.out.println("欢迎进入音乐管理系统");
                    System.out.println("\t1.查询音乐\t2.添加音乐\t3.修改音乐\t4.删除音乐");
                    int k=input.nextInt();
                    switch (k){
                        case  1:
                            List<Music> musics= MusicDao.findAll();
                            System.out.println(musics);
                        case 2:
                            System.out.println("请输入要添加的音乐名称：");
                            String n=input.next();
                            System.out.println("请输入作者");
                            String au=input.next();
                            Music music=new Music();
                            music.setMusicname(n);
                            music.setAuthor(au);
                            MusicDao.add(music);
                        case 3:
                            System.out.println(3);
                        case 4:
                            System.out.println("请输入要删除歌曲的id");
                            int id=input.nextInt();
                            MusicDao.delete(id);
                    }

                }

            } else {
                System.out.println("登入失败");
                System.out.println("请先注册");
                System.out.println("请输入注册名：");
                String zcm = input.next();
                System.out.println("请输入注册密码：");
                String zcmm1 = input.next();
                System.out.println("请确认密码：");
                String zcmm2 = input.next();
                if (zcmm1.equals(zcmm2)) {
                    userDao.zhuce(zcm, zcmm1);
                    System.out.println("是否登入还是退出Y/N");
                    String i = input.next();
                    if (i.equals("N")) {
                        System.exit(0);
                    } else if (!i.equals("Y")) {
                        System.out.println("输入错误！");
                        System.exit(0);
                    }
                } else {
                    System.out.println("密码有误，请重新注册！");
                }
                userDao.zhuce(zcm, zcmm1);
            }

        }
    }
}

package univ.nbcj.dao;

import univ.nbcj.bean.Music;
import univ.nbcj.util.DBUtil;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class MusicDao {
    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 anthor = resultSet.getString(3);
            Music music = new Music();
            music.setId(id);
            music.setMusicname(musicname);
            music.setAuthor(anthor);
            musics.add(music);
        }
        return musics;
    }

    public static 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();
        }


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


}