增删改查实现
select 查询语句
- id 对应namespace中的方法名
- resultType sql语句执行的返回值
- paramterType 参数类型
步骤
1.编写接口
代码演示
package com.tian.dao;
import com.tian.pojo.User;
import java.util.List;
public interface UserMapper {
//查询全部用户
List<User> getUserList();
//根据ID查询用户
User getUserById(int id);
//增加一个用户
int addUser(User user);
//修改一个用户
int updateUser(User user);
//删除一个用户
int delUser(int id);
}
2.编写对应的mapper中的sql语句
代码演示
<?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 绑定一个对应的dao/mapper文件-->
<mapper namespace="com.tian.dao.UserMapper">
<!--
select 查询语句
id 对应方法名
resultType 返回类型
parameterType 传参的类型
-->
<select id="getUserList" resultType="com.tian.pojo.User" >
select * from mybatis.user
</select>
<select id="getUserById" parameterType="int" resultType="com.tian.pojo.User">
select * from mybatis.user where id=#{id}
</select>
<insert id="addUser" parameterType="com.tian.pojo.User">
insert into mybatis.user(id,name,pwd) values (#{id},#{name},#{pwd});
</insert>
<update id="updateUser" parameterType="com.tian.pojo.User">
update mybatis.user set name=#{name},pwd=#{pwd} where id=#{id};
</update>
<delete id="delUser" parameterType="int">
delete from mybatis.user where id=#{id};
</delete>
</mapper>
3.测试
代码演示
package com.tian.dao;
import com.tian.pojo.User;
import com.tian.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.List;
public class UserMapperTest {
@Test
public void test(){
//获得sqlsession对象
SqlSession sqlSession = MybatisUtils.getSqlSession();
//方式一:getMapper 执行sql
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
List<User> userList = userMapper.getUserList();
for (User user : userList) {
System.out.println(user);
}
//关闭sqlsession
sqlSession.close();
}
@Test
public void getUserById(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User userById = userMapper.getUserById(1);
System.out.println(userById);
//关闭sqlsession
sqlSession.close();
}
//增删改需要提交事务 sqlSession.commit();
@Test
public void addUser(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
int i = userMapper.addUser(new User(4, "哈哈", "123456"));
System.out.println(i);
//提交事务
sqlSession.commit();
sqlSession.close();
}
@Test
public void updateUser(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
userMapper.updateUser(new User(4,"呵呵","123123"));
//提交事务
sqlSession.commit();
sqlSession.close();
}
@Test
public void delUser(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
userMapper.delUser(4);
//提交事务
sqlSession.commit();
sqlSession.close();
}
}
注意!增删改休要提交事务-----sqlSession.commit();
分析错误
- 标签不要匹配错
- resource绑定mapper,需要使用路径!
- 程序配置文件必须符合规范!
- NullPointerException,没有注册到资源!
- 输出的xml文件中存在中文乱码问题!
- maven资源没有导出问题!