mybatis的简单应用语句

简单的插入语句：

<insert id="insert" parameterClass="resultClassify" >  		
      INSERT INTO
	  D_RESULT_CLASSIFY(
			  	classify_id,
			  	company_id,
			  	type,
			  	classify_name,
			  	level,
			  	order_num,
			  	create_id,
			  	modify_id,
			  	gmt_create,
			  	gmt_modify,
			  	status,
			  	code,
			  	r_type
				)
		 VALUES( 
		  		#classify_id:INTEGER#,
		  		#company_id:INTEGER#,
		  		#type:TINYINT#,
		  		#classify_name:VARCHAR#,
		  		#level:INTEGER#,
		  		#order_num:INTEGER#,
		  		#create_id:VARCHAR#,
		  		#modify_id:VARCHAR#,
		  		now(),
			  	now(),
		  		#status:TINYINT#,
		  		#code:VARCHAR#,
		  		#r_type:TINYINT#
	  			)
  </insert>

对表中符合要求的数据进行批量复制，

<insert id="resultInitClassify" parameterClass="resultClassifyInit" >	  
	  INSERT INTO D_RESULT_CLASSIFY(
	  	  company_id,type,classify_name,level,order_num,create_id,modify_id,gmt_create,gmt_modify,status,code,r_type)
      SELECT 
      	  #new_company_id:INTEGER#,type,classify_name,level,order_num,#new_create_id:INTEGER#,#new_create_id:INTEGER#,now(),now(),status,code,r_type
	  FROM D_RESULT_CLASSIFY WHERE company_id = #old_company_id:INTEGER# and status = 1
  </insert> 

分页查询，

<select id="find" parameterClass="resultClassifyQuery" resultMap="resultClassifyMap">		
    SELECT t1.* FROM (
		SELECT 
		    a.classify_id,
		    a.company_id,
		    a.type,
		    a.classify_name,
		    a.level,
		    a.order_num,
		    a.create_id,
		    a.modify_id,
		    a.gmt_create,
		    a.gmt_modify,
		    a.status,
		    a.code,
		    a.r_type
		FROM 
			D_RESULT_CLASSIFY a
	) as t1
	  ORDER BY t1.gmt_modify DESC 
	  limit #startRow:INTEGER#,#endRow:INTEGER#
  </select>

查询数据表中符合条件的记录数，

<select id="findResultClassifyQueryCnt" resultClass="java.lang.Integer" parameterClass="resultClassifyQuery">
      SELECT 
    		COUNT(*)
        FROM 
    	   D_RESULT_CLASSIFY a
		   WHERE a.company_id = #company_id:INTEGER# and a.status = 1 and a.level = 1 
  </select>