侵删JAVA 框架 / MYBATIS / MYBATIS系列教材 (十二)- 注解 - 通过注解方式实现增删改查 CRUD
步骤 1 : 先运行,看到效果,再学习
步骤 2 : 模仿和排错
步骤 3 : 把XML方式的CRUD修改为注解方式
把 XML方式的CRUD 修改为注解方式
新增加接口CategoryMapper ,并在接口中声明的方法上,加上注解
对比配置文件Category.xml,其实就是把SQL语句从XML挪到了注解上来
package com.how2java.mapper;
import java.util.List;
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 com.how2java.pojo.Category;
public interface CategoryMapper {
@Insert(" insert into category_ ( name ) values (#{name}) ")
public int add(Category category);
@Delete(" delete from category_ where id= #{id} ")
public void delete(int id);
@Select("select * from category_ where id= #{id} ")
public Category get(int id);
@Update("update category_ set name=#{name} where id=#{id} ")
public int update(Category category);
@Select(" select * from category_ ")
public List<Category> list();
}
原本是像下面的
增加对CategoryMapper映射,原来的Category.xml 是否保留随意
<mapper class="com.how2java.mapper.CategoryMapper"/>
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<typeAliases>
<package name="com.how2java.pojo"/>
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/how2java?characterEncoding=UTF-8"/>
<property name="username" value="root"/>
<property name="password" value="admin"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/how2java/pojo/Category.xml"/>
<mapper class="com.how2java.mapper.CategoryMapper"/>
</mappers>
</configuration>