Mybatis-基础操作

删除

@Delete("delete from emp where id= #{id}")
    public void delete(Integer id);

增加

@Options(useGeneratedKeys = true,keyProperty = "id")
    @Insert("insert into emp(id, username, password, name, gender, image, job, entrydate, dept_id, create_time, update_time)" +
            "value (#{username},#{password},#{name},#{gender},#{image},#{job},#{entrydatre},#{deptId},#{createTime},#updateTime)")
    public void insert(Emp emp);

更新

@Update("update emp set username=#{username},password=#{password}, name=#{name}, gender=#{gender}, image=#{image}, job=#{job}, entrydate=#{entrydate}," +
            "dept_id=#{deptIid}, create_time=#{create_time}, update_time=#{update_time}")
    public void update(Emp emp);

查询

@Select("select * from emp where id=#{id}")
    public void select();

@Select("select *from emp where name like concat('%',#{name},'%') and gender =#{gender}")
    public void select (String name,Short gender);