目录结构:
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());
}
}
}