pom.xml:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.xf</groupId>
<artifactId>Mymybatis</artifactId>
<version>1.0-SNAPSHOT</version>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.7</maven.compiler.source>
<maven.compiler.target>1.7</maven.compiler.target>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<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.25</version>
</dependency>
</dependencies>
<build>
<!--解决xml没有到target-->
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
</resources>
</build>
</project>
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>
<typeAliases>
<typeAlias type="com.xf.mybatis.pojo.User" alias="user"/>
</typeAliases>
<!-- 配置MyBatis运行环境 -->
<environments default="development">
<environment id="development">
<!-- 配置JDBC事务管理 -->
<transactionManager type="JDBC"></transactionManager>
<!-- POOLED配置JDBC数据源连接池 -->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://120.78.195.41:3306/test?useUnicode=true&characterEncoding=UTF-8"/>
<property name="username" value="***"/>
<property name="password" value="***"/>
</dataSource>
</environment>
</environments>
<!--注册UserMapper.xml-->
<mappers>
<mapper resource="com/xf/mybatis/mapper/UserMapper.xml"/>
</mappers>
</configuration>
UserMapper.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.xf.mybatis.pojo.User">
<!-- resultMap标签:映射实体与表
type属性:表示实体全路径名
id属性:为实体与表的映射取一个任意的唯一的名字
-->
<!-- 当实体属性与表字段名不相同的时候,必须书写以下代码
当实体属性与表字段名相同的时候,以下代码可选
-->
<resultMap type="user" id="userMap">
<!-- id标签:映射主键属性
result标签:映射非主键属性
property属性:实体的属性名
column属性:表的字段名
-->
<id property="id" column="id"/>
<result property="username" column="username"/>
<result property="password" column="password"/>
<result property="age" column="age"/>
</resultMap>
<!-- 根据ID查询学生
如果参数不是一个实体的话,只是一个普通变量,例如:int,double,String
这里的#{中间的变量名可以随便写},不过提倡就用方法的形参
-->
<!--通过ID查找-->
<select id="get" parameterType="int" resultType="user">
select * from t_user where id=#{id}
</select>
<!--
insert标签:要书写insert这么一个sql语句
id属性:为insert这么一个sql语句取一个任意唯一的名字
parameterType:要执行的dao中的方法的参数,如果是类的话,必须使用全路径类
-->
<insert id="add1">
insert into t_user(id,username,password,age) values(8,'哈哈',7000,22)
</insert>
<!--添加-->
<insert id="add2" parameterType="user">
insert into t_user(id,username,password,age) values(#{id},#{username},#{password},#{age})
</insert>
<!--查找所有-->
<select id="findAll" resultType="user">
select * from t_user
</select>
<!--修改-->
<update id="update" parameterType="user">
update t_user set username=#{username},password=#{password},age=#{age} where id=#{id}
</update>
<!--删除-->
<delete id="delete" parameterType="user">
delete from t_user where id=#{id}
</delete>
<!-- 根据ID查询学生
mybatis会将查询出来的表记录和userMap这个id所对应的映射结果相互匹配
-->
<select id="findByIdTest" parameterType="int" resultMap="userMap">
select students_id,students_name,students_sal
from students
where students_id = #{xxxxxxxxxxxxxxxxxx}
</select>
</mapper>
MyBatisUtils:
package com.xf.mybatis.utils;
import java.io.IOException;
import java.io.Reader;
import java.sql.Connection;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
/*
* 工具类
* @author XF
*/
public class MybatisUtil {
private static ThreadLocal<SqlSession> threadLocal = new ThreadLocal<SqlSession>();
private static SqlSessionFactory sqlSessionFactory;
// 加载位于src/mybatis.xml配置文件
static{
try {
Reader reader = Resources.getResourceAsReader("config.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
} catch (IOException e) {
e.printStackTrace();
throw new RuntimeException(e);
}
}
// 禁止外界通过new方法创建
private MybatisUtil(){}
// 获取SqlSession
public static SqlSession getSqlSession(){
//从当前线程中获取SqlSession对象
SqlSession sqlSession = threadLocal.get();
//如果SqlSession对象为空
if(sqlSession == null){
//在SqlSessionFactory非空的情况下,获取SqlSession对象
sqlSession = sqlSessionFactory.openSession();
//将SqlSession对象与当前线程绑定在一起
threadLocal.set(sqlSession);
}
//返回SqlSession对象
return sqlSession;
}
// 关闭SqlSession与当前线程分开
public static void closeSqlSession(){
//从当前线程中获取SqlSession对象
SqlSession sqlSession = threadLocal.get();
//如果SqlSession对象非空
if(sqlSession != null){
//关闭SqlSession对象
sqlSession.close();
//分开当前线程与SqlSession对象的关系,目的是让GC尽早回收
threadLocal.remove();
}
}
// 测试
public static void main(String[] args) {
Connection conn = MybatisUtil.getSqlSession().getConnection();
System.out.println(conn!=null?"连接成功":"连接失败");
}
}
User:
package com.xf.mybatis.pojo;
public class User {
private int id;
private String username;
private String password;
private int age;
public User() {
}
public User(int id, String username, String password, int age) {
this.id = id;
this.username = username;
this.password = password;
this.age = age;
}
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;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
", age=" + age +
'}';
}
}
UserDao:
package com.xf.mybatis.Dao;
import com.xf.mybatis.pojo.User;
import com.xf.mybatis.utils.MybatisUtil;
import org.apache.ibatis.session.SqlSession;
import java.util.List;
public class UserDao {
/*
* 增加学生
*/
public void add1() throws Exception {
SqlSession sqlSession = null;
try {
sqlSession = MybatisUtil.getSqlSession();
//事务开始(默认)
//读取StudentMapper.xml映射文件中的SQL语句 名称空间+id
int i = sqlSession.insert(User.class.getName() + ".add1");
System.out.println("本次操作影响了" + i + "行");
//事务提交
sqlSession.commit();
} catch (Exception e) {
e.printStackTrace();
//事务回滚
sqlSession.rollback();
throw e;
} finally {
MybatisUtil.closeSqlSession();
}
}
/**
* 增加学生
*/
public void add2(User user) throws Exception {
SqlSession sqlSession = null;
try {
sqlSession = MybatisUtil.getSqlSession();
//事务开始(默认)
//UserMapper.xml映射文件中的SQL语句
sqlSession.insert(User.class.getName() + ".add2", user);
//事务提交
sqlSession.commit();
} catch (Exception e) {
e.printStackTrace();
//事务回滚
sqlSession.rollback();
throw e;
} finally {
MybatisUtil.closeSqlSession();
}
}
/**
* 通过id查找
*
* @param id
* @throws Exception
*/
public User findById(int id) throws Exception {
SqlSession sqlSession = null;
try {
sqlSession = MybatisUtil.getSqlSession();
User user = sqlSession.selectOne(User.class.getName() + ".get", id);
sqlSession.commit();
return user;
} catch (Exception e) {
e.printStackTrace();
sqlSession.rollback();
throw e;
} finally {
MybatisUtil.closeSqlSession();
}
}
/**
* 查找所有
*
* @return
* @throws Exception
*/
public List<User> findAll() throws Exception {
SqlSession sqlSession = null;
try {
sqlSession = MybatisUtil.getSqlSession();
return sqlSession.selectList(User.class.getName() + ".findAll");
} catch (Exception e) {
e.printStackTrace();
throw e;
} finally {
MybatisUtil.closeSqlSession();
}
}
/**
* 修改
* @param user
* @throws Exception
*/
public void update(User user) throws Exception {
SqlSession sqlSession = null;
try {
sqlSession = MybatisUtil.getSqlSession();
sqlSession.update(User.class.getName() + ".update", user);
sqlSession.commit();
} catch (Exception e) {
e.printStackTrace();
sqlSession.rollback();
throw e;
} finally {
MybatisUtil.closeSqlSession();
}
}
/**
* 删除
* @param user
* @throws Exception
*/
public void delete(User user) throws Exception {
SqlSession sqlSession = null;
try {
sqlSession = MybatisUtil.getSqlSession();
sqlSession.delete(User.class.getName()+".delete",user);
sqlSession.commit();
} catch (Exception e) {
e.printStackTrace();
sqlSession.rollback();
throw e;
} finally {
MybatisUtil.closeSqlSession();
}
}
public static void main(String[] args) throws Exception {
UserDao dao = new UserDao();
//dao.add1();
//dao.add2(new User(9,"谢飞","123",22));
//System.out.println(dao.findById(1));
/* List<User> users = dao.findAll();
for (User user:users){
System.out.println(user);
}*/
/* User user = dao.findById(1);
user.setUsername("测试");
dao.update(user);*/
/* User user = dao.findById(2);
dao.delete(user);*/
}
}
sql:
create table t_user(
id int primary key auto_increment,
username varchar(11),
password varchar(11),
age int
)
ok,完成