ibatis 学习笔记

<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();
		}

	}

}