Java Creativity

Search This Blog

Broadband software demo

on May 01, 2018

Get link
Facebook
X
Pinterest
Email
Other Apps

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Hibernate Composite Primary Key Example with Spring Boot

how to map a composite primary key in Hibernate using jPA’s @Embeddable and @EmbeddedId annotations. Let’s say that We have an application that manages Employees of various companies. Every employee has a unique employeeId within his company. But the same employeeId can be present in other companies as well, So we can not uniquely identity an employee just by his employeeId. To identify an employee uniquely, we need to know his employeeId and companyId both. Check out the following Employees table that contains a composite primary key which includes both the employeeId and companyId columns - Let’s create a project from scratch and learn how to map such composite primary key using JPA and Hibernate. Creating the Project You can generate the project quickly using Spring Boot CLI by typing the following command in the terminal - spring init -n = jpa-composite-primary-key-demo -d = web,jpa,mysql --package-name = com.example.jpa jpa-c...

Absolute Difference Between Any Two elements of An Array

import java.util.Arrays; public class diffBWtwoElements { public static void main(String[] args ) { // TODO Auto-generated method stub int a [] = { 5, -3, 7, -2 }; Arrays. sort ( a ); int diff = Integer. MAX_VALUE ; for ( int i = 0; i < a . length - 1; i ++) { if ( a [ i + 1] - a [ i ] < diff ) { diff = a [ i + 1] - a [ i ]; } } System. out .println( diff ); } }

date and time diff

select * from ( SELECT SHIFT_START_DATE,SHIFT_START_TIME,SHIFT_END_DATE,SHIFT_END_TIME, (TO_NUMBER( SUBSTR(NUMTODSINTERVAL(TO_DATE(SHIFT_END_DATE || ' ' || SHIFT_END_TIME , 'DD/MM/YY HH24:MI:SS') - TO_DATE(SHIFT_START_DATE || ' ' || SHIFT_START_TIME, 'DD/MM/YY HH24:MI:SS'), 'DAY'), 02, 9)) * 24) + (TO_NUMBER( SUBSTR(NUMTODSINTERVAL(TO_DATE(SHIFT_END_DATE || ' ' || SHIFT_END_TIME , 'DD/MM/YY HH24:MI:SS') - TO_DATE(SHIFT_START_DATE || ' ' || SHIFT_START_TIME, 'DD/MM/YY HH24:MI:SS'), 'DAY'), 12, 2))) || SUBSTR(NUMTODSINTERVAL(TO_DATE(SHIFT_END_DATE || ' ' || SHIFT_END_TIME , 'DD/MM/YY HH24:MI:SS') - TO_DATE(SHIFT_START_DATE || ' ' || SHIFT_START_TIME, 'DD/MM/YY HH24:MI:SS'), 'DAY'), 14, 6) AS dateDiff FROM SM_EMPLOYEE_SCHEDULES s WHERE PRS_ID = '219733' AND trunc(SHIFT_START_DATE) >= TO_DATE('14-08-2019', 'dd-MM-yy...

Powered by Blogger

Pavan kumar

Broadband software demo

Comments

Post a Comment