其中配置文件如下:
Login.xml:
<sqlMap namespace="Login">
    <typeAlias alias="LoginActionForm" type="com.home.only.model.login.LoginActionForm" />
    <select id="getLoginSuccess" parameterClass="LoginActionForm" resultClass="LoginActionForm">
            select id 
              from logintb 
             where userno = #userno# and userpassword = #password#   
    </select>
</sqlMap>SqlMapConfig.xml:
<sqlMapConfig>
<settings cacheModelsEnabled="true" enhancementEnabled="true"
  lazyLoadingEnabled="true" errorTracingEnabled="true" maxRequests="32"
  maxSessions="10" maxTransactions="5" useStatementNamespaces="false"/>
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="org.postgresql.Driver"/>
<property name="JDBC.ConnectionURL" value="jdbc:postgresql://localhost:5432/postgres"/>
<property name="JDBC.Username" value="user"/>
<property name="JDBC.Password" value="user"/>
<property name="Pool.MaximumActiveConnections" value="10"/>
<property name="Pool.MaximumIdleConnections" value="5"/>
<property name="Pool.MaximumcheckouTime" value="120000"/>
<property name="Pool.TimeToWait" value="500"/>
<property name="Pool.PingQuery" value="select 1 from sample"/>
<property name="Pool.PingEnabled" value="false"/>
<property name="Pool.PingconnectionsOlderThan" value="1"/>
<property name="Pool.PingconnectionsNotUsedFor" value="1"/>
</dataSource>
</transactionManager>
<sqlMap resource="com/home/only/xml/Login.xml"/>
</sqlMapConfig>