二、Spring能力方式
编写service
增加resoures文件

图 1

图 2
编写mybatis配置文件

图 3
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.yonyou.ucf.mdf.domain.dao.mybatisActivityDao">
<select id="select" resultType="map">
select code,name from psndoc_zzd limit 10
</select>
</mapper>
编写service

图 4
package com.yonyou.ucf.mdf.domain.service;
import com.yonyou.ucf.mdd.common.context.MddBaseContext;
import com.yonyou.ucf.mdd.core.dao.biz.IBizDataMapperDao;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
import java.util.Map;
/**
* mybatis方式操作数据库示例
*/
@Slf4j
@Service
public class MybatisActivityService {
/**
* 查询示例
* @param params
* @throws Exception
* @return
*/
public Object selectMybatis(Map<String, Object> params) throws Exception {
Object obj = ((IBizDataMapperDao) MddBaseContext.getMapperDao(IBizDataMapperDao.class)).
dynamicExecSelectSql("com.yonyou.ucf.mdf.domain.dao.mybatisActivityDao.select", null);
return obj;
}
}
编写controller

图 5
package com.yonyou.ucf.mdf.app.controller.activity;
import com.yonyou.ucf.mdd.common.context.MddBaseContext;
import com.yonyou.ucf.mdd.common.dto.BaseReqDto;
import com.yonyou.ucf.mdd.common.interfaces.context.ISimpleUser;
import com.yonyou.ucf.mdf.app.common.ResultMessage;
import com.yonyou.ucf.mdf.app.controller.BillController;
import com.yonyou.ucf.mdf.domain.service.MddActivityService;
import com.yonyou.ucf.mdf.domain.service.MybatisActivityService;
import com.yonyou.ucf.mdf.domain.service.SqlActivityService;
import lombok.extern.slf4j.Slf4j;
import org.imeta.orm.base.BizObject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.Map;
/**
* @author nishch
* @version 1.0
* @date 2020/7/7
* @des 活动管理控制器
*/
@Slf4j
@RestController
@RequestMapping("/activity")
public class ActivityController extends BillController {
@Autowired
MddActivityService mddActivityService;
@Autowired
MybatisActivityService mybatisActivityService;
/**
* 测试查询数据
*
* @param params
* @param request
* @param response
*/
@RequestMapping("/select")
public void getBill(@RequestBody BizObject params, HttpServletRequest request, HttpServletResponse response) {
try {
//获取当前登录用户信息
ISimpleUser user = MddBaseContext.getCurrentUser();
Object object2 = mybatisActivityService.selectMybatis(params);
this.renderJson(response, ResultMessage.data(object2));
} catch (Exception e) {
this.renderJson(response, ResultMessage.error(e.getMessage()));
}
}
@RequestMapping("/update")
public void update(@RequestBody BaseReqDto bill, HttpServletRequest request, HttpServletResponse response) {
try {
//可以在这里添加自己的逻辑bill
super.save(bill, request, response);
this.renderJson(response, ResultMessage.success());
} catch (Exception e) {
this.renderJson(response, ResultMessage.error(e.getMessage()));
}
}
}
自定义按钮

图 6
编写前端函数

图 7

图 8
function (event) {
var viewModel = this;
viewModel.get('button7pa').on('click', function () {
var proxy = cb.rest.DynamicProxy.create({
settle: {
url: 'activity/select',
method: 'POST'
}
});
proxy.settle(viewModel.getParams(), function(err, result) {
if (err) {
cb.utils.alert(err.message, 'error');
return;
}
if (result != undefined) {
//对结果进行处理
}
});
})
}
绑定函数

图 9
测试

图 10

图 11