Question

（高分）java中实现把word保存到oracle到的blob字段，请高手给出代码！

我写的方法，但是每次都报错： ORA-01006: 绑定变量不存在
错误在：pstmt.executeUpdate()
请高手指点

public static void saveFile() {
Connection conn = null;
PreparedStatement pstmt = null;
String sql = "insert into EAIFILETABLE(FILECONTENT,FILENAME,FILETYPE,SOAID,SOSSYSID) values(?,'test','1','soaid','sossysid')";
try {
Class.forName("oracle.jdbc.OracleDriver");
conn = DriverManager.getConnection("**", "**", "**");
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, 1);
File file = new File("e:\\test.doc");
int length = (int) file.length();
InputStream fin = new FileInputStream(file);
pstmt.setString(1, "存word");
pstmt.setBinaryStream(2, fin, length);
pstmt.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {

}
}

Answer 1

你的sql语句只有一个问号，怎么set两个值？
sql = "insert into EAIFILETABLE(FILECONTENT,FILENAME,FILETYPE,SOAID,SOSSYSID) values(?,'test','1','soaid','sossysid')";

pstmt.setString(1, "存word");
pstmt.setBinaryStream(2, fin, length);

Answer 2

pstmt.setBinaryStream(2, fin, length);
你的sql语句明明只有一个 ? ，这里怎么还能set变量?