mybatis java_java之mybatis之使用mybatis实现crud操作

目录结构：

1.封装 mybatis 的工具类：

MybatisUtil.java

public classMybatisUtil {private static SqlSessionFactory getSqlSessionFactory() throwsIOException{

Reader reader= Resources.getResourceAsReader("mybatis.cfg.xml");return newSqlSessionFactoryBuilder().build(reader);

}public static SqlSession getSqlSession() throwsIOException{//填写参数 true表示事务自动提交

return getSqlSessionFactory().openSession(true);

}

}

2.vo类

User.java

1 public class User implementsSerializable{2 private intid;3 privateString name;4 private intage;5 public intgetId() {6 returnid;7 }8 public void setId(intid) {9 this.id =id;10 }11 publicString getName() {12 returnname;13 }14 public voidsetName(String name) {15 this.name =name;16 }17 public intgetAge() {18 returnage;19 }20 public void setAge(intage) {21 this.age =age;22 }23 @Override24 publicString toString() {25 return "User [id=" + id + ", name=" + name + ", age=" + age + "]";26 }27 }

View Code

3.映射文件

UserMapper.xml

/p>

PUBLIC"-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

select*from t_user

select* from t_user where id =#{id}

insert into t_user(name,age) values(#{name},#{age})

delete from t_user where id=#{id}

update t_user set name=#{name},age=#{age} where id=#{id}

4.核心配置文件

mybatis.cfg.xml

/p>

PUBLIC"-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

jdbc.properties

driver=com.mysql.jdbc.Driver

url=jdbc:mysql://localhost:3306/test

username=root

password=1111

5.测试

MybatisTest.java

public classMybatisTest {

@Testpublic void testAdd() throwsIOException{

User user= newUser();

user.setName("刘德华");

user.setAge(55);

SqlSession session=MybatisUtil.getSqlSession();//增 删 改 返回值为受影响的行数

session.insert("cn.sxt.vo.UserMapper.insertUser", user);

session.close();

}

@Testpublic void testUpdate() throwsIOException{

SqlSession session=MybatisUtil.getSqlSession();

User user=session.selectOne("cn.sxt.vo.UserMapper.selectUser", 1);

user.setName("彰五金");

session.update("cn.sxt.vo.UserMapper.updateUser",user);

session.close();

}

@Testpublic void testDelete() throwsIOException{

SqlSession session=MybatisUtil.getSqlSession();

session.delete("cn.sxt.vo.UserMapper.deleteUser", 3);

session.close();

}

@Testpublic void testFindAll() throwsIOException{

SqlSession session=MybatisUtil.getSqlSession();

List list = session.selectList("cn.sxt.vo.UserMapper.findAll");for(User u:list){

System.out.println(u);

}

session.close();

}

}