目录
在java文件夹中创建entity文件夹,编写entity层实体类User
在java文件夹中创建dao文件夹,编写dao层文件UserDao
在resources文件夹中配置SqlMapConfig.xml配置文件
在resources文件夹中创建mapper文件夹,然后编写UserDao.xml文件
在test文件夹下的java文件夹内编写测试类UserTest
在pom.xml中引入依赖
<dependencies>
<!--mybatis核心包-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<!--mysql驱动包-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
</dependency>
<!-- 单元测试 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.10</version>
</dependency>
<!-- 日志 -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
</dependencies>
在java文件夹中创建entity文件夹,编写entity层实体类User
package com.mine.entity;
import java.io.Serializable;
import java.util.Date;
public class User {
private Integer id;
private String username;
private Date birthday;
private String sex;
private String address;
public User() {
}
public User(String a1, String 男, String 北京) {
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
@Override
public String toString() {
return "--执行结果-->" +
"User{" +
"id=" + id +
", username='" + username + '\'' +
", birthday=" + birthday +
", sex='" + sex + '\'' +
", address='" + address + '\'' +
'}';
}
}
在java文件夹中创建dao文件夹,编写dao层文件UserDao
package com.mine.dao;
import com.mine.entity.User;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface UserDao {
public List<User> findAll();
List<User> selectUserByNameAndSex(User user);
int insert(User user);
int update(User user);
List<User> selectUserByChoose(User user);
int deleteByArray(@Param("ids") Integer[] ids);
}
在resources文件夹中配置SqlMapConfig.xml配置文件
<?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>
<!--设置mybatis的输出日志-->
<!--logImpl:表示对日志的控制-->
<!--STDOUT_LOGGING:将日志输出到控制台上-->
<setting name="logImpl" value="STDOUT_LOGGING"/>
<!--指定哪些方法去触发延迟加载,hashCode,equals,clone,toString-->
<setting name="lazyLoadTriggerMethods" value=""/>
</settings>
<environments default="mysql">
<environment id="mysql">
<!--配置事务的类型,使用本地事务策略-->
<transactionManager type="JDBC"></transactionManager>
<!--是否使用连接池 POOLED表示使用链接池,UNPOOLED表示不使用连接池-->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis_demo?characterEncoding=utf8"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mapper/StudentDao.xml"/>
<mapper resource="mapper/TeacherDao.xml"/>
<mapper resource="mapper/UserDao.xml"/>
</mappers>
</configuration>
在resources文件夹中创建mapper文件夹,然后编写UserDao.xml文件
<?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.mine.dao.UserDao">
<select id="findAll" resultType="com.mine.entity.User">
select * from user
</select>
<select id="selectUserByNameAndSex" parameterType="com.mine.entity.User" resultType="com.mine.entity.User">
select * from user where
<if test="username !=null and username !=''">
username = #{username}
</if>
<if test="sex !=null and sex !=''" >
and sex = #{sex}
</if>
</select>
<insert id="insert" parameterType="com.mine.entity.User">
insert into student(username,birthday,sex,address) values (#{username},#{birthday},#{sex},#{address})
</insert>
<update id="update" parameterType="com.mine.entity.User">
update user
<trim prefix="set" suffixOverrides=",">
<if test="username !=null and username !=''">
username = #{username} ,
</if>
<if test="address !=null and address !=''">
address = #{address} ,
</if>
<if test="birthday !=null and birthday !=''">
birthday = #{birthday} ,
</if>
<if test="sex !=null and sex !=''">
sex = #{sex}
</if>
</trim>
where id = #{id}
</update>
<select id="selectUserByChoose" resultType="com.mine.entity.User" parameterType="com.mine.entity.User">
select * from user
<where>
<choose>
<when test="username !=null and username !=''">
username = #{username}
</when>
<when test="address !=null and address !=''">
and address = #{address}
</when>
<otherwise>
and sex = #{sex}
</otherwise>
</choose>
</where>
</select>
</mapper>
在test文件夹下的java文件夹内编写测试类UserTest
import com.mine.dao.UserDao1;
import com.mine.entity.User;
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.Arrays;
import java.util.Date;
import java.util.List;
public class UserTest {
private InputStream in = null;
private SqlSession session = null;
private UserDao1 mapper = null;
@Before //前置通知, 在方法执行之前执行
public void init() throws IOException {
//加载主配置文件,目的是为了构建SqlSessionFactory对象
in = Resources.getResourceAsStream("SqlMapConfig.xml");
//创建SqlSessionFactory对象
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
//通过SqlSessionFactory工厂对象创建SqlSesssion对象
session = factory.openSession();
//通过Session创建UserDao接口代理对象
mapper = session.getMapper(UserDao1.class);
}
@After //@After: 后置通知, 在方法执行之后执行 。
public void destory() throws IOException {
//释放资源
session.close();
in.close();
}
/**
* 测试所有的方法
*/
@Test
public void findAll() throws IOException {
List<User> users = mapper.findAll();
for (User user:users) {
System.out.println(user.toString());
}
}
@Test
public void selectUserByNameAndSex(){
User user = new User();
// user.setUsername("admin");
user.setSex("男");
List<User> users = mapper.selectUserByNameAndSex(user);
for (User user1: users
) {
System.out.println(user1.toString());
}
}
@Test
public void insert(){
User user = new User();
user.setSex("女");
user.setUsername("小红");
user.setAddress("M78星云");
mapper.insert(user);
session.commit();
}
@Test
public void update(){
User user = new User();
user.setId(1);
user.setSex("女");
user.setUsername("小黑");
mapper.update(user);
session.commit();
}
@Test
public void deleteMoreByArray(){
int result = mapper.deleteByArray(new Integer[]{6,7,8});
session.commit();
System.out.println(result);
}
}