# springJdbcJpaOrm

**Repository Path**: Jakarta-EE/springJdbcJpaOrm

## Basic Information

- **Project Name**: springJdbcJpaOrm
- **Description**: springJdbcTemplate
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2019-04-26
- **Last Updated**: 2020-12-20

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# springJdbcJpaOrm

# 介绍
###为什么会有这个项目
一条并不复杂的sql 
            
            select a.col1,a.col2,b.col3,b.col4 from table_a a left join table_b b on(a.id=b.aid) where a.xx=?
  需要把a.col1,a.col2,b.col1,b.col2 这些返回的结果转换为一个如下的java对象 
  ####Result.java:
      @Entity
      @Data
      public class Result {
      
          @Id
          @Column(name = "col1")
          private String filed1;
      
          @Column(name = "col2")
          private String filed2;
      
          @Column(name = "col3")
          private String filed3;
      
          @Column(name = "col4")
          private String filed4;
      
  
####Jpa 需要在实体类上加如下注解:
        
                  @NamedNativeQueries({
                          @NamedNativeQuery(
                                  name = "EntityName.myJoinQuery",   //需要调用的name
                                  query = "select a.col1,a.col2,b.col3,b.col4 from table_a a left join table_b b on(a.id=b.aid) where a.xx=?",
                                  resultClass = Result.class
                          )
                  })
                  @Entity
                  @Table("table_name")
                  public class EntityName{
                    @Id
                    @Column(name = "col1")
                    private String col1;
                    
                    @Column(name = "col2")
                    private String col2;
                    
                    @Column(name = "col3")
                    private String col3;
                  } 

对spring-jdbc的JdbcTemplate封装
    使用jdbcTemplate查询返回