求助!!!SQL2000不能更新数据
我想存一幅图片!!
数据库设为IMAGE 格式!
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Row update failed.
出现这个错误!!可是更新STRING 类型的却成功!!!
源码:
try {
byte[] b=new byte[50000];/
FileInputStream in=new FileInputStream("book.jpg");
BufferedInputStream bu=new BufferedInputStream(in);
bu.read(b);
// System.out.println(new String(b,0,b.length));
// bu.close();
jBook1.readFromBlob(b);
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url =
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=noriko";
String user = "sa";
String password = "sa";
Connection conn = DriverManager.getConnection(url, user, password);
System.out.println("连接成功!");
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("select * from liu");
while (rs.next()) {
if (rs.getString("国家").equals("中国")) {
System.out.println(rs.getString("国家"));
System.out.println(rs.getString("地区"));
rs.updateString("地区", "安阳");
rs.updateBytes("XML",b);
// 问题的关键。。。。。。
rs.updateRow();
FileOutputStream file = new FileOutputStream("XXX2");
file.write(b);
file.close();
}
}
rs.close();
stmt.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
那位大虾帮帮小弟