将JPA Spring Boot与SQL服务器一起使用

Question

我想通过STS在Spring Boot中使用JPA和SQL Server。这是我的表：

马文

<dependencies>

    <dependency>
    <groupId>com.hynnet</groupId>
    <artifactId>sqljdbc-chs</artifactId>
    <version>4.0.2206.100</version>
    </dependency>
    <dependency>
    <groupId>commons-lang</groupId>
    <artifactId>commons-lang</artifactId>
    <version>2.2</version>
    </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

application.properties

spring.datasource.driver-class-  name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.url=jdbc:sqlserver://localhost:1433;databaseName=quanlybanhang
spring.datasource.username=sa
spring.datasource.password=1
spring.jpa.hibernate.ddl-auto=create
spring.datasource.initialize=true
spring.jpa.database=SQL_SERVER

模型.Account.class

  @Entity
  @Table(name="taikhoan",uniqueConstraints=@UniqueConstraint(columnNames = {    "tendangnhap" }) )
 public class Account {
 @Id @GeneratedValue(strategy=GenerationType.AUTO)
 private int id;
 @NotNull

private String tendangnhap;
@NotNull
private String matkhau;
public Account(String tendangnhap, String matkhau) {
    super();
    this.tendangnhap = tendangnhap;
 this.matkhau = matkhau;
}
public Account() {
    super();
}
public int getId() {
    return id;
}
public void setId(int id) {
    this.id = id;
}
public String getTendangnhap() {
    return tendangnhap;
}

public void setTendangnhap(String tendangnhap) {
    this.tendangnhap = tendangnhap;
}
public String getMatkhau() {
    return matkhau;
}
public void setMatkhau(String matkhau) {
    this.matkhau = matkhau;
}   
}

接口账户

public interface AccountDAO extends JpaRepository<Account, Integer>{

}

ServiceAccount.class

@Service
public class ServerAccount {
    @Autowired
    AccountDAO server;
    public void them(Account acc){
        server.save(acc);   
    }
    public List<Account> lietke(){

        return server.findAll();    
    }
}

服务帐户类

@Service
public class ServerAccount {
    @Autowired
    AccountDAO server;

    Account acc=new Account("khang", "1");

    public void addAccount(){
        server.save(acc);
    }


    public List<Account> lietke(){

        return server.findAll();    
    }

}

我在控制器中调用了方法add帐户（），这是我得到的异常

"java.lang.NoClassDefFoundError： org/spingFramework/orm/jpa/support/Per的注释BeanPost处理器"

“原因：java.lang.ClassNotFoundException:org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor”

请帮我修复这个异常。谢谢！！！

Answer 1

从您错过的依赖项（检查您使用的java版本）：

 <dependency>
        <groupId>com.microsoft.sqlserver</groupId>
        <artifactId>mssql-jdbc</artifactId>
        <version>6.5.2.jre8-preview</version>
        <scope>test</scope>
    </dependency>

并在应用程序属性中更正以下行：

spring.datasource.driver-class-  name=com.microsoft.sqlserver.jdbc.SQLServerDriver

自

spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect