ibatis3

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
        "http://www.ibatis.com/dtd/sql-map-2.dtd">

<sqlmap namespace="Account">

    <typealias alias="account" type="com.j2eegeek.ibatis.domain.Account"/>

    <resultmap id="accounts" class="account">
        <result property="userID" column="userid"/>
        <result property="email" column="email"/>
        <result property="firstName" column="firstname"/>
        <result property="lastName" column="lastname"/>
    </resultmap>

    <select id="getAccount" resultClass="accounts" parameterClass="java.lang.Integer">
        SELECT
        userid, email, firstname, lastname
        FROM jpetstore.account
        where
        userid = #value#
    </select>

</sqlmap>