Advertisement
Guest User

Untitled

a guest
Mar 31st, 2016
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.88 KB | None | 0 0
  1. public List<Posts> connect() throws UnsupportedEncodingException {
  2. EntityManager em=EntityManagerUtil.getEntityManagerFactory().createEntityManager();
  3. Query q=em.createQuery("Select p from Posts p");
  4. result=q.getResultList();
  5. return result;
  6. }
  7.  
  8. <properties>
  9. <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/temp"/>
  10. <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
  11. <property name="hibernate.connection.username" value="user"/>
  12. <property name="hibernate.connection.password" value="user03022016"/>
  13. <property name="hibernate.archive.autodetection" value="class"/>
  14. <property name="hibernate.show_sql" value="true"/>
  15. <property name="hibernate.format_sql" value="true"/>
  16. <property name="hbm2ddl.auto" value="update"/>
  17. </properties>
  18. </persistence-unit>
  19.  
  20. <bean id="entityManagerFactory"
  21. class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
  22. <property name="dataSource" ref="dataSource" />
  23. <property name="packagesToScan" value="com.khodan.caferacer.model" />
  24. <property name="jpaVendorAdapter" ref="jpaVendorAdapter" />
  25. </bean>
  26.  
  27. <bean id="dataSource"
  28. class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  29. <property name="driverClassName" value="org.postgresql.Driver" />
  30. <property name="url" value="jdbc:postgresql://localhost:5433/caferacer" />
  31. <property name="username" value="root" />
  32. <property name="password" value="root" />
  33. </bean>
  34.  
  35. <bean id="jpaVendorAdapter"
  36. class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
  37. <property name="database" value="POSTGRESQL" />
  38. <property name="databasePlatform" value="org.hibernate.dialect.PostgreSQLDialect" />
  39. <property name="showSql" value="true" />
  40. <property name="generateDdl" value="false" />
  41. </bean>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement