将音频文件插入Mysql数据库

发布于 2024-11-04 03:45:16 字数 661 浏览 1 评论 0原文

我们如何使用 JAVA 数据库连接连接将音频文件插入 MYSQL 数据库

对于插入图像，我们使用

 psmnt = conn.prepareStatement("INSERT INTO upload_data(user_id,photo) "
                            + "values(?,?)");

            psmnt.setLong(1, userId);

            fis = new FileInputStream(photoFile);
            psmnt.setBinaryStream(2, (InputStream) fis, (int) (photoFile
                    .length()));
            /*
             * executeUpdate() method execute specified sql query. Here this
             * query insert data and image from specified address.
             */
            int s = psmnt.executeUpdate();

要插入 3gp 格式的音频文件，使用 JDBC 的代码是什么

原文

How can we insert audio files in to MYSQL Database using JAVA DATABASE CONNECTIVITY connectivity

For inserting image we use

 psmnt = conn.prepareStatement("INSERT INTO upload_data(user_id,photo) "
                            + "values(?,?)");

            psmnt.setLong(1, userId);

            fis = new FileInputStream(photoFile);
            psmnt.setBinaryStream(2, (InputStream) fis, (int) (photoFile
                    .length()));
            /*
             * executeUpdate() method execute specified sql query. Here this
             * query insert data and image from specified address.
             */
            int s = psmnt.executeUpdate();

To insert an audio file in 3gp format , what will be the code using JDBC

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

ゃ人海孤独症 2024-11-11 03:45:16

代码应该完全相同：您需要确保您的音频文件足够小以适合该列（如果我没记错的话，mediumblob 是 16MBits 或大约）。数据库不关心它是音频还是图像数据。

为了讨论：

psmnt = conn.prepareStatement("INSERT INTO upload_data(user_id,audiofile) "
                            + "values(?,?)");

            psmnt.setLong(1, userId);

            fis = new FileInputStream(audioFile);
            psmnt.setBinaryStream(2, (InputStream) fis, (int) (audioFile
                    .length()));
            /*
             * executeUpdate() method execute specified sql query. Here this
             * query insert data and image from specified address.
             */
            int s = psmnt.executeUpdate();

看起来公平吗？

The code should be exactly the same: you will need to make sure your audio file is small enough to fit into the column (mediumblob is 16MBits or there abouts if I recall correctly. The database doesn't care if its audio or image data.

For the sake of discussion:

psmnt = conn.prepareStatement("INSERT INTO upload_data(user_id,audiofile) "
                            + "values(?,?)");

            psmnt.setLong(1, userId);

            fis = new FileInputStream(audioFile);
            psmnt.setBinaryStream(2, (InputStream) fis, (int) (audioFile
                    .length()));
            /*
             * executeUpdate() method execute specified sql query. Here this
             * query insert data and image from specified address.
             */
            int s = psmnt.executeUpdate();

Seems fair?

回复收藏 0 原文

~没有更多了~