Mybatis简单入门

pom文件

    <dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.2.1</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.17</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
        </dependency>
    </dependencies>

1.创建项目和模块

就不介绍啦 然后添加pom依赖

2.添加配置

在resources创建mybatis-config.xml
里面配置mysql

<?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/mybatis"/>
                <property name="username" value="root"/>
                <property name="password" value="123"/>
            </dataSource>
        </environment>
    </environments>
    <!-- 引入映射文件 -->
    <mappers>
        <mapper resource="UserMapper.xml"/>
    </mappers>
</configuration>

3.创建库和表

		mysql>create database mybatis ;
		mysql>use mybatis ;
		mysql>create table users(id int primary key auto_increment , name varchar(20) ,age int) ;
		mysql>desc users ;

4.测试连接

public class TestApp{
			public static void main(String[] args) {
				try {
					//指定配置文件的路径(类路径)
					String resource = "mybatis-config.xml";
					//加载文件
					InputStream inputStream = Resources.getResourceAsStream(resource);

					//创建会话工厂Builder,相当于连接池
					SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);

					//通过sf开启会话，相当于打开连接。
					SqlSession s = sf.openSession();
					System.out.println(s);

				} catch (Exception e) {
					e.printStackTrace();
				}
			}

5.编写mapper文件

（1）创建User类，和user表对应

public class User {
				private Integer id ;
				private String name ;
				private int age ;
				//get/set
			}

（2）b)创建UserMapper.xml,存放在resources/目录下

			[resources/UserMapper.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">
			<!-- 定义名字空间 -->
			<mapper namespace="users">
				<!-- 定义insert语句 -->
				<insert id="insert">
				//#{name},#{age}   获取属性值
				  insert into users(name,age) values(#{name},#{age})
				</insert>
			</mapper>

6.在resources/mybatis-config.xml文件中引入mapper的xml文件

			<!-- *****引入映射文件(新增部分)***** -->
			<mappers>
				<mapper resource="UserMapper.xml"/>
			</mappers>

7.编写单元测试，实现插入

public void insert() throws Exception {
//指定配置文件的路径(类路径)
String resource = “mybatis-config.xml”;
//加载文件
InputStream inputStream = Resources.getResourceAsStream(resource);

		//创建会话工厂Builder,相当于连接池
		SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);

		//通过sf开启会话，相当于打开连接。
		SqlSession s = sf.openSession();
		User u = new User();

		u.setName("slm");
		u.setAge(2);
		//users为你名字空间
		s.insert("users.insert", u);
		s.commit();
		s.close();
	}

8.查看结果

9.编写单元测试实现更新和删除
在UserMapper.xml中添加执行语句

//更新
    <update id="update">
        update user set name = #{name},age =#{age} where id =#{id}
    </update>

//删除
    <delete id="delete">
        delete from user where name = #{name}
    </delete>

10.以此测试就可以啦

public void insert() throws Exception {
			//指定配置文件的路径(类路径)
			String resource = "mybatis-config.xml";
			//加载文件
			InputStream inputStream = Resources.getResourceAsStream(resource);

			//创建会话工厂Builder,相当于连接池
			SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);

			//通过sf开启会话，相当于打开连接。
			SqlSession s = sf.openSession();
			User u = new User();

			u.setName("slm");
			u.setAge(2);
			//users为你名字空间
			//s.insert("users.delete", u);
			s.insert("users.update", u);
			s.commit();
			s.close();
		}