ssm框架 maven配置 使用quartz 调用kettle已经写好的job执行

最新推荐文章于 2023-04-16 13:11:42 发布
最新推荐文章于 2023-04-16 13:11:42 发布
阅读量458 收藏 1
点赞数 1
分类专栏： Java后端 文章标签： quartz kettle job ssm
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Eric_aixiansen/article/details/103769424
版权

maven 配置只上quartz和kettle的配置部分

<dependency>
            <groupId>org.quartz-scheduler</groupId>
            <artifactId>quartz</artifactId>
            <version>2.2.1</version>
        </dependency>
        <dependency>
            <groupId>org.quartz-scheduler</groupId>
            <artifactId>quartz-jobs</artifactId>
            <version>2.2.1</version>
        </dependency>
         <!-- kettle -->
        <dependency>
            <groupId>pentaho-kettle</groupId>
            <artifactId>kettle-core</artifactId>
            <version>7.1.0.0-12</version>
        </dependency>
        <dependency>
            <groupId>pentaho-kettle</groupId>
            <artifactId>kettle-dbdialog</artifactId>
            <version>7.1.0.0-12</version>
        </dependency>
        <dependency>
            <groupId>pentaho-kettle</groupId>
            <artifactId>kettle-engine</artifactId>
            <version>7.1.0.0-12</version>
        </dependency>
        <dependency>
            <groupId>pentaho</groupId>
            <artifactId>metastore</artifactId>
            <version>7.1.0.0-12</version>
        </dependency>
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-vfs2</artifactId>
            <version>2.2</version>
        </dependency>
        <dependency>
            <groupId>com.google.guava</groupId>
            <artifactId>guava</artifactId>
            <version>19.0</version>
        </dependency>



<repositories>
        <repository>
            <id>pentaho-releases</id>
            <name>Kettle</name>
            <url>https://nexus.pentaho.org/content/groups/omni/</url>
        </repository>
        <!-- 阿里云maven仓库 -->
        <repository>
            <id>public</id>
            <name>aliyun nexus</name>
            <url>http://maven.aliyun.com/nexus/content/groups/public/</url>
            <releases>
                <enabled>true</enabled>
            </releases>
        </repository>
    </repositories>

job类代码：

package com.doart.job;

import org.quartz.Job;
import org.quartz.JobDetail;
import org.quartz.JobExecutionContext;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import com.doart.utils.KettleUtils;

/**
 * testSecondsStore job.
 */
public class TestSecondsStoreJob implements Job {

    /**
     * 日志.
     */
    private Logger log = LoggerFactory.getLogger(TestSecondsStoreJob.class);

    @Override
    public void execute(JobExecutionContext context) {

        JobDetail jobDetail = context.getJobDetail();
        String jobName = jobDetail.getKey().getName();
        // String name = jobDetail.getJobDataMap().getString("name");
        log.info(jobName  + "执行开始!");
        String kjbPath = "E:\\kettle\\project\\testSecondsStore.kjb";//job的路径
        try {

            KettleUtils.runJob(kjbPath);
        } catch (Exception e) {

            String msg = "runJob错误:" + e.getMessage();
            log.error(msg, e);
        }
    }
}

前端代码如下：

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Insert title here</title>
        <link rel="stylesheet" href="js/layui/css/layui.css" />
    </head>
    <body>
        <div class="layui-form" style="margin:10px 0px 10px 10px">
            <div class="layui-inline">
                <label class="layui-form-lable">任务</label>
                <div class="layui-inline" style="margin:0px 0px 0px 10px">
                    <a class="layui-btn" id="start">开始</a>
                </div>
                <div class="layui-inline" style="margin:0px 0px 0px 10px">
                    <a class="layui-btn layui-btn-warm" id="pause">暂停</a>
                </div>
                <div class="layui-inline" style="margin:0px 0px 0px 10px">
                    <a class="layui-btn layui-btn-warm" id="resume">恢复</a>
                </div>
                <div class="layui-inline" style="margin:0px 0px 0px 10px">
                    <a class="layui-btn layui-btn-danger" id="stop">停止</a>
                </div>
                <div class="layui-inline" style="margin:0px 0px 0px 10px">
                    <label class="layui-form-lable">job1执行间隔</label>
                </div>
                <div class="layui-inline" style="margin:0px 0px 0px 10px">
                    <input class="layui-input" type="text" id="cronExpression1" placeholder="请输入频率时间" autocomplete="off">
                </div>
                <div class="layui-inline" style="margin:0px 0px 0px 10px">
                    <label class="layui-form-lable">job2执行间隔</label>
                </div>
                <div class="layui-inline" style="margin:0px 0px 0px 10px">
                    <input class="layui-input" type="text" id="cronExpression2" placeholder="请输入频率时间" autocomplete="off">
                </div>
                <div class="layui-inline" style="margin:0px 0px 0px 10px">
                    <a class="layui-btn layui-btn-danger" id="updateQuartz">修改执行间隔</a>
                </div>
            </div>
        </div>
        <table id="dataTbl2" lay-filter="tblFilter1" class="layui-table"></table>
        <table id="dataTbl1" lay-filter="tblFilter2" class="layui-table"></table>
        <script type="text/javascript" src="js/layui/layui.all.js"></script>
        <script type="text/html" id="opera">
            <input type="button" name="update"  lay-event="edit" value="编辑" class="layui-btn layui-btn-sm" >
            <input type="button" name="delete"  lay-event="delete" value="删除" class="layui-btn layui-btn-danger layui-btn-sm" >
        </script>
        <script>
            layui.use(["form", "table", "element", "layer"], function () {

                var form = layui.form;
                var table = layui.table;
                var element = layui.element;
                var layer = layui.layer;
                var $ = layui.jquery;
                var timer;
                // test_client_1数据
                table.render({

                    elem : "#dataTbl1",
                    id : "dataTbl1",
                    skin: "row",
                    even: true,
                    url : "/demo/kettle/getTestClinet1PageBean.do",
                    page : true,
                    limits: [3, 5, 10],
                    limit: 5,
                    cols : [ [ {type: "numbers", title:"序号", width:50},
                               {field : "id", title:"Id", sort:true, align:"center"},
                               {field : "userId", title : "用户id", align:"center"}, 
                               {field : "userName", title : "用户名", align:"center"},
                               {title : "操作", width:150, align:"center", toolbar:"#opera"},
                   ] ],
                   request: {

                   page : "curr",
                   limit : "size"
                   },
                   parseData : function(res) {

                       if (res.code == 200) {

                           return {

                               "code": 0,
                               "msg": res.msg,
                               "count": res.data.count,
                               "data": res.data.data
                           }
                       }
                   }
                });
                // test_日期表数据
                table.render({

                    elem : "#dataTbl2",
                    id : "dataTbl2",
                    skin: "row",
                    even: true,
                    url : "/demo/kettle/getTestTodayPageBean.do",
                    page : true,
                    limits: [3, 5, 10],
                    limit: 5,
                    cols : [ [ {type: "numbers", title:"序号", width:50},
                               {field : "id", title:"Id", sort:true, align:"center"},
                               {field : "userId", title : "用户id", align:"center"}, 
                               {field : "userName", title : "用户名", align:"center"},
                               {title : "操作", width:150, align:"center", toolbar:"#opera"},
                   ] ],
                   request: {

                   page : "curr",
                   limit : "size"
                   },
                   parseData : function(res) {

                       if (res.code == 200) {

                           return {

                               "code": 0,
                               "msg": res.msg,
                               "count": res.data.count,
                               "data": res.data.data
                           }
                       }
                   }
                });
                $("#start").click(function () {

                    $.ajax({

                        type : "post",
                        url : "/demo/kettle/startJob.do",
                        success : function (data) {

                            var data = JSON.parse(data);
                            if (data["code"] == "200") {

                                layer.msg(data.msg, {icon : 1}, 3000);
                            } else {

                                layer.msg(data.msg, {icon : 2}, 3000);
                            }
                        }
                    });
                    timer = setInterval(function () {

                        table.reload('dataTbl1', {

                            page : {curr:1},
                            url : "/demo/kettle/getTestClinet1PageBean.do",
                            method : "post"
                        });
                        table.reload('dataTbl2', {

                            page : {curr:1},
                            url : "/demo/kettle/getTestTodayPageBean.do",
                            method : "post"
                        });
                    }, 10000);
                    
                });
                $("#stop").click(function () {

                    $.ajax({

                        type : "post",
                        url : "/demo/kettle/stopJob.do",
                        success : function (data) {

                            var data = JSON.parse(data);
                            if (data.code == 200) {

                                layer.msg(data.msg, {icon : 1}, 3000);
                            } else {

                                layer.msg(data.msg, {icon : 2}, 3000);
                            }
                        }
                    });
                    clearInterval(timer);
                });
                $("#pause").click(function () {

                    $.ajax({

                        type : "post",
                        url : "/demo/kettle/pauseJob.do",
                        success : function (data) {

                            var data = JSON.parse(data);
                            if (data.code == 200) {

                                layer.msg(data.msg, {icon : 1}, 3000);
                            } else {

                                layer.msg(data.msg, {icon : 2}, 3000);
                            }
                        }
                    });
                });
                $("#resume").click(function () {

                    $.ajax({

                        type : "post",
                        url : "/demo/kettle/resumeJob.do",
                        success : function (data) {

                            var data = JSON.parse(data);
                            if (data.code == 200) {

                                layer.msg(data.msg, {icon : 1}, 3000);
                            } else {

                                layer.msg(data.msg, {icon : 2}, 3000);
                            }
                        }
                    });
                });
                $("#updateQuartz").click(function () {

                    var cronExpression1 = $("#cronExpression1").val();
                    var cronExpression2 = $("#cronExpression2").val();
                    $.ajax({

                        type : "post",
                        url : "/demo/kettle/updateTriggerInterval.do",
                        data : {
                            "cronExpression1" : cronExpression1,
                            "cronExpression2" : cronExpression2},
                        success : function (data) {

                            var data = JSON.parse(data);
                            if (data.code == 200) {

                                layer.msg(data.msg, {icon : 1}, 3000);
                            } else {

                                layer.msg(data.msg, {icon : 2}, 3000);
                            }
                        }
                    });
                });
            });
        </script>
    </body>
</html>

controller代码：

package com.doart.controller;

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.doart.bean.TestClient1Bean;
import com.doart.bean.TestTodayBean;
import com.doart.service.IKettleService;

/**
 * kettle控制器.
 */
@Controller
@RequestMapping("/kettle")
public class KettleController extends BaseController {

    /**
     * 日志.
     */
    private static Logger log = LoggerFactory.getLogger(KettleController.class);

    /**
     * kettle Service.
     */
    @Autowired
    private IKettleService kettleService;

    /**
     * seconds job名字.
     */
    private String jobName1 = "testSecondsStore";

    /**
     * seconds job 组名.
     */
    private String groupName1 = "group1";

    /**
     * seconds job 触发器名.
     */
    private String triggerName1 = "trigger1";

    /**
     * seconds job cron表达式.
     */
    private String cronExpression1 = "*/20 * * * * ?";

    /**
     * day job 名字.
     */
    private String jobName2 = "testDayStore";

    /**
     * day job 组名.
     */
    private String groupName2 = "group2";

    /**
     * day job 触发器名.
     */
    private String triggerName2 = "trigger2";

    /**
     * day job cron表达式.
     */
    private String cronExpression2 = "0 0 3 * * ? ";

    /**
     * job 参数名.
     */
    private String jobPara = "name";

    /**
     * job 参数值.
     */
    private String jobValue = "doart123";

    /**
     * 分页查询testClinet1数据.
     * @param form form
     * @param response 响应
     */
    @RequestMapping("/getTestClinet1PageBean")
    @ResponseBody
    public void getTestClinet1PageBean(HttpServletResponse response, TestClient1Bean form) {

       try {

           Map<String, Object> map = new HashMap<String, Object>();
           form.setPage((form.getPage() - 1) * form.getLimit());
           List<TestClient1Bean> list = kettleService.getTestClinet1PageBean(form);
           int count = kettleService.getTestClient1Count();
           map.put("code", "0");
           map.put("msg", "查询成功");
           map.put("count", count);
           map.put("data", list);
           respSuccessMsg(response, map, "查询成功");
       } catch (Exception e) {

           String msg = "查询失败" + e.getMessage();
           log.error(msg, e);
           respErrorMsg(response, msg);
       }
    }

    /**
     * 分页查询test_today数据.
     * @param form form
     * @param response 响应
     */
    @RequestMapping("/getTestTodayPageBean")
    private void getTestTodayPageBean(HttpServletResponse response, TestTodayBean form) {

        try {

        Map<String, Object> map = new HashMap<String, Object>();
        form.setPage((form.getPage() - 1) * form.getLimit());
        SimpleDateFormat format = new SimpleDateFormat("yyyyMMdd");
        String date = format.format(new Date());
        form.setTableName("test_" + date);
        List<TestClient1Bean> list = kettleService.getTestTodayPageBean(form);
        int count = kettleService.getTestTodayCount(form);
        map.put("code", "0");
        map.put("msg", "查询成功");
        map.put("count", count);
        map.put("data", list);
        respSuccessMsg(response, map, "查询成功");
        } catch (Exception e) {

            String msg = "查询失败" + e.getMessage();
            log.error(msg, e);
            respErrorMsg(response, msg);
        }
    }

    /**
     * 执行job.
     * @param response 响应
     */
    @RequestMapping("/startJob")
    public void startJob(HttpServletResponse response) {

        try {

            kettleService.runSecondsJob(jobName1, groupName1, triggerName1, cronExpression1, jobPara, jobValue);
            kettleService.runDayJob(jobName2, groupName2, triggerName2, cronExpression2, jobPara, jobValue);
            respSuccessMsg(response, "", "job执行成功");
        } catch (Exception e) {

            String msg = "job执行出现错误:" + e.getMessage();
            log.error(msg, e);
            respErrorMsg(response, msg);
        }
    }

    /**
     * 暂停job.
     * @param response 响应
     */
    @RequestMapping("/pauseJob")
    public void pauseJob(HttpServletResponse response) {

        try {

            kettleService.pauseSecondsTrigger(groupName1, triggerName1);
            kettleService.pauseDayTrigger(groupName2, triggerName2);
            respSuccessMsg(response, "", "job暂停成功");
        } catch (Exception e) {

            String msg = "job暂停出现错误：" + e.getMessage();
            log.error(msg, e);
            respErrorMsg(response, msg);
        }
    }

    /**
     * 恢复job.
     * @param response 响应
     */
    @RequestMapping("/resumeJob")
    public void resumeJob(HttpServletResponse response) {

        try {

            kettleService.resumeSecondsTrigger(groupName1, triggerName1);
            kettleService.resumeDayTrigger(groupName2, triggerName2);
            respSuccessMsg(response, "", "job恢复成功");
        } catch (Exception e) {

            String msg = "job恢复出现错误：" + e.getMessage();
            log.error(msg, e);
            respErrorMsg(response, msg);
        }
    }

    /**
     * 停止seconds job.
     * @param response 响应
     */
    @RequestMapping("/stopJob")
    public void stopJob(HttpServletResponse response) {

        try {

            kettleService.removeSecondsTrigger(groupName1, triggerName1);
            kettleService.removeDayTrigger(groupName2, triggerName2);
            respSuccessMsg(response, "", "job停止成功");
        } catch (Exception e) {

            String msg = "job停止出现错误：" + e.getMessage();
            log.error(msg, e);
            respErrorMsg(response, msg);
        }
    }

    /**
     * 修改 trigger 执行间隔.
     * @param response 响应
     * @param request 请求
     */
    @RequestMapping("/updateTriggerInterval")
    public void updateTriggerInterval(HttpServletResponse response, HttpServletRequest request) {

        String cronExpression1 = request.getParameter("cronExpression1");
        String cronExpression2 = request.getParameter("cronExpression2");
        try {

            if (cronExpression1 != null && cronExpression1 != "") {

                kettleService.updateSecondsTriggerInterval(cronExpression1, groupName1, jobName1, triggerName1);
            }
            if (cronExpression2 != null && cronExpression2 != "") {

                kettleService.updateDayTriggerInterval(cronExpression2, groupName2, jobName2, triggerName2);
            }
            respSuccessMsg(response, "", "修改执行间隔成功");
        } catch (Exception e) {

            String msg = "修改执行间隔出现错误" + e.getMessage();
            log.error(msg, e);
            respErrorMsg(response, msg);
        }
    }
}

service 接口代码 不给了 直接实现类：

package com.doart.service.impl;

import java.util.List;
import java.util.Properties;

import org.quartz.CronScheduleBuilder;
import org.quartz.JobBuilder;
import org.quartz.JobDetail;
import org.quartz.Scheduler;
import org.quartz.SchedulerException;
import org.quartz.Trigger;
import org.quartz.TriggerBuilder;
import org.quartz.TriggerKey;
import org.quartz.impl.StdSchedulerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.doart.bean.TestClient1Bean;
import com.doart.bean.TestTodayBean;
import com.doart.dao.KettleDao;
import com.doart.job.TestDayStoreJob;
import com.doart.job.TestSecondsStoreJob;
import com.doart.service.IKettleService;

/**
 * kettle 实现类.
 */
@Service
public class KettleServiceImpl implements IKettleService {

    /**
     * testSecondsStore job 调度器.
     */
    private Scheduler secondsScheduler;
    /**
     * testDayStore job 调度器.
     */
    private Scheduler dayScheduler;

    /**
     * 构造器.
     * @throws Exception 异常
     */
    public  KettleServiceImpl() throws Exception {

        StdSchedulerFactory sf1 = new StdSchedulerFactory();
        Properties props1 = new Properties();
        props1.put("org.quartz.scheduler.instanceName", "Seconds");
        props1.put("org.quartz.threadPool.threadCount", "10");
        sf1.initialize(props1);
        secondsScheduler = sf1.getScheduler();
        StdSchedulerFactory sf2 = new StdSchedulerFactory();
        Properties props2 = new Properties();
        props2.put("org.quartz.scheduler.instanceName", "Seconds");
        props2.put("org.quartz.threadPool.threadCount", "10");
        sf2.initialize(props2);
        dayScheduler = sf2.getScheduler();
    }

    /**
     * kettle DAO.
     */
    @Autowired
    private KettleDao kettleDao;

    @Override
    public List<TestClient1Bean> getTestClinet1PageBean(TestClient1Bean form) {

        return kettleDao.getTestClinet1PageBean(form);
    }

    @Override
    public int getTestClient1Count() {

        return kettleDao.getTestClient1Count();
    }

    @Override
    public List<TestClient1Bean> getTestTodayPageBean(TestTodayBean form) {

        return kettleDao.getTestTodayPageBean(form);
    }

    @Override
    public int getTestTodayCount(TestTodayBean form) {

        return kettleDao.getTestTodayCount(form);
    }

    @Override
    public void runSecondsJob(String jobName, String groupName, String triggerName, String cronExpression,
        String jobPara, String jobValue) throws SchedulerException {

        JobDetail jobDetail = JobBuilder.newJob(TestSecondsStoreJob.class)
            .withIdentity(jobName, groupName).usingJobData(jobPara, jobValue).build();
        Trigger trigger = TriggerBuilder.newTrigger().withIdentity(triggerName, groupName).startNow()
            .withSchedule(CronScheduleBuilder.cronSchedule(cronExpression)).build();
        secondsScheduler.scheduleJob(jobDetail, trigger);
        secondsScheduler.start();
    }

    @Override
    public void runDayJob(String jobName, String groupName, String triggerName, String cronExpression,
        String jobPara, String jobValue) throws SchedulerException {


        JobDetail jobDetail = JobBuilder.newJob(TestDayStoreJob.class)
            .withIdentity(jobName, groupName).usingJobData(jobPara, jobValue).build();
        Trigger trigger = TriggerBuilder.newTrigger().withIdentity(triggerName, groupName).startNow()
            .withSchedule(CronScheduleBuilder.cronSchedule(cronExpression)).build();
        dayScheduler.scheduleJob(jobDetail, trigger);
        dayScheduler.start();
    }

    @Override
    public void pauseSecondsTrigger(String groupName, String triggerName) throws Exception {

        secondsScheduler.pauseTrigger(new TriggerKey(triggerName, groupName));
    }

    @Override
    public void pauseDayTrigger(String groupName, String triggerName) throws Exception {

        dayScheduler.pauseTrigger(new TriggerKey(triggerName, groupName));
    }

    @Override
    public void resumeSecondsTrigger(String groupName, String triggerName) throws Exception {

        secondsScheduler.resumeTrigger(new TriggerKey(triggerName, groupName));
    }

    @Override
    public void resumeDayTrigger(String groupName, String triggerName) throws Exception {

        dayScheduler.resumeTrigger(new TriggerKey(triggerName, groupName));
    }

    @Override
    public void removeSecondsTrigger(String groupName, String triggerName) throws Exception {

        // 先暂停在移除
        secondsScheduler.pauseTrigger(new TriggerKey(triggerName, groupName));
        secondsScheduler.unscheduleJob(new TriggerKey(triggerName, groupName));
    }

    @Override
    public void removeDayTrigger(String groupName, String triggerName) throws Exception {

        // 先暂停在移除
        dayScheduler.pauseTrigger(new TriggerKey(triggerName, groupName));
        dayScheduler.unscheduleJob(new TriggerKey(triggerName, groupName));
    }

    @Override
    public void updateSecondsTriggerInterval(String cronExpression, String groupName, String jobName,
        String triggerName) throws Exception {

        Trigger trigger = secondsScheduler.getTrigger(new TriggerKey(triggerName, groupName));
        if (trigger != null) {

            removeSecondsTrigger(groupName, triggerName);
            runSecondsJob(jobName, groupName, triggerName, cronExpression, "name", "doart1");
        }
    }

    @Override
    public void updateDayTriggerInterval(String cronExpression, String groupName, String jobName,
        String triggerName) throws Exception {

        Trigger trigger = dayScheduler.getTrigger(new TriggerKey(triggerName, groupName));
        if (trigger != null) {

            removeDayTrigger(groupName, triggerName);
            runDayJob(jobName, groupName, triggerName, cronExpression, "name", "doart2");
        }
    }
}

dao代码：

package com.doart.dao;

import java.util.List;

import com.doart.bean.TestClient1Bean;
import com.doart.bean.TestTodayBean;

/**
 * kettle DAO.
 */
public interface KettleDao {

    /**
     * 获取testClient1数据.
     * @param form form
     * @return testClient1数据集合
     */
    List<TestClient1Bean> getTestClinet1PageBean(TestClient1Bean form);

    /**
     * 获取testClint1数量.
     * @return 数量
     */
    int getTestClient1Count();

    /**
     * 获取testToday数据.
     * @param form form
     * @return testToday数据集合
     */
    List<TestClient1Bean> getTestTodayPageBean(TestTodayBean form);

    /**
     * 获取testToday数量.
     * @param form form
     * @return testToday数量
     */
    int getTestTodayCount(TestTodayBean form);
}

mapper映射文件：

<?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.doart.dao.KettleDao">
    <select id="getTestClinet1PageBean" resultType="com.doart.bean.TestClient1Bean" parameterType="com.doart.bean.TestClient1Bean">
        select id, user_id, user_name from test_client_1
        <if test = "page !=null and limit != null">
            limit #{page}, #{limit}
        </if>
    </select>
    <select id="getTestClient1Count" resultType="int" parameterType="com.doart.bean.TestClient1Bean">
        select count(*) from test_client_1
    </select>
        <select id="getTestTodayPageBean" resultType="com.doart.bean.TestClient1Bean" parameterType="com.doart.bean.TestTodayBean">
        select id, user_id, user_name from ${tableName}
        <if test = "page !=null and limit != null">
            limit #{page}, #{limit}
        </if>
    </select>
    <select id="getTestTodayCount" resultType="int" parameterType="com.doart.bean.TestTodayBean">
        select count(*) from ${tableName}
    </select>
</mapper>

 

叫我小艾就好啦
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 3
    评论
专栏目录
使用maven搭建的ssm框架
09-09
通过以上步骤，我们就成功地使用Maven搭建了一个基本的SSM框架项目。当然，实际项目中还需要考虑异常处理、安全控制、国际化、日志管理等多个方面，这些都可以通过引入相应的Spring或第三方库来实现。总的来说，SSM...
定时任务之kettle设计器使用之一（quartz）
qq_36688928的博客
05-30 331
转自：https://blog.csdn.net/weixin_41446894/article/details/83030250 今天在写定时任务job的问题，涉及到了kettle 就是所谓的数据设计器 帮助我们进行数据转换，数据清洗。 话不多说 简要上一个教程 教大家使用kettle 我这个是我们公司自己设计的 设计器是一款ETL工具，纯java编写，可以在Windows、Li...
Java调Kettle插件报找不到plugin missing
最新发布
qq_35989920的博客
04-16 1342
java调用kettle出现Can't run transformation due to plugin missing。此方法可解决Mongodb等其他插件缺失错误。
这是一篇有深度的文章，没研究过kettle源码是看不懂的
Huangjiazhen711的博客
10-23 1305
直接上干货。
Maven中央仓库地址大全
热门推荐
yygr的博客
11-29 6万+
一、一般使用中央仓库地址1（本人推荐仓库）3关于Maven远程仓库地址的配置方式有两种：第1种：直接在项目的pom.文件中进行修改（不推荐，尤其是在多人协助的开发过程中非常的费事费力）；第2种：将Maven的远程仓库统一的配置到Maven的的配置文件中。二、Maven中央仓库地址大全1、阿里中央仓库（首选推荐）2、中央仓库（第2推荐使用）
quartz + kettle8二次开发-实现集群高可用
天地炫舞的博客
07-31 4905
quartz+kettle8二次开发-实现集群高可用quartz+kettle8二次开发-实现集群高可用 quartz+kettle8二次开发-实现集群高可用
初学者配置maven及使用SSM框架创建maven项目
08-22
这是一个压缩包。这是一个maven项目，使用Java语言开发的web工程，使用了SpringMVC+Spring+Mybatis，建议初学者入手。
java使用idea搭建ssm+maven框架项目，单model，精简配置
09-09
最近跟着Gerry老师学习了使用idea搭建ssm+maven框架项目，学完后才发现以前自己使用eclipse搭建的ssm+maven框架有多么乱，至于配置等等更不用说，大都不怎么理解，只知道在网上百度复制粘贴，至于为啥这么配不知道，...
SSM+Maven整合.zip_SSM框架_SSM框架实例_maven_maven SSM_ssm
09-21
ssm+maven整合实例，这是一个简单的实例，可以发布对于ssm框架与maven工具使用。
基于maven的ssm框架整合的示例代码
08-28
本篇文章将详细讲解基于Maven的SSM框架整合过程，旨在帮助开发者理解和实践。 1. **Spring框架** Spring是一个开源的轻量级Java开发框架，它主要解决企业应用开发的复杂性，通过控制反转（IoC）和面向切面（AOP）...
Kettle运行jar及其mvn脚本及配置文件.rar
05-14
本下载包包括kettle集成java时候所需要的基本jar包以及将jar包打入本地仓库的脚本
Maven 构建 Kettle 时所需的部分jar包
10-20
Maven 构建 Kettle 时所需的部分jar包，具体构建操作请参考 http://blog.csdn.net/dongyuan234/article/details/78293699
kettle定时任务
09-14
kettle定时任务 数据抽取
sping4.2.5 springmvc4.2.5 mybatis3.4框架(SSM)的maven web项目,整合了log4j redis quartz
05-06
本人搭建的ssm框架的maven web项目,用maven管理项目的jar包,项目架构搭好,用的都是现阶段最新的jar包,整合了log4j日志,redis缓存,quartz定时任务,全局配置文件在代码中使用等,controller层/service层/bo层/dao层都整合好,测试通过,可以直接用作项目开发
spring+quartz+maven项目实例
12-19
本代码是定时器的实例，两种运行模式，一种是直接以Java程序的形式运行，指定加载的配置文件；另一种是在tomcat下运行
Kettle学习（一）：下载编译与部署（9.4.0.0版本）
好好学习天天向上
04-25 2539
一、下载 https://github.com/pentaho/pentaho-kettle 二、安装 一.编译环境 Maven, version 3+ Java JDK 11 Maven配置 <?xml version="1.0" encoding="UTF-8"?> <settings xmlns="http://maven.apache.org/SETTINGS/1.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-insta
kettle执行job流程分析
u013257767的博客
09-08 1615
文章目录调试代码 调试 kettle调试远程执行的作业 代码 在远程调用使用carte服务的时候，使用比较多的2个工具类：Trans,Job 下面看一下经常用的Job的远程调用方法： public static String sendToSlaveServer( JobMeta jobMeta, JobExecutionConfiguration executionConfiguration, Repository repository, IMetaStore metaStore ) throw
kettle整合到web项目并运用quartz实现定时任务
live_xian的专栏
08-02 1万+
目前正在做的项目需要用将主业务库的部分数据同步出去以作统计用，为了保持数据实时同步需要定时执行同步操作。 同步工具运用了比较流行的ETL工具kettle，首先我们在kettle界面工具Spoon中设计好同步文件如 studentTableETL.ktr，然后在web项目通过quartz定时调用studentTableETL.ktr即可。 1、以下是pom.xml中的依赖包
SSM框架Maven项目搭建与配置指南
"本资源主要介绍了如何创建一个基于SSM框架的Maven项目，并详细讲述了在Eclipse环境下配置和修改项目设置的过程，包括调整Maven的JRE编译版本、解决项目错误、设置Tomcat服务器、修改web.xml版本以及处理项目模板...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值