一、环境配置
首先导入下载好的mybatis包(下载请看上篇博客https://blog.csdn.net/kshon/article/details/82698914)
将mybatis-3.4.6.jar和lib目录下的jar包全导入到项目中,不导入lib中的jar包会报日志错误。
注意:由于mybatis是基于JDBC实现的,所以需要导入jdbc的jar包
二、编写配置文件
1、在src/pojo目录下新建User.java类
package pojo;
public class User {
private Integer id;
private String name;
private String sex;
private Integer age;
public User(){super();}
public User(String name,String sex,Integer age){
this.name = name;
this.sex = sex;
this.age = age;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
}
2、编写User类的映射文件UserMapper.xml,跟User.java位于同级目录下,在映射文件中配置了增删改查四个功能
<?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="pojo.UserMapper">
<insert id="saveUser" parameterType="pojo.User" useGeneratedKeys="true">
INSERT INTO USER(name,sex,age) VALUES(#{name},#{sex},#{age})
</insert>
<select id="selectUser" parameterType="int" resultType="user">
SELECT * FROM USER WHERE id=#{id}
</select>
<update id="updateUser" parameterType="user">
UPDATE USER SET
name = #{name}, sex = #{sex}, age = #{age}
WHERE id = #{id}
</update>
<delete id="deleteUser" parameterType="int">
DELETE FROM USER WHERE id=#{id}
</delete>
</mapper>
3、编写mybatis的配置文件mybatis-config.xml,直接位于src目录下即可,注意数据库配置
<?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>
<setting name="logImpl" value="LOG4J"/>
</settings>
<!-- 环境配置 -->
<environments default="mysql">
<environment id="mysql">
<!-- 指定事务管理类型 -->
<transactionManager type="JDBC" />
<!-- 配置数据源,POOLED是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告诉mybatis找持久化类的映射文件 -->
<mappers>
<mapper resource="pojo/UserMapper.xml"/>
</mappers>
</configuration>
4、编写日志的配置文件log4j.properties,同样是位于src目录下,与mybatis的配置文件同级
log4j.rootLogger=DEBUG,Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.org.apache=INFO
三、增删改查
由于每次操作都要读取mybatis-config.xml根配置文件,然后创建SqlSessionFactory对象生成SqlSession,操作比较比较频繁,所以先开发一个工厂类封装以上操作,在src/factory包下创建MyFactory.java
package factory;
import java.io.IOException;
import java.io.InputStream;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
public class MyFactory {
private static SqlSessionFactory ssf = null;
static{
try {
InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
ssf = new SqlSessionFactoryBuilder().build(is);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//获取SqlSession的静态方法
public static SqlSession getSqlSession(){
return ssf.openSession();
}
//获取SqlSessionFactory的静态方法
public static SqlSessionFactory getSqlSessionFactory(){
return ssf;
}
}
现在数据库中创建mybatis数据库,然后创建user表,表的字段对应User.java中的属性
1、增
在src目录下新建test包,然后新建InsertTest.java
package test;
import org.apache.ibatis.session.SqlSession;
import factory.MyFactory;
import pojo.User;
public class InsertTest {
public static void main(String[] args) {
// TODO Auto-generated method stub
//获取SqlSession实例
SqlSession session = MyFactory.getSqlSession();
//创建User对象
User user = new User("小王","男",22);
//插入到数据库,第一个参数对应User映射文件中的命名空间+语句id
session.insert("pojo.UserMapper.saveUser",user);
//提交事务
session.commit();
//关闭session
session.close();
}
}
右键,运行java Application,可看到控制台输出
可以从数据库中看到增加了一条数据,我这里应该是中文编码有问题
2、查
在test包下新建SelectTest.java
package test;
import factory.MyFactory;
import pojo.User;
import org.apache.ibatis.session.SqlSession;
public class SelectTest {
public static void main(String[] args) {
// TODO Auto-generated method stub
//获取SqlSession
SqlSession session = MyFactory.getSqlSession();
//根据id查询一个User对象
User user = session.selectOne("pojo.UserMapper.selectUser", 1);
System.out.println(user.getId()+"-"+user.getName()+"-"+user.getAge());
//提交事务
session.commit();
//关闭session
session.close();
}
}
运行后可查看控制台
3、改
在test包下新建UpdateTest.java
package test;
import org.apache.ibatis.session.SqlSession;
import factory.MyFactory;
import pojo.User;
public class UpdateTest {
public static void main(String[] args) {
// TODO Auto-generated method stub
//获取SqlSession
SqlSession session = MyFactory.getSqlSession();
//根据id查询一个User对象
User user = session.selectOne("pojo.UserMapper.selectUser", 1);
//修改user的值
user.setAge(99);
user.setSex("女");
//更新user
session.update("pojo.UserMapper.updateUser",user);
//提交事务
session.commit();
//关闭session
session.close();
}
}
运行后看到控制台
查看数据库,年龄更新到99了
4、删
在test包下新建DeleteTest.java
package test;
import org.apache.ibatis.session.SqlSession;
import factory.MyFactory;
import pojo.User;
public class DeleteTest {
public static void main(String[] args) {
// TODO Auto-generated method stub
//获取SqlSession实例
SqlSession session = MyFactory.getSqlSession();
//删除id为1的user对象
session.delete("pojo.UserMapper.deleteUser",1);
//提交事务
session.commit();
//关闭session
session.close();
}
}
运行后可以看到控制台输出
查看数据库,已经为空表了