myBatis实例应用（基于配置文件）

今天初步学习了下myBatis框架，现在把学习过程总结下。

一、创建数据库表。

DROP TABLE IF EXISTS `tb_user`;CREATE TABLE `tb_user` (  `id` int(10) NOT NULL AUTO_INCREMENT,  `username` varchar(40) DEFAULT NULL,  `password` varchar(40) DEFAULT NULL,  `email` varchar(40) DEFAULT NULL,  `age` int(10) DEFAULT NULL,  `sex` char(2) DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

二、创建项目

1、项目结构图

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2、创建实体类User

package com.firstbatis.entity;public class User {private int id;private String username;private String password;private String sex;private String email;private int 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 String getSex() {return sex;}public void setSex(String sex) {this.sex = sex;}public String getEmail() {return email;}public void setEmail(String email) {this.email = email;}public int getAge() {return age;}public void setAge(int age) {this.age = age;}}

3、创建UserDao接口

package com.firstbatis.dao;import java.util.List;import com.firstbatis.entity.User;public interface UserDao {public int insert(User user);public int update(User user);public int delete(String username);public List<User> selectAll();public int countAll();public User findByUserName(String userName);}

4、创建UserDaoMapper.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.firstbatis.dao.UserDao"><select id="countAll" resultType="int">select count(*)  from tb_user</select><select id="selectAll" resultType="com.firstbatis.entity.User">select * from tb_user order by username asc</select><insert id="insert" parameterType="com.firstbatis.entity.User">insert into tb_user(username,password,email,sex,age) values(#{username},#{password},#{email},#{sex},#{age})</insert><update id="update" parameterType="com.firstbatis.entity.User">update tb_user set username=#{username},password=#{password},email=#{email},sex=#{sex},age=#{age} where username=#{username}</update><delete id="delete" parameterType="String">delete from tb_user where username=#{username}</delete><select id="findByUserName" parameterType="String" resultType="com.firstbatis.entity.User">select * from tb_user where username=#{username}</select></mapper>

5、创建MyBatis-Configuration.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/bk_shop?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull"/><property name="username" value="root"/><property name="password" value="123456"/></dataSource></environment></environments><mappers><mapper resource="com/firstbatis/dao/UserDaoMapper.xml"/></mappers></configuration>

6、创建主测试类

package com.firstbatis.test;import java.io.Reader;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 com.firstbatis.dao.UserDao;import com.firstbatis.entity.User;public class MybatisHandler {public static void main(String[] args) throws Exception{String resource = "MyBatis-Configuration.xml";Reader reader = Resources.getResourceAsReader(resource);SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();SqlSessionFactory factory = builder.build(reader);SqlSession session = factory.openSession();UserDao userDao = session.getMapper(UserDao.class);User user = new User();user.setUsername("zhaozp");user.setPassword("test1234");user.setEmail("[e-mail]");user.setSex("男");user.setAge(24);userDao.insert(user);System.out.println("数据库中的记录数:" +userDao.countAll());User usn = userDao.findByUserName("zhaozp");if(usn!=null){System.out.println("检索用户信息["+usn.getId()+","+ usn.getUsername()+","+ usn.getPassword()+","+ usn.getEmail()+","+ usn.getAge()+","+ usn.getSex());}User updUser = new User();updUser.setUsername("chensh");updUser.setPassword("update");updUser.setEmail("[e-mail]");updUser.setSex("女");updUser.setAge(26);List<User> list = userDao.selectAll();for(int i=0;i<list.size();i++){User us=list.get(i);System.out.println("用户信息"+i+"["+us.getId()+","+ us.getUsername()+","+ us.getPassword()+","+ us.getEmail()+","+ us.getAge()+","+ us.getSex());}userDao.delete("zhaozp");System.out.println("执行删除后数据库中的记录数:" + userDao.countAll());session.commit();}}