MyBatis （一）基本步骤

1.com.pojo

1) 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> <!--环境配置：默认开发模式--> <environments default="development"> <environment id="development"> <!--JDBC进行事务管理--> <transactionManager type="JDBC"/> <!--数据源配置：底层连接池--> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/student?characterEncoding=utf8"/> <property name="username" value="root"/> <property name="password" value="123"/> </dataSource> </environment> </environments> <!--注册映射 XML 文件--> <mappers> <mapper resource="com/pojo/mapper/StudentMapper.xml"/> </mappers> </configuration>

2)实体类

2.com.util

1)mybatisUtil.java

public class MyBatisUtil { private static SqlSessionFactory sqlSessionFactory = null; static { try { InputStream is = Resources.getResourceAsStream("com/pojo/pojo/mybatis-config.xml"); sqlSessionFactory = new SqlSessionFactoryBuilder().build(is); } catch (IOException e) { e.printStackTrace(); System.out.println("配置文件解析问题"); } } public static SqlSession getSqlSession(boolean isCommit){ return sqlSessionFactory.openSession(isCommit); } }

3.com.mapper

1) StudentMapper.xml

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!--无代理：namespace：值是任意的，一般是映射接口全路径--> <!--有代理：namespace：值映射接口全路径--> <!--项目中所有的映射 XML 中 namespace 值是唯一的--> <mapper namespace="abc"> <!-- // 查询所有--> <select id="findAll" resultType="com.pojo.pojo.StudentInfo"> select * from StudentInfo </select> <!--// 查询单条--> <select id="findAllBySid" resultType="com.pojo.pojo.StudentInfo" parameterType="Integer"> SELECT * from StudentInfo WHERE sid=#{sid} </select> <!--// 根据主键修改--> <update id="updateBySid" parameterType="com.pojo.pojo.StudentInfo"> update StudentInfo set sname=#{sname}, sgender=#{sgender}, sage=#{sage}, saddress=#{saddress}, semail=#{semail} WHERE sid=#{sid} </update> </mapper>

2)StudentMapper接口定义方法

4.com.mapper.IMP

1) StudentMapperIMP

重写的方法： 1)SqlSession sqlSession = MyBatisUtil.getSqlSession(false); 2)sqlSession.selectList("abc.findAll"); sqlSession.selectOne("abc.findAllBySid",sid); sqlSession.update("abc.updateBySid",studentInfo); <!--// namespace.id--> 3)sqlSession.close();