springjpa连接postgre

来源：互联网发布：linux下串口调试编辑：程序博客网时间：2024/06/05 04:38

1 xml配置文件

首先，在src/main/resources下，建立applicationContext.xml

内容如下：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:jpa="http://www.springframework.org/schema/data/jpa"
       xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/data/jpa
       http://www.springframework.org/schema/data/jpa/spring-jpa.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd
       http://www.springframework.org/schema/tx
       http://www.springframework.org/schema/tx/spring-tx.xsd">
    

    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="org.postgresql.Driver"/>
          <property name="url" value="jdbc:postgresql://localhost:5432/dataBase1"/>
          <property name="username" value="postgres"/>
          <property name="password" value="1234567"/>
    </bean>


    <context:component-scan base-package="cn.dev.sync.core"/>
    <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <property name="persistenceUnitName" value="spring"></property>
        <property name="dataSource" ref="dataSource"></property>
        <property name="packagesToScan" value="cn.dev.sync.core.domain"></property>
        <property name="persistenceProviderClass" value="org.hibernate.jpa.HibernatePersistenceProvider"></property>
        <property name="jpaVendorAdapter">
            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
                
                <property name="generateDdl" value="false"/>
                <property name="database" value="POSTGRESQL"/>
                <property name="showSql" value="true"/>
            </bean>
        </property>
    </bean>

    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManagerFactory"></property>
    </bean>
    <tx:annotation-driven transaction-manager="transactionManager"/>
    <jpa:repositories base-package="cn.dev.sync.core.util"
                      query-lookup-strategy = "use-declared-query"
                      entity-manager-factory-ref="entityManagerFactory"
                      transaction-manager-ref="transactionManager"
            />
</beans>

2 model类

其中：cn.dev.sync.core.domain包中存放了，具体的Modle类型。

如用户：User

package cn.dev.sync.core.domain;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "v_user")       //liferay实体中User用户
public class User {

   public User() {
       super();
   }


   @Id                                //一定有有主键
   @Column(name="uid")
   private String uid;

   @Column(name="email")
   private String email;


   public String getUid() {
       return uid;
   }

   public void setUid(String uid) {
       this.uid = uid;
   }

   public String getEmail() {
       return email;
   }

   public void setEmail(String email) {
       this.email = email;
   }


}

3 测试类

package cn.dev.sync.core.test;

import java.util.List;

import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import cn.dev.sync.core.domain.User;
import cn.dev.sync.core.service.UserService;

@RunWith(SpringJUnit4ClassRunner.class) //使用junit4进行测试
@ContextConfiguration ({"/applicationContextLiferay.xml"})
public class LiferayTest {

   @Autowired
   private UserService userService ;

   @org.junit.Test
   public void search(){
       List<User> userList = userService.searchAll();
       for(int i=0;i<100;i++){
           System.out.println(userList.get(i).getUid()+"-----");
       }
       System.out.println(userList.size()+"---------userList size-----------");
   }
}

4 其他文件

UserService和UserDao

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.dev.sync.core.domain.User;
import cn.dev.sync.core.util.UserDao;

@Service
public class UserService{
   @Autowired
   private UserDao userDao;

   public List<User> searchAll() {
       return (List<User>)userDao.findAll();
   }
}

UserDao文件：

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;

import org.springframework.data.repository.PagingAndSortingRepository;

import cn.dev.sync.core.domain.User;

public interface UserDao extends PagingAndSortingRepository<User, Integer>,JpaSpecificationExecutor<User>
{

}

阅读全文

1 0