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,有这四个文件就搞定了，再写一个测试的类就行了，我把源代码发上来了，有兴趣的可以看看