栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

SpringDataJpa学习笔记

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

SpringDataJpa学习笔记

目录

一、导入pom包

二、配置文件

三、基于应用Dao层继承的类自带方法进行增删改查

3.1实体类Customer

3.2Dao层

3.3测试类

 四、基于注解的增删改查

4.1Dao层

4.2测试类

五、一对多关系的表的案例

5.1联系人表

5.2顾客表

5.3Dao层

5.4.测试类

六、多对多关系的表的案例

6.1用户表

6.2角色表

6.3Dao层

6.4测试类


一、导入pom包

        4.2.4.RELEASE
        5.0.7.Final
        1.6.6
        1.2.12
        0.9.1.2
        8.0.27
    

    
        
        
            junit
            junit
            4.9
            test
        

        
        
            org.aspectj
            aspectjweaver
            1.6.8
        

        
            org.springframework
            spring-aop
            ${spring.version}
        

        
            org.springframework
            spring-context
            ${spring.version}
        

        
            org.springframework
            spring-context-support
            ${spring.version}
        

        
            org.springframework
            spring-orm
            ${spring.version}
        

        
            org.springframework
            spring-beans
            ${spring.version}
        

        
            org.springframework
            spring-core
            ${spring.version}
        
        

        
        
            org.hibernate
            hibernate-core
            ${hibernate.version}
        
        
            org.hibernate
            hibernate-entitymanager
            ${hibernate.version}
        
        
            org.hibernate
            hibernate-validator
            5.2.1.Final
        
        

        
        
            c3p0
            c3p0
            ${c3p0.version}
        
        

        
        
            log4j
            log4j
            ${log4j.version}
        

        
            org.slf4j
            slf4j-api
            ${slf4j.version}
        

        
            org.slf4j
            slf4j-log4j12
            ${slf4j.version}
        
        


        
            mysql
            mysql-connector-java
            ${mysql.version}
        

        
            org.springframework.data
            spring-data-jpa
            1.9.0.RELEASE
        

        
            org.springframework
            spring-test
            4.2.4.RELEASE
        

        
        
            javax.el
            javax.el-api
            2.2.4
        

        
            org.glassfish.web
            javax.el
            2.2.4
        
        
    

二、配置文件
 
    
        
        
        
        
    

    
    
        
        
        
            
        
        
        
            
                
                
                
                
            
        
        
            
                update
            
        
        
            
        
    


    
    
    
        
    

    
    

    
    
        
            
            
            
            
            
            
            
        
    

    
    
        
        
    
    

    

三、基于应用Dao层继承的类自带方法进行增删改查

3.1实体类Customer

@Entity
@Table(name="cst_customer_2")
public class Customer implements Serializable {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name="cust_id")
    private Long custId;

    @Override
    public String toString() {
        return "Customer{" +
                "custId=" + custId +
                ", custName='" + custName + ''' +
                ", custSource='" + custSource + ''' +
                ", custIndustry='" + custIndustry + ''' +
                ", custLevel='" + custLevel + ''' +
                ", custAddress='" + custAddress + ''' +
                ", custPhone='" + custPhone + ''' +
                '}';
    }

    @Column(name="cust_name")
    private String custName;
    @Column(name="cust_source")
    private String custSource;
    @Column(name="cust_industry")
    private String custIndustry;
    @Column(name="cust_level")
    private String custLevel;
    @Column(name="cust_address")
    private String custAddress;
    @Column(name="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;
    }
}

3.2Dao层
public interface CustomerDao extends JpaRepository, JpaSpecificationExecutor {


}

3.3测试类
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:applicationContext.xml")
public class CustomDaoTest {
    @Autowired
    private CustomerDao customerDao;

    @Test
    public void TestSave(){
        Customer c=new Customer();
        c.setCustName("多宝鱼");
        customerDao.save(c);
    }

    @Test
    public void TestUpadate(){
        Customer c=customerDao.findOne(1L);
        c.setCustName("多宝鱼");
        customerDao.save(c);
    }

    @Test
    public void testById(){
        Customer customer=customerDao.findOne(1L);
        System.out.println(customer);
    }
    @Test
    public void testDelete(){
        customerDao.delete(1L);
    }

四、基于注解的增删改查

4.1Dao层
public interface CustomerDao extends JpaRepository, JpaSpecificationExecutor {

    @Query(value="update Customer  set custName=?1 where custId=?2")
    @Modifying
    void UpdateCustmer(String custName, long custId);

    @Query(value="from Customer where custName= ?1 and custId=?2")
    Customer findCustNameAndId(String custName, long custId);

    @Query(value="select  * from cst_customer_2 where cust_name like ?1",nativeQuery = true)
    List testFindByLikeName(String custName);

    Customer findByCustName(String custName);

    Customer findBycustIndustry(String custIndustry);
}

4.2测试类
@Test
    @Transactional
    @Rollback(value=false)
    public void testUpdate2(){
        customerDao.UpdateCustmer("WW666",2L);
    }

    @Test
    public void findCustNameAndId(){
        Customer c=customerDao.findCustNameAndId("多宝鱼",3L);
        System.out.println(c);
    }

    @Test
    public void testFindByLikeName(){
        Listlist=customerDao.testFindByLikeName("%6%");
        for(Object[] objects:list){
            System.out.println(Arrays.toString(objects));
        }
    }

    @Test
    public void findByname(){
        Customer c=customerDao.findByCustName("WW666");
        System.out.println(c);
    }

    @Test
    public void findcustIndustry(){
        Customer c=customerDao.findBycustIndustry("123");
        System.out.println(c);
    }

五、一对多关系的表的案例

Customer(顾客)表和Linkman(联系人)表之间的关系是一对多的。

5.1联系人表
@Entity
@Table(name="cst_linkman")
public class LinkMan implements Serializable {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name="lkm_id")
    private Long lkmId;
    @Column(name = "lkm_name")
    private String lkmName;
    @Column(name="lkm_gender")
    private String lkmGender;
    @Column(name="lkm_phone")
    private String lkmPhone;
    @Column(name="lkm_mobile")
    private String lkmMobile;
    @Column(name="lkm_email")
    private String lkmEmail;
    @Column(name="lkm_position")
    private String lkmPosition;
    @Column(name="lkm_memo")
    private String lkmMemo;

    @ManyToOne(targetEntity = Customer.class)
    @JoinColumn(name="lmk_cust_id",referencedColumnName = "cust_id")  //外键和表的主键
    private Customer customer;

    public Long getLkmId() {
        return lkmId;
    }

    public void setLkmId(Long lkmId) {
        this.lkmId = lkmId;
    }

    public String getLkmName() {
        return lkmName;
    }

    public void setLkmName(String lkmName) {
        this.lkmName = lkmName;
    }

    public String getLkmGender() {
        return lkmGender;
    }

    public void setLkmGender(String lkmGender) {
        this.lkmGender = lkmGender;
    }

    public String getLkmPhone() {
        return lkmPhone;
    }

    public void setLkmPhone(String lkmPhone) {
        this.lkmPhone = lkmPhone;
    }

    public String getLkmMobile() {
        return lkmMobile;
    }

    public void setLkmMobile(String lkmMobile) {
        this.lkmMobile = lkmMobile;
    }

    public String getLkmEmail() {
        return lkmEmail;
    }

    public void setLkmEmail(String lkmEmail) {
        this.lkmEmail = lkmEmail;
    }

    public String getLkmPosition() {
        return lkmPosition;
    }

    public void setLkmPosition(String lkmPosition) {
        this.lkmPosition = lkmPosition;
    }

    public String getLkmMemo() {
        return lkmMemo;
    }

    public void setLkmMemo(String lkmMemo) {
        this.lkmMemo = lkmMemo;
    }

    @Override
    public String toString() {
        return "LinkMan{" +
                "lkmId=" + lkmId +
                ", lkmName='" + lkmName + ''' +
                ", lkmGender='" + lkmGender + ''' +
                ", lkmPhone='" + lkmPhone + ''' +
                ", lkmMobile='" + lkmMobile + ''' +
                ", lkmEmail='" + lkmEmail + ''' +
                ", lkmPosition='" + lkmPosition + ''' +
                ", lkmMemo='" + lkmMemo + ''' +
                '}';
    }

5.2顾客表

在三的基础上,添加如下内容:

 @OneToMany(targetEntity = LinkMan.class)
    @JoinColumn(name="lmk_cust_id",referencedColumnName = "cust_id")
    private Set linkmans=new HashSet(0);

5.3Dao层
public interface LinkManDao  extends JpaRepository, JpaSpecificationExecutor {

}
public interface CustomerDao   extends JpaRepository, JpaSpecificationExecutor {

}

5.4.测试类
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations ="classpath:applicationContext.xml")
public class TestOnetoMany {
    @Autowired
    private CustomerDao customerDao;
    @Autowired
    private LinkManDao linkManDao;
    @Test
    @Transactional
    @Rollback(value = false)
    public void testAdd(){
        Customer customer=new Customer();
        customer.setCustName("buka");
        LinkMan linkMan=new LinkMan();
        linkMan.setLkmName("小明");
        customerDao.save(customer);
        linkManDao.save(linkMan);
    }

    }

六、多对多关系的表的案例

用户表和角色表是多对多的关系。

6.1用户表
@Entity
@Table(name="sys_user")
public class SysUser implements Serializable {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name="user_id")
    private Long userId;

    @Column(name="user_code")
    private String userCode;

    @Column(name="user_name")
    private String username;

    @Column(name="user_password")
    private String userPassword;

    @Column(name="user_state")
    private String userState;

    @ManyToMany(mappedBy = "users")
    private Set roles=new HashSet(0);

    public Long getUserId() {
        return userId;
    }

    public void setUserId(Long userId) {
        this.userId = userId;
    }

    public String getUserCode() {
        return userCode;
    }

    public void setUserCode(String userCode) {
        this.userCode = userCode;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getUserPassword() {
        return userPassword;
    }

    public void setUserPassword(String userPassword) {
        this.userPassword = userPassword;
    }

    public String getUserState() {
        return userState;
    }

    public void setUserState(String userState) {
        this.userState = userState;
    }

    public Set getRoles() {
        return roles;
    }

    public void setRoles(Set roles) {
        this.roles = roles;
    }

    @Override
    public String toString() {
        return "SysUser{" +
                "userId=" + userId +
                ", userCode='" + userCode + ''' +
                ", username='" + username + ''' +
                ", userPassword='" + userPassword + ''' +
                ", userState='" + userState + ''' +
                ", roles=" + roles +
                '}';
    }
}

6.2角色表
@Entity
@Table
public class SysRole implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name="role_id")
    private Long roleId;

    @Column(name="role_name")
    private String roleName;

    @Column(name="role_memo")
    private String roleMemo;

    @ManyToMany
    @JoinTable(name="user_role_rel",
            joinColumns = {@JoinColumn(name="role_id",referencedColumnName = "role_id")},   //当前表的
            inverseJoinColumns = {@JoinColumn(name="user_id",referencedColumnName ="user_id")}  //另一个表的
    )
    private Set users=new HashSet(0);

    public Long getRoleId() {
        return roleId;
    }

    public void setRoleId(Long roleId) {
        this.roleId = roleId;
    }

    public String getRoleName() {
        return roleName;
    }

    public void setRoleName(String roleName) {
        this.roleName = roleName;
    }

    public String getRoleMemo() {
        return roleMemo;
    }

    public void setRoleMemo(String roleMemo) {
        this.roleMemo = roleMemo;
    }

    public Set getUsers() {
        return users;
    }

    public void setUsers(Set users) {
        this.users = users;
    }

    @Override
    public String toString() {
        return "SysRole{" +
                "roleId=" + roleId +
                ", roleName='" + roleName + ''' +
                ", roleMemo='" + roleMemo + ''' +
                ", users=" + users +
                '}';
    }
}

6.3Dao层
public interface SysUserDao extends JpaRepository, JpaSpecificationExecutor {

}
public interface SysRoleDao extends JpaRepository, JpaSpecificationExecutor {

}

6.4测试类
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations ="classpath:applicationContext.xml")
public class TestManytoMany {
  
    @Autowired
    private SysRoleDao sysRoleDao;
    @Autowired
    private SysUserDao sysUserDao;

    @Test
    @Transactional
    @Rollback(value = false)
    public void test(){
        SysUser u1=new SysUser();
        u1.setUsername("用户2");
        SysRole r1=new SysRole();
        r1.setRoleName("角色2");
        u1.getRoles().add(r1);
        r1.getUsers().add(u1);
        sysRoleDao.save(r1);
        sysUserDao.save(u1);
    }

}

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/940850.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号