Mybatis注解版的CRUD

代码

1. com.mybatis.pojo
2. com.mybatis.mapper
3. com.mybatis.item

package com.mybatis.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.mybatis.pojo.Flower;

/**
 * 数据访问层
 * @author Lenovo
 *com.mybatis.mapper.FlowerMapper
 */
public interface FlowerMapper {

	
	//增加
	@Insert("INSERT INTO flower(`name`,price,production) VALUES(#{name},#{price},#{production});")
	void insertInfo(Flower ff);
	//删除
	@Delete("DELETE	FROM flower WHERE id=#{id}")
	void deleteInfo(int id);
	//修改
	@Update("UPDATE flower SET `name`=#{name},price=#{price},production=#{production} WHERE id=#{id}")
	void updateInfo(Flower ff);
	//查询
	@Select("SELECT * FROM flower;")
	List<Flower> selectAll();
	
}

/**
	 * 查询;
	 * FlowerMapper fm = session.getMapper(FlowerMapper.class);
	 * FlowerMapper fm = new FlowerMapper();
	 */
	@Test
	public void selectAll() {
		SqlSession session = this.getConnDB();
		//拿到FlowerMapper类/接口的完整名称
		FlowerMapper fm = session.getMapper(FlowerMapper.class);
		List<Flower> list = fm.selectAll();
		for (Flower flower : list) {
			System.out.println(flower);
		}
		session.close();
	}