User.xml

<?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="User">

    <resultMap id="resultMap" class="com.oneupthis.dataAccess.model.User">
        <result property="id" column="id" javaType="int"/>
        <result property="emailAddress" column="email_address"/>
        <result property="firstName" column="firstName"/>
        <result property="lastName" column="lastName"/>
        <result property="password" column="password"/>
    </resultMap>

    <insert id="insert" parameterClass="com.oneupthis.dataAccess.model.User">
        insert user
        (email_address, first_name, last_name, password)
        values
        (#emailAddress#, #firstName#, #lastName#, #password#);
        <selectKey resultClass="int">
            SELECT @@IDENTITY AS ID
        </selectKey>
    </insert>

    <select id="findAll" resultMap="resultMap">
        select * from user
    </select>

</sqlMap>