mybatis快速入门

来源：互联网发布：js 新建json对象编辑：程序博客网时间：2024/06/08 12:57

1，建工程，导入jar包：

mybatis-3.4.1.jar
mysql-connector-java-6.0.5-bin.jar

2，建表

CREATE DATABASE mybatis;

USE mybatis;

CREATE TABLE users(id INT PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(20), age INT);

INSERT INTO users(NAME, age) VALUES('Tom', 12);

INSERT INTO users(NAME, age) VALUES('Jack', 11);

3，添加mybatis配置文件conf.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?serverTimezone=UTC" /><property name="username" value="root" /><property name="password" value="123456" /></dataSource></environment></environments><mappers><mapper resource="com/zhuyun/mybatis/userMapper.xml" /></mappers></configuration>

4，新建User实体类

package com.zhuyun.mybatis;public class User {private int id;private String name;private int age;public User() {super();// TODO Auto-generated constructor stub}public User(int id, String name, int age) {super();this.id = id;this.name = name;this.age = age;}public int getId() {return id;}public void setId(int id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public int getAge() {return age;}public void setAge(int age) {this.age = age;}@Overridepublic String toString() {return "User [id=" + id + ", name=" + name + ", age=" + age + "]";}}

5，创建user表的sql映射文件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.zhuyun.mybatis.userMapper"><insert id="addUser" parameterType="User">insert into users(name,age) values(#{name}, #{age})</insert><delete id="deleteUser" parameterType="int">delete from users where id=#{id}</delete><update id="updateUser" parameterType="User">update users set name=#{name},age=#{age} where id=#{id}</update><select id="getUser" parameterType="int" resultType="User">select * from users where id = #{id}</select><select id="getAllUsers" resultType="User">select * from users</select></mapper>

6, 新建Test测试类

package com.zhuyun.mybatis;import java.io.InputStream;import java.util.List;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;public class Test {public static void main(String[] args) throws Exception {InputStream is = Test.class.getClassLoader().getResourceAsStream("conf.xml");SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is);//设置成自动提交，默认手动提交SqlSession session = sessionFactory.openSession(true);String statement = null;//添加statement = "com.zhuyun.mybatis.userMapper.addUser";int insert = session.insert(statement, new User(-1, "infi", 28));System.out.println(insert);//删除statement = "com.zhuyun.mybatis.userMapper.deleteUser";int delete = session.delete(statement, 9);System.out.println(delete);//查询statement = "com.zhuyun.mybatis.userMapper.getUser";User user = session.selectOne(statement,1);System.out.println(user);//修改statement = "com.zhuyun.mybatis.userMapper.updateUser";int update = session.update(statement, new User(10, "yinfei", 30));System.out.println(update);//查询所有statement = "com.zhuyun.mybatis.userMapper.getAllUsers";List<User> list = session.selectList(statement);System.out.println(list);session.close();}}

0 0