【急】IBatis中update时提示java.lang.NullPointerException?
来源:互联网 发布:mysql中文乱码问题 编辑:程序博客网 时间:2024/05/11 00:58
sqlmap:
<update id="updateByMapSQL" parameterClass="java.util.Map">
update MEAT_OUT_INFO_BASE set SEND_STATE ='0' where TRAN_ID ='1001'
<dynamic prepend="set">
<isNotEmpty prepend="," property="butcherFacId">
<![CDATA[ BUTCHER_FAC_ID = #butcherFacId# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="butcherFacName">
<![CDATA[ BUTCHER_FAC_NAME = #butcherFacName# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="sellerId">
<![CDATA[ SELLER_ID = #sellerId# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="sellerName">
<![CDATA[ SELLER_NAME = #sellerName# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="buyerId">
<![CDATA[ BUYER_ID = #buyerId# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="buyerName">
<![CDATA[ BUYER_NAME = #buyerName# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="dest">
<![CDATA[ DEST = #dest# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="sendState">
<![CDATA[ SEND_STATE = #sendState# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="sendFailReson">
<![CDATA[ SEND_FAIL_RESON = #sendFailReson# ]]>
</isNotEmpty>
</dynamic>
<dynamic prepend="where">
<isNotEmpty prepend="AND" property="tranId">
<![CDATA[ TRAN_ID = #tranId# ]]>
</isNotEmpty>
</dynamic>
</update>
dao.impl:
public int update(String[] pK, String[] properties, Object[] propertyValues) throws Exception {
// 更新数据库
Map<String, Object> map = new HashMap<String, Object>();
for (int i = 0; i < properties.length; i++) {
map.put(properties[i], propertyValues[i]);
}
map.put(pK[0], pK[1]);
return masterSqlMapClientTemplate.update(clazz.getName() + POSTFIX_UPDATEBYMAP, map);
}
调用:
public static void updateState(String tranId) {
System.out.println("更新交易信息");
/*
* MeatOutInfoBase model = new MeatOutInfoBase();
* model.setTranId(tranId); model.setSendState("1");
* model.setSendFailReson("失败了"); MeatOutInfoBaseDaoImpl dao = new
* MeatOutInfoBaseDaoImpl(); int result = dao.updateState(model);
*/
MeatOutInfoBaseDao dao = (MeatOutInfoBaseDao) context
.getBean("meatOutInfoBaseDao");
String[] pK = { "tranId", tranId };
String[] properties = { "sendState", "sendFailReson" };
String[] propertyValues = { "0", "数据读取超时" };
int result = 0;
try {
result = dao.update(pK, properties, propertyValues);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("更新返回值:" + result);
}
报错:
java.lang.NullPointerException
at com.sunraw.rock.dao.impl.GenericDaoImpl.update(GenericDaoImpl.java:339)
at com.sunraw.test.MeatOutInfoBaseTest.updateState(MeatOutInfoBaseTest.java:88)
更新交易信息
更新返回值:0
at com.sunraw.test.MeatOutInfoBaseTest.main(MeatOutInfoBaseTest.java:25)
请问一下,这个是哪里有问题?
<update id="updateByMapSQL" parameterClass="java.util.Map">
update MEAT_OUT_INFO_BASE set SEND_STATE ='0' where TRAN_ID ='1001'
<dynamic prepend="set">
<isNotEmpty prepend="," property="butcherFacId">
<![CDATA[ BUTCHER_FAC_ID = #butcherFacId# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="butcherFacName">
<![CDATA[ BUTCHER_FAC_NAME = #butcherFacName# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="sellerId">
<![CDATA[ SELLER_ID = #sellerId# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="sellerName">
<![CDATA[ SELLER_NAME = #sellerName# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="buyerId">
<![CDATA[ BUYER_ID = #buyerId# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="buyerName">
<![CDATA[ BUYER_NAME = #buyerName# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="dest">
<![CDATA[ DEST = #dest# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="sendState">
<![CDATA[ SEND_STATE = #sendState# ]]>
</isNotEmpty>
<isNotEmpty prepend="," property="sendFailReson">
<![CDATA[ SEND_FAIL_RESON = #sendFailReson# ]]>
</isNotEmpty>
</dynamic>
<dynamic prepend="where">
<isNotEmpty prepend="AND" property="tranId">
<![CDATA[ TRAN_ID = #tranId# ]]>
</isNotEmpty>
</dynamic>
</update>
dao.impl:
public int update(String[] pK, String[] properties, Object[] propertyValues) throws Exception {
// 更新数据库
Map<String, Object> map = new HashMap<String, Object>();
for (int i = 0; i < properties.length; i++) {
map.put(properties[i], propertyValues[i]);
}
map.put(pK[0], pK[1]);
return masterSqlMapClientTemplate.update(clazz.getName() + POSTFIX_UPDATEBYMAP, map);
}
调用:
public static void updateState(String tranId) {
System.out.println("更新交易信息");
/*
* MeatOutInfoBase model = new MeatOutInfoBase();
* model.setTranId(tranId); model.setSendState("1");
* model.setSendFailReson("失败了"); MeatOutInfoBaseDaoImpl dao = new
* MeatOutInfoBaseDaoImpl(); int result = dao.updateState(model);
*/
MeatOutInfoBaseDao dao = (MeatOutInfoBaseDao) context
.getBean("meatOutInfoBaseDao");
String[] pK = { "tranId", tranId };
String[] properties = { "sendState", "sendFailReson" };
String[] propertyValues = { "0", "数据读取超时" };
int result = 0;
try {
result = dao.update(pK, properties, propertyValues);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("更新返回值:" + result);
}
报错:
java.lang.NullPointerException
at com.sunraw.rock.dao.impl.GenericDaoImpl.update(GenericDaoImpl.java:339)
at com.sunraw.test.MeatOutInfoBaseTest.updateState(MeatOutInfoBaseTest.java:88)
更新交易信息
更新返回值:0
at com.sunraw.test.MeatOutInfoBaseTest.main(MeatOutInfoBaseTest.java:25)
请问一下,这个是哪里有问题?
0 0
- 【急】IBatis中update时提示java.lang.NullPointerException?
- 急java.lang.NullPointerException是什么错误
- 急java.lang.NullPointerException是什么错误
- Android使用HttpClient时出现的 java.lang.NullPointerException提示
- 测试类提示错误:java.lang.NullPointerException
- myeclispe中创建maven web工程update project configuration 报错java.lang.NullPointerException解决方法
- android中调用findViewById时出现:java.lang.NullPointerException
- android 中碰到:java.lang.NullPointerException状况
- android 中碰到:java.lang.NullPointerException状况
- Android 开发中出现java.lang.NullPointerException
- 安卓开发时提示:java.lang.NullPointerException空指针异常
- Eclipse打开提示parseSdkContent failed java.lang.NullPointerException
- listView.getChildAt(i)时java.lang.NullPointerException
- java.lang.NullPointerException翻译
- java.lang.NullPointerException
- java.lang.NullPointerException
- Java.lang.NullPointerException
- java.lang.NullPointerException
- 在Android 中,创建Handler 和继承Handler再重写handleMessage方法的区别是什么
- [TYVJ P1716/BZOJ 3132 上帝造题的七分钟] 二维树状数组区间修改、区间查询
- 求助,查询问题,高手请进
- 分享几个下载YouTube视频的网站和工具
- 急!新装了xp后,为什么access数据库不能读数据了?
- 【急】IBatis中update时提示java.lang.NullPointerException?
- 如何隐藏ppc的开始菜单?
- 怎么管理上传的图片,高级的.
- 数据汇总显示
- 为什么我的asp页面在IE6中无法显示
- 哪里有同学录源码带论坛的 可以上传视频文件并播放的那种
- 请教j2me怎么实现断点续传
- J2ME画布效果显示问题
- 通过输出流蓝牙打印出错