Shulou(Shulou.com)06/02 Report--

This article mainly introduces how Mybatis uses JSONObject to receive database queries, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

1. Mapper.xml sets resultType

ResultType= "com.alibaba.fastjson.JSONObject"

2. Mapper.java uses JSONObject to receive

/ / query isvalid=1 data JSONObject selectValidBom (String parentsCode)

3. test

/ / Test the sql statement of BOM @ Test () public void testSelectValidBom () {JSONObject validBom = ebomService.getValidBom ("YZCL-80051-0010"); System.out.println ("result:" + validBom); System.out.println ("primary key:" + validBom.getString ("AutoID")); System.out.println ("version number:" + validBom.getIntValue ("bbh"));}

Output result:

Thank you for reading this article carefully. I hope the article "how Mybatis uses JSONObject to receive database queries" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.