ibatis 初学

目录结构:

sqlmap.properties

jdbc.driverClass=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@ip:unieap
jdbc.username=scott
jdbc.password=tiger

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> 
      
    <properties resource="sqlmap.properties"/> 
          
    <transactionManager type="JDBC"> 
        <dataSource type="SIMPLE">      
            <property name="JDBC.Driver" value="${jdbc.driverClass}" /> 
            <property name="JDBC.ConnectionURL" value="${jdbc.url}" /> 
            <property name="JDBC.Username" value="${jdbc.username}" /> 
            <property name="JDBC.Password" value="${jdbc.password}" /> 
        </dataSource> 
    </transactionManager> 
    <sqlMap resource="com/zzl/sql/User.xml" /> 
  </sqlMapConfig> 

Utils.java:

package com.zzl.dao;

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

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

public class Utils
{
    private static SqlMapClient sqlMapper;
    public static synchronized SqlMapClient getSqlMap(){
        if(sqlMapper==null)
        {
            try
            {
                Reader reader=Resources.getResourceAsReader("SqlMapConfig.xml");
                sqlMapper=SqlMapClientBuilder.buildSqlMapClient(reader);
                reader.close();
            }
            catch (IOException e)
            {
                e.printStackTrace();
            }
        }
        return sqlMapper;
    }
}

UserDao.java

package com.zzl.dao;

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

import com.ibatis.sqlmap.client.SqlMapClient;

 

public class UserDao
{
    public static List getAllUsers(){
        SqlMapClient sqlMap=Utils.getSqlMap();
        List li=null;
        try
        {
            li=sqlMap.queryForList("getAllUsers");
        }
        catch (SQLException e)
        {
          
            e.printStackTrace();
        }
        return li;
    }
  

}

User.java

package com.zzl.entity;

public class User
{
    private int id;
    private String username;
    private String userpwd;
    private String userdesc;
    public int getId()
    {
        return id;
    }
    public void setId(int id)
    {
        this.id = id;
    }
    public String getUsername()
    {
        return username;
    }
    public void setUsername(String username)
    {
        this.username = username;
    }
    public String getUserpwd()
    {
        return userpwd;
    }
    public void setUserpwd(String userpwd)
    {
        this.userpwd = userpwd;
    }
    public String getUserdesc()
    {
        return userdesc;
    }
    public void setUserdesc(String userdesc)
    {
        this.userdesc = userdesc;
    }
}

User.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="User"> 
 
    <typeAlias alias="user" type="com.zzl.entity.User"/> 
 
    <select id="getAllUsers" resultClass="user"> 
        select * from user_tab1 order by id   
    </select> 
  
 
</sqlMap> 

test.java

package com.zzl.test;

import java.util.List;

import com.zzl.dao.UserDao;
import com.zzl.entity.User;

public class Test
{

    public static void main(String[] args)
    {
       List<User> userList= (List<User>) UserDao.getAllUsers();
       for(User user:userList)
       {
           System.out.println(user.getId());
           System.out.println(user.getUsername());
       }
    }
}