stmt = conn.prepareStatement(sql);
for (i = 0; i < parasKey.size(); i++)
{
String key = (String) parasKey.get(i);
setParas(i,stmt,key,vo);
}
以上代码段中调用方法
private static void setParas(int i, PreparedStatement stmt, String key,
BaseVO vo) throws Exception
{
Object para = vo.get(key);
if (para != null)
{
if (vo.isImage(key))
{
InputStream is = new ByteArrayInputStream((byte[])para);
stmt.setBinaryStream(i + 1, is, is.available());
}
}
}其中para为jsp页面传入的图片流
保存时报“[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]操作数类型冲突: nvarchar 与 image 不兼容”错误,请帮忙分析一下,谢谢!
for (i = 0; i < parasKey.size(); i++)
{
String key = (String) parasKey.get(i);
setParas(i,stmt,key,vo);
}
以上代码段中调用方法
private static void setParas(int i, PreparedStatement stmt, String key,
BaseVO vo) throws Exception
{
Object para = vo.get(key);
if (para != null)
{
if (vo.isImage(key))
{
InputStream is = new ByteArrayInputStream((byte[])para);
stmt.setBinaryStream(i + 1, is, is.available());
}
}
}其中para为jsp页面传入的图片流
保存时报“[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]操作数类型冲突: nvarchar 与 image 不兼容”错误,请帮忙分析一下,谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货