医学关键词 是哪个网站做,湛江做网站电话,做饲料机械的网站,河北省住房和建设厅网站概述
使用springboot 集成 mybatys后#xff0c;通过http请求接口#xff0c;使得通过http请求可以直接直接操作数据库#xff1b; 完成后端功能框架#xff1b;前端是准备上小程序#xff0c;调用https的请求接口用。简单实现后端框架#xff1b;
详细
springboot 集…概述
使用springboot 集成 mybatys后通过http请求接口使得通过http请求可以直接直接操作数据库 完成后端功能框架前端是准备上小程序调用https的请求接口用。简单实现后端框架
详细
springboot 集成 mybatys项目demo 通过idea实现springboot集成mybatys通过http请求操作mysql数据库
先将science.zip导入idea 在mysql中运行test.sql;创建测试用数据库数据库test用户名密码root/root 项目中只实现了一个对象User通过controller接受http请求实现对user的操作 实现过程
编辑application.properties
spring.datasource.url jdbc:mysql://127.0.0.1:3306/test
spring.datasource.username root
spring.datasource.password root
spring.datasource.driverClassName com.mysql.cj.jdbc.Driver
实现springboot启动类
package com.liji.science;import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;SpringBootApplication
public class ScienceApplication {public static void main(String[] args) {SpringApplication.run(ScienceApplication.class, args);}}
实现controller
package com.liji.science.controller;import com.liji.science.bean.User;
import com.liji.science.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;import java.util.List;RestController
public class UserController {Autowiredprivate UserService userService;RequestMapping(/listUser)public ListUser listUser(Model model) {ListUser users userService.findAll();model.addAttribute(users, users);return users;}/*RequestMapping(/toAdd)public String toAdd() {return /addUser;}RequestMapping(/add)public String addUser(User user) {userService.addUser(user);return redirect:/listUser;}RequestMapping(/toUpdate)public String toUpdate(Model model, int id) {User user userService.findById(id);model.addAttribute(user, user);return /updateUser;}RequestMapping(/update)public String updateUser(User user) {userService.updateUser(user);return redirect:/listUser;}RequestMapping(/delete)public String deleteUser(int id) {userService.deleteUser(id);return redirect:/listUser;}*/}service实现
package com.liji.science.mapper;import com.liji.science.bean.User;
import org.apache.ibatis.annotations.*;import java.util.List;Mapper
public interface UserMapper {/*** 全部用户查询* return*/Select(SELECT ID,NAME,PASSWORD,AGE FROM USER)ListUser findAll();/*** 新增用户*/Insert(INSERT INTO USER(NAME,PASSWORD,AGE)VALUES(#{name}, #{password}, #{age}))void addUser(User user);/*** 修改用户*/Update(UPDATE USER SET NAME#{name}, PASSWORD#{password}, AGE#{age} WHERE ID#{id})void updateUser(User user);/*** 删除用户*/Delete(DELETE FROM USER WHERE ID#{id})void deleteUser(int id);Select(SELECT ID,NAME,PASSWORD,AGE FROM USER WHERE ID#{id})User findById(Param(id)int id);
}
创建实体类
package com.liji.science.bean;public class User {private int id;private String name;private String password;private int age;public int getId() {return id;}public void setId(int id) {this.id id;}public String getName() {return name;}public void setName(String name) {this.name name;}public String getPassword() {return password;}public void setPassword(String password) {this.password password;}public int getAge() {return age;}public void setAge(int age) {this.age age;}
}
idea启动成功
idea启动成功 范文用户列表
