Thursday, 27 June 2019
Wednesday, 26 June 2019
Thursday, 20 June 2019
Monday, 17 June 2019
batch insert get insert id.
https://stackoverflow.com/questions/4224228/preparedstatement-with-statement-return-generated-keys
ps = connection.prepareStatement(sql, ps.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;
}
//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());
}
}