ibatis3 Configuration

最新推荐文章于 2022-05-11 21:37:32 发布

win_yee

最新推荐文章于 2022-05-11 21:37:32 发布

阅读量273

点赞数

CC 4.0 BY-SA版权

分类专栏：笔记文章标签： iBATIS log4j maven Apache HSQLDB

本文链接：https://blog.youkuaiyun.com/win_yee/article/details/83453840

笔记专栏收录该内容

8 篇文章

订阅专栏

本文详细介绍了如何使用Maven创建项目并整合MyBatis框架，包括配置依赖、编译插件支持、设置XML配置文件、定义映射文件等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.用maven 创建项目(俺用netbeans).
2.在pom.xml添加和修改.
dependencies:


<dependencies>
    <dependency>
            <groupId>org.apache.ibatis</groupId>
            <artifactId>ibatis-sqlmap</artifactId>
            <version>3.0-beta-2</version>
     </dependency>
<!-- others -->
</dependencies>

增加一个plugin, 支持java5


<build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <configuration>
                    <source>1.5</source>
                    <target>1.5</target>
                </configuration>
            </plugin>
        </plugins>
</build>

3.在src\main\resources下创建sqlmapconfig.xml


<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN"
  "http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
<configuration>
    <properties resource="blog-hsqldb.properties">

    </properties>
    <typeAliases>
        <typeAlias type="com.yy.ibatis.Blog" alias="Blog" />
    </typeAliases>
    <plugins>
        <plugin interceptor="com.yy.ibatis.BlogInterceptor">
            <property name="key" value="ABCD" />
            <property name="key2" value="CDEF" />
        </plugin>
    </plugins>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="map/BlogMapper.xml"/>
    </mappers>

</configuration>

创建blog-hsqldb.properties文件


driver=org.hsqldb.jdbcDriver
url=jdbc:hsqldb:testdb
username=sa
password=

创建log4j.properties配置文件


log4j.rootLogger=DEBUG, stdout

### Uncomment ALL for iBATIS logging
log4j.logger.org.apache.ibatis=DEBUG

log4j.logger.java.sql=DEBUG

### For Testing
log4j.logger.java.lang.Object=DEBUG

### Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

4.定义map文件


<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
    PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"
    "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="com.yy.ibatis.BlogMapper">
  <!-- 命名空间主要用来区分,并且,如果此名字同时时也是一个接口的完整名字的话,那么.... -->
  <select id="selectBlog" parameterType="int" resultType="Blog">
    select * from Blog where id = #{id}
  </select>
</mapper>