public interface AdminMaintainDao { 	

 /** 从数据库中查询所有的记录 *  */ 
	 public List<AdminMaintain> getAllAdminMaintain(); 
	
 /** 新增记录 *  */ 
	 public void add(AdminMaintain am); 

 /** 修改记录 *  */ 
	 public void update(AdminMaintain am); 

 /** 删除记录 *  */ 
	 public void delete(String id); 
	
 }

 <?xml version="1.0" encoding="UTF-8"?> 
 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
 "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> 
 <mapper namespace="com.ibm.wah.widgets.dao.AdminMaintainDao"> 
	 
    <!-- 数据库表字段到 java 类的映射 --> 
    <resultMap type="com.ibm.wah.widgets.vo.AdminMaintain" id="AdminMaintain"> 
    	 <result property="id" column="maintain_id"/> 
    	 <result property="agentTeam" column="agentTeam"/> 
    	 <result property="forum" column="forum"/> 
    	 <result property="url" column="url"/>    
    	 <result property="forumType" column="forum_Type"/> 	
    	 <result property="communityUuid" column="COMMUNITY_UUID"/> 
    </resultMap> 
	
    <!-- 从数据库表中取得所有的记录并按降序排序 --> 
     <select id="getAllAdminMaintain" resultMap="AdminMaintain"> 
    	 SELECT * FROM TLD.Admin_Maintain m order by m.maintain_id desc 	
    </select> 
    
     <insert id="add"  parameterType="com.ibm.wah.widgets.vo.AdminMaintain">          
      insert into TLD.Admin_Maintain(agentTeam,forum,url,forum_Type,COMMUNITY_UUID)
	   values (#{agentTeam},#{forum},#{url},#{forumType},#{communityUuid}) 
	 </insert> 
	
     <update id="update"  parameterType="com.ibm.wah.widgets.vo.AdminMaintain">
	   update TLD.Admin_Maintain set agentTeam=#{agentTeam},forum=#{forum},url=#{url},forum_Type=#{forumType},COMMUNITY_UUID=#{communityUuid} 
	   where maintain_id=#{id} 
	 </update> 
	
    <delete id="delete" parameterType="String">  
        delete from TLD.Admin_Maintain where maintain_id = #{id}  
    </delete>     
 </mapper>

 CREATE TABLE "TLD"."ADMIN_MAINTAIN"  ( 
 "MAINTAIN_ID" BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY (  
    START WITH +0  
    INCREMENT BY +1  
    MINVALUE +0  
    MAXVALUE +9223372036854775807  
    NO CYCLE  
    CACHE 20  
    NO ORDER ),"AGENTTEAM" CHAR(50) NOT NULL,"FORUM" CHAR(50) NOT NULL,"URL" CHAR(200) NOT NULL,"FORUM_TYPE" INTEGER NOT NULL,"COMMUNITY_UUID" CHAR(50) NOT NULL )   
		 IN "USERSPACE1" ;

下面对上面的 dao 代码进行单元测试：

 public class TestAdminMaintainDao { 
	 private Logger logger = Logger.getLogger(this.getClass()); 
	 private ClassPathXmlApplicationContext ctx = \
	 new ClassPathXmlApplicationContext("applicationContext.xml"); 
	 // 从配置文件中初始化实例
     private AdminMaintainDao dao = \
     (AdminMaintainDao)ctx.getBean("adminMaintainDao"); 

  /** 测试查询 */ 
 @Test 
 public void testGetAllAdminMaintain() { 				
	  List<AdminMaintain> list=dao.getAllAdminMaintain(); 
	  for (AdminMaintain am : list) { 			
            logger.info(am.getAgentTeam()+" : "+am.getUrl()); 
	      //add your code here; 
	  } 
		
  } 
 /** 测试新增 */ 
 @Test 
 public void testAdd() { 			
	  AdminMaintain am=new AdminMaintain(); 
	  am.setAgentTeam("C"); 
	  am.setCommunityUuid("UUidssss8080-980sf"); 
	  am.setForum("C Awards"); 
	  am.setUrl("http:// c wards"); 
	  am.setForumType(1); 
	  dao.add(am); 	  
  } 
	
 /** 测试修改 */ 
 @Test 
 public void testUpdate() { 		
	  AdminMaintain am=new AdminMaintain(); 
	  am.setId(11); 
	  am.setAgentTeam("D"); 
	  am.setCommunityUuid("sfs080-sfs"); 
      am.setForum("D FAQ"); 
	  am.setUrl("http:// D FAQ"); 
	  am.setForumType(3); 
	  dao.update(am); 	  
  } 
	
 /** 测试删除 */ 
  @Test 
  public void testDelete() { 	
	  dao.delete("11"); 
  } 
 }