游客发表

mysql插入Clob字段的实例

发帖时间:2025-11-05 01:09:34

mysql插入Clob字段的实例
复制import java.io.*;   import java.sql.*;   public class DBTest {       public static void main(String[] args) {           String driver = "com.mysql.jdbc.Driver";           String url = "jdbc:mysql://localhost:3306/upload?实例useUnicode=true&characterEncoding=Big5";           String user = "caterpillar";           String password = "123456";           try {               Class.forName(driver);               Connection conn = DriverManager.getConnection(url, user, password);               File file = new File("./logo_phpbb.jpg");               int length = (int) file.length();               InputStream fin = new FileInputStream(file);               PreparedStatement pstmt = conn.prepareStatement(                          "INSERT INTO files VALUES(?, ?)");               pstmt.setString(1, "Logo");               pstmt.setBinaryStream (2, fin, length);               pstmt.executeUpdate();               pstmt.clearParameters();               pstmt.close();               fin.close();               Statement stmt = conn.createStatement();               ResultSet result = stmt.executeQuery("SELECT * FROM files");               result.next();               String description = result.getString(1);               Blob blob = result.getBlob(2);               System.out.println("描述:" + description);               FileOutputStream fout = new FileOutputStream("./logo_phpbb_2.jpg");                             fout.write(blob.getBytes(1, (int)blob.length()));               fout.flush();               fout.close();               stmt.close();               conn.close();           }           catch(ClassNotFoundException e) {               System.out.println("找不到驱动");               e.printStackTrace();           }           catch(SQLException e) {               e.printStackTrace();           }           catch(IOException e) {               e.printStackTrace();           }       }   }   1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.

    热门排行

    友情链接