SpringBoot初体验（适合小白）

SpringBoot体验

编程环境 idea(maven工程)

全文附代码

1. 新建maven 工程
   

2. 导入依赖包

3. 创建 springboot 启动类

@SpringBootApplication 
public class TestApplication {

    public static void main(String[] args) {
        SpringApplication.run(TestApplication.class, args);
    }
}

4. 数据库配置文件
   
5. 实体类创建

public class User {
    private Integer id;
    private String name;
    private int age;

    public User() {
    }

    public User(Integer id, String name, int age) {
        this.id = id;
        this.name = name;
        this.age = age;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                '}';
    }
    
}

6. mapper接口编写 实现数据库的CRUD

public interface UserMapper {

    @Select("SELECT * FROM user WHERE id =  #{id}#")
    User getUserInfo(@Param("id") int id);

    @Select("SELECT * FROM user")
    List<User> findAll();

    @Insert("INSERT INTO user(name,age) VALUES(#{name},#{age})")
    int insertUser(@Param("name") String name, @Param("age") int age);

    @Update("UPDATE user  set name = #{name}# ,age =#{age}# WHERE  #{id}#;")
    int updateUser(@Param("id") int id, @Param("name") String name, @Param("age") int age);

    @Delete("DELETE FROM user WHERE id = #{id}#")
    int deleteUser(@Param("id") int id);
}

7. service层编写

@Service
public class UserService {
    @Autowired
    private UserMapper userMapper;

    /**
     * 根据id查询用户信息
     *
     * @param id
     * @return
     */
    public User selectUserById(int id) {
        User user = userMapper.getUserInfo(id);
        //控制台打印user信息
        System.out.println(user);
        return user;
    }

    /**
     * 查询所有用户信息
     *
     * @return
     */
    public List<User> findAll() {
        List<User> users = userMapper.findAll();
        //遍历users
        for (User user : users) {
            System.out.println(user);
        }
        return users;
    }

    /**
     * 用户插入 实现用户注册
     * @param name
     * @param age
     */
    public void register(String name, int age) {

        int rows = userMapper.insertUser(name, age);

        System.out.println("Affected rows:" + rows);

    }

    /**
     * 数据表的删除
     * @param id
     */
    public void deleteUser(int id){
        int rows = userMapper.deleteUser(id);
        System.out.println("Affected rows:" + rows);
    }

    /**
     * 数据表的修改
     * 根据id修改其他内容
     * @param id
     * @param name
     * @param age
     */
    public void updateUser(int id, String name, int age) {
        int col = userMapper.updateUser(id, name, age);
        System.out.println(col + "行受影响");
    }
    
}

8. controller层编写

@RestController
@RequestMapping("user")
public class UserController {

    @Autowired
    private UserService service;

    @GetMapping("info")
    public User getInfo(int id) {
        return service.selectUserById(id);
    }
    @PutMapping("/register")
    public void register(String name, int age) {
        service.register(name, age);
    }

    @GetMapping("findAll")
    public List<User> findAll() {
        List<User> users = service.findAll();

        //遍历结果打印在控制台
        for (User user : users) {
            System.out.println(user);
        }
        return users;
    }

    @PostMapping("/delete")
    public void deleteUser(int id) {
        service.deleteUser(id);
    }

    @PostMapping("/update")
    public void updateUser(int id, String name, int age) {
        service.updateUser(id, name, age);
    }
}

到此 一个普通的CRUD编写完毕

然后开始测试

• 测试工具 Postman
  点击下载

8. 测试

   启动成功
   
   测试结果不在过多赘述 直接上图 ^_

注:结果都可以通过打印在控制台查看 也可通过BDMS

更多请点击这里