สมมติตาราง MyData:
+---------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+---------+-------+ | Name | varchar(255) | YES | | NULL | | | Article | longtext | YES | | NULL | | +---------+--------------+------+-----+---------+-------+
เมธอด insert Clob:
void setCharacterStream(int parameterIndex, Reader reader) ตั้งค่าเนื้อหา Reader
รูปแบบอื่น: setCharacterStream(int, Reader, int length) และ setCharacterStream(int, Reader, long length)
void setClob(int parameterIndex, Clob x) ตั้งค่า Clob object
รูปแบบอื่น: setClob(int, Reader) และ setClob(int, Reader, long length)
ตัวอย่างใช้ setClob()
import java.io.FileReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class InsertingValueInClob {
public static void main(String args[]) throws Exception {
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String mysqlUrl = "jdbc:mysql://localhost/sampleDB";
Connection con = DriverManager.getConnection(mysqlUrl, "root", "password");
System.out.println("Connection established......");
String query = "INSERT INTO MyData(Name, Article ) VALUES (?, ?)";
PreparedStatement pstmt = con.prepareStatement(query);
pstmt.setString(1, "JavaFX");
FileReader reader = new FileReader("E:\\images\\javafx.txt");
pstmt.setClob(2, reader);
pstmt.execute();
System.out.println("Data inserted");
}
}
ผลลัพธ์
Connection established...... Table Created...... Contents of the table are: JavaFX E:\images\MyData_clob_output1.txt
ดูค่า Clob ใน MySQL Workbench จะเห็นข้อความที่ insert:
