Mybatis基本配置与使用

**

一.Mybatis的配置

**

1.导入jar包，推荐使用maven工具。
必要的jar包为mybatis.jar，mysql-connector-java.jar(用于连接数据库)，我的项目结构

2.编写mybatis的配置文件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">
    <!-- 加载数据库 -->
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/shop?useSLL=false"/>
        <property name="username" value="root"/>
        <property name="password" value="1071562691"/>
      </dataSource>
    </environment>
  </environments>
  <!-- 映射文件的位置，使用完全限定名 -->
  <mappers>
    <mapper resource="ClassMaper.xml"/>
  </mappers>
</configuration>

3.编写mapper映射sql语句

<?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">
  <!-- 此处共映射了简单查找和插入。更新。删除和查找删除大致相同 -->
<mapper namespace="ClassMaper.xml">
  <select id="select" resultType="entity.Classs">
    select * from class where id = #{id}
  </select>
  <insert id="insert">
  insert into class(name,teacherid) values(#{name},#{id})
  </insert>
</mapper>

4.使用输入流加载资源mybatis配置文件，创建SqlSessionFactory工厂，获取SqlSession实例，执行sql语句

String path="mybatis-config.xml";
		InputStream is;
		try {
			is = Resources.getResourceAsStream(path);
			SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(is);
			SqlSession  session=factory.openSession();
		//	Classs cls=session.selectOne("select",1);
		//	System.out.println(cls);
			Classs ccc=new Classs();
			ccc.setName("ccc");
			ccc.setTeacherid(1);
			session.insert("insert",ccc);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}