ibatis基础开发

一、

SqlMapConfig.xml为工程ibatis的配置文件

com.test.domain.Employe.java为一个Employ的实体类

com.sql.Employ.xml为Employ.java的映射文件

com.test.util.SQLMapClient.java为获得sqlmap的一个工具

com.test.domain.EmploySQLMapper.java Employe的dao类

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

二、文件内容

1、Employ.java

package com.test.domain;

public class Employ {
    private int id;
    private String enployName;
    private int salary;
   
    public Employ() {
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

   

    public String getEnployName() {
        return enployName;
    }

    public void setEnployName(String enployName) {
        this.enployName = enployName;
    }

    public int getSalary() {
        return salary;
    }

    public void setSalary(int salary) {
        this.salary = salary;
    }
}

 

 

 

2、Employ.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 namespace="Employ">

  <!-- Use type aliases to avoid typing the full classname every time. -->
  <typeAlias alias="Employ" type="com.test.domain.Employ"/>

  <!-- Result maps describe the mapping between the columns returned
       from a query, and the class properties.  A result map isn't
       necessary if the columns (or aliases) match to the properties
       exactly. -->
  <resultMap id="EmployResult" class="Employ">
    <result property="id" column="id"/>
    <result property="enployName" column="employ_name"/>
    <result property="salary" column="salary"/>
  </resultMap>

  <!-- Select with no parameters using the result map for Account class. -->
  <select id="selectAllEmploy" resultMap="EmployResult">
      <![CDATA[
          select * from employees
      ]]>
  </select>
  <!-- A simpler select example without the result map.  Note the
       aliases to match the properties of the target result class. -->
  
  <!-- Insert example, using the Account parameter class -->
  <insert id="insertEmploy" parameterClass="Employ">
      <![CDATA[
          insert into employees (employ_name, salary) values(#enployName#, #salary#)
      ]]>
  </insert>

  <!-- Update example, using the Account parameter class -->

  <!-- Delete example, using an integer as the parameter class -->
</sqlMap>

 

 

 

3、SqlMapConfig.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>

  <!-- Configure a built-in transaction manager.  If you're using an
       app server, you probably want to use its transaction manager
       and a managed datasource -->
  <transactionManager type="JDBC" commitRequired="false">
    <dataSource type="SIMPLE">
      <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
      <property name="JDBC.ConnectionURL" value="jdbc:mysql:///test"/>
      <property name="JDBC.Username" value="root"/>
      <property name="JDBC.Password" value="root"/>
    </dataSource>
  </transactionManager>

  <!-- List the SQL Map XML files. They can be loaded from the
       classpath, as they are here (com.domain.data...) -->
  <sqlMap resource="com/sql/Employ.xml"/>
  <!-- List more here...
  <sqlMap resource="com/mydomain/data/Order.xml"/>
  <sqlMap resource="com/mydomain/data/Documents.xml"/>
  -->
</sqlMapConfig>

 

 

 

4、SQLMapClient.java

package com.test.util;

import java.io.IOException;
import java.io.Reader;

import sun.misc.Resource;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class SQLMapClient {
    private static SqlMapClient sqlMaper = null;
   
    static {
        String resource = "SqlMapConfig.xml";
        try {
            Reader reader = Resources.getResourceAsReader(resource);
            sqlMaper = SqlMapClientBuilder.buildSqlMapClient(reader);
            reader.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    public static SqlMapClient getSqlMaper() {
        return sqlMaper;
    }
}

 

 

 

5、EmploySQLMapper.java

package com.test.domain;

import java.sql.SQLException;
import java.util.List;

import com.ibatis.sqlmap.client.SqlMapClient;
import com.test.util.SQLMapClient;

public class EmploySQLMapper {
    private SqlMapClient sqlMapper = null;
   
    public EmploySQLMapper() {
        sqlMapper = SQLMapClient.getSqlMaper();
    }
   
    public void insertEmploy(Employ employ) throws SQLException {
        sqlMapper.insert("insertEmploy", employ);
    }
   
    public List<Employ> selectAllEmploy() throws SQLException {
        return sqlMapper.queryForList("selectAllEmploy");
    }
   
    public static void main(String[] args) throws SQLException {
        Employ employ = new Employ();
        employ.setEnployName("sun");
        employ.setSalary(1500);
//       
        EmploySQLMapper employSQLMapper = new EmploySQLMapper();
//        employSQLMapper.insertEmploy(employ);
       
        List<Employ> employees = employSQLMapper.selectAllEmploy();
       
        for (Employ e : employees) {
            System.out.println(e.getEnployName() + ":" + e.getSalary());
        }
    }
}