mybatis入门
1.创建java web项目
2.添加mybatis的jar包和mysql的驱动jar包
3.在数据库中创建一个数据库,并创建一个测试的数据表user并添加数据
4.添加user 的java类
package com.xiaopeng.model;
public class User {
private int id;
private String username;
private String userAge;
private String userAddress;
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 getUserAge() {
return userAge;
}
public void setUserAge(String userAge) {
this.userAge = userAge;
}
public String getUserAddress() {
return userAddress;
}
public void setUserAddress(String userAddress) {
this.userAddress = userAddress;
}
@Override
public String toString() {
return "User [id=" + id + ", username=" + username + ", userAge=" + userAge + ", userAddress=" + userAddress
+ "]";
}
}
5.添加mybatis的mapper配置文件user.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.xiaopeng.dao.UserMapper">
<select id="getUser" resultType="com.xiaopeng.model.User">
select * from user where id = #{id}
</select>
</mapper>
6.添加mybatis的配置文件mybatis-config.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>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mapper/user.xml"/>
</mappers>
</configuration>
7.添加mybatis的工具类MyBatisUtil 用来创建SqlSessionFactory
package com.xiaopeng.mybatisutil;
import java.io.IOException;
import java.io.InputStream;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
/**
* 创建sqlsessionfactor
* @author PengChan
*
*/
public class MyBatisUtil {
private static SqlSessionFactory sqlSessionFactory = null;
public static SqlSessionFactory getSqlSessionFactory(){
InputStream inputStream = null;
if(sqlSessionFactory==null){
String resource = "config/mybatis-config.xml";
try {
sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream(resource));
return sqlSessionFactory;
} catch (IOException e) {
e.printStackTrace();
}
}
return sqlSessionFactory;
}
}
优化可以只用单利模式来创建sqlsessionfactory
package com.xiaopeng.mybatisutil;
import java.io.IOException;
import java.io.InputStream;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
/**
* 创建sqlsessionfactor
* 使用单例模式创建SqlSessionFactory
* @author PengChan
*
*/
public class MyBatisUtil {
private static SqlSessionFactory sqlSessionFactory = null;
private static final Class CLASS_LOCK = MyBatisUtil.class;
private MyBatisUtil(){
}
public static SqlSessionFactory getSqlSessionFactory(){
InputStream inputStream = null;
String resource = "config/mybatis-config.xml";
synchronized (CLASS_LOCK) {
if(sqlSessionFactory==null){
try {
sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream(resource));
} catch (IOException e) {
e.printStackTrace();
}
}
}
return sqlSessionFactory;
}
}
8.添加测试类运行测试
package comxiaopeng.test;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import com.xiaopeng.dao.UserMapper;
import com.xiaopeng.model.User;
import com.xiaopeng.mybatisutil.MyBatisUtil;
public class MyTest {
@Test
public void testDemo01(){
SqlSession sqlSession=null;
try {
sqlSession = MyBatisUtil.getSqlSessionFactory().openSession();
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User user = userMapper.getUser(1L);
System.out.println(user);
} catch (Exception e) {
e.printStackTrace();
}
}
}
9.运行结果