IDE:IntelliJ IDEA 2018.3.1
项目结构
SftpConfig 配置类
package com.czx.scheduleddownloadcsv.entity;
import lombok.Data;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.stereotype.Component;
@Component
@ConfigurationProperties(prefix = "sftp")
@Data
public class SftpConfig {
//ip
private String host;
//端口
private int port;
//连接sftp用户名
private String username;
//连接sftp密码
private String password;
//存放文件目录
private String dir;
//sftp 中文件名前缀
private String fileNamePrefix;
//从sftp 下载文件保存位置
private String savePath;
}
user 用户实体类
package com.czx.scheduleddownloadcsv.entity;
import lombok.Data;
@Data
public class User {
private int id;
private String name;
private int age;
private String city;
}
UserMapper
package com.czx.scheduleddownloadcsv.mapper;
import com.czx.scheduleddownloadcsv.entity.User;
import org.apache.ibatis.annotations.Insert;
import java.util.List;
public interface UserMapper {
@Insert({
"<script>",
"insert into t_user(name, age, city) values ",
"<foreach collection='list' item='item' index='index' separator=','>",
"(#{item.name}, #{item.age}, #{item.city})",
"</foreach>",
"</script>"
})
void addUser(List<Us