how to update a column value by old column value within update statement in ibatis?

[ha a]

hi,

in fact, in sql, I can write "update foo_table set column=column+1 where 
name='abc'".
It resets the new value with one sql.

but how can I do that in ibatis with one statement, not by three statements: 
one gets the value, then add 1, then set the new value?

BTW, Can I do it by JDBC? 

Thanks in advance.





      ___________________________________________________________ 
  好玩贺卡等你发，邮箱贺卡全新上线！ 
http://card.mail.cn.yahoo.com/