Skip to content

Instantly share code, notes, and snippets.

View dungdm93's full-sized avatar
🏁
Working hard

Đặng Minh Dũng dungdm93

🏁
Working hard
  • VPBank
  • Hanoi, Vietnam
  • Facebook dungdm93
View GitHub Profile
@dungdm93
dungdm93 / ER diagram.png
Last active December 28, 2015 03:11
[Java] [JPA] Map @OneToMany, @manytoone example
ER diagram.png
@dungdm93
dungdm93 / gist:62c36ca0bfab7749cbad
Last active September 20, 2021 14:43
[Java] [JPA] @mapkey example
We couldn’t find that file to show.
@dungdm93
dungdm93 / @Inheritance.jpg
Last active August 26, 2015 07:20
[Java] [JPA] @Inheritance example
@Inheritance.jpg
@dungdm93
dungdm93 / Parameters.java
Created August 28, 2015 08:41
[Java] [JPA] [JPQL] Parameters example
// JPA defines named parameters, and positional parameters.
// Named parameters can be specified in JPQL using the syntax :<name>.
Query query = em.createQuery("SELECT e FROM Employee e WHERE e.firstName = :first and e.lastName = :last");
query.setParameter("first", "Bob");
query.setParameter("last", "Smith");
List<Employee> list = query.getResultList();
// Positional parameters can be specified in JPQL using the syntax ? or ?<position>.
// Positional parameters start at position 1 not 0.
@dungdm93
dungdm93 / EclipseLink.out
Last active August 31, 2015 02:24
[Java][JPA] Field vs. Property Access
@dungdm93
dungdm93 / User.java
Last active August 30, 2015 05:10
[Java][JPA] LOB example
import javax.persistence.*;
@Entity
public class User {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
private String name;
@Lob
private String avatar;
@dungdm93
dungdm93 / Console.txt
Last active August 30, 2015 06:02
[Java][JPA] Listener & Callback example
[EL Info]: connection: 2015-08-30 12:52:11.554--ServerSession(1286783232)--/file:/C:/Users/KiT/IdeaProjects/Database Sample/service/target/classes/_pu login successful
Employee.prePersist
[EL Fine]: sql: 2015-08-30 12:52:11.635--ClientSession(1437983537)--Connection(1614079837)--INSERT INTO EMPLOYEE (NAME, SALARY) VALUES (?, ?)
bind => [2 parameters bound]
[EL Fine]: sql: 2015-08-30 12:52:11.637--ClientSession(1437983537)--Connection(1614079837)--SELECT LAST_INSERT_ID()
Employee.postPersist
========================================
[EL Fine]: sql: 2015-08-30 12:52:11.729--ServerSession(1286783232)--Connection(1614079837)--SELECT ID, NAME, SALARY FROM EMPLOYEE WHERE (ID = ?)
bind => [1 parameter bound]
Employee.postLoad
@dungdm93
dungdm93 / Company.java
Created August 31, 2015 08:15
[Java][JPA] xml vs. annotation models mapping
package com.gem.demo.database.model;
public class Company {
public int id;
public String name;
public String address;
...
@Override
@dungdm93
dungdm93 / ConstructorReferenceDemo.java
Created September 1, 2015 08:22
[Java 8] Constructor Reference example
interface NoArgConstructor<T> {
T foo();
}
interface ArgConstructor<T, U> {
T bar(U arg);
}
interface MultiArgsConstructor<T, U> {
T magic(U... arg);
@dungdm93
dungdm93 / Model.java
Created November 5, 2015 08:13
[Java][JPA][Hibernate] UUID & Hibernate
@Entity
public class Employee extends AbstractBaseEntity {
// Approach 1:
// @Id
// public String id;
// Approach 2:
@Id
// default column type is byte array
@Type(type = "org.hibernate.type.PostgresUUIDType") // or type = "pg-uuid"