springmvc mybatis 调用sql , 转成json

1.代码

1	@Autowired
2    private	 SqlSessionFactoryBean  sqlSessionFactory  ;
3	@RequestMapping(value = "f3")
4	public String f3( @RequestBody Map<String,String>  map,HttpServletRequest request, HttpServletResponse response) throws Exception {
5		SqlSessionFactory object = sqlSessionFactory.getObject();
6		SqlSession session = null;
7		try {
8			session = object.openSession();
9			Object selectOne = session.selectOne("test.get2", map);
10			 MappedStatement mappedStatement = session.getConfiguration().getMappedStatement("test.get2");
11			String jsonString = JsonMapper.toJsonString(selectOne);
12			System.out.println(11);
13		} finally {
14			session.close();
15		}
16		return "f1";
17	}
18
19<mapper namespace="test">
20	<select id="get1" resultType="TestData">
21		SELECT 
22			 *
23		FROM test_data a
24		WHERE a.id = #{id}
25	</select>
26	
27		<select id="get2" resultType="map">
28		SELECT 
29			*
30		FROM test_data a
31		WHERE a.id = #{id}
32	</select>
33</mapper>

2.前台

1$.ajax({
2			        url :'${ctx}/test/testData/f3?book=java',
3			        type: 'post',
4			        dataType : "json",
5			        contentType:'application/json;charset=UTF-8',//关键是要加上这行
6			        data : JSON.stringify( {id:'22',remarks:'aaa'}),
7			        async : false, // 同步请求
8			        success : function(data) {
9			             debugger ;
10			        }
11			    });

3,转成json   ,在数据库就转成 json

        <select id="get2" resultType="map">
        SELECT 
            id,user_id, date_format(create_date,'%Y-%m-%d') as cdate
        FROM test_data a
        WHERE a.id = #{id}
    </select>

4, 数据对比

1		a.id AS "id",
2		a.user_id AS "user.id",
3		a.office_id AS "office.id",
4		a.area_id AS "area.id",
5		a.name AS "name",
6		a.sex AS "sex",
7		a.in_date AS "inDate",
8		a.create_by AS "createBy.id",
9	     date_format(create_date,'%Y-%m-%d')  AS "createDate",
10		a.update_by AS "updateBy.id",
11		date_format(update_date,'%Y-%m-%d') AS "updateDate",
12		a.remarks AS "remarks",
13		testint,
14		a.del_flag AS "delFlag"

上面可以重新 封装成map