There is no statement named...错误, 使用了abator

0 0

There is no statement named...错误, 使用了abator5

红色为感觉程序用到的部分. 命名对比认为没有问题, 不知道哪里错了...

错误信息:

com.ibatis.sqlmap.client.SqlMapException: There is no statement named WAP_USERS.abatorgenerated_selectByExample in this SqlMap.
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.getMappedStatement(SqlMapExecutorDelegate.java:231)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:558)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94)
at com.hnmcc.wap.dao.UsersDAOImpl.selectByExample(UsersDAOImpl.java:69)
at com.hnmcc.wap.bean.dbDemo.main(dbDemo.java:38)

dbDemo.jsp

public class dbDemo {

	/**
	 * @param args
	 * @throws Exception 
	 */
	public static void main(String[] args) throws IOException {

		String resource = "com/hnmcc/wap/entity/WAP_USERS_SqlMap.xml";
		SqlMapClient sqlMap = null;
		try
		{
			Reader reader = Resources.getResourceAsReader(resource);
			sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		
		try
		{
			UsersExample ue = new UsersExample();
			ue.setOrderByClause("ID");
			UsersDAOImpl dao = new UsersDAOImpl(sqlMap);
			List ls = dao.selectByExample(ue);
			for(Object obj : ls)
			{
				Users user = (Users)obj;
				System.out.println("id : " + user.getId());
				System.out.println("username : " + user.getUsername());
				System.out.println("passowrd : " + user.getPassword());
				System.out.println("role : " + user.getRole());
				System.out.println();
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			sqlMap = null;
		}
		
	}
}

UsersDAOImpl.java

public class UsersDAOImpl implements UsersDAO {

    private SqlMapClient sqlMapClient;

    public UsersDAOImpl(SqlMapClient sqlMapClient) {
        super();
        this.sqlMapClient = sqlMapClient;
    }

    public void insert(Users record) throws SQLException {
        sqlMapClient.insert("WAP_USERS.abatorgenerated_insert", record);
    }

    public int updateByPrimaryKey(Users record) throws SQLException {
        int rows = sqlMapClient.update("WAP_USERS.abatorgenerated_updateByPrimaryKey", record);
        return rows;
    }

    public int updateByPrimaryKeySelective(Users record) throws SQLException {
        int rows = sqlMapClient.update("WAP_USERS.abatorgenerated_updateByPrimaryKeySelective", record);
        return rows;
    }

    public List selectByExample(UsersExample example) throws SQLException {
        List list = sqlMapClient.queryForList("WAP_USERS.abatorgenerated_selectByExample", example);
        return list;
    }

    public Users selectByPrimaryKey(BigDecimal id) throws SQLException {
        Users key = new Users();
        key.setId(id);
        Users record = (Users) sqlMapClient.queryForObject("WAP_USERS.abatorgenerated_selectByPrimaryKey", key);
        return record;
    }

    public int deleteByExample(UsersExample example) throws SQLException {
        int rows = sqlMapClient.delete("WAP_USERS.abatorgenerated_deleteByExample", example);
        return rows;
    }

    public int deleteByPrimaryKey(BigDecimal id) throws SQLException {
        Users key = new Users();
        key.setId(id);
        int rows = sqlMapClient.delete("WAP_USERS.abatorgenerated_deleteByPrimaryKey", key);
        return rows;
    }

    public int countByExample(UsersExample example) throws SQLException {
        Integer count = (Integer)  sqlMapClient.queryForObject("WAP_USERS.abatorgenerated_countByExample", example);
        return count.intValue();
    }

    public int updateByExampleSelective(Users record, UsersExample example) throws SQLException {
        UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
        int rows = sqlMapClient.update("WAP_USERS.abatorgenerated_updateByExampleSelective", parms);
        return rows;
    }

    public int updateByExample(Users record, UsersExample example) throws SQLException {
        UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
        int rows = sqlMapClient.update("WAP_USERS.abatorgenerated_updateByExample", parms);
        return rows;
    }

    private static class UpdateByExampleParms extends UsersExample {
        private Object record;

        public UpdateByExampleParms(Object record, UsersExample example) {
            super(example);
            this.record = record;
        }

        public Object getRecord() {
            return record;
        }
    }
}

WAP_USERS_SqlMap.xml

<!---->

<sqlmap namespace="WAP_USERS">
  <resultmap id="abatorgenerated_UsersResult" class="com.hnmcc.wap.entity.Users">
    <!---->
    <result column="ID" property="id" jdbctype="DECIMAL">
    <result column="USERNAME" property="username" jdbctype="VARCHAR">
    <result column="PASSWORD" property="password" jdbctype="VARCHAR">
    <result column="ROLE" property="role" jdbctype="DECIMAL">
  </resultmap>
  <sql id="abatorgenerated_Example_Where_Clause">
    <!---->
    <iterate property="oredCriteria" conjunction="or" prepend="where" removefirstprepend="iterate">
      <isequal property="oredCriteria[].valid" comparevalue="true">
        (
        <iterate prepend="and" property="oredCriteria[].criteriaWithoutValue" conjunction="and">
          $oredCriteria[].criteriaWithoutValue[]$
        </iterate>
        <iterate prepend="and" property="oredCriteria[].criteriaWithSingleValue" conjunction="and">
          $oredCriteria[].criteriaWithSingleValue[].condition$
            #oredCriteria[].criteriaWithSingleValue[].value#
        </iterate>
        <iterate prepend="and" property="oredCriteria[].criteriaWithListValue" conjunction="and">
          $oredCriteria[].criteriaWithListValue[].condition$
          <iterate property="oredCriteria[].criteriaWithListValue[].values" open="(" close=")" conjunction=",">
            #oredCriteria[].criteriaWithListValue[].values[]#
          </iterate>
        </iterate>
        <iterate prepend="and" property="oredCriteria[].criteriaWithBetweenValue" conjunction="and">
          $oredCriteria[].criteriaWithBetweenValue[].condition$
          #oredCriteria[].criteriaWithBetweenValue[].values[0]# and
          #oredCriteria[].criteriaWithBetweenValue[].values[1]#
        </iterate>
        )
      </isequal>
    </iterate>
  </sql>
  <select id="Abatorgenerated_selectByPrimaryKey">
    <!---->
    select ID, USERNAME, PASSWORD, ROLE
    from WAP.USERS
    where ID = #id:DECIMAL#
  </select>
  <select id="abatorgenerated_selectByExample">
    <!---->
    select ID, USERNAME, PASSWORD, ROLE
    from WAP.USERS
    <isparameterpresent>
      <include refid="WAP_USERS.abatorgenerated_Example_Where_Clause">
      <isnotnull property="orderByClause">
        order by $orderByClause$
      </isnotnull>
    </isparameterpresent>
  </select>
  <delete id="abatorgenerated_deleteByPrimaryKey" parameterclass="com.hnmcc.wap.entity.Users">
    <!---->
    delete from WAP.USERS
    where ID = #id:DECIMAL#
  </delete>
  <delete id="abatorgenerated_deleteByExample" parameterclass="com.hnmcc.wap.entity.UsersExample">
    <!---->
    delete from WAP.USERS
    <include refid="WAP_USERS.abatorgenerated_Example_Where_Clause">
  </delete>
  <insert id="abatorgenerated_insert" parameterclass="com.hnmcc.wap.entity.Users">
    <!---->
    insert into WAP.USERS (ID, USERNAME, PASSWORD, ROLE)
    values (#id:DECIMAL#, #username:VARCHAR#, #password:VARCHAR#, #role:DECIMAL#)
  </insert>
  <update id="abatorgenerated_updateByPrimaryKey" parameterclass="com.hnmcc.wap.entity.Users">
    <!---->
    update WAP.USERS
    set USERNAME = #username:VARCHAR#,
      PASSWORD = #password:VARCHAR#,
      ROLE = #role:DECIMAL#
    where ID = #id:DECIMAL#
  </update>
  <update id="abatorgenerated_updateByPrimaryKeySelective" parameterclass="com.hnmcc.wap.entity.Users">
    <!---->
    update WAP.USERS
    <dynamic prepend="set">
      <isnotnull prepend="," property="username">
        USERNAME = #username:VARCHAR#
      </isnotnull>
      <isnotnull prepend="," property="password">
        PASSWORD = #password:VARCHAR#
      </isnotnull>
      <isnotnull prepend="," property="role">
        ROLE = #role:DECIMAL#
      </isnotnull>
    </dynamic>
    where ID = #id:DECIMAL#
  </update>
  <select id="abatorgenerated_countByExample">
    <!---->
    select count(*) from WAP.USERS
    <include refid="WAP_USERS.abatorgenerated_Example_Where_Clause">
  </select>
  <update id="abatorgenerated_updateByExampleSelective">
    <!---->
    update WAP.USERS
    <dynamic prepend="set">
      <isnotnull prepend="," property="record.id">
        ID = #record.id:DECIMAL#
      </isnotnull>
      <isnotnull prepend="," property="record.username">
        USERNAME = #record.username:VARCHAR#
      </isnotnull>
      <isnotnull prepend="," property="record.password">
        PASSWORD = #record.password:VARCHAR#
      </isnotnull>
      <isnotnull prepend="," property="record.role">
        ROLE = #record.role:DECIMAL#
      </isnotnull>
    </dynamic>
    <isparameterpresent>
      <include refid="WAP_USERS.abatorgenerated_Example_Where_Clause">
    </isparameterpresent>
  </update>
  <update id="abatorgenerated_updateByExample">
    <!---->
    update WAP.USERS
    set ID = #record.id:DECIMAL#,
      USERNAME = #record.username:VARCHAR#,
      PASSWORD = #record.password:VARCHAR#,
      ROLE = #record.role:DECIMAL#
    <isparameterpresent>
      <include refid="WAP_USERS.abatorgenerated_Example_Where_Clause">
    </isparameterpresent>
  </update>
</sqlmap>

abatorConfig.xml

<!---->

<abatorconfiguration>
  <abatorcontext>
    <jdbcconnection driverclass="oracle.jdbc.driver.OracleDriver" connectionurl="jdbc:oracle:thin:@192.168.0.103:1521:orcl10g" userid="wap" password="wap">
      <classpathentry location="G:\oracle\product\10.1.0\Db_1\jdbc\lib\ojdbc14.jar">
    </jdbcconnection>
    <javamodelgenerator targetpackage="com.hnmcc.wap.entity" targetproject="WAP">
    <sqlmapgenerator targetpackage="com.hnmcc.wap.entity" targetproject="WAP">
    <daogenerator targetpackage="com.hnmcc.wap.dao" targetproject="WAP" type="GENERIC-CI">
    
    
  </abatorcontext>
</abatorconfiguration>

iBATIS