新建一个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\:orcl
- driverClass=oracle.jdbc.OracleDriver
- account=scott
- password=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);
- }
- }
- @Test
- public void update(){
- SqlSession session = getSession();
- session.update("updateEmp");
- //需要提交事务
- session.commit();
- }
- @Test
- public void add(){
- SqlSession session = getSession();
- session.update("addEmp");
- //需要提交事务
- session.commit();
- }
- @Test
- public void delete(){
- SqlSession session = getSession();
- session.update("deleteEmp");
- //需要提交事务
- session.commit();
- }
- }