MyBatis框架

第2章 MyBatis HelloWorld

2.1 开发环境的准备

  • 导入MyBatis框架的jar包、Mysql驱动包、log4j的jar包

 

myBatis-3.4.1.jar

mysql-connector-java-5.1.37-bin.jar

log4j.jar

  • 导入log4j 的配置文件

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

 

<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">

 

 <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">

   <param name="Encoding" value="UTF-8" />

   <layout class="org.apache.log4j.PatternLayout">

    <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS} %m  (%F:%L) \n" />

   </layout>

 </appender>

 <logger name="java.sql">

   <level value="debug" />

 </logger>

 <logger name="org.apache.ibatis">

   <level value="info" />

 </logger>

 <root>

   <level value="debug" />

   <appender-ref ref="STDOUT" />

 </root>

</log4j:configuration>

 

 

2.2 创建测试表

-- 创建库

CREATE DATABASE test_mybatis;

-- 使用库

USE test_mybatis;

-- 创建表

CREATE TABLE tbl_employee(

   id INT(11) PRIMARY KEY AUTO_INCREMENT,

   last_name VARCHAR(50),

   email VARCHAR(50),

   gender CHAR(1)

);

2.3 创建javaBean

public class Employee {

 

         private Integer id ;

         private String lastName;

         private String email ;

         private String gender ;

         public Integer getId() {

                   return id;

         }

         public void setId(Integer id) {

                   this.id = id;

         }

         public String getLastName() {

                   return lastName;

         }

         public void setLastName(String lastName) {

                   this.lastName = lastName;

         }

         public String getEmail() {

                   return email;

         }

         public void setEmail(String email) {

                   this.email = email;

         }

         public String getGender() {

                   return gender;

         }

         public void setGender(String gender) {

                   this.gender = gender;

         }

         @Override

         public String toString() {

                   return "Employee [id=" + id + ", lastName=" + lastName + ", email=" + email + ", gender=" + gender + "]";

         }