Ibatis+JDBC+Mysql数据库访问

1. 添加ibatis的jar包依赖

<dependency>
    <groupId>org.apache.ibatis</groupId>
    <artifactId>ibatis-sqlmap</artifactId>
    <version>2.3.4.726</version>
</dependency>
<dependency>
    <groupId>com.ibatis</groupId>
    <artifactId>ibatis-common</artifactId>
    <version>2.1.0.565</version>
</dependency>

2. 新建ibatis-jdbc-config.xml文件配置db数据源以及指定DO和表的sql映射关系文件路径

如果http://www.ibatis.com/dtd/sql-map-config-2.dtd文件找不到，请自行百度下载到本地目录，然后在idea的preference中搜索DTD标签页进行配置：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
    <settings
            cacheModelsEnabled ="true"
            lazyLoadingEnabled="true"
            enhancementEnabled="true"
            errorTracingEnabled="true"
            maxRequests="1000"
            maxSessions="800"
            maxTransactions="500"
            useStatementNamespaces="true&#