How to develop a simple online music player using MySQL and Java

How to use MySQL and Java to develop a simple online music player

Developing an online music player is a challenging and interesting project. This article will introduce how to use the MySQL database and Java programming language to build a simple online music player, and provide specific code examples.

1. Project requirements analysis
Before starting development, we need to clarify the project requirements. A simple online music player needs to have the following functions:

1. user registration and login function;
2. song upload and deletion function;
3. song search and Playback function;
4. song list creation and management function.

2. Database design
In order to store data such as users, songs and playlists, we need to design a suitable database structure. Create the following data tables in the MySQL database:

1. The user table named users contains fields such as id, username and password;
2. The song table named songs contains Fields such as id, title, artist, and url;
3. is a playlist table named playlists, including fields such as id, name, and userId.

3. Implementation of user registration and login functions
User registration and login are the basic functions of online music players. In Java, you can use JDBC to connect to the MySQL database to operate user tables. The following is a code example to implement the registration and login functions:

1. User registration function

   public class UserRegistration {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement pstmt = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost/music_player", "root", "password");
            String sql = "INSERT INTO users (username, password) VALUES (?, ?)";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, "username");
            pstmt.setString(2, "password");
            pstmt.executeUpdate();
            System.out.println("User registered successfully!");
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (pstmt != null) {
                    pstmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
   }

2. User login function

   public class UserLogin {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost/music_player", "root", "password");
            String sql = "SELECT * FROM users WHERE username = ? AND password = ?";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, "username");
            pstmt.setString(2, "password");
            rs = pstmt.executeQuery();
            if (rs.next()) {
                System.out.println("User logged in successfully!");
            } else {
                System.out.println("Invalid username or password!");
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (pstmt != null) {
                    pstmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
   }

4. Implementation of the song upload and delete functions
The song upload and delete functions can be realized by storing the song files on the server and storing the song information in the MySQL database. The following is a code example to implement the upload and delete functions:

1. Song upload function

   public class SongUpload {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement pstmt = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost/music_player", "root", "password");
            String sql = "INSERT INTO songs (title, artist, url) VALUES (?, ?, ?)";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, "song title");
            pstmt.setString(2, "artist");
            pstmt.setString(3, "song_url");
            pstmt.executeUpdate();
            System.out.println("Song uploaded successfully!");
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (pstmt != null) {
                    pstmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
   }

2. Song deletion function

   public class SongDelete {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement pstmt = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost/music_player", "root", "password");
            String sql = "DELETE FROM songs WHERE id = ?";
            pstmt = conn.prepareStatement(sql);
            pstmt.setInt(1, 1);
            pstmt.executeUpdate();
            System.out.println("Song deleted successfully!");
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (pstmt != null) {
                    pstmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
   }

5. Implementation of song search and playback functions
The song search and playback functions can be implemented by using JDBC in Java to query the database and display the song list on the front-end page. The following is a code example to implement the search and playback functions:

1. Song Search Function

   public class SongSearch {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost/music_player", "root", "password");
            String sql = "SELECT * FROM songs WHERE title LIKE ?";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, "%keyword%");
            rs = pstmt.executeQuery();
            while (rs.next()) {
                System.out.println("Song Title: " + rs.getString("title"));
                System.out.println("Artist: " + rs.getString("artist"));
                System.out.println("URL: " + rs.getString("url"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (pstmt != null) {
                    pstmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
   }

2. Song Playback Function

   public class SongPlayer {
    public static void main(String[] args) {
        // 根据歌曲URL进行音频播放
    }
   }

6. Implementation of playlist creation and management functions
The creation and management of playlists can be achieved by using JDBC to operate the playlist table in Java. The following is a code example for the playlist creation and management function:

1. Playlist Creation Function

   public class PlaylistCreate {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement pstmt = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost/music_player", "root", "password");
            String sql = "INSERT INTO playlists (name, userId) VALUES (?, ?)";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, "playlist name");
            pstmt.setInt(2, 1);
            pstmt.executeUpdate();
            System.out.println("Playlist created successfully!");
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (pstmt != null) {
                    pstmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
   }

2. Playlist Management Function

   public class PlaylistManagement {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost/music_player", "root", "password");
            String sql = "SELECT * FROM playlists WHERE userId = ?";
            pstmt = conn.prepareStatement(sql);
            pstmt.setInt(1, 1);
            rs = pstmt.executeQuery();
            while (rs.next()) {
                System.out.println("Playlist Name: " + rs.getString("name"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (pstmt != null) {
                    pstmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
   }

7. Summary
By using the MySQL database and Java programming language, we can develop a simple online music player. This article provides specific code examples, covering user registration and login functions, song upload and deletion functions, song search and playback functions, and playlist creation and management functions. Developers can build on this foundation to further refine and expand the project.

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