ibatis简单使用

1.创建配置文件，数据库连接xml,实体xml,configuration.xml
configuration.xml文件如下

<sqlMapConfig>
<properties resource="com/zyt/comm/ibatis/dbconfig.properties"/><!--连接数据库信息-->
<settings
            cacheModelsEnabled="true"
            errorTracingEnabled="true"
            enhancementEnabled="true"
            lazyLoadingEnabled="true"
            maxRequests="32"
            maxSessions="10"
            maxTransactions="5"
            useStatementNamespaces="true"/>
       <transactionManager type="JDBC">
       <dataSource type="SIMPLE">
       <property name="JDBC.Driver" value="${dirver}"/><!--根据dbconfig.properties文件自动匹配-->
       <property name="JDBC.ConnectionURL" value="${url}"/>
       <property name="JDBC.Username" value="${username}"/>
       <property name="JDBC.Password" value="${password}"/>
       </dataSource>
       </transactionManager>
       <sqlMap resource="com/zyt/comm/ibatis/user.xml"/><!--对象映射实体类-->
</sqlMapConfig>

dbconfig.properties文件内容如下

dirver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/zytcomdb
username=root
password=sa

user.xml文件跟Hibernate差不多对象映射文件

<?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.zyt.test.user.model.Userinfo"/>
<typeAlias alias="Role" type="com.zyt.test.user.model.Role"/>

<resultMap class="User" id="resultUser">
	<result property="name"  column="name"/>
	<result property="password" column="password"/>
	<result property="uid" column="uid"/>
	<!-- <result property="roleModel" column="role" select="getRoleId"/>-->
	<result property="roleModel.roleName" column="roleName"/>  
</resultMap>

<resultMap class="Role" id="resultRole">
	<result property="id" column="id"/>
	<result property="roleName" column="roleName"/>
</resultMap>

<select id="getRoleId" resultMap="resultRole" >
	select * from roletype where id=#value#
</select>

<select id="getAll" resultMap="resultUser">
	select * from user
</select>
 
<select id="getList" resultMap="resultUser" parameterClass="User">
	select * from  user a inner join roletype b on a.role=b.id limit #offset#,#pageSize#
</select>

<select id="userquer" parameterClass="java.lang.String" resultClass="User">
	select * from user where name=#name#
</select>

	<select id="queryinner" resultClass="User">
		select * from user  a inner join role b on a.role=b.roleId
	</select>
	
	<insert id="insertUser" parameterClass="User">
		insert into user (name,password)values(#name#,#password#)
	</insert>
	
	<update id="updateUser" parameterClass="User">
		update user set name = #name# ,password=#password# where uid=#uid#
	</update>
	
	<delete id="deleteUser" parameterClass="java.lang.Integer">
		delete from user where uid=#uid#
	</delete>
</sqlMap>

2.创建IbatisUtil
加载配置文件

	public class IbatisUtil {
	private static SqlMapClient sqlMapClient;
	private static final String fileName="com/zyt/comm/ibatis/configuration.xml";
	static {
		try {
			Reader reader = Resources.getResourceAsReader(fileName);//读取配置文件信息
			sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);//装载流，构造sqlmapclient实例
			reader.close();//关闭流
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	//返回sqlMapclient
	public static SqlMapClient getSqlMapClient(){
		return sqlMapClient;
	}
}

3.在DAO中使用并得到数据

	public Userinfo getUserinfo(String name) throws SQLException{
		Userinfo userinfo = (Userinfo)sqlMapClient.queryForObject("User.userquer",name);//注意User.userquer是在user.xml配置的ID，根据这个ID可以得到查询SQL。后面name是参数。
		return userinfo;
	}
	

  


  

    
    
分享到：
      
      
    
  

  

    

      android布局 LinearLayout和RelativeLayo ...
      |
      android Activity生命周期
    
  
  

    

      
2011-02-14 15:02
      
浏览 1005
      
评论(0)
      
      
      
分类:企业架构
      
      
查看更多