Mybatis Dao开发

1 创建项目，lib下引入Mybatis的jar包

 2 引入数据库连接的jar包

3 选中所有lib下的包右键Build Path

 4 编写Mybatis核心配置文件（sqlMapConfig.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>
	<!-- 和spring整合后 environments配置将废除 -->
	<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/mybatis?characterEncoding=utf-8" />
				<property name="username" value="root" />
				<property name="password" value="123456" />
			</dataSource>
		</environment>
	</environments>
	<!-- mapper的位置 -->
	<mappers>
	<mapper resource="sqlmap/User.xml"/>
	</mappers>
</configuration>

 5 创建POJO类

public class User{
	private Integer id;
	private String username;
	private String sex;
	private Date birthday;
	private String address;
    .......get/set方法........

}

6 创建sql映射User.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">
<!-- sql语句 -->
<!-- namespace:命名空间 -->
<mapper namespace="test">


	<!-- 通过id查询一个用户 -->

	<select id="findUserById" parameterType="Integer" resultType="com.entity.User">
		select * from user where id = #{v}
	</select>


	<!--              根据用户名称模糊查询用户列表
	 #{} 占位符(带引号) 		  select * from user where id = ? ？ ==  '欧文' 
	 ${} 字符拼接('%赵薇%')    select * from user where username like '%${}%' -->


	<select id="findUserByUsername" parameterType="String"
		resultType="com.entity.User">
		<!-- 防sql注入 -->
		<!-- select * from user where username like "%"#{username}"%" -->
		select * from user where username like '%${value}%'
	</select>

	<!-- 添加用户 -->

	<insert id="insertUser" parameterType="com.entity.User">
		<!-- 添加用户后用户下单，需要返回用户的id 使用selectKey -->
		<selectKey keyProperty="id" resultType="Integer" order="AFTER">
			select LAST_INSERT_ID()
		</selectKey>
		insert into user(username,sex,birthday,address)
		values(#{username},#{sex},#{birthday},#{address})
	</insert>

	
	<!-- 修改 -->

	<update id="updateUserByID" parameterType="com.entity.User">
	update user set username=#{username},sex=#{sex},birthday=#{birthday},address=#{address} where id=#{id}
	</update>


	<!-- 删除 -->

	<delete id="deleteUserById" parameterType="Integer">
	 delete from user where id = #{value}
	</delete>
</mapper>

7 加载映射文件

 

8 编写 Dao层

package com.dao;

import java.util.List;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

import com.entity.User;

public class UserDaoImpl implements UserDao {
		//注入SqlSessionFactory
		 private SqlSessionFactory sqlSessionFactory;
		 //构造方法
		public UserDaoImpl(SqlSessionFactory sqlSessionFactory) {
			this.sqlSessionFactory = sqlSessionFactory;
		}
		//通过用户ID查询一个用户
		public User selectUserById(Integer id) {
			SqlSession sqlSession = sqlSessionFactory.openSession();
			User user = sqlSession.selectOne("test.findUserById", id);
			return user;

		}
		//根据用户名称模糊查询用户列表
		public List<User> selectByUserName(String username) {
			SqlSession sqlSession = sqlSessionFactory.openSession();
			List<User> users = sqlSession.selectList("findUserByUsername", username);
			return users;

		}
		 
}

 9 编写测试类

package com.junit;

import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;

import com.dao.UserDao;
import com.dao.UserDaoImpl;
import com.entity.User;

public class MybatisDaoTest {
	public SqlSessionFactory sqlSessionFactory;
	@Before
	public void before() throws IOException {
	    String resource = "sqlMapConfig.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

	}
	@Test
	public void testById() {
		UserDao userDao = new UserDaoImpl(sqlSessionFactory);
		User user = userDao.selectUserById(10);
		System.out.println(user);
	}
	@Test
	public void testByName() {
		UserDao userDao = new UserDaoImpl(sqlSessionFactory);
		List<User> list = userDao.selectByUserName("三");
		for (User user : list) {
		System.out.println(user);	
		}
	}
}