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})
加了之后,又报错