吉安哪家做网站的公司好,2023房地产新闻,响应式中文网站模板,肯尼亚网站域名2019独角兽企业重金招聘Python工程师标准 简单查询 spring data jpa是spring全家桶成员之一#xff0c;用于操作各种数据库#xff0c;下面写一个查询订单的简单示例 引入sqlserver驱动包及jpa所需包implementation(org.springframework.boot:spring-boot-star… 2019独角兽企业重金招聘Python工程师标准 简单查询 spring data jpa是spring全家桶成员之一用于操作各种数据库下面写一个查询订单的简单示例 引入sqlserver驱动包及jpa所需包 implementation(org.springframework.boot:spring-boot-starter-data-jpa)runtimeOnly(com.microsoft.sqlserver:mssql-jdbc)2.配置连接字符串 spring.datasource.urljdbc:sqlserver://machinename or ip:1433;databasedbname
spring.datasource.usernameusername
spring.datasource.passwordpassword
spring.datasource.driver-class-namecom.microsoft.sqlserver.jdbc.SQLServerDriver
spring.jpa.hibernate.naming.physical-strategyorg.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
#关闭初始化数据库
spring.jpa.generate-ddlfalse
#显示生成的sql
spring.jpa.show-sqltrue3.创建entity可用idea生成 Entity
Table(name Order, schema dbo)
class OrderEntity {get:Idget:Column(name OrderID)var orderId: String? nullget:Basicget:Column(name OrderStatus)var orderStatus: Byte 0get:Basicget:Column(name OrderDate)var orderDate: LocalDateTime? nullget:Basicget:Column(name CurrencyCode)var currencyCode: String? nullget:Basicget:Column(name OrderAmount)var orderAmount: BigDecimal? null
}4.创建repository Repository
interface OrderRepository:JpaRepositoryOrderEntity,String可以简单调用一下了 Autowiredprivate lateinit var orderRepository: OrderRepositoryorderRepository.findAll()转载于:https://my.oschina.net/weidedong/blog/2396136
