ibatis3 Configuration
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 configurationPUBLIC "-//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.jdbcDriverurl=jdbc:hsqldb:testdbusername=sapassword=
创建log4j.properties配置文件
log4j.rootLogger=DEBUG, stdout### Uncomment ALL for iBATIS logginglog4j.logger.org.apache.ibatis=DEBUGlog4j.logger.java.sql=DEBUG### For Testinglog4j.logger.java.lang.Object=DEBUG### Console output...log4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.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>
页:
[1]