mybatis--注解实现增删改查

1.往pom.xml导入依赖：

<dependency>
  <groupId>junit</groupId>
  <artifactId>junit</artifactId>
  <version>4.12</version>
  <scope>test</scope>
</dependency>

<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>3.4.5</version>
</dependency>
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>5.1.43</version>
</dependency>

 2.我的实体类：

private String pname;
private int pid;
private int page;

3.dao方法：

@Select("select * from person where pid=#{pid}")
public Person getperson(int pid);

@Select("select * from person")
public List<Person> getall();

@Insert("insert into person(pname,page) values(#{pname},#{page})")
public void addperson(Person person);

@Delete("delete from person where pid=#{pid}")
public void delperson(int pid);

@Update("update person set pname=#{pname},page=#{page} where pid=#{pid}")
public void updateperson(Person person);

4.然后，再是我的mybatis-config.xml配置文件：

<?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>
    <!--<typeAlias type="com.desert.Dto.MyPerson" alias="a"></typeAlias>-->
    <package name="com.desert"></package>
</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/test"/>
            <property name="username" value="root"/>
            <property name="password" value="root"/>
        </dataSource>
    </environment>
</environments>
<mappers>
    <mapper class="com.desert.Dao.PersonDao"/>
</mappers>
</configuration>

5.然后，测试：

try {
    SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config"));

    //通过sessionFactory获得SqlSession
    SqlSession sqlSession=sqlSessionFactory.openSession();
    PersonDao personDao=sqlSession.getMapper(PersonDao.class);
    personDao.delperson(1);
    sqlSession.commit();
    sqlSession.commit();
}catch(IOException e){

     e.printStackTrace();

}

就可以了。