ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daryl Stultz <da...@6degrees.com>
Subject Re: XML vs Annotations
Date Sat, 06 Feb 2010 22:21:37 GMT
On Sat, Feb 6, 2010 at 3:29 PM, Daryl Stultz <daryl@6degrees.com> wrote:

> Hmm, I may be stuck then on finding my own "style" of using iBATIS.
> I'm wondering if I can do away with XML and annotations and build the
mappings programmatically. So far I've done this:

SqlSession session = factory.openSession();
final Configuration configuration = session.getConfiguration();
SqlSource sqlSource = new SqlSource() {
 public BoundSql getBoundSql(Object parameterObject) {
List<ParameterMapping> paramMap = new ArrayList<ParameterMapping>();
paramMap.add(new ParameterMapping.Builder(configuration, "id",
return new BoundSql(configuration, "select userId as user_id, name as
user_name, userTypeId as user_userTypeId\n" +
" from Users \n" +
" where userId = ?", paramMap, parameterObject);
MappedStatement.Builder builder = new MappedStatement.Builder(configuration,
"model.UserMapper.findById", sqlSource, SqlCommandType.SELECT);
final MappedStatement ms = builder.build();


To replace this:

<select id="findById" parameterType="Integer" resultMap="userResult">
select userId as user_id, name as user_name, userTypeId as user_userTypeId
from Users
where userId = #{id}

It doesn't work, since I haven't figured out how to specify the resultMap.
Can anyone tell me if this is a futile effort, or is it reasonable to think
I can build up my configuration entirely with Java objects (no annotations)?


Daryl Stultz
6 Degrees Software and Consulting, Inc.

View raw message