Guest User

Untitled

a guest
Apr 7th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. spring.datasource.driver-class-name=com.mysql.jdbc.Driver
  2. spring.datasource.url=jdbc:mysql://xx.xx.xx.xx:3306/dbA?useSSL=false
  3. spring.datasource.username=username
  4. spring.datasource.password=password
  5.  
  6. spring.jpa.hibernate.ddl-auto=update
  7. spring.jpa.show-sql=true
  8. spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
  9.  
  10. spring.DSB.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
  11.  
  12. # Enable to auto identify each datasource
  13. spring.jpa.database=default
  14.  
  15. import java.util.List;
  16.  
  17. import javax.persistence.EntityManager;
  18. import javax.persistence.PersistenceContext;
  19.  
  20. import org.springframework.stereotype.Repository;
  21.  
  22. @Repository
  23. public class ClassDaoDSA {
  24.  
  25. @PersistenceContext
  26. private EntityManager manager;
  27.  
  28. public List<T> Records() {
  29.  
  30. String stmt = "SELECT d FROM Data d ORDER BY d.id DESC";
  31.  
  32. return manager.createQuery(stmt).getResultList();
  33. }
  34.  
  35. }
Add Comment
Please, Sign In to add comment