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
- select statement problem Okan Çetin
- Re: select statement problem Larry Meadors
- Re: select statement problem Okan Çetin
- RE: select statement problem Daniel Pitts
- Re: select statement problem Okan Çetin