(8.15)

8.15讲了音乐管理系统的增删改查，

代码如下：
MusicService:

package com.zhongruan.service;

import com.zhongruan.bean.Music;
import com.zhongruan.dao.Musicdao;
import com.zhongruan.dao.Userdao;

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

public class MusicService {
public static void main(String[] args) throws SQLException {
Userdao userdao=new Userdao();
Musicdao musicdao=new Musicdao();

    List<Music> musics=new ArrayList<>();
    System.out.println("请输入用户名：");
    try (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.音乐管理\2.用户管理\3.退出系统");
            int j = input.nextInt();
            if (j == 1) {
                System.out.println("欢迎来到音乐管理系统");
                System.out.println("\1.查询音乐\2.添加音乐\3.修改音乐\4.删除音乐");
             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();
                        Music music=new Music();
                        music.setMusicname(n);
                        music.setAuthor(au);
                        musicdao.add(music);
                    case 3:
                        System.out.println(3);
                    case 4:
                        System.out.println("请输入要删除的歌曲：");
                        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(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);
                }
                userdao.zhuce(username, password);
            } else {
                System.out.println("密码有误，请重新注册");
            }

        }
    }

}

}

musicdao:

package com.zhongruan.dao;

import com.zhongruan.bean.Music;
import com.zhongruan.util.DBUtil;

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

public class Musicdao {
public List findAll() throws SQLException {
Listmusics=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.getNString(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 static void delete(int id) throws SQLException {

    PreparedStatement statement=null;
    Connection connection=null;

    connection=DBUtil.getConnection();
    int i=0;
    try{
        connection.prepareStatement("delete from music where id=?");
        statement.setString(1, String.valueOf(id));

    i=statement.executeUpdate();
    if(i!=0){
        System.out.println("删除");
    }else{
        System.out.println("删除失败");

    }

    }catch(SQLException e){
      e.printStackTrace();;
    }
}

public void add(Music music) throws SQLException{
Connection connection=DBUtil.getConnection();
PreparedStatement statement=connection.prepareStatement(“inser into music (musicname,author) values(?,?)”);
statement.setString(1,“123”);
statement.setString(2,“123”);
statement.executeQuery();
}
}

DBUtil:

package com.zhongruan.util;

import java.sql.*;

public class DBUtil {
public static Connection getConnection() {

    Connection connection = null;
    try {
        Class.forName("com.mysql.jdbc.Drivers");
        connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/nbcj?useSSL=true&characterEncoding=utf-8&user=root&password=123456\n");

    } catch (SQLException e) {
        e.printStackTrace();
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }

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

}

}

user:

package com.zhongruan.bean;

public class user {
private int id;
private String username;
private String password;

public int getId() {
    return id;
}

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

public String getUsername() {
    return username;
}

public void setUsername(String username) {
    this.username = username;
}

public String getPassword() {
    return password;
}

@Override
public String toString() {
    return "user{" +
            "id=" + id +
            ", username='" + username + '\'' +
            ", password='" + password + '\'' +
            '}';
}

public void setPassword(String password) {
    this.password = password;


}

}