CREATE TABLE USER_ACCOUNT (

USERID INT(3) NOT NULL AUTO_INCREMENT,

USERNAME VARCHAR(10) NOT NULL,

PASSSWORD VARCHAR(30) NOT NULL,

GROUPNAME VARCHAR(10),

PRIMARY KEY (USERID)

);

CREATE TABLE USER_ACCOUNT (

USERID INT(3) NOT NULL AUTO_INCREMENT,

USERNAME VARCHAR(10) NOT NULL,

PASSSWORD VARCHAR(30) NOT NULL,

GROUPNAME VARCHAR(10),

PRIMARY KEY (USERID)

);

import com.ibatis.sqlmap.client.*;

import com.ibatis.common.resources.Resources;

import java.io.Reader;

import java.util.List;

public class Main {

public static void main(String arg[]) throws Exception {

String resource = "SqlMapConfig.xml";

Reader reader = Resources.getResourceAsReader (resource);

SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);

List list = sqlMap.queryForList("getAllUsers", "EMPLOYEE");

System.out.println("Selected " + list.size() + " records.");

for(int i = 0; i < list.size(); i++) {

System.out.println(list.get(i));

}

}

}

<?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 name="JDBC.Driver"

value="com.mysql.jdbc.Driver"/>

<property name="JDBC.ConnectionURL"

value="jdbc:mysql://localhost/test"/>

<property name="JDBC.Username"

value="root"/>

<property name="JDBC.Password"

value="wangwei"/>

</dataSource>

</transactionManager>

<sqlMap resource="SqlMap.xml" />

</sqlMapConfig>

<?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" parameterClass="string"

resultClass="hashmap">

SELECT * FROM USER_ACCOUNT WHERE GROUPNAME = #groupName#

</select>

</sqlMap>

  public List queryForList(String id, Object paramObject) throws SQLException {

    return getLocalSqlMapSession().queryForList(id, paramObject);

  }
  protected SqlMapSessionImpl getLocalSqlMapSession() {
    SqlMapSessionImpl sqlMapSession = localSqlMapSession.get();
    if (sqlMapSession == null || sqlMapSession.isClosed()) {
      sqlMapSession = new SqlMapSessionImpl(this);
      localSqlMapSession.set(sqlMapSession);
    }
    return sqlMapSession;
  }

  public List queryForList(String id, Object paramObject) throws SQLException {

    return delegate.queryForList(sessionScope, id, paramObject);

  }

  public List queryForList(SessionScope sessionScope, String id, Object paramObject) throws SQLException {

    return queryForList(sessionScope, id, paramObject, SqlExecutor.NO_SKIPPED_RESULTS, SqlExecutor.NO_MAXIMUM_RESULTS);

  }
  public List queryForList(SessionScope sessionScope, String id, Object paramObject, int skip, int max) throws SQLException {
    List list = null;

    MappedStatement ms = getMappedStatement(id);
    Transaction trans = getTransaction(sessionScope);
    boolean autoStart = trans == null;

    try {
      trans = autoStartTransaction(sessionScope, autoStart, trans);

      StatementScope statementScope = beginStatementScope(sessionScope, ms);
      try {
        list = ms.executeQueryForList(statementScope, trans, paramObject, skip, max);
      } finally {
        endStatementScope(statementScope);
      }

      autoCommitTransaction(sessionScope, autoStart);
    } finally {
      autoEndTransaction(sessionScope, autoStart);
    }

    return list;
  }