<setting>元素 maxRequest同时执行SQL语句最大线程数。默认512
maxSession 执行使用sqlMapClient时自动获得session。默认128
maxTransactions:同时进入SqlMapConfig.StartTransaction()。默认32
cachemodelsEnabled :全局性禁用或去启用SqlMapClient所有缓存。默认为true;启用
lazyLoadEnabled : 全局性禁用或启用延迟加载。默认为true;启用
enhancementEnabled:默认为false 不启用!
useStatementNamesspaces:全局限定名:就是/and.的区别。默认为false 为/
事务管理器别名:
JDBC JdbcTransactionconfig
JTA JtaTransactionconfig
EXTERNAL ExternalTransactionconfig
datasource
SIMPlE
DBCP
JNDI
insert插入! 给进去实体!ID不用给
update执行:可以是实体类。给定值就更新,不给定的保持原样子
多条件查询:
Map map = new HashMap();
map.put("password", "pangxin");
map.put("groupname", "ooo");
loginDbDao.selectByNames("getUserListByNames", map);
<parameterMap class="java.util.Map" id="selectMap">
<parameter property="password" javaType="String" mode="IN"
jdbcType="VARCHAR" />
<parameter property="groupname" javaType="String" mode="IN"
jdbcType="VARCHAR" />
</parameterMap>
<select id="getUserListByNames" parameterMap="selectMap" resultClass="com.tjpu.helen.entity.LoginEntity">
select * from user_count where password=? and groupname=?
</select>
sqlMapConfig
<?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>
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property value="com.mysql.jdbc.Driver" name="JDBC.Driver"/>
<property value="jdbc:mysql://localhost/ibatis" name="JDBC.ConnectionURL"/>
<property value="root" name="JDBC.Username"/>
<property value="shanghai" name="JDBC.Password"/>
</dataSource>
</transactionManager>
<sqlMap resource="userAccount.xml"/> 单体控制
</sqlMapConfig>
SqlMap
<?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>
<select id="getAllUsers" resultClass="hashmap"
parameterClass="string">
SELECT * FROM USER_ACCOUNT WHERE GROUPNAME=#groupName#
</select>
</sqlMap>
java
package com.air;
import com.ibatis.sqlmap.client.*;
import com.ibatis.common.resources.*;
import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;
public class Demo {
/**
* @param args
* @throws SQLException
*/
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub
String resource ="SqlMapConfig.xml";
Reader reader;
try {
reader = Resources.getResourceAsReader(resource);
SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
List list= sqlMap.queryForList("getAllUsers", "EMPLOYEE");
for (int i=0;i<list.size();i++){
System.out.println(list.get(i));
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}