myBatis 基于动态代理方式实现的增删改查

1.配置数据源和需要加载的映射文件

<?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/mapper/personMapper.xml"/> </mappers> </configuration>

2.配置映射文件

<?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="yang.text.mapper.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>

3.配置映射文件对应的接口

package yang.text.mapper; import yang.text.entity.Person; public interface personMapper { Person queryPersonById(int id); void addPerson(Person person); void updatePerson(Person person); void deletePersonById(int id); }

4.测试类

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 yang.text.mapper.personMapper; 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的第二个参数来改变数据库环境 SqlSession sqlSession = sqlSessionFactory.openSession(); personMapper mapper = sqlSession.getMapper(personMapper.class); Person person = mapper.queryPersonById(1); System.out.println(person.toString()); sqlSession.close(); } }