JAVA_LandaryEKP（蓝凌）_OA_定时任务创建教程_蓝凌ekp如何创建任务

1. 软件环境

Windows10

JDK1.8

Tomcat8.0

Eclipse2017

---

2.代码实现步骤

---

1. spring.xml ，Bean注入

2. design.xml ，定时任务配置

<quartz

messageKey=“cee-attendance:bank.bankinfo”

jobService=“ceeAttendanceMainBankInfoJobService”

jobMethod=“doBankInfo”

cronExpression=“0 0 * * * ?”

enable=“true”

description=“cee-attendance:bank.bankinfoDescription”/>

3. JAVA 业务逻辑实现

com.landray.kmss.cee.attendance.service.spring.CeeAttendanceMainBankInfoJobServiceImp

4 文本国际化

/ekp_dev/src/com/landray/kmss/cee/attendance/ApplicationResources.properties

cee-attendance:bank.bankinfo

cee-attendance:bank.bankinfoDescription

5 主要数据表

hr_staff_emolument_welfare

hr_staff_person_info

---

package com.landray.kmss.cee.attendance.service.spring;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.sql.DataSource;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.landray.kmss.cee.sapcall.util.GetSapConn;
import com.landray.kmss.sys.quartz.interfaces.SysQuartzJobContext;
import com.landray.kmss.util.SpringBeanUtil;
import com.sap.conn.jco.JCoDestination;
import com.sap.conn.jco.JCoException;
import com.sap.conn.jco.JCoFunction;
import com.sap.conn.jco.JCoStructure;

/**
 * @author Terry 
 * 员工信息同步SAP
 */

public class CeeAttendanceMainBankInfoJobServiceImp {
	 private static final Log logger = LogFactory.getLog(CeeAttendanceMainBankInfoJobServiceImp.class);
	 public void doBankInfo(SysQuartzJobContext context) throws Exception {
		 
		 Map<String,String> map          = null;
		 Map<String,String> sapReturnMap = null;
		 
		 List<Map<String,String>> list   = getBankInfo();
		  
		 if(list != null && list.size() > 0 ) {
			 for(int i = 0 ;i < list.size() ; i++) {
				 map          = list.get(i);
				 sapReturnMap = doTosap(map);
				 save(sapReturnMap);
			 }
		 }
		 
	 }


	private List<Map<String, String>> getBankInfo() throws Exception {
		
		DataSource dataSource = (DataSource) SpringBeanUtil.getBean("dataSource");


### 最后

光给面试题不给答案不是我的风格。这里面的面试题也只是凤毛麟角，还有答案的话会极大的**增加文章的篇幅**，减少文章的可读性

# Java面试宝典2021版

![](https://img-blog.csdnimg.cn/img_convert/63060ad1045c5eba31f59f2ab57535c0.webp?x-oss-process=image/format,png)

![](https://img-blog.csdnimg.cn/img_convert/7c31ab02991635bc134cc5e48b2bd7ca.webp?x-oss-process=image/format,png)

# 最常见Java面试题解析（2021最新版）

![](https://img-blog.csdnimg.cn/img_convert/6fbafc817ecefaeb08d587cd71fa5104.webp?x-oss-process=image/format,png)

![](https://img-blog.csdnimg.cn/img_convert/6832aeaf726c9fc875d5e27c9e5affd7.webp?x-oss-process=image/format,png)

# 2021企业Java面试题精选

![](https://img-blog.csdnimg.cn/img_convert/4f982bd720f715600c89a88ee9e662bb.webp?x-oss-process=image/format,png)

![](https://img-blog.csdnimg.cn/img_convert/b1080b41cfe745247d2f945b3b66574a.webp?x-oss-process=image/format,png)


加入社区：https://bbs.csdn.net/forums/4304bb5a486d4c3ab8389e65ecb71ac0

# 2021企业Java面试题精选

[外链图片转存中...(img-R8sBLOvu-1725650348700)]

[外链图片转存中...(img-bvrcDe1f-1725650348701)]


加入社区：https://bbs.csdn.net/forums/4304bb5a486d4c3ab8389e65ecb71ac0