MyBatis HelloWorld

用MyBatis进行简单的增删改查

项目结构如下：

各部分代码

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration><!-- 引入配置信息文件 --><properties resource="mysql.properties" /><!-- 必须放在environments和properties之间，不然解析xml会发生错误 --><typeAliases><typeAlias alias="User" type="com.test.bean.User" /></typeAliases><environments default="demo"><environment id="demo"><transactionManager type="JDBC" /><dataSource type="POOLED"><property value="${driver}" name="driver" /><property value="${url}" name="url" /><property value="${username}" name="username" /><property value="${password}" name="password" /></dataSource></environment></environments><mappers><mapper resource="com/test/bean/UserMapper.xml" /></mappers></configuration>

mysql.properties

driver=com.mysql.jdbc.Driverurl=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8user=rootpassword=

log4j.properties用来打印日志和MyBatis的sql语句

log4j.rootLogger=DEBUG, Console#Consolelog4j.appender.Console=org.apache.log4j.ConsoleAppenderlog4j.appender.Console.layout=org.apache.log4j.PatternLayoutlog4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%nlog4j.logger.java.sql.ResultSet=INFOlog4j.logger.org.apache=INFOlog4j.logger.java.sql.Connection=DEBUGlog4j.logger.java.sql.Statement=DEBUGlog4j.logger.java.sql.PreparedStatement=DEBUG

User.java

package com.test.bean;import java.util.Date;public class User {private int uid;private String token;private String account;private String password;private String userName;private Date createdDate;public int getUid() {return uid;}public void setUid(int uid) {this.uid = uid;}public String getToken() {return token;}public void setToken(String token) {this.token = token;}public String getAccount() {return account;}public void setAccount(String account) {this.account = account;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public String getUserName() {return userName;}public void setUserName(String userName) {this.userName = userName;}public Date getCreatedDate() {return createdDate;}public void setCreatedDate(Date createdDate) {this.createdDate = createdDate;}@Overridepublic String toString() {return "-------\nuid:"+uid+"\ntoken:"+token+"\naccount:"+account+"\nuserName:"+userName+"\ncreatedDate:"+createdDate;}}

UserMapper.java 操作的接口类

package com.test.bean;import java.util.List;import org.apache.ibatis.annotations.Insert;import org.apache.ibatis.annotations.Select;import org.apache.ibatis.annotations.Update;public interface UserMapper {//****** 查询用户  ******public User selectUser(String id);@Select("select * from user where uid = #{id}") public User selectUser2(String id);@Select("select * from user where user_name like \"%\"#{name}\"%\"")public List<User> fuzzyQuery(String name);//****** 查询所有用户  ******public List<User> selectAll();//****** 插入用户  ******public int insertUser(User user);@Insert("insert into user(account,user_name,created_date) values(#{account},#{userName},now())")public int insertUser2(User user);//******* 修改用户  *******@Update("update user set user_name=#{userName} where uid=#{uid}")public int updateUser(User user);//******* 删除  *******@Update("delete from user where uid = #{id}")public int deleteUser(int id);//******* 批量插入  *******public int insertBatch(List list);}

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.test.bean.UserMapper"><sql id="userColuns"> uid,account,user_name </sql><!-- 查询 --><select id="selectUser" parameterType="java.lang.String" resultType="User">select <include refid="userColuns"/> from user where uid = #{id};</select><select id="selectAll" resultType="User">select * from user;</select><!-- 插入 --><insert id="insertUser" parameterType="User">insert into user(account,user_name,created_date) values(#{account},#{userName},now())</insert><!-- 批量插入 --><insert id="insertBatch" parameterType="java.util.List">insert into user(account,user_name,created_date) values<foreach collection="list" item="item" index="index" separator="," >(#{item.account},#{item.userName},now())</foreach></insert></mapper>  

测试类

Main.java

import java.io.IOException;import java.io.InputStream;import java.util.ArrayList;import java.util.List;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.apache.log4j.Logger;import com.test.bean.User;import com.test.bean.UserMapper;public class Main {private SqlSession session = null;private UserMapper userMapper = null;private final Logger log = Logger.getLogger(Main.class);public static void main(String[] args) {    new Main();}public Main(){session = initSession();userMapper = session.getMapper(UserMapper.class);testDelete();testUpdate();testInsert();testSelect();if(null != session){session.commit();session.close();}}private void testDelete(){System.out.println(userMapper.deleteUser(10000));}private void testUpdate(){User user = new User();user.setUid(10000);user.setUserName("修改");System.out.println(userMapper.updateUser(user));}private void testInsert(){User user = new User();user.setUid(10000);user.setAccount("aaaaa");user.setUserName("展示");System.out.println(user.toString());System.out.println(userMapper.insertUser2(user));//批量插入User u1 = new User();u1.setAccount("user1");u1.setUserName("user1");User u2 = new User();u2.setAccount("user3");u2.setUserName("user3");List<User> l = new ArrayList<User>();l.add(u1);l.add(u2);userMapper.insertBatch(l);}private void testSelect(){User user = userMapper.selectUser("10003");System.out.println(user.toString());user = userMapper.selectUser2("10000");System.out.println(user.toString());List<User> list = userMapper.selectAll();for(User u : list){System.out.println(u.toString());}List<User> list2 = userMapper.fuzzyQuery("展");for(User u : list2){System.out.println(u.toString());}}private SqlSession initSession(){//获取配置文件的输入流      InputStream is;try {is = Resources.getResourceAsStream("mybatis-config.xml");//获取我们的SqlSessionFactory（相当于Hibernate的SessionFactory）；SqlSessionFactoryBuilder有点类似于Hibernate的Configuration。      SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);      //获取一个Session      return sqlSessionFactory.openSession();} catch (IOException e) {e.printStackTrace();}return null;}}