SpringMVC+Mybatis全套增删改(小白入门)

作者：刘佳乐

• 2020.6.27

先到官网了解mybatis的语法：https://mybatis.org/mybatis-3/zh/index.html

一、创建如下所示项目

二、在src下的cn.kgc.vo包下创建 Dept.java

package cn.kgc.vo;
public class Dept {
   

  private long deptno;
  private String dname;
  private String loc;


  public long getDeptno() {
   
    return deptno;
  }

  public void setDeptno(long deptno) {
   
    this.deptno = deptno;
  }


  public String getDname() {
   
    return dname;
  }

  public void setDname(String dname) {
   
    this.dname = dname;
  }


  public String getLoc() {
   
    return loc;
  }

  public void setLoc(String loc) {
   
    this.loc = loc;
  }

}

三、在src下的cn.kgc.mapper包下创建 DeptMapper.java

package cn.kgc.mapper;

import cn.kgc.vo.Dept;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

public interface DeptMapper {
   
    @Select("select * from dept")
    List<Dept> selectDept();

    @Insert("insert into dept(dname) values (#{dname})")
    int insertDept(Dept dept);

    @Update("update dept set dname=#{dname} values deptno=#{deptno}")
    int updateDept(Dept dept);

    @Delete("delete  from dept where deptno=#{deptno}")
    int deleteDept(Integer deptno)