初识mybatis_02 基于注解实现增删改查

xml配置和注解的区别：

<mappers>

　　<!-- 基于注解，mapper需要指定接口 -->

　　<mapper class="com.sunmap.dao.IPersonOperation"/>

</mappers>

<?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>
     <!-- 顾名思义类型的别名,即 Person 代指com.sunmap.model.Person-->
    <typeAliases>
        <typeAlias alias="Person" type="com.sunmap.model.Person" />
        <typeAlias alias="Article" type="com.sunmap.model.Article" />
    </typeAliases>
    
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <dataSource type="POOLED">
                <property name="driver" value="org.postgresql.Driver" />
                <property name="url"
                    value="jdbc:postgresql://192.168.5.11:5432/poidata" />
                <property name="username" value="postgres" />
                <property name="password" value="123456" />
            </dataSource>
        </environment>
    </environments>
    
    <!--  -->
    <mappers>
        <!-- <mapper resource="com/sunmap/model/Person.xml" /> -->
        <!-- <mapper url="file:///home/wanggang/图片/Person.xml"/> -->

        <!-- <package name="com.sunmap.dao"/>   -->
        
        <!-- 基于注解，mapper需要指定接口 -->
         <mapper class="com.sunmap.dao.IPersonOperation"/>
    </mappers>

</configuration>

package com.sunmap.dao;

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.SelectKey;
import org.apache.ibatis.annotations.Update;

import com.sunmap.model.Article;
import com.sunmap.model.Person;

/**
 * 
 * 定义的接口
 * */
public interface IPersonOperation {

    @Select("select * from person where id = #{id}")
    public Person selectPersonByID(int id);
    
    @Select("select * from person where name like '%${_parameter}%'")
    public List<Person> selectPersonByName(String name);
    
    /**
     * 
     * 
     * */
    @SelectKey (statement="SELECT nextval('test_c_id_seq'::regclass) as id ", keyProperty="id", before=true, resultType=int.class)
    @Insert ("insert into person (id,name,age) values(#{id,jdbcType=INTEGER},#{name},#{age})")
    public void addPerson(Person p);
    
    @Select("select * from person where id = #{id}")
    public List<Person> selectPerson();
    
    @Update("update person set name =#{name},age = #{age} where id = #{id}")
    public void updatePerson(Person p);

    @Delete("delete from person where id = #{id}")
    public void deletePersonById(Person p);
    
    @Select("select person.id,person.name,person.age,article.id from person,article    where person.id=article.personid and person.id=#{id}")
    public List<Article> getUserArticle(int id);
}