/*
|
* Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license
|
* Click nbfs://nbhost/SystemFileSystem/Templates/Classes/Class.java to edit this template
|
*/
|
package com.megatim.fdxcommons.tools.database.queries;
|
|
import java.sql.Connection;
|
import java.sql.PreparedStatement;
|
import java.sql.SQLException;
|
import java.sql.Timestamp;
|
import java.time.LocalDateTime;
|
|
/**
|
*
|
* @author ASUS
|
*/
|
public class EchecIntegrationQueries {
|
|
private final Connection connection;
|
private final Long dataProductionId;
|
|
public EchecIntegrationQueries(Connection connection, Long dataProductionId) {
|
this.connection = connection;
|
this.dataProductionId = dataProductionId;
|
}
|
|
public void save() throws SQLException {
|
String query = "INSERT INTO ECHECINTEGRATION (dataproductionid, datecreation) values(?,?)";
|
|
try ( PreparedStatement statement = connection.prepareStatement(query)) {
|
statement.setLong(1, dataProductionId);
|
statement.setTimestamp(2, Timestamp.valueOf(LocalDateTime.now()));
|
|
statement.executeUpdate();
|
}
|
}
|
}
|
