关于setCharacterStream和setAsciiStream，求解答。

逸花城 2016-09-20 07:01:23

用setCharacterStream一切正常：

import java.sql.*;

import java.io.*;

public class ClobDemo

{

	public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";

	public static final String DBURL = "jdbc:oracle:oci:@zqmpc_orcl";

	public static final String DBUSER = "mark";

	public static final String DBPASS = "markadmin";

	public static void main(String[] args) throws Exception{

		Connection conn  = null;

		PreparedStatement pstmt = null;

		String title = "天龙八部";

		String author = "金庸";

		File f = new File("f:"+File.separator+"documents"+File.separator+"金庸全集"+File.separator+"天龙八部.txt");

		Reader content = new FileReader(f);

		String sql = "insert into myclob(title,author,content) values(?,?,?)";

		Class.forName(DBDRIVER);

		conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS);

		pstmt = conn.prepareStatement(sql);

		pstmt.setString(1,title);

		pstmt.setString(2,author);

		pstmt.setCharacterStream(3,content);

		pstmt.executeUpdate();

		pstmt.close();

		conn.close();

	}

};

如果用setAsciiStream的话，MySQL直接抛异常写不进，Oracle能写进但却是乱码：

import java.sql.*;

import java.io.*;

public class ClobDemo

{

	public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";

	public static final String DBURL = "jdbc:oracle:oci:@zqmpc_orcl";

	public static final String DBUSER = "mark";

	public static final String DBPASS = "markadmin";

	public static void main(String[] args) throws Exception{

		Connection conn  = null;

		PreparedStatement pstmt = null;

		String title = "天龙八部";

		String author = "金庸";

		File f = new File("f:"+File.separator+"documents"+File.separator+"金庸全集"+File.separator+"天龙八部.txt");

		InputStream content = new FileInputStream(f);

		String sql = "insert into myclob(title,author,content) values(?,?,?)";

		Class.forName(DBDRIVER);

		conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS);

		pstmt = conn.prepareStatement(sql);

		pstmt.setString(1,title);

		pstmt.setString(2,author);

		pstmt.setAsciiStream(3,content,f.length());

		pstmt.executeUpdate();

		pstmt.close();

		conn.close();

	}

};