package com.ftz.Demo.dao;
import com.ftz.Demo.po.User;
import java.util.List;
public interface UserMapper {
/**
* 查询全部用户
* @return
*/
List<User> getUserList();
/**
* 根据查询用户
*/
User getUserById(int id);
/**
* 增加用户
*/
int addUser(User user);
/**
* 修改用户
*/
int updateUser(User user);
/**
* 删除用户
*/
int deleteUser(int id);
}
<?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.ftz.Demo.dao.UserMapper">
<select id="getUserList" resultType="com.ftz.Demo.po.User">
select * from mybatis.user
</select>
<select id="getUserById" parameterType="int" resultType="com.ftz.Demo.po.User">
select * from mybatis.user where id = #{id}
</select>
<insert id="addUser" parameterType="com.ftz.Demo.po.User" >
insert into mybatis.user (id,name,pwd) values (#{id},#{name},#{pwd});
</insert>
<update id="updateUser" parameterType="com.ftz.Demo.po.User">
update mybatis.user set name = #{name},pwd=#{pwd} where id = #{id};
</update>
<delete id="deleteUser" parameterType="int">
delete from mybatis.user where id = #{id};
</delete>
</mapper>
SqlSession sqlSession = MybatisUtil.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
sqlSession.close();
sqlSession.commit();
package com.ftz.Demo.dao;
import com.ftz.Demo.po.User;
import com.ftz.Demo.utils.MybatisUtil;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.List;
public class UserDaoTest {
@Test
public void test() {
SqlSession sqlSession = MybatisUtil.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List<User> userList = mapper.getUserList();
for (User user : userList) {
System.out.println(user);
}
sqlSession.close();
}
@Test
public void getUserById(){
SqlSession sqlSession = MybatisUtil.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
User userById = mapper.getUserById(1);
System.out.println(userById);
sqlSession.close();
}
/**
* 增删改去要提交事务
*/
@Test
public void addUser(){
SqlSession sqlSession = MybatisUtil.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int number = mapper.addUser(new User(4, "邓家佳", "123321"));
//提交事务
sqlSession.commit();
sqlSession.close();
}
@Test
public void updateUser(){
SqlSession sqlSession = MybatisUtil.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
mapper.updateUser(new User(4, "笑嘻嘻", "12332112"));
//提交事务
sqlSession.commit();
sqlSession.close();
}
@Test
public void deleteUser(){
SqlSession sqlSession = MybatisUtil.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
mapper.deleteUser(4);
//提交事务
sqlSession.commit();
sqlSession.close();
}
}
版权说明 : 本文为转载文章, 版权归原作者所有 版权申明
原文链接 : https://blog.csdn.net/justleavel/article/details/122707308
内容来源于网络,如有侵权,请联系作者删除!