ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Okan Çetin" <okance...@gmail.com>
Subject select statement problem
Date Fri, 08 Sep 2006 20:12:27 GMT
Hello;
I could not getting something from db. list object does not contain any
value.  Do you have any idea ?
The code and xml map files:

1) Code

            List list;
            Reader reader = Resources.getResourceAsReader
("com/data/SqlMapConfig.xml");
            SqlMapClient sqlMapper =
SqlMapClientBuilder.buildSqlMapClient(reader);
            reader.close();
            //usr=(User)sqlMapper.queryForObject("selectAllUsers");
            list=sqlMapper.queryForList("selectAllUsers");

2) 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">

  <!-- Use type aliases to avoid typing the full classname every time. -->
  <typeAlias alias="User" type="com.domain.User"/>

  <!-- Result maps describe the mapping between the columns returned
       from a query, and the class properties.  A result map isn't
       necessary if the columns (or aliases) match to the properties
       exactly. -->
    <!--    <resultMap id="UserResult" class="User">
        <result property="firstname" column="firstname"/>
      </resultMap>
   -->

  <!-- Select with no parameters using the result map for Account class. -->

  <select id="selectAllUsers" >
    select firstname from PUBLIC.user
  </select>

</sqlMap>

3) User.java

public class User {
      private String firstname;
      // getter, setter methods..

Thanks for reply.

-- 
~
otomatik oluşturuldu:
http://ocetin.net/log
http://linux.beykent.edu.tr
Mime
View raw message