package cn.tedu.boot22.mapper;

import cn.tedu.boot22.entity.Hero;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper //Mybatis框架提供的注解,会创建实现类
public interface HeroMapper {
    /**
     * #{xxx}会从下面方法中的参数列表中找到同名的变量,如果没有同名的变量则进入对象中查找同名
     * 的成员变量的get方法
     * mybatis框架根据此方法声明生成具体的实现类的实现方法,方法内部就是JDBC代码
     */
    @Insert("insert into hero values(null,#{name},#{money})")
    void insert(Hero hero);

    @Delete("delete from hero where name = #{name}")
    void deleteByName(String name);

    @Select("select * from hero")
    List<Hero> select();

    @Update("update hero set name = #{name},money = #{money} where id = #{id}")
    void update(Hero hero);
}

package cn.tedu.boot22.controller;

@Controller
public class HeroController {
    /**
     * 自动注入/自动装配注解的作用:Spring框架结合mybatis框架会自动的将HeroMapper生成一个实现类和
     * 实现内部的方法,并且会自动实例化此对象,并交给Spring容器管理
     * required = false 告诉idea编译器此对象是非必须的
     */
    @Autowired(required = false)
    HeroMapper mapper;

    @RequestMapping("add")
    @ResponseBody
    public String add(Hero hero) {
        System.out.println("hero:"+hero);
        mapper.insert(hero);
        return "添加完成";
    }

    @RequestMapping("delete")
    @ResponseBody
    public String delete(String name) {
        mapper.deleteByName(name);
        return "删除完成";
    }

    @RequestMapping("select")
    @ResponseBody
    public String select() {
        List<Hero> list = mapper.select();
        return list.toString();
    }

    @RequestMapping("update")
    @ResponseBody
    public String update(Hero hero) {
        mapper.update(hero);
        return "修改完成";
    }
}

package cn.tedu.boot31.controller;

//@Controller
//@ResponseBody //此注解相当于在每个方法上都添加了ResponseBody注解
@RestController //=@Controller + @ResponseBody
public class ProductController {
    @Autowired
    ProductMapper mapper;

    @RequestMapping("insert")
    public String insert(Product product) {
        mapper.insert(product);
        return "添加完成!<a href='/'>返回首页</a>";
    }

    @RequestMapping("select")
    public String select() {
        List<Product> list = mapper.select();
        String html = "<table border=1>";
        html+="<caption>商品列表</caption>";
        html+="<tr><th>id</th><th>标题</th><th>价格</th><th>销量</th><th>操作</th></tr>";
        for (Product p : list) {
            html+="<tr>";
            html+="<td>"+p.getId()+"</td>";
            html+="<td>"+p.getTitle()+"</td>";
            html+="<td>"+p.getPrice()+"</td>";
            html+="<td>"+p.getSaleCount()+"</td>";
            html+="<td><a href='/delete?id="+p.getId()+"'>删除</a></td>";
            html+="</tr>";
        }
        html+="</table>";
        return html;
    }

    @RequestMapping("delete")
    public String delete(int id) {
        mapper.deleteById(id);
        return "删除完成!<a href='/select'>返回列表页面</a>";
    }

    @RequestMapping("update")
    public String update(Product product) {
        mapper.update(product);
        return "修改完成<a href='/select'>返回列表页面</a>";
    }
}

package cn.tedu.boot31.entity;

public class Product {
    private Integer id;
    private String title;
    private Double price;
    private Integer saleCount;

    public Integer getId() {
        return id;
    }

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

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public Double getPrice() {
        return price;
    }

    public void setPrice(Double price) {
        this.price = price;
    }

    public Integer getSaleCount() {
        return saleCount;
    }

    public void setSaleCount(Integer saleCount) {
        this.saleCount = saleCount;
    }

    @Override
    public String toString() {
        return "Product{" +
                "id=" + id +
                ", title='" + title + '\'' +
                ", price=" + price +
                ", saleCount=" + saleCount +
                '}';
    }
}

package cn.tedu.boot31.mapper;

@Mapper
public interface ProductMapper {

    @Insert("insert into product values(null,#{title},#{price},#{saleCount})")
    void insert(Product product);

    @Select("select * from product")
    @Result(column = "sale_count",property = "saleCount")
    List<Product> select();

    @Delete("delete from product where id = #{id}")
    void deleteById(int id);

    @Update("update product set title = #{title},price = #{price},sale_count=#{saleCount} where id = #{id}")
    void update(Product product);
}

package cn.tedu.boot31.controller;

@RestController
public class AxiosController {

    @RequestMapping("hello1Axios")
    public String hello1(String info) {
        return "请求成功! info="+info;
    }
    
    /**
     * @RequestBody 注解作用:当客户端发出post请求并且提交的是自定义对象时,服务器端接收参数
     * 必须使用此注解,否则获取不到传递过来的参数
     */
    @RequestMapping("hello2Axios")
    public String hello2(@RequestBody String info) {
        return "请求成功! info="+info;
    }
}

package cn.tedu.boot32.controller;

@RestController
public class UserController {

    @Autowired
    UserMapper mapper;

    @RequestMapping("reg")
    public int reg(@RequestBody User user) {
        //获取用户输入的用户名到数据库中查询用户信息
        User u = mapper.selectByUsername(user.getUsername());
        if (u != null) {
            return 2; //2代表用户名已存在
        }
        mapper.insert(user);
        return 1; //1注册成功
    }

    @RequestMapping("login")
    public int login(@RequestBody User user) {
        //获取用户输入的用户名到数据库中查询用户信息
        User u = mapper.selectByUsername(user.getUsername());
        if (u != null) {//代表查询到了用户信息
            //判断用户输入的密码和查询的密码是否一致
            if (user.getPassword().equals(u.getPassword())) {
                return 1; //登录成功
            }
            return 3; //密码错误
        }
        return 2; //用户名不存在
    }
}

package cn.tedu.boot32.entity;

public class User {
    private Integer id;
    private String username;
    private String password;
    private String nickname;

    public Integer getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

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

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getNickname() {
        return nickname;
    }

    public void setNickname(String nickname) {
        this.nickname = nickname;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", nickname='" + nickname + '\'' +
                '}';
    }
}

package cn.tedu.boot32.mapper;

@Mapper
public interface UserMapper {
    //因为返回值为一个对象,要求查询回来的结果必须是0或者1条
    @Select("select * from user where username = #{username}")
    User selectByUsername(String username);

    @Insert("insert into user values(null,#{username},#{password},#{nickname})")
    void insert(User user);
}