Mybatis框架

1
<!DOCTYPE html>
2
<html lang="en">
3
<head>
4
    <meta charset="UTF-8">
5
    <title>Title</title>
6
</head>
7
<body>
8
    <h1>首页</h1>
9
    <a href="/add.html">添加英雄</a>
10
    <a href="/delete.html">删除英雄</a>
11
    <a href="/select">查询英雄</a>
12
</body>
13
</html>

1
<!DOCTYPE html>
2
<html lang="en">
3
<head>
4
    <meta charset="UTF-8">
5
    <title>Title</title>
6
</head>
7
<body>
8
    <h1>添加英雄页面</h1>
9
    <form action="/add">
10
        <input type="text" name="name" placeholder="英雄名">
11
        <input type="text" name="money" placeholder="英雄价格">
12
        <input type="submit" value="添加">
13
    </form>
14
</body>
15
</html>

1
<!DOCTYPE html>
2
<html lang="en">
3
<head>
4
    <meta charset="UTF-8">
5
    <title>Title</title>
6
</head>
7
<body>
8
    <h1>请输入要删除的英雄名称</h1>
9
    <form action="/delete">
10
        <input type="text" name="name">
11
        <input type="submit" value="删除">
12
    </form>
13
</body>
14
</html>

1
package cn.tedu.boot22.mapper;
2

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

6
import java.util.List;
7

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

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

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

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

1
<!DOCTYPE html>
2
<html lang="en">
3
<head>
4
    <meta charset="UTF-8">
5
    <title>Title</title>
6
</head>
7
<body>
8
    <h1>修改英雄页面</h1>
9
    <form action="/update">
10
        <input type="text" name="id" placeholder="请输入修改的id">
11
        <input type="text" name="name" placeholder="名字">
12
        <input type="text" name="money" placeholder="价格">
13
        <input type="submit" value="修改">
14
    </form>
15
</body>
16
</html>

1
package cn.tedu.boot22.controller;
2

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

13
    @RequestMapping("add")
14
    @ResponseBody
15
    public String add(Hero hero) {
16
        System.out.println("hero:"+hero);
17
        mapper.insert(hero);
18
        return "添加完成";
19
    }
20

21
    @RequestMapping("delete")
22
    @ResponseBody
23
    public String delete(String name) {
24
        mapper.deleteByName(name);
25
        return "删除完成";
26
    }
27

28
    @RequestMapping("select")
29
    @ResponseBody
30
    public String select() {
31
        List<Hero> list = mapper.select();
32
        return list.toString();
33
    }
34

35
    @RequestMapping("update")
36
    @ResponseBody
37
    public String update(Hero hero) {
38
        mapper.update(hero);
39
        return "修改完成";
40
    }
41
}

1
use empdb;
2

3
create table product(id int primary key auto_increment,title varchar(100),price double(10,2),sale_count int)charset=utf8;

1
<!DOCTYPE html>
2
<html lang="en">
3
<head>
4
    <meta charset="UTF-8">
5
    <title>Title</title>
6
</head>
7
<body>
8
    <h1>商品管理首页</h1>
9
    <a href="/insert.html">添加商品</a>
10
    <a href="/select">查询商品</a>
11
    <a href="/update.html">修改商品</a>
12

13
    <hr>
14
    <a href="/helloAxios.html">异步请求测试</a>
15
</body>
16
</html>

1
<!DOCTYPE html>
2
<html lang="en">
3
<head>
4
    <meta charset="UTF-8">
5
    <title>Title</title>
6
</head>
7
<body>
8
    <h1>添加商品页面</h1>
9
    <form action="/insert">
10
        <input type="text" name="title" placeholder="商品标题">
11
        <input type="text" name="price" placeholder="商品价格">
12
        <input type="text" name="saleCount" placeholder="商品销量">
13
        <input type="submit" value="添加">
14
    </form>
15
</body>
16
</html>

1
<!DOCTYPE html>
2
<html lang="en">
3
<head>
4
    <meta charset="UTF-8">
5
    <title>Title</title>
6
</head>
7
<body>
8
    <h1>修改商品页面</h1>
9
    <form action="/update">
10
        <input type="text" name="id" placeholder="请输入修改商品的id">
11
        <input type="text" name="title" placeholder="商品标题">
12
        <input type="text" name="price" placeholder="商品价格">
13
        <input type="text" name="saleCount" placeholder="商品销量">
14
        <input type="submit" value="修改">
15
    </form>
16
</body>
17
</html>

1
package cn.tedu.boot31.controller;
2

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

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

16
    @RequestMapping("select")
17
    public String select() {
18
        List<Product> list = mapper.select();
19
        String html = "<table border=1>";
20
        html+="<caption>商品列表</caption>";
21
        html+="<tr><th>id</th><th>标题</th><th>价格</th><th>销量</th><th>操作</th></tr>";
22
        for (Product p : list) {
23
            html+="<tr>";
24
            html+="<td>"+p.getId()+"</td>";
25
            html+="<td>"+p.getTitle()+"</td>";
26
            html+="<td>"+p.getPrice()+"</td>";
27
            html+="<td>"+p.getSaleCount()+"</td>";
28
            html+="<td><a href='/delete?id="+p.getId()+"'>删除</a></td>";
29
            html+="</tr>";
30
        }
31
        html+="</table>";
32
        return html;
33
    }
34

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

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

1
package cn.tedu.boot31.entity;
2

3
public class Product {
4
    private Integer id;
5
    private String title;
6
    private Double price;
7
    private Integer saleCount;
8

9
    public Integer getId() {
10
        return id;
11
    }
12

13
    public void setId(Integer id) {
14
        this.id = id;
15
    }
16

17
    public String getTitle() {
18
        return title;
19
    }
20

21
    public void setTitle(String title) {
22
        this.title = title;
23
    }
24

25
    public Double getPrice() {
26
        return price;
27
    }
28

29
    public void setPrice(Double price) {
30
        this.price = price;
31
    }
32

33
    public Integer getSaleCount() {
34
        return saleCount;
35
    }
36

37
    public void setSaleCount(Integer saleCount) {
38
        this.saleCount = saleCount;
39
    }
40

41
    @Override
42
    public String toString() {
43
        return "Product{" +
44
                "id=" + id +
45
                ", title='" + title + '\'' +
46
                ", price=" + price +
47
                ", saleCount=" + saleCount +
48
                '}';
49
    }
50
}

1
package cn.tedu.boot31.mapper;
2

3
@Mapper
4
public interface ProductMapper {
5

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

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

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

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