我们可以在工具类创建的时候实现自动提交事务
public static SqlSession getSqlSession(){
//设置自动提交事务为true
return sqlSessionFactory.openSession(true);
}
关于@Param()注解
- 基本类型的参数或者String类型,需要使用该注解;
- 引用类型不使用该注解;
- 如果只有一个基本类型的话,可以忽略,但是建议加上该注解;
- 我们在SQL中引用的就是@Param()中设定的属性名。
#{}与${}的区别
https://www.cnblogs.com/wwct/p/12994340.html
1、查询(select)
-
注解在接口上实现;
package com.beyond.dao; import com.beyond.pojo.User; import org.apache.ibatis.annotations.Select; import java.util.List; public interface UserMapper { //方法存在多个基本类型参数时,所有的参数前面必须加上@Param()注解,并且{}里面的参数与@Param()的参数一一对应 @Select("select * from user where id=#{uid}") User getUserById(@Param("uid") int id); }
-
需要在核心配置文件中绑定接口;
<mappers> <mapper class="com.beyond.dao.UserMapper"/> </mappers>
-
测试
package com.beyond.dao; import com.beyond.pojo.User; import com.beyond.utils.MyBatisUtil; import org.apache.ibatis.session.SqlSession; import org.junit.Test; import java.util.List; public class UserMapperTest{ @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(); } }
2、插入(insert)
-
注解在接口上实现;
package com.beyond.dao; import com.beyond.pojo.User; import org.apache.ibatis.annotations.Select; import java.util.List; public interface UserMapper { //引用类型的参数不需要@Param()注解 @Insert("insert into user(id,name,pwd) values (#{id},#{name},#{password})") int addUser(User user); }
-
需要在核心配置文件中绑定接口;
<mappers> <mapper class="com.beyond.dao.UserMapper"/> </mappers>
-
测试
package com.beyond.dao; import com.beyond.pojo.User; import com.beyond.utils.MyBatisUtil; import org.apache.ibatis.session.SqlSession; import org.junit.Test; import java.util.List; public class UserMapperTest{ @Test public void addUser(){ SqlSession sqlSession = MyBatisUtil.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); mapper.addUser(new User(5,"玲玲","yhicioc")); sqlSession.close(); } }
3、修改(update)
-
注解在接口上实现;
package com.beyond.dao; import com.beyond.pojo.User; import org.apache.ibatis.annotations.Select; import java.util.List; public interface UserMapper { @Update("update mybatis.user set name=#{name},pwd=#{password} where id=#{id}") int updateUser(User user); }
-
需要在核心配置文件中绑定接口;
<mappers> <mapper class="com.beyond.dao.UserMapper"/> </mappers>
-
测试
package com.beyond.dao; import com.beyond.pojo.User; import com.beyond.utils.MyBatisUtil; import org.apache.ibatis.session.SqlSession; import org.junit.Test; import java.util.List; public class UserMapperTest{ @Test public void updateUser(){ //1、获得SqlSession对象 SqlSession sqlSession= MyBatisUtil.getSqlSession(); //2、执行SQL //方式一:getMapper UserMapper mapper = sqlSession.getMapper(UserMapper.class); mapper.updateUser(new User(2,"张飞","uiioop")); //关闭SqlSession sqlSession.close(); } }
4、删除(delete)
-
注解在接口上实现;
package com.beyond.dao; import com.beyond.pojo.User; import org.apache.ibatis.annotations.Select; import java.util.List; public interface UserMapper { @Delete("delete from mybatis.user where id=#{id}") void deleteUser(@Param("id") int id); }
-
需要在核心配置文件中绑定接口;
<mappers> <mapper class="com.beyond.dao.UserMapper"/> </mappers>
-
测试
package com.beyond.dao; import com.beyond.pojo.User; import com.beyond.utils.MyBatisUtil; import org.apache.ibatis.session.SqlSession; import org.junit.Test; import java.util.List; public class UserMapperTest{ @Test public void deleteUser(){ //1、获得SqlSession对象 SqlSession sqlSession= MyBatisUtil.getSqlSession(); //2、执行SQL //方式一:getMapper UserMapper mapper = sqlSession.getMapper(UserMapper.class); mapper.deleteUser(2); //关闭SqlSession sqlSession.close(); } }