Visitor :

May 4, 2009

Dynamically creating table in ibatis

Ibatis sqlclient provides "statement" tag to create table in dynamic. "Statement" tag are used in various way.

"http://www.ibatis.com/dtd/sql-map-2.dtd">

CREATE TABLE exam_$tableid$ (
logid int(11) NOT NULL auto_increment primary key,
projectname varchar(30),
disttype varchar(7),
contents longtext,
isSuccess char(1)
);

DROP TABLE IF EXISTS exam_$tableid$;


Map map = new HashMap();
map.put("tableid", "test");
sqlMap.queryForObject("com.google.com.test.createJavabasic", map);

No comments:

Post a Comment