Monday, 17 June 2019

batch insert get insert id.

https://stackoverflow.com/questions/4224228/preparedstatement-with-statement-return-generated-keys


PreparedStatement preparedStatement = connection.prepareStatement(YOUR_SQL_HERE, PreparedStatement.RETURN_GENERATED_KEYS);
preparedStatement.setXXX(index, VALUE);
preparedStatement.executeUpdate();

ResultSet rs = preparedStatement.getGeneratedKeys();

if (rs.next()) {
    key = rs.getLong(1);
}


ps = connection.prepareStatement(sql, ps.RETURN_GENERATED_KEYS);

Thursday, 13 June 2019

Java curl call

    public static String sendJAVARequest(String method, String javaApiPath, String requestBody, String sessionToken) {
        //String javaBasePath = "http://34.214.14.50:8484/adminservices/service/";
        String javaBasePath = System.getenv("JAVA_API_BASEURL");
        String responseOfRequest = "";
        try {
            URL url = new URL(javaBasePath + javaApiPath);
            HttpURLConnection conn = (HttpURLConnection) url.openConnection();
            conn.setRequestMethod(method);
            conn.setDoOutput(true);
            conn.setRequestProperty("Content-Type", "application/json");
            conn.setRequestProperty("session-token", sessionToken);
            String input = requestBody;
            OutputStream os = conn.getOutputStream();
            os.write(input.getBytes());
            os.flush();
            BufferedReader br = new BufferedReader(new InputStreamReader((conn.getInputStream())));
            String output;
            System.out.println("Output from Server .... \n");
            while ((output = br.readLine()) != null) {
                responseOfRequest += output;
                System.out.println(output);
            }
            conn.disconnect();
        } catch (Exception ex) {
            ex.printStackTrace();
            Sentry.capture(ex);
        }
        return responseOfRequest;
    }

Java calander implementation

import java.util.*;
public class Main {
    public static void main(String args[])
    {
        TimeZone time_zone
            = TimeZone.getTimeZone("Pacific/Tahiti");
        Calendar calendar = Calendar.getInstance();
        calendar.setTimeZone(time_zone);
        System.out.println("Modified Zone: "
                           + calendar.getTimeZone()
.getDisplayName());
        System.out.println("The Current Date is:" + calendar.getTime());
        System.out.println("Current Calendar's Year: " + calendar.get(Calendar.YEAR));
        System.out.println("Current Calendar's Day: " + calendar.get(Calendar.DATE));
        System.out.println("Current MINUTE: " + calendar.get(Calendar.MINUTE));
        System.out.println("Current SECOND: " + calendar.get(Calendar.SECOND));
        calendar.add(Calendar.DATE, -15);
        System.out.println("15 days ago: " + calendar.getTime());

    }
}