音乐管理系统2

在bean包里新建了一个名为Music的class类
在数据库中新建了一个名为music的表，它有三列，为id，musicname，author

public class Music {
    private int id;
    private String musicname;
    private String author;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getMusicname() {
        return musicname;
    }

    public void setMusicname(String musicname) {
        this.musicname = musicname;
    }

    public String getAuthor() {
        return author;
    }

    public void setAuthor(String author) {
        this.author = author;
    }

    @Override
    public String toString() {
        return "Music{" +
                "id=" + id +
                ", musicname='" + musicname + '\'' +
                ", author='" + author + '\'' +
                '}';
    }
}

在dao包中新建了一个名为MusicDao的class类

public class MusicDao {
    public 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;
    }

    public void delete(int id) throws SQLException {
        PreparedStatement statement=null;
        Connection connection=null;
        connection=DBUtil.getConnection();
        int i=0;
        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("================删除失败================");
        }
    }

    public void add(Music music) throws SQLException {
        Connection connection=DBUtil.getConnection();
        PreparedStatement statement=connection.prepareStatement
                ("insert into music (musicname,author) values (?,?)");
        statement.setString(1,music.getMusicname());
        statement.setString(2,music.getAuthor());
        int i=statement.executeUpdate();
        if (i!=0){
            System.out.println("添加成功！");
        }else{
            System.out.println("添加失败！");
        }
    }
}

在MusicService中添加了如下代码，实现jdbc的查询和删除：

System.out.println("1.查询音乐\t2.用户管理\t3.退出系统");
                int k = input.nextInt();
                if (k == 1) {
                    System.out.println("========欢迎进入音乐管理系统========");
                    System.out.println("1.查询音乐\t2.添加音乐\t3.修改音乐\t4.删除音乐");
                    int a = input.nextInt();
                    switch (a) {
                        case 1:
                            List<Music> musics = musicDao.findAll();
                            System.out.println(musics);
                            break;
                        case 2:
                            System.out.println("请输入要添加的音乐名称：");
                            Scanner input1 = new Scanner(System.in);
                            String n = input1.nextLine();
                            System.out.println("请输入作者：");
                            String m = input1.nextLine();
                            Music music = new Music();
                            music.setMusicname(n);
                            music.setAuthor(m);
                            musicDao.add(music);
                            break;
                        case 3:

                        case 4:
                            System.out.println("请输入要删除的歌曲id：");
                            int id = input.nextInt();
                            musicDao.delete(id);
                            break;

注册完成后，判断是否登录：

System.out.println("是否登录Y/N:");
                    String choice = input.next();
                    if (choice.equals("N")) {
                        System.exit(0);
                    } else if (choice.equals("Y")) {
                        System.out.println("================傻子，输错了！！！！！================");
                        System.exit(0);
                    }

MusicService完整代码：

public class MusicService {
    public static void main(String[] args) throws SQLException {
        UserDao userDao = new UserDao();
        MusicDao musicDao = new MusicDao();
        while (true) {
            Scanner input = new Scanner(System.in);
            System.out.println("请输入用户名：");
            String username = input.next();
            System.out.println("请输入密码：");
            String password = input.next();
            boolean flag = userDao.login(username, password);
            if (flag) {
                System.out.println("================登陆成功================");
                System.out.println("==========欢迎来到音乐管理系统==========");
                System.out.println("1.查询音乐\t2.用户管理\t3.退出系统");
                int k = input.nextInt();
                if (k == 1) {
                    System.out.println("========欢迎进入音乐管理系统========");
                    System.out.println("1.查询音乐\t2.添加音乐\t3.修改音乐\t4.删除音乐");
                    int a = input.nextInt();
                    switch (a) {
                        case 1:
                            List<Music> musics = musicDao.findAll();
                            System.out.println(musics);
                            break;
                        case 2:
                            System.out.println("请输入要添加的音乐名称：");
                            Scanner input1 = new Scanner(System.in);
                            String n = input1.nextLine();
                            System.out.println("请输入作者：");
                            String m = input1.nextLine();
                            Music music = new Music();
                            music.setMusicname(n);
                            music.setAuthor(m);
                            musicDao.add(music);
                            break;
                        case 3:

                        case 4:
                            System.out.println("请输入要删除的歌曲id：");
                            int id = input.nextInt();
                            musicDao.delete(id);
                            break;
                    }
                }
            } 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(username, password);
                    System.out.println("是否登录Y/N:");
                    String choice = input.next();
                    if (choice.equals("N")) {
                        System.exit(0);
                    } else if (choice.equals("Y")) {
                        System.out.println("================傻子，输错了！！！！！================");
                        System.exit(0);
                    }
                } else {
                    System.out.println("================两次输入的密码不一致，请重新输入！================");
                }

            }
        }
    }
}