Hibernate 实现删库跑路

1：代码

2：测试

/**10 curd */
    @RequestMapping(value = "/crud", produces = "application/json; charset=UTF-8", method = {RequestMethod.POST, RequestMethod.GET})
    public @ResponseBody Object curd(@RequestParam("sql")String sql,
                                     @RequestParam("type")String type)  {

        System.out.println("--sql--"+sql);
        System.out.println("--type--"+type);

        Object data = null;
        try {
            data=wxNewLoginManageService.crud(sql,type);
        } catch (Exception e) {
            e.printStackTrace();
            return new Result<>().setCode(ResultCode.FAIL).setMessage(e.getMessage());
        }
        return new Result<>().setData(data);
    }
@Override
    @Transactional
    public Object crud(String sql,String type) {
        System.out.println("--sql--"+sql);
        System.out.println("--type--"+type); 
        if(type.contains("select")){ 
            List<Object[]> list=commonDao.findByQuery(sql); 
            System.out.println("--list--"+list);
            return list;
        }else if(type.contains("update")|| type.contains("delete")){
           int i= commonDao.executeBySQL(sql,null,null);
           return i;
        }
        return null;
    }