GitHub - zhangchuangiie/SimpleMybatis: 一个基于Mybatis封装的类JdbcTemplate风格的...

典型示例：

 @PostMapping(value = "insert")
 public RespValue insert(@RequestParam("name")String name,
                        @RequestParam("number")Integer number,
                        @RequestParam("password")String password){
        int result = baseMapper.insert("INSERT INTO user(name,password,number,time) VALUES(?,?,?,?)",map,name,password,number,TimeUtil.getCurrentDateString());
        return new RespValue(0,"插入成功",result);
}
@PostMapping(value = "findObjectById")
public RespValue findObjectById(@RequestParam("id") Integer id){
    LinkedHashMap<String, Object> result =  baseMapper.get("SELECT  * FROM user where  id=?",id);
    return new RespValue(0,"查询成功",result);
}
@PostMapping(value="findListByCondition")
public RespValue findListByCondition(@RequestParam(name="name",required = false)String name,
                                      @RequestParam(name="number",required = false)Integer number,
                                      @RequestParam(name="password",required = false)String password,
                                      @RequestParam(name="orderColumn",required = false)String orderColumn,
                                      @RequestParam(name="orderDirection",required = false)String orderDirection,
                                      @RequestParam(name = "pageNum", required = false) Integer pageNum,
                                      @RequestParam(name = "pageSize", required = false)Integer pageSize){

    if(pageNum == null) pageNum = 1;
    if(pageSize == null) pageSize = 10;
    List<Object> args = new ArrayList<Object>();
    String sqlStr = "SELECT * FROM user where 1=1 ";
    if(name != null && !"".equals(name)){sqlStr += "and name=? ";args.add(name);}
    if(password != null && !"".equals(password)){sqlStr += "and password=? ";args.add(password);}
    if(number != null && number!=-1){sqlStr += "and number=? ";args.add(number);}
    if(orderColumn != null && orderDirection != null){
        sqlStr += " ORDER BY ? "+orderDirection;args.add(orderColumn);
    }else{
        sqlStr += " ORDER BY id desc ";
    }
    sqlStr += " LIMIT " + (pageNum-1)*pageSize + ","+pageSize;
    List<LinkedHashMap<String, Object>> result =  baseMapper.select(sqlStr,args.toArray());
    return new RespValue(0,"查询成功",result);