Skip to content

Instantly share code, notes, and snippets.

View Nanra's full-sized avatar
:octocat:
Code & Learn Day by Day 😃

Nanra Sukedy Nanra

:octocat:
Code & Learn Day by Day 😃
View GitHub Profile
$(document).off("click", "#btn-save");
$(document).on("click", "#btn-save", function(e) {
let idEmployee = $("#form-employee #idEmployee").val();
console.log("Isi Id Employee : " + idEmployee);
if (idEmployee === "" || idEmployee === null) {
console.log("onSave()");
public ResponseSave insertEmployee(Employee dataForSave) {
// Calling Stored Procedure To Get All User List
JdbcHelper helper = new JdbcHelper();
simpleJdbcCall = helper.useTemplate(this.jdbcTemplate)
.spName("SP_EMPLOYEE_INSERT")
.mapTo(ResponseSave.class)
.outParameter(InformationConstant.REF_CURSOR_RECORDSET)
.build();
<!DOCTYPE html>
<html lang="en" xmlns="http://www.w3.org/1999/xhtml" xmlns:th="http://www.thymeleaf.org">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="../static/css/bootstrap.css" rel="stylesheet" th:href="@{/css/bootstrap.css}"/>
<link href="../static/custom-css/login-page.css" rel="stylesheet" th:href="@{/custom-css/login-page.css}"/>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<script src="../static/js/bootstrap.js" th:href="@{/js/bootstrap.js}"></script>
<!DOCTYPE html>
<html lang="en" xmlns="http://www.w3.org/1999/xhtml" xmlns:th="http://www.thymeleaf.org">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
# ==================================================================================================================== #
# TEMPLATING PROPERTIES
# ==================================================================================================================== #
spring.thymeleaf.enabled=true
spring.thymeleaf.prefix=classpath:/templates/
spring.thymeleaf.suffix=.html
spring.thymeleaf.mode=HTML
spring.thymeleaf.encoding=UTF-8
spring.thymeleaf.servlet.content-type=text/html
spring.thymeleaf.cache=false
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<link rel="icon" type="image/png" sizes="16x16" href="/plugins/images/favicon.png">
<!-- Bootstrap Core CSS -->
<link href="bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
<!-- Menu CSS -->
<link href="/plugins/bower_components/sidebar-nav/dist/sidebar-nav.min.css" rel="stylesheet">
@Nanra
Nanra / pom.xml
Last active August 10, 2020 06:47
<!-- Oracle JDBC Driver compatible with JDK8, JDK9, and JDK11 -->
<!-- https://mvnrepository.com/artifact/com.oracle.ojdbc/ojdbc8 -->
<dependency>
<groupId>com.oracle.ojdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>19.3.0.0</version>
<scope>runtime</scope>
</dependency>
<!-- Starter for using JDBC with the HikariCP connection pool -->
@Nanra
Nanra / Share-Link.txt
Created August 3, 2020 02:51
Share Link For Requirements
CREATE OR REPLACE procedure GRIFES.SP_PRODUCT_PLAN_SETUP_LIST(
P_ID PRODUCT_PLAN_SETUP.ID%TYPE,
P_PRODUCTNUMBER PRODUCT_PLAN_SETUP.PRODUCT_NUMBER%TYPE,
P_PLANCODE PRODUCT_PLAN_SETUP.PLAN_CODE%TYPE,
p_recordset OUT SYS_REFCURSOR)
IS
BEGIN
OPEN p_recordset FOR
SELECT
*
CREATE OR REPLACE procedure GRIFES.SP_PRODUCT_AGE_LIMIT_LIST(
P_ID PRODUCT_AGE_SETUP.ID%TYPE,
P_PRODUCTNUMBER PRODUCT_AGE_SETUP.PRODUCTNUMBER%TYPE,
P_EFFECTIVEDATE PRODUCT_AGE_SETUP.EFFECTIVE_DATE%TYPE,
p_recordset OUT SYS_REFCURSOR)
IS
BEGIN
OPEN p_recordset FOR
SELECT "pas".*, "p".PRODUCTNAME AS ProductName
FROM PRODUCT_AGE_SETUP "pas" LEFT OUTER JOIN PRODUCT "p" ON "pas".PRODUCTNUMBER = "p".PRODUCTNUMBER