JPA--SpringData JPA环境搭建及简单操作

雨点打透心脏的1/2处 2021-08-13 22:53 371阅读 0赞

### 创建工程并导入依赖 ###

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>pers.zhang</groupId>
        <artifactId>spirngdata_jpa</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        <properties>
            <spring.version>4.2.4.RELEASE</spring.version>
            <hibernate.version>5.0.7.Final</hibernate.version>
            <slf4j.version>1.6.6</slf4j.version>
            <log4j.version>1.2.12</log4j.version>
            <c3p0.version>0.9.1.2</c3p0.version>
            <mysql.version>5.1.6</mysql.version>
        </properties>
    
        <dependencies>
            
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.9</version>
                <scope>test</scope>
            </dependency>
    
            
            <dependency>
                <groupId>org.aspectj</groupId>
                <artifactId>aspectjweaver</artifactId>
                <version>1.6.8</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aop</artifactId>
                <version>${spring.version}</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>${spring.version}</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context-support</artifactId>
                <version>${spring.version}</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-orm</artifactId>
                <version>${spring.version}</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-beans</artifactId>
                <version>${spring.version}</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-core</artifactId>
                <version>${spring.version}</version>
            </dependency>
    
            
    
            
            <dependency>
                <groupId>org.hibernate</groupId>
                <artifactId>hibernate-core</artifactId>
                <version>${hibernate.version}</version>
            </dependency>
            <dependency>
                <groupId>org.hibernate</groupId>
                <artifactId>hibernate-entitymanager</artifactId>
                <version>${hibernate.version}</version>
            </dependency>
            <dependency>
                <groupId>org.hibernate</groupId>
                <artifactId>hibernate-validator</artifactId>
                <version>5.2.1.Final</version>
            </dependency>
            
    
            
            <dependency>
                <groupId>c3p0</groupId>
                <artifactId>c3p0</artifactId>
                <version>${c3p0.version}</version>
            </dependency>
            
    
            
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>${log4j.version}</version>
            </dependency>
    
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-api</artifactId>
                <version>${slf4j.version}</version>
            </dependency>
    
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-log4j12</artifactId>
                <version>${slf4j.version}</version>
            </dependency>
            
    
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>${mysql.version}</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.data</groupId>
                <artifactId>spring-data-jpa</artifactId>
                <version>1.9.0.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-test</artifactId>
                <version>4.2.4.RELEASE</version>
            </dependency>
    
            
            <dependency>
                <groupId>javax.el</groupId>
                <artifactId>javax.el-api</artifactId>
                <version>2.2.4</version>
            </dependency>
    
            <dependency>
                <groupId>org.glassfish.web</groupId>
                <artifactId>javax.el</artifactId>
                <version>2.2.4</version>
            </dependency>
            
        </dependencies>
    
    
    </project>

### 创建表并准备数据 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NvbGRfX19wbGF5_size_16_color_FFFFFF_t_70]

### 实体类 ###

package pers.zhang.entity;
    
    /** * @author zhang * @date 2019/12/15 - 22:10 */
    
    import javax.persistence.*;
    
    /** * 1.实体类和表的映射关系 * @Entity * @Table * 2.类中属性和表中字段的映射关系 * @Id * @GeneratedValue * @Colum */
    
    @Entity //声明实体类
    @Table(name="cst_customer") //建立实体类和表的映射关系
    public class Customer { 
    
        @Id//声明当前私有属性为主键
        @GeneratedValue(strategy= GenerationType.IDENTITY) //配置主键的生成策略
        @Column(name="cust_id") //指定和表中cust_id字段的映射关系
        private Long custId;
    
        @Column(name="cust_name") //指定和表中cust_name字段的映射关系
        private String custName;
    
        @Column(name="cust_source")//指定和表中cust_source字段的映射关系
        private String custSource;
    
        @Column(name="cust_industry")//指定和表中cust_industry字段的映射关系
        private String custIndustry;
    
        @Column(name="cust_level")//指定和表中cust_level字段的映射关系
        private String custLevel;
    
        @Column(name="cust_address")//指定和表中cust_address字段的映射关系
        private String custAddress;
    
        @Column(name="cust_phone")//指定和表中cust_phone字段的映射关系
        private String custPhone;
    
        public Long getCustId() { 
            return custId;
        }
        public void setCustId(Long custId) { 
            this.custId = custId;
        }
        public String getCustName() { 
            return custName;
        }
        public void setCustName(String custName) { 
            this.custName = custName;
        }
        public String getCustSource() { 
            return custSource;
        }
        public void setCustSource(String custSource) { 
            this.custSource = custSource;
        }
        public String getCustIndustry() { 
            return custIndustry;
        }
        public void setCustIndustry(String custIndustry) { 
            this.custIndustry = custIndustry;
        }
        public String getCustLevel() { 
            return custLevel;
        }
        public void setCustLevel(String custLevel) { 
            this.custLevel = custLevel;
        }
        public String getCustAddress() { 
            return custAddress;
        }
        public void setCustAddress(String custAddress) { 
            this.custAddress = custAddress;
        }
        public String getCustPhone() { 
            return custPhone;
        }
        public void setCustPhone(String custPhone) { 
            this.custPhone = custPhone;
        }
    
        @Override
        public String toString() { 
            return "Customer{" +
                    "custId=" + custId +
                    ", custName='" + custName + '\'' +
                    ", custSource='" + custSource + '\'' +
                    ", custIndustry='" + custIndustry + '\'' +
                    ", custLevel='" + custLevel + '\'' +
                    ", custAddress='" + custAddress + '\'' +
                    ", custPhone='" + custPhone + '\'' +
                    '}';
        }
    }

### 创建测试类 ###

package pers.zhang;
    
    import org.junit.Test;
    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 pers.zhang.dao.CustomerDao;
    import pers.zhang.entity.Customer;
    
    import java.util.List;
    
    /** * @author zhang * @date 2019/12/15 - 22:40 */
    @RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration(locations = "classpath:applicationContext.xml")
    public class mytest { 
    
        @Autowired
        private CustomerDao customerDao;
    
    
        /* 根据id查询 */
        @Test
        public void testFindById(){ 
            Customer one = customerDao.findOne(2l);
            System.out.println(one);
        }
    
        /* save:保存或更新 如果传递的对象中没有id：保存 如果传递的对象中有id：根据id查询，然后更新数据 */
        @Test
        public void testSave(){ 
            Customer customer = new Customer();
            customer.setCustName("三星");
            customer.setCustAddress("思密达");
            customerDao.save(customer);
        }
    
    
        /* delete:根据id删除 */
        @Test
        public void testDelete(){ 
            customerDao.delete(7l);
        }
    
    
        /* findAll：查询所有 */
        @Test
        public void testFindAll(){ 
            List<Customer> all = customerDao.findAll();
            for(Customer c : all)
                System.out.println(c);
        }
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NvbGRfX19wbGF5_size_16_color_FFFFFF_t_70]: /images/20210813/d9920ffe0bdd4bba841aa2d72c4e3840.png