1.Categoty.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.how2java.springboot.mapper.CategoryMapper">
<select id="findAll" resultType="Category">
select * from product_
</select>
</mapper>
2.CategoryMapper
package com.how2java.springboot.mapper;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import com.how2java.springboot.pojo.Category;
@Mapper
public interface CategoryMapper {
@Select("select * from product_ ")
List<Category> findAll();
@Insert(" insert into product_ ( name ) values (#{name}) ")
public int save(Category category);
@Delete(" delete from product_ where id= #{id} ")
public void delete(int id);
@Select("select * from product_ where id= #{id} ")
public Category get(int id);
@Update("update product_ set name=#{name} where id=#{id} ")
public int update(Category category);
}
3.运行
由于只会写基础的修改,把price和cid加进去之后出现了错误,所以暂时只改了id和name,文件名也没有改变。今天先写到这里。6.8
package com.how2java.springboot.mapper;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import com.how2java.springboot.pojo.Product;
@Mapper
public interface ProductMapper {
@Select("select * from product_ ")
List<Product> findAll();
@Insert(" insert into product_ ( name,price ) values (#{name},#{price} ) ")
public int save(Product product);
@Delete(" delete from product_ where id= #{id} ")
public void delete(int id);
@Select("select * from product_ where id= #{id} ")
public Product get(int id);
@Update("update product_ set name=#{name}, price=#{price} where id=#{id} ")
public int update(Product product);
}
package com.how2java.springboot.pojo;
public class Product {
private int id;
private String name;
private float price;
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 float getPrice() {
return price;
}
public void setPrice(float price) {
this.price = price;
}
}
package com.how2java.springboot.web;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.how2java.springboot.mapper.ProductMapper;
import com.how2java.springboot.pojo.Product;
@Controller
public class ProductController {
@Autowired ProductMapper productMapper;
@RequestMapping("/addProduct")
public String listProduct(Product c) throws Exception {
productMapper.save(c);
return "redirect:listProduct";
}
@RequestMapping("/deleteProduct")
public String deleteProduct(Product c) throws Exception {
productMapper.delete(c.getId());
return "redirect:listProduct";
}
@RequestMapping("/updateProduct")
public String updateProduct(Product c) throws Exception {
productMapper.update(c);
return "redirect:listProduct";
}
@RequestMapping("/editProduct")
public String listProduct(int id,Model m) throws Exception {
Product c= productMapper.get(id);
m.addAttribute("c", c);
return "editProduct";
}
@RequestMapping("/listProduct")
public String listProduct(Model m,@RequestParam(value = "start", defaultValue = "1") int start,@RequestParam(value = "size", defaultValue = "5") int size) throws Exception {
PageHelper.startPage(start,size,"id asc");
List<Product> cs=productMapper.findAll();
PageInfo<Product> page = new PageInfo<>(cs);
m.addAttribute("page", page);
return "listProduct";
}
}
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" isELIgnored="false"%>
<div style="margin:0px auto; width:500px">
<form action="updateProduct" method="post">
name: <input name="name" value="${c.name}"> <br>
price: <input name="price" values="${c.price}"><br>
<input name="id" type="hidden" value="${c.id}">
<button type="submit">提交</button>
</form>
</div>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<div align="center">
</div>
<div style="width:500px;margin:20px auto;text-align: center">
<table align='center' border='1' cellspacing='0'>
<tr>
<td>id</td>
<td>name</td>
<td>price</td>
<td>编辑</td>
<td>删除</td>
</tr>
<c:forEach items="${page.list}" var="c" varStatus="st">
<tr>
<td>${c.id}</td>
<td>${c.name}</td>
<td>${c.price}</td>
<td><a href="editProduct?id=${c.id}">编辑</a></td>
<td><a href="deleteProduct?id=${c.id}">删除</a></td>
</tr>
</c:forEach>
</table>
<br>
<div>
<a href="?start=1">[首 页]</a>
<a href="?start=${page.pageNum-1}">[上一页]</a>
<a href="?start=${page.pageNum+1}">[下一页]</a>
<a href="?start=${page.pages}">[末 页]</a>
</div>
<br>
<form action="addProduct" method="post">
name: <input name="name"> <br>
price: <input price="price"> <br>
<input name="product.id" value="${product.id}" type="hidden"> <br><br>
<button type="submit">提交</button>
</form>
</div>
增加:
删除:
修改: