创建有mybatis的maven项目
创建maven项目
项目名输入
本地maven仓库所在地
main文件下创建两个文件夹java和resources
添加依赖
然后在pom.xml文件中添加mybatis依赖、mysql连接依赖
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
<scope>runtime</scope>
</dependency>
接下来创建数据库表
在java目录下创建实体类
class User
package entity;
public class User {
private Integer id;
private String userName;
private String password;
private Integer age;
private String address;
private String phoneNum;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", userName='" + userName + '\'' +
", password='" + password + '\'' +
", age=" + age +
", address='" + address + '\'' +
", phoneNum='" + phoneNum + '\'' +
'}';
}
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;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getPhoneNum() {
return phoneNum;
}
public void setPhoneNum(String phoneNum) {
this.phoneNum = phoneNum;
}
}
编写映射配置文件件userMapper.xml
在resources 目录下创建一个mapper文件夹,存放该映射文件
userMapper.xml内容
<?xml version='1.0' encoding='UTF-8'?>
<!-- 注:在书写mapper映射文件之前需要先引入此约束 -->
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--
mapper 是当前xml文件的根元素
需要通过namespace 属性指定当前mapper映射文件对应的DAO
注: 一个mapper映射文件对应一个DAO
-->
<mapper namespace="dao.UserDAO">
<!--
所有的sql语句都要书写在相应的sql标签中
select 标签: 查询
update: 修改
insert: 插入
delete ;删除
通用属性:
id : 指定对应的方法名
parameterType: 指定方法传入的数据类型
resultType: 指定返回的数据类型, 一般只有查询语句用
-->
<select id="findUserByUserName" parameterType="String" resultType="entity.User">
SELECT * FROM user WHERE user_name= #{userName}
</select>
</mapper>
书写核心配置文件mybatisconfig.xml
放置在resources文件夹下
mybatisconfig.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 为mybatis核心配置文件的根标签
-->
<configuration>
<environments default="mysql">
<!--配置对应数据库的连接环境,每个数据库都有一个对应的environment元素-->
<environment id="mysql">
<!-- 配置事务管理-->
<transactionManager type="JDBC"></transactionManager>
<!-- 配置数据库连接相关,POOLED表示数据为数据库连接池-->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mybatistest"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<!-- 指定映射配置文件的位置-->
<mappers>
<mapper resource="mapper/userMapper.xml"></mapper>
</mappers>
</configuration>
配置测试
在src文件夹下创建一个test文件夹,再创建一个java文件夹,java文件夹里面写一个class文件
```java
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;
import java.io.InputStream;
import java.util.List;
public class UserTest {
private SqlSession sqlSession;
private UserDAO userDAO;
@Before
public void init(){
InputStream inputStream = UserTest.class.getClassLoader().getResourceAsStream("mybatisconfig.xml");
//获取sqlSessionFactory对象
SqlSessionFactory build = new SqlSessionFactoryBuilder().build(inputStream);
//借助SqlSessionFactory 获取到sqlSession对象
sqlSession = build.openSession();
userDAO= sqlSession.getMapper(UserDAO.class);
}
@Test
public void test01(){
User user =(User) sqlSession.selectOne("dao.UserDAO.findUserByUserName", "zhangsan");
System.out.println(user);
}
}
顺便附上tomcat的配置过程
点击Add Configguration…
点击+号
选择Tomcat Server->Local
切换到deployment目录下
选择后点击ok然后apply