/*創(chuàng)建Visitor*/
CREATE TABLE Visitor
(
  Id INT(11) NOT NULL AUTO_INCREMENT,
  Name VARCHAR(1000) NOT NULL,
  Email VARCHAR(1000) NOT NULL,
  Status INT NOT NULL DEFAULT 1,
  CreateTime DateTime,
  PRIMARY KEY(Id)
)
/*創(chuàng)建網(wǎng)站表*/
CREATE TABLE Website
(
  Id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  Name VARCHAR(1000) NOT NULL,
  VisitorId INT REFERENCES Visitor(Id),
  Status INT NOT NULL DEFAULT 1,
  CreateTime DateTime
)

/*創(chuàng)建頻道表*/
CREATE TABLE Channel
(
  Id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  Name VARCHAR(1000) NOT NULL,
  WebsiteId INT REFERENCES Website(Id),
  Status INT NOT NULL DEFAULT 1,
  CreateTime DateTime
)

<?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>
  <typeAliases>
    <typeAlias type="david.mybatis.model.Visitor" alias="Visitor" />
  </typeAliases>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"></transactionManager>
      <dataSource type="POOLED">
        <property name="driver" value="com.mysql.jdbc.Driver" />
        <!-- ?useUnicode=true&amp;characterEncoding=utf8為了支持中文插入 -->
        <property name="url"
          value="jdbc:mysql://127.0.0.1:3306/mybatis_db?useUnicode=true&amp;characterEncoding=utf8" />
        <property name="username" value="root" />
        <property name="password" value="123456" />
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="mapper/VisitorMapper.xml" />
  </mappers>
</configuration>

package david.mybatis.demo;

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;

import david.mybatis.model.CRUD_Enum;

public class MybatisUtils {

  private static final String CONFIG_PATH = "config/mybatis_demo_config.xml";

  /*
   * 獲取數(shù)據(jù)庫訪問鏈接
   */
  public static SqlSession getSqlSession() {
    SqlSession session = null;
    try {
      InputStream stream = Resources.getResourceAsStream(CONFIG_PATH);
      //可以根據(jù)配置的相應(yīng)環(huán)境讀取相應(yīng)的數(shù)據(jù)庫環(huán)境
      // SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(
      // stream, "development"); 
      SqlSessionFactory factory = new SqlSessionFactoryBuilder()
          .build(stream);
      session = factory.openSession();
    } catch (Exception e) {
      // TODO: handle exception
      e.printStackTrace();
    }
    return session;
  }

  /*
   * 獲取數(shù)據(jù)庫訪問鏈接
   */
  public static void closeSession(SqlSession session) {
    session.close();
  }
  
  /*
   * 返回操作記錄消息
   */
  public static void showMessages(CRUD_Enum type, int count) {
    switch (type) {
    case Add:
      System.out.println("添加了" + count + "條記錄。");
      break;
    case Delete:
      System.out.println("刪除了" + count + "條記錄。");
      break;
    case Update:
      System.out.println("更新了" + count + "條記錄。");
      break;
    case Query:
      System.out.println("匹配了" + count + "條記錄。");
      break;
    case List:
      System.out.println("共有" + count + "條記錄。");
      break;
    default:
      break;
    }
  }
}

package david.mybatis.model;

import java.text.SimpleDateFormat;
import java.util.Date;

public class Visitor {
  private int id;
  private String name;
  private String email;
  private int status;
  private Date createTime;

  public Visitor() {
    // TODO Auto-generated constructor stub
    createTime = new Date();
  }

  public Visitor(String name, String email) {
    this.name = name;
    this.email = email;
    this.status = 1;
    this.createTime = new Date();
  }

  public int getId() {
    return id;
  }

  public void setName(String name) {
    this.name = name;
  }

  public String getName() {
    return name;
  }

  public void setEmail(String email) {
    this.email = email;
  }

  public String getEmail() {
    return email;
  }

  public Date getCreateTime() {
    return createTime;
  }

  @Override
  public String toString() {
    // TODO Auto-generated method stub
    return String.format("{Id: %d, Name: %s, CreateTime: %s}", id, name,
        new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(createTime));
  }
}

<mapper namespace="david.mybatis.demo.IVisitorOperation">
  <select id="basicQuery" parameterType="int" resultType="Visitor">
    select * from visitor where id=#{id} and
    Status>0 order by Id
  </select>
</mapper>

 public static void testBasicQuery(int id) {
    SqlSession session = MybatisUtils.getSqlSession();
    try {
      Visitor visitor = (Visitor) session.selectOne("david.mybatis.demo.IVisitorOperation.basicQuery", id);
      MybatisUtils.closeSession(session);
      System.out.println(visitor);
    } catch (Exception e) {
      // TODO: handle exception
    }
  }