Mybatis使用注解开发
流程简介:
- mybatis核心配置文件的编写
- mybatis工具类的编写
- 实体类的编写
- dao层接口的实现
- 测试
1.mybatis核心配置文件的编写
<?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>
<settings>
<setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>
<environments default="mysql">
<environment id="mysql">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql:///mybatis?serverTimezone=UTC"/>
<property name="username" value="root"/>
<property name="password" value="1234"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper class="com.momo.dao.UserDao"/>
</mappers>
</configuration>
此时mybatis核心配置文件中mapper绑定的为dao层的接口
2.Mybatis工具类的编写
package com.momo.utils;
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 java.io.IOException;
import java.io.InputStream;
public class MybatisUtils {
static SqlSessionFactory sqlSessionFactory;
static {
String path = "mybatis-config.xml";
try {
InputStream is = Resources.getResourceAsStream(path);
SqlSessionFactoryBuilder ssfb = new SqlSessionFactoryBuilder();
sqlSessionFactory = ssfb.build(is);
} catch (IOException e) {
e.printStackTrace();
}
}
public static SqlSession getSqlSession(){
return sqlSessionFactory.openSession();
}
}
3.实体类的编写
package com.momo.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private int id;
private String name;
private String pwd;
}
4.dao层接口的实现
package com.momo.dao;
import com.momo.entity.User;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import java.util.List;
public interface UserDao {
//查所有
@Select("select * from user")
public List<User> findUser();
//增
@Insert("insert into user values (#{id},#{name},#{pwd})")
public int addUser(User user);
//删
@Delete("delete from user where id = #{id}")
public int deleteUser(int id);
//改
@Update("update user set name = #{name},pwd = #{pwd} where id = #{id}")
public int updateUser(User user);
}
5.测试
package com.momo.test;
import com.momo.dao.UserDao;
import com.momo.entity.User;
import com.momo.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.After;
import org.junit.Before;
import java.util.List;
public class Test {
private SqlSession sqlSession;
private UserDao userDao;
@Before
public void init(){
sqlSession = MybatisUtils.getSqlSession();
userDao = sqlSession.getMapper(UserDao.class);
}
@After
public void close(){
sqlSession.close();
}
@org.junit.Test
public void test1(){
List<User> teacherAll =
userDao.findUser();
teacherAll.forEach(System.out::println);
}
@org.junit.Test
public void test2(){
int xx = userDao.addUser(new User(11, "王大", "666"));
sqlSession.commit();
System.out.println(xx);
}
@org.junit.Test
public void test3(){
int i = userDao.deleteUser(11);
sqlSession.commit();
System.out.println(i);
}
@org.junit.Test
public void test4(){
int xx = userDao.updateUser(new User(10, "王大", "777"));
sqlSession.commit();
System.out.println(xx);
}
}
注意:
@Select("select * from account where id = #{aa}")
public Account findAccountById(String name,@Param("aa") int id);
/*
#{aa} : 就是占位符,里面的单词是啥不是特别重要,会根据方法中参数的顺序一一赋值。如果顺序和占位符的顺序不同,就需要加一个注解。
在参数前面 @Param("占位符里的那个单词")
*/
@Insert("insert into account(id,name,money) values(#{id},#{name},#{money})")
public int saveAccount(Account account);
/*
当参数是 对象 或者是 Map 的时候,这里的占位符里面的单词不是乱起的
对象: 和属性名称一致
Map : 和key 一致。
*/
@Param(“id”)
1.基本类型或者 String类型就加上这个注解。
2.引用类型不需要加
3.如果只有一个参数,并且是基本类型或者String,可以不加,但是建议加上。