ibatis简介

1、jar包

ibatis-2.3.4.726.jar; 数据库驱动 spring.jar
org.springframework.orm-3.0.3.release.jar

代码

import java.util.HashMap;
import java.util.Map;

import org.junit.Test;
import org.springframework.core.io.ClassPathResource;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

import org.springframework.orm.ibatis.SqlMapClientFactoryBean;
import com.ibatis.sqlmap.client.SqlMapClient;

public class IbatisTest {
    public DriverManagerDataSource Connection(){

        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("com.sybase.jdbc4.jdbc.SybDriver");
        dataSource.setUrl("jdbc:sybase:Tds:XXXXXXXX:4100");

        dataSource.setUsername("xxxx");
        dataSource.setPassword("xxxx");
        return dataSource;
    }

    @Test
    public void testQuery() throws Exception
    {


         SqlMapClientFactoryBean scfb = new SqlMapClientFactoryBean();
         scfb.setDataSource(Connection());
         scfb.setConfigLocation(new ClassPathResource("SqlMapConfigBatch.xml"));
         scfb.afterPropertiesSet();
         SqlMapClient sqlMapClient = (SqlMapClient) scfb.getObject();


        Map<String, Object> param = new HashMap<String, Object>();

        param.put("callingno", "15994994044");
        param.put("linkphone","44444444");
        param.put("mobilephone", "446545456");
        param.put("createtime","2013-07-11 20:10:10");
        param.put("operid", 100);
        param.put("lastcalltime","2014-08-19 20:10:10");
        param.put("lastcallno","15994994044");

        sqlMapClient.update("batchInsertTask", param);
     }
}

SqlMapConfigBatch.xml

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMapConfig      
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"      
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>


 <sqlMap resource="student.ibatis.xml"/> 

</sqlMapConfig>

student.ibatis.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>

  <insert id="insertSample" parameterClass="map" >
    insert into easy_sample(id,vcid,name,activityid) values(
    seq_easy_log_call.nextval,#vcid#,#name#,#activityid#)
  </insert>

</sqlMap>