ibatis-beiyou

<dao-config>
  <context name="MySQLDaoManager" default="true">
    <transaction-pool implementation="com.ibatis.db.dao.jdbc.SqlMapDaoTransactionPool">
      <property name="sql-map-config-file" value="sql-map-config-db.xml"/>
    </transaction-pool>
    <dao-factory>
        <dao name="User" implementation="ibatis.dao.UserDao"/>
		<dao name="UserPic" implementation="ibatis.dao.UserPicDao"/>
		
	</dao-factory>
  </context>

• user.xml

<sql-map name="User">
    <result-map name="result" class="ibatis.entity.User">
		<property name="id" column="id"/>
		<property name="username" column="username"/>
		<property name="percent" column="percent"/>
	</result-map>

<mapped-statement name="getUserByInUid" result-map="result">
		<![CDATA[
			select  id, nickname from user where id in ($inUid$)
		]]>
	</mapped-statement>

<mapped-statement name="updateUser">
		<![CDATA[
		update user set
			username=#username#,
			password=#password#,
			nickname=#nickname#,
			grade=#grade#,
			createtime=#createtime#,
			action=#action#
		where id=#id#
		]]>
	</mapped-statement>
</sql-map>

 

public List getUserByInUid(String inUid) throws DaoException{
        return this.executeQueryForList("getUserByInUid", inUid);
    }

 

public void updateUser(User user) throws DaoException{
        this.executeUpdate("updateUser", user);
    }