音乐管理系统的基本功能

一、音乐管理系统的基本功能

1.新建了一个class，用来存放与数据库中表中的内容
代码：

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

    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 getAuto() {
        return auto;
    }

    public void setAuto(String auto) {
        this.auto = auto;
    }

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

2.音乐管理系统的基本功能代码
查询代码：

public List<Music> findAll() throws SQLException {
           Connection connection= DBUtil.getConnection();
            String sql="select * from music";
            PreparedStatement statement=connection.prepareStatement(sql);
            ResultSet resultSet=statement.executeQuery();
             List<Music> musics=new ArrayList<>();
            while (resultSet.next()){
                int id = resultSet.getInt(1);
                String musicname = resultSet.getString(2);
                String write = resultSet.getString(3);
                Music music=new Music();
                music.setId(id);
                music.setMusicname(musicname);
                music.setAuto(write);
                musics.add(music);
            }
            return musics;
    }

添加代码

 public void insert(Music music) throws SQLException {
        Connection connection=null;
       connection=DBUtil.getConnection();
        PreparedStatement statement=connection.prepareStatement("insert into music (musicname,auto) values (?,?)");
        statement.setString(1,music.getMusicname());
        statement.setString(2,music.getAuto());
        int re=statement.executeUpdate();
        DBUtil.close(connection,statement,null);
        if(re!=-1){
            System.out.println("添加成功！");
        }
        else{
            System.out.println("没有添加成功！");
        }
    }

删除代码：

public void update(Music music) throws SQLException {
        Connection connection=null;
        connection=DBUtil.getConnection();
        PreparedStatement statement=connection.prepareStatement("update music set musicname=? , auto=? where id=?");
        statement.setString(1,music.getMusicname());
        statement.setString(2,music.getAuto());
        statement.setInt(3,music.getId());
        int re=statement.executeUpdate();
        DBUtil.close(connection,statement,null);
        if(re!=-1){
            System.out.println("修改成功！");
        }
        else{
            System.out.println("没有修改成功！");
        }
    }

删除代码：

public void delete(String musicname) throws SQLException {
        Connection connection=DBUtil.getConnection();
        PreparedStatement statement=connection.prepareStatement("delete from music where musicname=?");
        statement.setString(1,musicname);
        int re=statement.executeUpdate();
        if(re!=-1){
            System.out.println("删除成功！");
        }
        else{
            System.out.println("没有删除成功！");
        }
    }

3.音乐管理系统的基本界面
代码：

public static void main(String[] args) throws SQLException, NoSuchAlgorithmException {
        Scanner input = new Scanner(System.in);
        UserDao userDao = new UserDao();
        MusicDao musicDao=new MusicDao();
        while (true) {
            System.out.print("请输入用户名：");
            String username = input.next();
            System.out.print("请输入密码：");
            String password=input.next();
            MessageDigest md=MessageDigest.getInstance("MD5");
            md.update(password.getBytes());
            String str=new BigInteger(1,md.digest()).toString(16);
            System.out.println("用户名"+username + "密码："+str);
            boolean flag = userDao.loges(username,password);
            if (flag) {
                System.out.println("---------------登录成功---------------");
                System.out.println("---------欢迎来到音乐管理系统---------");
                System.out.println("\t1.音乐管理\t2.用户管理\t3.退出系统");
                int j=input.nextInt();
                if(j==1){
                    System.out.println("---------欢迎进入音乐管理系统---------");
                    System.out.println("\t1.查询音乐\t2.添加音乐\t3.修改音乐\t4.删除音乐");
                    j=input.nextInt();
                    switch (j){
                        case 1:
                            List<Music> musics=musicDao.findAll();
                            System.out.println(musics);
                        case 2:
                            System.out.println("请输入要添加的歌名：");
                            String name=input.next();
                            System.out.println("请输入要添加的作者名：");
                            String write=input.next();
                            Music music=new Music();
                            music.setMusicname(name);
                            music.setAuto(write);
                            musicDao.insert(music);
                        case 3:
                            System.out.println("请输入要修改的编号：");
                            int id=input.nextInt();
                            System.out.println("请输入要修改的歌名：");
                            String name1=input.next();
                            System.out.println("请输入要修改的作者名：");
                            String auto=input.next();
                            Music music1=new Music();
                            music1.setMusicname(name1);
                            music1.setAuto(auto);
                            music1.setId(id);
                            musicDao.update(music1);
                        case 4:
                            System.out.println("请输入要删除的歌名：");;
                            musicDao.delete(input.next());
                    }
                }
            }
         }