一 概述
整理代码逻辑,要从方法代码开始,不去关心配置文件
1.四个对应
(1) namespace对应接口全名
(2) id 对应 接口方法名
(3) 参数类型对应
(4) 返回类型对应
2.代码逻辑概述
**使用代理对象进行数据库操作(调用代理对象的方法(自定义接口的实现方法)进行操作)
&&传统方式使用的是sqlSession对象的方法来操作,所以namespace名字自定义
二 实例代码
- 创建一个接口,定义方法
package com.itheima.mapperTest;
import java.util.List;
import com.itheima.domain.User;
public interface UserDao {
public List<User> findAllUser();
public User findUserById(int id);
public void insertUser(User user);
//映射文件 namespace对应 id对应 参数类型对应 返回类型对应
//映射 两个东西关联,不只有对象和数据库映射
}
2.映射文件配置
<?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="com.itheima.mapperTest.UserDao">
<!-- id为sql语句的id,parameterType 参数类型 , resultType 返回的类型 (实体类要写类全名)-->
<select id="findUserById" parameterType="int" resultType="com.itheima.domain.User">
SELECT * from user where id= #{aid}
</select>
<select id="findAllUser" resultType="com.itheima.domain.User">
SELECT * from user
</select>
<insert id="insertUser" parameterType="com.itheima.domain.User">
<selectKey keyProperty="id" resultType="java.lang.Integer" order="AFTER">
select LAST_INSERT_ID(); <!-- 主键返回,自增主键生成后返回,UUID主键生成策略是before -->
</selectKey>
INSERT into user VALUES (#{id},#{username},#{birthday},#{sex},#{address});
</insert>
</mapper>
3 .核心配置文件配置 , 将映射文件配置到核心配置文件
<?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="root" />
</dataSource>
</environment>
</environments>
<mappers>
<!--将UserMapper.xml添加在SqlMapConfig.xml -->
<mapper resource="sqlMapper/UserMapper.xml"/>
</mappers>
</configuration>
4 .代码测试(操作数据表)
package com.itheima.test;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;
import com.itheima.domain.User;
import com.itheima.mapperTest.UserDao;
public class UserDaoTest {
private SqlSessionFactory sqlSessionFactory;
@Before
public void setSqlSession() throws Exception{
//1.获得SqlSession对象
SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");
sqlSessionFactory = sqlSessionFactoryBuilder.build(inputStream);
}
@Test
public void test() throws Exception{
SqlSession sqlSession = sqlSessionFactory.openSession();
//2.获得接口的代理对象 sqlSession.getMapper()
UserDao userDaoMapper = sqlSession.getMapper(UserDao.class);
//3.使用代理对象的方法操作
/*List<User> list = userDaoMapper.findAllUser();
for (User user : list) {
System.out.println(user);
}*/
User user = userDaoMapper.findUserById(1);
System.out.println(user);
//4.释放资源
sqlSession.close();
}
}