1,创建一个springboot项目
2,配置properties文件
spring.datasource.url=jdbc:mysql://124.70.190.246:3306/spring?serverTimezone=UTC spring.datasource.username=root spring.datasource.password=111 spring.jpa.hibernate.ddl-auto=update//开启数据库自动更新 spring.jpa.show-sql=true//开启sql语句显示3,创建实体类
@Entity @Table public class Teacher { @Id @GeneratedValue(strategy = GenerationType.IDENTITY)//自增 private Integer id; @Column private String name; @Column private String local; /** *Constructor有参,无参 *Getting,Setting *toString */ }4,编写service接口
public interface TeacherService { void saveTeacher(Teacher teacher); Teacher findTeacher(int id); }5,编写数据库操作接口,Teacher类操作方法接口库 🐖:JpaRepository<T,ID> T:哪个实体类的方法接口库 ID:这个实体类的主键
public interface TeacherRepository extends JpaRepository<Teacher,Integer> { Teacher findById(int id); //需要什么方法可以自己任意挑选 }6,Service的实现类Impl 🐖:加@Service标签 注入方法接口类@Resource/@Autowried(都可用但有区别) 重写方法@Override
@Service public class TeacherSericeImp implements TeacherService { @Resource TeacherRepository teacherRepository; @Override public void saveTeacher(Teacher teacher) { Teacher result =teacherRepository.save(teacher); return ; } @Override public Teacher findTeacher(int id) { Teacher teacher = teacherRepository.findById(id); return teacher; } }7,Controller类用来相应前端请求 🐖:加@RestController注解,注入service接口,相应PostMapping("/index)请求
@RestController public class TeacherController { @Autowired private TeacherService teacherService; @PostMapping("/index") public String saveTeacher(@RequestParam("id") int id, @RequestParam("name") String name, @RequestParam("local") String local){ Teacher teacher = new Teacher(id,name,local); teacherService.saveTeacher(teacher); return "success"; } }