ibatis
谁有ibatis在Eclipse上开发的例子，或者如何在Eclipse上开发一个ibatis的例子，各位大师有知情者定有重谢！！！ 问题点数：50、回复次数：5Top
1 楼tcmis（难道你忘了吗？）回复于 2006-11-01 22:41:02 得分 0
JPetstore这个例子，可以下载下来看看，就有采用ibatis的，不过这个有点复杂。。。Top
2 楼hohowu（北冥鲲）回复于 2006-11-01 23:17:27 得分 0
ibatis很简单的啊。
一般半天就ok了~:)
Top
3 楼xlyyc（宇）回复于 2006-11-02 13:03:41 得分 0
半天足够
写好SQL-MAP映射文件、作好JAVABEAN类，配置一下数据库参数就OKTop
4 楼xlyyc（宇）回复于 2006-11-02 13:07:07 得分 0
举个大概的例子
import com.ibatis.sqlmap.client.*;
import java.io.Reader;
import com.ibatis.common.resources.Resources;
import org.apache.log4j.Logger;
public class SqlMap{
private static Logger logger = Logger.getLogger(SqlMap.class);
private static final SqlMapClient smc;
static{
try{
String resource="sql-map-config.xml";
Reader reader = Resources.getResourceAsReader(resource);
smc = SqlMapClientBuilder.buildSqlMapClient(reader);
logger.info("Ibatis初始化成功");
}catch(Exception e){
logger.error("Ibatis初始化发生严重错误，原因："+e.toString());
throw new RuntimeException("Error initializing SqlMap class. Cause: "+e);
}
}
public static SqlMapClient getSqlMapInstance(){
return smc;
}
}
下面是sql-map-config.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<settings
cacheModelsEnabled="true"
enhancementEnabled="true"
lazyLoadingEnabled="true"
errorTracingEnabled="false"
maxRequests="512"
maxSessions="128"
maxTransactions="32"
useStatementNamespaces="true"
/>
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
<property name="JDBC.ConnectionURL" value="jdbc:mysql://127.0.0.1:3306/xiqibao-erp?useUnicode=true&characterEncoding=UTF-8"/>
<property name="JDBC.Username" value="root"/>
<property name="JDBC.Password" value="windows"/>
</dataSource>
</transactionManager>
<sqlMap resource="sql-map.xml"/>
</sqlMapConfig>
下面是sql-map.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="base">
<typeAlias alias="EMPLOYEE_TAB" type="com.xiqibao.erp.model.EMPLOYEE_TAB"/>
<typeAlias alias="Integer" type="java.lang.Integer"/>
<select id="selectEMPLOYEE_TAB" parameterClass="EMPLOYEE_TAB" resultClass="EMPLOYEE_TAB">
SELECT EMPID,EMPNUM,DEPID,EMPNAME,EMPCLASS,SEX
,MARRIAGE,DATE_FORMAT(BIRTHDAY,'%Y-%m-%d') AS BIRTHDAY,FOLK,POLITY,IDCARD
,RESIDENCE,PLACE,SOCIALID,ADDRESS,PHONE
,ZIPCODE,DEGREE,SPECIALTY,SCHOOL,HEADSHIP
,TITLE,POLEVEL,COMPUTER,LANGUAGE,LANGUAGELEVEL
,DATE_FORMAT(BEGWORKDATE,'%Y-%m-%d') AS BEGWORKDATE,WORKTYPE,WORKSTAT,EMPDESC,DATE_FORMAT(ENDWORKDATE,'%Y-%m-%d') AS ENDWORKDATE
,EMPTYPE,DATE_FORMAT(FIRSTBIRGAINDATE,'%Y-%m-%d') AS FIRSTBIRGAINDATE,DATE_FORMAT(BIRGAINDATE,'%Y-%m-%d') AS BIRGAINDATE,DATE_FORMAT(BIRGAINENDDATE,'%Y-%m-%d') AS BIRGAINENDDATE,POSTID
,SCORE,EMPBANK,EMPBANKCODE,PICTURE,LOGINNAME
,PASSWORD,ISOPEN,DATE_FORMAT(OPENDATE,'%Y-%m-%d') AS OPENDATE,RIGHTLIST,ISDEL,DATE_FORMAT(CREATEDTIME,'%Y-%m-%d %H:%i:%S') AS CREATEDTIME
,NOTE FROM T_EMPLOYEE
<dynamic prepend="WHERE">
<isNotEmpty prepend="AND" property="EMPID"> EMPID = #EMPID# </isNotEmpty>
<isNotEmpty prepend="AND" property="DEPID"> DEPID = #DEPID# </isNotEmpty>
<isNotEmpty prepend="AND" property="EMPNUM"> EMPNUM = #EMPNUM# </isNotEmpty>
<isNotEmpty prepend="AND" property="LOGINNAME"> LOGINNAME = #LOGINNAME# </isNotEmpty>
<isNotEmpty prepend="AND" property="PASSWORD"> PASSWORD = #PASSWORD# </isNotEmpty>
<isNotEmpty prepend="AND" property="ISOPEN"> ISOPEN = #ISOPEN# </isNotEmpty>
<isNotEmpty prepend="AND" property="EMPCLASS"> EMPCLASS = #EMPCLASS# </isNotEmpty>
<isNotEmpty prepend="AND" property="SEX"> SEX = #SEX# </isNotEmpty>
<isNotEmpty prepend="AND" property="IDCARD"> IDCARD = #IDCARD# </isNotEmpty>
<isNotEmpty prepend="AND" property="PLACE"> PLACE = #PLACE# </isNotEmpty>
<isNotEmpty prepend="AND" property="DEGREE"> DEGREE = #DEGREE# </isNotEmpty>
<isNotEmpty prepend="AND" property="EMPNAME"> EMPNAME LIKE '%$EMPNAME$%' </isNotEmpty>
<isNotEmpty prepend="AND" property="ISDEL"> ISDEL = #ISDEL# </isNotEmpty>
</dynamic>
</select>
<select id="countEMPLOYEE_TAB" parameterClass="EMPLOYEE_TAB" resultClass="Integer">
SELECT count(*) AS COUNT FROM T_EMPLOYEE
<dynamic prepend="WHERE">
<isNotEmpty prepend="AND" property="EMPID"> EMPID = #EMPID# </isNotEmpty>
<isNotEmpty prepend="AND" property="DEPID"> DEPID = #DEPID# </isNotEmpty>
<isNotEmpty prepend="AND" property="LOGINNAME"> LOGINNAME = #LOGINNAME# </isNotEmpty>
<isNotEmpty prepend="AND" property="PASSWORD"> PASSWORD = #PASSWORD# </isNotEmpty>
<isNotEmpty prepend="AND" property="ISOPEN"> ISOPEN = #ISOPEN# </isNotEmpty>
<isNotEmpty prepend="AND" property="EMPCLASS"> EMPCLASS = #EMPCLASS# </isNotEmpty>
<isNotEmpty prepend="AND" property="ISDEL"> ISDEL = #ISDEL# </isNotEmpty>
</dynamic>
</select>
</sqlMap>
Top
5 楼tianzhijie11（抓青蛙）回复于 2006-11-02 13:51:21 得分 0
ibatis是简单。但是昨天我想操作oracle中的CLOB大类型就不行了。只能插入。但提取不出来。。ibatis怎么搞的。不是说是成熟的框架吗？怎么不能提取出来CLOB类型。。Top
