ibatis入门贴

前段时间做毕业设计，新学习了ibatis，感觉很好用，比hibernate要灵活很多，而且配置也少了不少。

现在写一个ibatis的入门例子，分享一下。

 

1.SqlMapConfigExample.properties

这个文件放你要连接数据库的一些参数

 

 

username=sa
password=1234
url=jdbc:sqlserver://192.168.0.22:1433;DatabaseName=testdb
driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

 

 

2.SqlMapConfigExample.xml

这个是sqlMap的配置文件，

 

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd">

<sqlMapConfig>

 <properties resource="SqlMapConfigExample.properties" />
 <settings cacheModelsEnabled="true" lazyLoadingEnabled="false"
  enhancementEnabled="true" maxSessions="64" maxTransactions="8"
  maxRequests="128" />

 <transactionManager type="JDBC">
  <dataSource type="SIMPLE">
   <property value="${driver}" name="JDBC.Driver" />
   <property value="${url}" name="JDBC.ConnectionURL" />
   <property value="${username}" name="JDBC.Username" />
   <property value="${password}" name="JDBC.Password" />
   <property value="15" name="Pool.MaximumActiveConnections" />
   <property value="15" name="Pool.MaximumIdleConnections" />
   <property value="1000" name="Pool.MaximumWait" />
  </dataSource>
 </transactionManager>

 <sqlMap resource="User.xml" />

</sqlMapConfig>

 

3.User.java  

 

package example.sqlmap.bean;

public class User {
 
 private int id;
 
 private String username;
 
 private String password;

 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 getPassword() {
  return password;
 }

 public void setPassword(String password) {
  this.password = password;
 }

}

 

 

4.User.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="Person">
 <typeAlias alias="employee" type="example.sqlmap.bean.Employee"/>
 <select id="getUser" resultClass="example.sqlmap.bean.User" parameterClass="example.sqlmap.bean.User">
  select id as id, name as username, password as password from
  users WHERE name = #username# and password = #password#;
 </select>
 
</sqlMap>

 

 

ok,有这四个文件就搞定了，再写一个测试的类就行了，我把源代码发上来了，有兴趣的可以看看