Mybatis用xml文件映射的增删查改

新建一个maven项目

pom.xml需要添加的标签：

  <!-- 自动加载mybatis架包 -->    <dependency>  <groupId>org.mybatis</groupId>  <artifactId>mybatis</artifactId>  <version>3.2.8</version></dependency><!-- 加载本地ojdbc6.jar前面三个可以乱填，最好是配上，不然可能会报错scope   系统scope路径 --><dependency>  <groupId>oracle</groupId>  <artifactId>orcale</artifactId>  <version>3.2.8</version><scope>system</scope><systemPath>C:\app\Administrator\product\11.2.0\dbhome_1\jdbc\lib\ojdbc6.jar</systemPath></dependency>

主配置文件config--mybatis.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><properties resource="cn/et/mybatis/lesson01/jdbc.properties"></properties>  <!--   配置连接数据库的环境   development开发环境  -->  <environments default="development">    <environment id="development">      <!-- 事务交给JDBC来管理   也就是通过 Connection的 commit和rollback管事事务 -->      <transactionManager type="JDBC"/>      <dataSource type="POOLED">        <property name="driver" value="${driverClass}"/>        <property name="url" value="${url}"/>        <property name="username" value="${account}"/>        <property name="password" value="${password}"/>      </dataSource>    </environment>  </environments>    <mappers>  <mapper resource="cn/et/mybatis/lesson01/emp_mapper.xml" />  </mappers>  </configuration>

副配置文件mapper--emp_mapper.xml:

<?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="helloworld"><!-- id标识符  用天唯一标示一条sql语句resultType需要指定单行数据返回的类型可以去org.apache.ibatis.type.TypeAliasRegistry类去找映射虚的变量名 --><select id="query" resultType="map">select * from emp</select><update id="updateEmp">update emp2 set sal=sal+1000 where ename='张三'</update><insert id="addEmp">insert into emp2 values(20,'李白', 8500)</insert><delete id="deleteEmp">delete from emp2 where eno=20</delete></mapper>

jdbc.properties:

url=jdbc\:oracle\:thin\:@localhost\:1521\:orcldriverClass=oracle.jdbc.OracleDriveraccount=scottpassword=tiger

java测试类：

package cn.et.mybatis.lesson01;import java.io.InputStream;import java.util.List;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.junit.Test;public class TestMybatis {public static SqlSession getSession(){String resource = "mybatis.xml";InputStream inputStream = TestMybatis.class.getResourceAsStream(resource);SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);//打开会话SqlSession session = sqlSessionFactory.openSession();return session;}public static void main(String[] args) {//打开会话SqlSession session = getSession();List list=session.selectList("helloworld.query");//System.out.println(list.size());for (Object object : list) {System.out.println(object);}}@Testpublic void update(){SqlSession session = getSession();session.update("updateEmp");//需要提交事务session.commit();}@Testpublic void add(){SqlSession session = getSession();session.update("addEmp");//需要提交事务session.commit();}@Testpublic void delete(){SqlSession session = getSession();session.update("deleteEmp");//需要提交事务session.commit();}}