IDE maven 创建spring boot 用hibernate 实现连接数据库

来源:互联网 发布:怎么设置网络防火墙 编辑:程序博客网 时间:2024/05/17 08:05






package com.jm.Model;


import javax.persistence.Entity;


@Entity
public class UserDB {


    private  int userid  ;
    private  String  username;
    private String userno ;


    public int getUserid() {
        return userid;
    }


    public String getUsername() {
        return username;
    }


    public String getUserno() {
        return userno;
    }


    public void setUserid(int userid) {
        this.userid = userid;
    }


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


    public void setUserno(String userno) {
        this.userno = userno;
    }
}






package com.jm.controller;




import com.jm.Model.UserDB;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;


import java.util.List;


@Controller
public class UserController {
    @Autowired
    private UserDBRepository userdb;


    /**查询所有用户列表*/


    @GetMapping(value = "/users")
    private List<UserDB> userList(){


        System.out.println(userdb.findAll());
        return userdb.findAll();


    }
//    /**添加一个女生*/
//    @PostMapping(value="/users")
//    public Girl girlAdd(@RequestParam("cupSize") String cupSize,
//                        @RequestParam("age") Integer age){
//        Girl girl=new Girl();
//        girl.setCupSize(cupSize);
//        girl.setAge(age);
//        return girlRepository.save(girl);
//    }
//    //查询一个女生
//    @GetMapping(value = "/girls/{id}")
//    public Girl girlFindOne(@PathVariable("id")Integer id){
//        return girlRepository.findOne(id);
//    }
//    //更新
//    @PutMapping(value = "/girls/{id}")
//    public Girl girlUpdate(@PathVariable("id") Integer id,
//                           @RequestParam("cupSize") String cupSize,
//                           @RequestParam("age") Integer age){
//        Girl girl=new Girl();
//        girl.setId(id);
//        girl.setCupSize(cupSize);
//        girl.setAge(age);
//        return girlRepository.save(girl);
//    }
//    //删除
//    @DeleteMapping(value="/girls/{id}")
//    public void girlDelete(@PathVariable("id") Integer id){
//        girlRepository.delete(id);
//    }
//
//    //通过年龄查询女生列表
//    @GetMapping(value = "/girls/age/{age}")
//    public  List<Girl> girlListByAge(@PathVariable("age")Integer age){
//        return girlRepository.findByAge(age);
//    }
}






package com.jm.controller;


import com.jm.Model.UserDB;
import org.springframework.data.jpa.repository.JpaRepository;


import java.util.List;


public interface UserDBRepository  extends JpaRepository{
    public List<UserDB>;


}




ERROR 1384 --- [  restartedMain] o.s.b.d.LoggingFailureAnalysisReporter  






Description:


Cannot determine embedded database driver class for database type NONE


Action:


If you want an embedded database please put a supported one on the classpath. If you have database settings to be loaded from a particular profile you may need to active it (no profiles are currently active).




Process finished with exit code 0




原因是:springboot启动时会自动注入数据源和配置jpa
解决:在@SpringBootApplication中排除其注入


@SpringBootApplication(exclude={DataSourceAutoConfiguration.class,HibernateJpaAutoConfiguration.class})




加了之后,又报错