How to use MySQL and Java to implement a simple music player function

Introduction:
With the continuous development of technology, music players have become people’s daily life An integral part of life. This article will introduce how to use MySQL and Java programming language to implement a simple music player function. The article will contain detailed code examples to help readers understand and practice.

1. Preparation work:
Before using MySQL and Java to implement the music player, we need to do some preparation work:

1. Install the MySQL database: Download and install the MySQL database, And create a database named "music_player".
2. Create table structure: Create two tables in the "music_player" database, namely "songs" and "playlists". The table structure is as follows:
3. songs table: id(INT), title(VARCHAR), artist(VARCHAR), duration(INT)
4. playlists table: id(INT), name(VARCHAR) , songs(VARCHAR)

2. Add music and create playlist:
We need to write some Java code to add music to the database and create our own playlist. The following is a sample code:

import java.sql.*;

public class MusicPlayer {
    private static final String DB_URL = "jdbc:mysql://localhost/music_player";
    private static final String DB_USERNAME = "your_username";
    private static final String DB_PASSWORD = "your_password";

    public static void main(String[] args) {
        try {
            // 連接數(shù)據(jù)庫(kù)
            Connection conn = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);

            // 向songs表中插入數(shù)據(jù)
            insertSong(conn, "Song Title 1", "Artist 1", 180);
            insertSong(conn, "Song Title 2", "Artist 2", 200);

            // 創(chuàng)建一個(gè)播放列表，并向playlists表中插入數(shù)據(jù)
            createPlaylist(conn, "My Playlist");
            addSongToPlaylist(conn, "My Playlist", 1);
            addSongToPlaylist(conn, "My Playlist", 2);

            // 關(guān)閉數(shù)據(jù)庫(kù)連接
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    // 向songs表中插入數(shù)據(jù)
    private static void insertSong(Connection conn, String title, String artist, int duration) {
        try {
            String sql = "INSERT INTO songs (title, artist, duration) VALUES (?, ?, ?)";
            PreparedStatement statement = conn.prepareStatement(sql);
            statement.setString(1, title);
            statement.setString(2, artist);
            statement.setInt(3, duration);
            statement.executeUpdate();
            System.out.println("Song inserted successfully!");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    // 創(chuàng)建一個(gè)播放列表，并向playlists表中插入數(shù)據(jù)
    private static void createPlaylist(Connection conn, String name) {
        try {
            String sql = "INSERT INTO playlists (name) VALUES (?)";
            PreparedStatement statement = conn.prepareStatement(sql);
            statement.setString(1, name);
            statement.executeUpdate();
            System.out.println("Playlist created successfully!");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    // 向播放列表中添加歌曲
    private static void addSongToPlaylist(Connection conn, String playlistName, int songId) {
        try {
            String sql = "SELECT songs FROM playlists WHERE name = ?";
            PreparedStatement statement = conn.prepareStatement(sql);
            statement.setString(1, playlistName);
            ResultSet resultSet = statement.executeQuery();
            resultSet.next();
            String songs = resultSet.getString("songs");
            if (songs == null || songs.isEmpty()) {
                songs = String.valueOf(songId);
            } else {
                songs += "," + songId;
            }
            sql = "UPDATE playlists SET songs = ? WHERE name = ?";
            statement = conn.prepareStatement(sql);
            statement.setString(1, songs);
            statement.setString(2, playlistName);
            statement.executeUpdate();
            System.out.println("Song added to playlist successfully!");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

The above code first connects to the database, and then inserts music information into the songs table through the insertSong method, createPlaylistMethod creates a playlist and inserts it into the playlists table, addSongToPlaylist method adds songs to the playlist. Finally close the database connection. If necessary, you can modify these methods to suit your needs.

3. Play music:
In order to play music, we can use Java's audio playback library, such as javax.sound.sampled. The following is a simple sample code:

import javax.sound.sampled.*;
import java.io.*;

public class MusicPlayer {

    public static void main(String[] args) {
        try {
            // 創(chuàng)建音頻流
            AudioInputStream audioInputStream = AudioSystem.getAudioInputStream(new File("song.wav"));

            // 獲取音頻格式
            AudioFormat format = audioInputStream.getFormat();

            // 創(chuàng)建音頻剪輯
            Clip clip = AudioSystem.getClip();
            clip.open(audioInputStream);

            // 播放音頻剪輯
            clip.start();

            // 等待音頻播放完畢
            Thread.sleep(clip.getMicrosecondLength() / 1000);

            // 關(guān)閉音頻流
            audioInputStream.close();

        } catch (UnsupportedAudioFileException | IOException | LineUnavailableException | InterruptedException e) {
            e.printStackTrace();
        }
    }
}

The above code opens an audio file in wav format and plays it. You can replace the song.wav file name with the path to your music file.

Conclusion:
This article introduces how to use MySQL and Java programming language to implement a simple music player function. The article contains specific code examples to help readers understand and practice. Of course, this is just a basic demo, you can extend and improve this music player according to your needs. I hope this article can be helpful to you, thank you for reading!

The above is the detailed content of How to implement a simple music player function using MySQL and Java. For more information, please follow other related articles on the PHP Chinese website!