Mybatis的CRUD（增删改查）
1.pom.xml
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.41</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
</dependencies>
2.SqlMapperConfig.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPEconfiguration
PUBLIC"-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<!--mybatis的主配置文件-->
<configuration>
<!--配置环境-->
<environments default="mysql">
<!--配置mysql环境-->
<environment id="mysql">
<!--配置事务的类型-->
<transactionManager type="JDBC"></transactionManager>
<!--配置数据源（连接池）-->
<dataSource type="POOLED">
<!--配置连接数据库的4个基本信息-->
<property name="driver" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/zml?useUnicode=true&characterEncoding=utf-8"></property>
<property name="username" value="root"></property>
<property name="password" value="root"></property>
</dataSource>
</environment>
</environments>
<!--指定映射配置文件的位置，映射配置文件指的是每个dao独立的配置文件-->
<mappers>
<mapper resource="dao/UserDao.xml"></mapper>
</mappers>
</configuration>
3.Users.java
package entity;
public class Users {
private int id;
private String username;
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public String toString() {
return "Users{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
}
4.UserVo.java
package entity;
public class UserVo {
private Users users;
public Users getUsers() {
return users;
}
public void setUsers(Users users) {
this.users = users;
}
}
5.UserDao.java
package dao;
import entity.UserVo;
import entity.Users;
import java.util.List;
public interface UserDao {
List<Users> findAll();
Users find(int id);
void save(Users users);
void update(Users users);
void delete(int id);
List<Users> findVague(String name);
int count();
List<Users> findVo(UserVo vo);
}
6.UserDao.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPEmapper
PUBLIC"-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="dao.UserDao">
<!--查询所有-->
<select id="findAll" resultType="entity.Users">
select * from users
</select>
<!--根据ID查询-->
<select id="find" resultType="entity.Users">
select * from users where id=#{id}
</select>
<!--增加-->
<insert id="save" parameterType="entity.Users">
<!--查询新增用户的ID-->
<selectKey keyProperty="id" keyColumn="id" resultType="int" order="AFTER">
select last_insert_id()
</selectKey>
insert into users(username,password) values(#{username},#{password})
</insert>
<!--根据ID进行修改-->
<update id="update" parameterType="entity.Users">
update users set username=#{username},password=#{password} where id=#{id}
</update>
<!--根据ID进行删除-->
<delete id="delete" parameterType="entity.Users">
delete from users where id=#{id}
</delete>
<!--模糊查询-->
<select id="findVague" resultType="entity.Users">
-- select * from users where username like '%${value}%'
select * from users where username like #{name}
</select>
<!--查询用户总数-->
<select id="count" resultType="int">
select count(id) from users
</select>
<!--将实体类封装到另一个实体类中的模糊查询-->
<select id="findVo" resultType="entity.Users">
select * from users where username like #{users.username}
</select>
</mapper>
7.UserTest.java
package test;
import dao.UserDao;
import entity.UserVo;
import entity.Users;
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.After;
import org.junit.Before;
import org.junit.Test;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class UserTest {
private InputStream in;
private SqlSession sqlSession;
private UserDao UserDaoImpl;
@Before
public void init() throws IOException {
//1.读取配置文件
in= Resources.getResourceAsStream("SqlMapperConfig.xml");
//2.创建SqlSessionFactory工厂
SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
SqlSessionFactory factory=builder.build(in);
//3.使用工厂生产SqlSession对象
sqlSession=factory.openSession();
//4.使用SqlSession创建dao接口的代理对象
UserDaoImpl=sqlSession.getMapper(UserDao.class);
}
@After
public void destroy() throws IOException {
//提交事务
sqlSession.commit();
//6.释放资源
sqlSession.close();
in.close();
}
/**
* 查询所有
* @throws IOException
*/
@Test
public void findall() throws IOException {
//5.使用代理对象执行方法
List<Users> users=UserDaoImpl.findAll();
for(Users u:users){
System.out.println(u);
}
}
/**
* 增加
*/
@Test
public void save(){
Users users=new Users();
users.setUsername("哈哈哈");
users.setPassword("456");
UserDaoImpl.save(users);
}
/**
* 根据ID查询并修改
*/
@Test
public void update(){
Users u=UserDaoImpl.find(15);
u.setPassword("456");
u.setUsername("小喵");
UserDaoImpl.update(u);
}
/**
* 根据id进行删除
*/
@Test
public void delete(){
UserDaoImpl.delete(16);
}
/**
* 模糊查询，查询所有名字中有小的用户
* @throws IOException
*/
@Test
public void findVague() throws IOException {
//5.使用代理对象执行方法
List<Users> users=UserDaoImpl.findVague("%小%");
for(Users u:users){
System.out.println(u);
}
}
/**
* 查询用户总数
*/
@Test
public void count(){
int c=UserDaoImpl.count();
System.out.println(c);
}
/**
* 将实体类封装到另一个实体类中的模糊查询
*/
@Test
public void findVo(){
UserVo vo=new UserVo();
Users users=new Users();
users.setUsername("%小%");
vo.setUsers(users);
List<Users> list=UserDaoImpl.findVo(vo);
for(Users u:list){
System.out.println(u);
}
}
}
