Java课程第九天-优快云博客

本文介绍了一个简单的音乐管理系统的设计与实现，包括用户登录、音乐查询、添加、修改和删除等功能。系统采用Java编程，利用DAO模式进行数据库操作，实现了基本的音乐管理业务流程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

写完了一个音乐管理系统的基本功能。
代码如下：

package service;

import bean.Music;
import dao.MusicDao;
import dao.UserDao;

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

public class MusicService {

    public static void main(String[] args) throws Exception {
        UserDao userDao = new UserDao();
        MusicDao musicDao=new MusicDao();
        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.用户管理\t3.退出系统");
                int j=input.nextInt();
                if (j==1){
                    System.out.println("欢迎进入音乐管理系统");
                    System.out.println("\t1.查询\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("输入要要添加的音乐名称：");
                            String n=input.next();
                            System.out.println("输入作者：");
                            String au=input.next();
                            musicDao.add(n,au);
                            break;
                        case 3:
                            System.out.println("输入要要修改的id：");
                            int id1=input.nextInt();
                            System.out.println("输入修改后的音乐名称：");
                            String name=input.next();
                            System.out.println("输入修改后作者：");
                            String au1=input.next();
                            musicDao.update(id1,name,au1);
                            break;
                        case 4:
                            System.out.println("输入要删除的id");
                            int id=input.nextInt();
                            musicDao.Delete(id);
                    }

                }else if (j==2){
                    System.out.println("欢迎进入用户管理系统");
                    System.out.println("\t1.查询\t2.添加\t3.修改\t4.删除");
                    int b=input.nextInt();
                    switch (b){
                        case 1:
                        case 2:
                        case 3:
                        case 4:
                    }

                }
            } 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("是否登入还是退出N/Y");
                    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("密码有误请重新注册！");
                }
            }
        }
    }
}

上面这个是service部分。
下面是bean部分：

package bean;

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部分：

package dao;

import Utill.DBUtill;
import bean.Music;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

public class MusicDao {
    public  static List<Music> findAll() throws Exception {
        List<Music> musics=new ArrayList<>();
        Connection connection = DBUtill.getconnection();
       PreparedStatement statement=connection.prepareStatement("select * from music");
        ResultSet resultSet = statement.executeQuery();
        while (resultSet.next()){
            int id=resultSet.getInt(1);
            String musicnama=resultSet.getString(2);
            String author=resultSet.getString(3);
           Music music=new Music();
           music.setId(id);
           music.setMusicname(musicnama);
           music.setAuthor(author);
           musics.add(music);


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

    }
    public void  add(String musicname, String author) throws Exception {
        Connection connection=DBUtill.getconnection();
        PreparedStatement statement=connection.prepareStatement("insert into music (musicname,author)value (?,?)");
        statement.setString(1,musicname);
        statement.setString(2,author);
        statement.executeUpdate();

    }
     public void update(int id1,String name,String au1) throws Exception {
        Connection connection=DBUtill.getconnection();
        PreparedStatement statement=null;

       String sql="update music set musicname=?,author=? where id=?";
        statement=connection.prepareStatement(sql);
        statement.setString(1,name);
        statement.setString(2,au1);
        statement.setInt(3,id1);
         int i=0;
         i=statement.executeUpdate();
         if (i==1){
             System.out.println("修改成功");
         }else {
             System.out.println("失败了");
         }
     }
}