今天完成的事情：

一、学习mybatis

1.案例学习mybatis连接数据库实现crud操作。MySQL数据库准备如下，

2.eclipse新建工程mybatis-test，添加外部依赖，项目文件目录如下

3.首先是config.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>

<typeAliases>

<typeAlias alias="User" type="com.yiibai.mybatis.models.User" />

</typeAliases>

<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/yiibai" />

   <property name="username" value="root" />

   <property name="password" value="1234" />

                       </dataSource>

</environment>

</environments>

<mappers>

    <!-- // power by http://www.yiibai.com -->

    <mapper resource="com/yiibai/mybatis/models/User.xml" />

</mappers>

</configuration>

4.新建User.java源文件与数据表中字段定义。

package com.yiibai.mybatis.models;

public class User {
    private int id;
    private String name;
    private String dept;
    private String phone;
    private String website;

    public String getWebsite() {
        return website;
    }
    public void setWebsite(String website) {
        this.website = website;
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }

4.新建User.xml文件主要作用是建立user源文件与数据库的映射及写入SQL的操作语句。

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.yiibai.mybatis.dao.IUser">

<select id="getUser" parameterType="int"
    resultType="com.yiibai.mybatis.models.User">
    SELECT *
    FROM USER
    WHERE id = #{userId}
</select>


<insert id="insertUser" parameterType="User">
    INSERT INTO USER(name,
                     dept, website,phone)
    VALUES(#{name}, #{dept}, #{website}, #{phone})
</insert>

<select id="getUserList" resultType="com.yiibai.mybatis.models.User">
    SELECT * FROM USER
</select>

<update id="updateUser" parameterType="User">
    UPDATE USER
    SET
            name=
       #{name},
    dept = #{dept},
    website = #{website},
    phone = #{phone}
    WHERE
           id =
       #{id}
</update>

<delete id="deleteUser" parameterType="int">
    DELETE FROM USER WHERE id = #{id}
</delete>

5.新建IUser接口，定义增删改查抽象方法。

package com.yiibai.mybatis.dao;
import java.util.List;
import org.apache.ibatis.annotations.*;

import com.yiibai.mybatis.models.User;
/**
 * @author yiibai.com
 */
public interface IUser {
    //@Select("select * from user where id= #{id}")
    //public User getUserByID(int id);
    public List<User> getUserList();

    public void insertUser(User user);

    public void updateUser(User user);

    public void deleteUser(int userId);

    public User getUser(int id);
}

6.最后写Main.java来测试运行

import java.io.Reader;
import java.text.MessageFormat;
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.yiibai.mybatis.dao.IUser;
import com.yiibai.mybatis.models.User;

public class Main {
    private static SqlSessionFactory sqlSessionFactory;
    private static Reader reader;

    static {
        try {
            reader = Resources.getResourceAsReader("config.xml");
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static SqlSessionFactory getSession() {
        return sqlSessionFactory;
    }

    /**
     * @param args
     */
    public static void main(String[] args) {
        // TODO Auto-generated method stub
        SqlSession session = sqlSessionFactory.openSession();
        try {
            //sqlSessionFactory.getConfiguration().addMapper(IUser.class);
            //User user = (User) session.selectOne( "com.yiibai.mybatis.models.UserMapper.getUserByID", 1);

            // 用户数据列表
            getUserList();
            // 插入数据
            testInsert();

            // 更新用户
            //testUpdate();

            // 删除数据
            //testDelete();

        } finally {
            session.close();
        }
    }

    //
    public static void testInsert()
    {
        try
        {
            // 获取Session连接
            SqlSession session = sqlSessionFactory.openSession();
            // 获取Mapper
            IUser userMapper = session.getMapper(IUser.class);
            System.out.println("Test insert start...");
            // 执行插入
            User user = new User();
            user.setId(0);
            user.setName("Google");
            user.setDept("Tech");
            user.setWebsite("http://www.google.com");
            user.setPhone("120");
            userMapper.insertUser(user);
            // 提交事务
            session.commit();

            // 显示插入之后User信息
            System.out.println("After insert");
            getUserList();
            System.out.println("Test insert finished...");
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }

    // 获取用户列表
    public static void getUserList() {
        try {
            SqlSession session = sqlSessionFactory.openSession();
            IUser iuser = session.getMapper(IUser.class);
            // 显示User信息
            System.out.println("Test Get start...");
            printUsers(iuser.getUserList());
            System.out.println("Test Get finished...");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void testUpdate()
    {
        try
        {
            SqlSession session = sqlSessionFactory.openSession();
            IUser iuser = session.getMapper(IUser.class);
            System.out.println("Test update start...");
            printUsers(iuser.getUserList());
            // 执行更新
            User user = iuser.getUser(1);
            user.setName("New name");
            iuser.updateUser(user);
            // 提交事务
            session.commit();
            // 显示更新之后User信息
            System.out.println("After update");
            printUsers(iuser.getUserList());
            System.out.println("Test update finished...");
        }catch (Exception e)
        {
            e.printStackTrace();
        }
    }

    // 删除用户信息
    public static void testDelete()
    {
        try
        {
            SqlSession session = sqlSessionFactory.openSession();
            IUser iuser = session.getMapper(IUser.class);
            System.out.println("Test delete start...");
            // 显示删除之前User信息
            System.out.println("Before delete");
            printUsers(iuser.getUserList());
            // 执行删除
            iuser.deleteUser(2);
            // 提交事务
            session.commit();
            // 显示删除之后User信息
            System.out.println("After delete");
            printUsers(iuser.getUserList());
            System.out.println("Test delete finished...");
        }catch (Exception e)
        {
            e.printStackTrace();
        }
    }

    /**
     *
     * 打印用户信息到控制台
     *
     * @param users
     */
    private static void printUsers(final List<User> users) {
        int count = 0;

        for (User user : users) {
            System.out.println(MessageFormat.format(
                    "============= User[{0}]=================", ++count));
            System.out.println("User Id: " + user.getId());
            System.out.println("User Name: " + user.getName());
            System.out.println("User Dept: " + user.getDept());
            System.out.println("User Website: " + user.getWebsite());
        }
    }
}

测试结果如下：

Test Get start...

Sun Sep 17 22:47:15 CST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

============= User[1]=================

User Id: 1

User Name: 张三

User Dept: 科技部

User Website: www.tech001.com

============= User[2]=================

User Id: 2

User Name: Google

User Dept: Tech

User Website: http://www.google.com

============= User[3]=================

User Id: 3

User Name: Google

User Dept: Tech

User Website: http://www.google.com

============= User[4]=================

User Id: 4

User Name: Google

User Dept: Tech

User Website: http://www.google.com

----------------------------------分割线-----------------------------------------------------------

二、配置上述项目测试Tomcat服务

1.Tomcat安装配置参考教程http://jingyan.baidu.com/article/870c6fc33e62bcb03fe4be90.html

2.Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.

百度该问题经测试不是版本的问题，暂未解决。

明天的计划的事情：   

1.学习spring框架，学习单元测试Junit

遇到的问题：

暂无

收获：

还没来得及总结jdbcTemplate 和Mybatis的不同点，明天抽时间做一下。