mysql - 从表中读取数据编辑并保存到另一个表中

Question

在我的系统中，我已从 checkin 表中读取数据(该表是从不同的网络系统创建的，我必须为我的系统更改一些数据)编辑这些详细信息并将结果列表作为列表。现在我想将这些检索到的详细信息保存在记录表中。有人可以帮我吗？非常感谢。

记录表(id,user_id,日期,时间)

Controller

@RequestMapping("/records")
    public String read(Model model) throws ParseException {
        System.out.println("hey");
        List<CheckInOut> recordDetails= checkInOutDAO.findAll();
        //System.out.println(recordDetails.toString());

        CheckInOut[] arr = new CheckInOut[recordDetails.size()];
       for(int i = 0 ; i < recordDetails.size(); i++) {
            //System.out.println(recordDetails.get(i).getUserid());
            arr[i]=recordDetails.get(i);
        }

//result list
List<Records> recordsList= DateToDayConvert.main(arr);



        model.addAttribute("records",recordsList);
        return "records";
    }

DAO

 public Records save(Records records){
        return recordsRepository.save(records);
    }

型号

@Entity
@Table(name="records")
@EntityListeners(AuditingEntityListener.class)

public class Records {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;
    private int userid;
    private String day;
    private int time;


    public Records() {
    }

    public Records(int userid, String day, int time) {
        this.userid = userid;
        this.day = day;
        this.time = time;
    }

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public int getUserid() {
        return userid;
    }

    public void setUserid(int userid) {
        this.userid = userid;
    }

    public String getDay() {
        return day;
    }

    public void setDay(String day) {
        this.day = day;
    }

    public int getTime() {
        return time;
    }

    public void setTime(int time) {
        this.time = time;
    }

}

Answer 1

您可以一次保存所有记录，而不是为每条记录调用保存。

DOA

public Records save(Records records){
  return recordsRepository.save(records);
}

public List<Records> save(List<Records> records){
  return recordsRepository.save(records);
}

现在您可以在单个数据库调用中保存所有记录。