Atitit 提升开发效率 通道化驱动化数据操作与查询 目录 1. xiaoguo 1 1.1. Atitit mybatis 简化开发与提升开发效率法 1 2. Code 1 3. ref 4

Atitit 提升开发效率  通道化驱动化数据操作与查询

目录

1. xiaoguo 1

1.1. Atitit mybatis 简化开发与提升开发效率法 1

2. Code 1

3. ref 4

1. xiaoguo

http://localhost:9301/query?cmd=call sp1(1)

返回

[

{

"renwuMinchen":"task",

"shouldProcessTime":1533112642000,

"shijiChuleiShijian":1533112642000,

"id":1

}

]

1. 1. Atitit mybatis 简化开发与提升开发效率法

目录

1.1. 使用注解模式代替xml模式 1

1.2. 使用通用mapper代替专用mapper 1

1.3. 使用js等脚本语言来输出sql方便无java环境测试 1

1.4. 使用sp存储过程，将java mybatis部分通道化 2

1. Code

1. 1. DataCtronler

package org.chwin.firefighting.apiserver.data;

import com.alibaba.fastjson.JSON;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;
import java.util.Map;

@Controller
public class DataCtronler {


    @RequestMapping(value = "/query")
    public void query(HttpServletRequest req, HttpServletResponse res) throws Exception {
      String cmd=req.getParameter("cmd");
        SqlSessionFactory sqlSessionFactory =MybatisUtil. getSqlSessionFactory();
        SqlSession session = sqlSessionFactory.openSession(true);
//"call sp1(2)"
        MybatisMapperCls mapper = session.getMapper(MybatisMapperCls.class);

        List<Map> li = mapper.query(cmd);
        String rzt = JSON.toJSONString(li, true);
       // System.out.println(rzt);
        session.close();
        res.getWriter().write(rzt);
        res.getWriter().flush();
        res.flushBuffer();
return;
    }

1. ref

Atitit mybatis 简化开发与提升开发效率法.docx

Atitit 通道化数据查询