Ibatis 1-准备环境

搭建环境：导入相关的jar包

配置文件：
1.jdbc链接的属性文件(properties文件)
2.总配置文件(SqlMapConfig.xml)
3.关于每个实体的映射文件（map文件）

 

1. jdbc.properties

 

driver= 数据库驱动包 url= 链接 url username= 数据库登录名 password= 数据库登录密码

 

2.SqlMapConfig.xml

 

<? xml version = "1.0" encoding = "UTF-8" ?>   <! DOCTYPE sqlMapConfig           PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"           "http://ibatis.apache.org/dtd/sql-map-config-2.dtd" >     < sqlMapConfig >       < properties resource = "resources/SqlMap.properties" />       < transactionManager type = "JDBC" commitRequired = "false" >             < dataSource type = "SIMPLE" >                   < property name = "JDBC.Driver" value = "${driver}" />                   < property name = "JDBC.ConnectionURL" value = "${url}" />                   < property name = "JDBC.Username" value = "${username}" />                   < property name = "JDBC.Password" value = "${password}" />             </ dataSource >       </ transactionManager >       < sqlMap resource = "com/jxhuang/beginer/Account.xml" /> </ sqlMapConfig >

 

3. Account.xml (map)

 

<? xml version = "1.0" encoding = "UTF-8" ?> <! DOCTYPE sqlMap           PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"           "http://ibatis.apache.org/dtd/sql-map-2.dtd" > < sqlMap namespace = "Account" >       <!-- POJO class -->       < typeAlias alias = "Account" type = "com.jxhuang.beginer.bean.Account" />         < select id = "selectAllAccounts" resultClass = "Account" >       <![CDATA[             select *             from t_account       ]]>       </ select > </ sqlMap >