音乐系统4

存放音乐管理系统的增删改查

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("添加失败！");
        }
    }

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

存放用户信息的增删改查

public class UserDao {
    public User login(String username, String password) throws SQLException {
        Connection connection= DBUtil.getConnection();
        String sql="select * from tb_user where username=? and password=?";