mybatis mysql demo_Idea搭建mybatis环境demo

这两天看看mybatis，这个轻量级orm框架，看后面把它整合进项目中。把JDBC分离出来。这里只是简单环境搭建，未涉及原理。

1.创建工程

这里为了方便直接用一个模板

创建完毕

2.引入mybatis所需jar包

org.mybatis

mybatis

3.4.1

mysql

mysql-connector-java

6.0.6

//测试相关

junit

junit

4.12

//日志相关

log4j

log4j

1.2.17

org.slf4j

slf4j-log4j12

1.7.25

3.创建一个实体类对应数据字段，并在数据库中创建对应的数据表

public class User implementsSerializable {private static final long serialVersionUID = 8104961490512068314L;private intid;privateString name;privateString dept;privateString phone;privateString website;public intgetId() {returnid;

}public void setId(intid) {this.id =id;

}publicString getName() {returnname;

}public voidsetName(String name) {this.name =name;

}publicString getDept() {returndept;

}public voidsetDept(String dept) {this.dept =dept;

}publicString getPhone() {returnphone;

}public voidsetPhone(String phone) {this.phone =phone;

}publicString getWebsite() {returnwebsite;

}public voidsetWebsite(String website) {this.website =website;

}

@OverridepublicString toString() {return "User{" +

"id=" + id +

", name='" + name + '\'' +

", dept='" + dept + '\'' +

", phone='" + phone + '\'' +

", website='" + website + '\'' +

'}';

}

}

4.添加mysql配置文件，mybatis配置文件

mybatis-config.xml

mysql.properties:

jdbc.databaseurl=jdbc:mysql:///javaweb_community?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false

jdbc.driver=com.mysql.cj.jdbc.Driver

jdbc.username=root

jdbc.password=

jdbc.maxActive=100

jdbc.maxWait=5000

jdbc.filters=wall,stat

ps: 这里mysql的jar包版本在6.0以上的和以前版本有一点差异。

5.添加mapper类接口以及对应mapper.xml

packagecom.mybatis.demo.mapper;importcom.mybatis.demo.Entity.User;public interfaceUserMapper {

User GetUserByID(Integer id)throwsException;

}

select * from `user` where id = #{id}

6.在配置文件中注册该xml.

7.编写单元测试，通过sqlSession 操作数据库

public classAppTest

{/*** Rigorous Test :-)*/@Testpublic voidshouldAnswerWithTrue()

{try{//使用MyBatis提供的Resources类加载mybatis的配置文件

Reader reader = Resources.getResourceAsReader("mybatis/mybatis-config.xml");//构建sqlSession的工厂

SqlSessionFactory sessionFactory = newSqlSessionFactoryBuilder().build(reader);

SqlSession session=sessionFactory.openSession();

UserMapper mapper=session.getMapper(UserMapper.class);

User user= mapper.GetUserByID(1);

System.out.println(user.toString());

session.commit();

}catch(Exception e) {

e.printStackTrace();

}

}

}