java音乐管理系统

bean包

Music.java

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 + '\'' +
                '}';
    }
}

User.java

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;
    }

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

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

Dao包

MusicDao.java

import com.ningcai.bean.Music;
import com.ningcai.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;

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;
            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 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());
        statement.executeUpdate();
    }

    public void update() throws SQLException {

    }
}

UserDao.java

import com.ningcai.util.DBUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Collection;


public class UserDao {

    public boolean login(String username,String password) throws SQLException {
        Connection connection =  DBUtil.getConnection();
        String sql="select * from tb_user where username=? and password=?";
        PreparedStatement statement =connection.prepareStatement(sql);
        statement.setString(1,username);
        statement.setString(2,password);
        ResultSet resultSet = statement.executeQuery();
        if(resultSet.next()){
            return true;
        }else
            return false;
    }

    public boolean zhuce(String username,String password) throws SQLException {
        Connection connection = DBUtil.getConnection();
        String sql="insert into tb_user(username,password) values(?,?)";
        PreparedStatement statement = connection.prepareStatement(sql);
        statement.setString(1,username);
        statement.setString(2,password);
        int i=statement.executeUpdate();
        if(i!=0){
            return true;
        }else{
            return false;
        }
    }
}

util包

DBUtil.java

import java.sql.*;

public class DBUtil {
    public static Connection getConnection(){
        Connection connection=null;
        //1.加载驱动
        try {
            Class.forName("com.mysql.jdbc.Driver");
            //2.创建连接
            connection= DriverManager.getConnection
                    ("jdbc:mysql://127.0.0.1:3306/nbcj?useSSL=true&characterEncoding=utf-8&user=root&password=123");
            System.out.println("创建连接成功");
        } catch (Exception e) {
            e.printStackTrace();
        }
        return connection;
    }

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

            try {
                preparedStatement.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            if(connection!=null){
                try{
                    connection.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }

        }
    }
}