加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

控制层 Controller 调用 xml

发布时间:2020-12-16 02:07:47 所属栏目:百科 来源:网络整理
导读:1. java 代码 @ResponseBody@RequestMapping(value = {"testMap"})public Object testMap( HttpServletRequest request,HttpServletResponse response,Model model) throws Exception {SqlSessionFactory sessionFactory = sqlSessionFactoryBean.getObject(

1. java 代码

@ResponseBody
	@RequestMapping(value = {"testMap"})
	public Object  testMap( HttpServletRequest request,HttpServletResponse response,Model model) throws Exception {
		
		SqlSessionFactory sessionFactory = sqlSessionFactoryBean.getObject();
		SqlSession session = sessionFactory.openSession();   // 打开连接
		
		Map  sMap=new HashMap<String,String >();
		sMap.put("id","72b499e409b34c12883fa73cba9ed905") ;
	//	Object resultObject = session.selectOne("timeUtil.findUserById",sMap);
		sMap.put("procInsId","47184536c2c24584a58bad2add714cdc") ;
		Object resultObject = session.selectOne("timeUtil.findBeanByProIns",sMap);
		session.close(); /// 关闭连接	
		String string = resultObject.toString();
		//String json = JsonMapper.getInstance().toJson(resultObject);
		return resultObject;
	}

2. xml 配置

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="timeUtil">
    
	<select id="findUserById"  resultType="Evection" >
       SELECT * FROM  FLOW_EVECTION  where id= #{id}
	</select>
	
		<select id="findBeanByProIns"  resultType="java.util.HashMap" >
       SELECT * FROM  FLOW_EVECTION  where proc_ins_id= #{procInsId}
	</select>
	
</mapper>

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读