myBatis 实现增删改查（基础方式）

1.配置需要加载的映射文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<!-- namespace:该映射文件的唯一标识 -->
<mapper namespace="personMapper">

    <select id="queryPersonById" resultType="yang.text.entity.Person" parameterType="int">
    select * from person where id = #{id}
      </select>

    <insert id="addPerson" parameterType="yang.text.entity.Person">
        insert into person(id,name,age) values(#{id},#{name},#{age})
    </insert>

    <update id="updatePerson" parameterType="yang.text.entity.Person">
        update person set id = #{id},name = #{name},language = #{age}
    </update>

    <delete id="deletePersonById" parameterType="int">
       delete from person where id = #{id}
    </delete>
</mapper>>

2.配置数据库信息

<?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>
    <environments default="development">
        <environment id="development">
            <!-- 事务提交方式:
                    JDBC：利用jdbc方式处理事务(commit rollback close)
                    MANAGED:将事务交由其他组件去托管（spring，jBoss)，默认会关闭连接
                    -->
            <transactionManager type="MANAGED"/>
            <!-- 数据源类型：
                    POOLED：使用数据库连接池
                    UNPOOLED:传统的jdbc模式
                    JNDI：从tomcat中获取一个内置的数据库连接池
             -->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/firstdb?serverTimezone=GMT"/>
                <property name="username" value="root"/>
                <property name="password" value="mysqlpasw"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="yang/text/entity/personMapper.xml"/>
    </mappers>
</configuration>

3.测试类

package yang.text.entity;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.Reader;

public class myBatisTest {
    public static void main(String[] args) throws Exception{
        Reader reader = Resources.getResourceAsReader("config.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);//可以通过build的第二个参数来改变数据库环境
        //相当于connection
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //String sqlStatement = "personMapper.queryPersonById";
        //Person person = sqlSession.selectOne(sqlStatement,1);
        //sqlSession.delete("personMapper.deletePersonById",1);
        //System.out.println(person.toString());
        Person person = new Person();
        person.setAge(18);
        person.setId(2);
        person.setName("zs");
        sqlSession.insert("personMapper.addPerson",person);
        //sqlSession.commit();
        sqlSession.close();
    }
}