通过javaBean反射转换成mybatis映射文件

卢水发

浏览: 386642 次
性别:
来自: 深圳

最近访客更多访客>>

lesliehanhan

djl_cp

qiushenchao

sotier

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

java工具类

bean转换成mybatis映射文件

package mysql.tool;

import java.util.List;

import mysql.model.LoanTransferDto;

public class MapperUtils {
	
	public static String genBaseResultMap(Class<?> clazz){
		 List<String> fieldList = BeanUtil.getBeanPropertyList(clazz);
		 StringBuffer sb = new StringBuffer();
		 sb.append("<resultMap id=\"BaseResultMap\" type=\""+clazz.getSimpleName().toUpperCase()+"\">\r\n");
		 int index = 0;
		 for (String fields : fieldList) {
			  String[] fieldArr = fields.split("`");
			  String columnStr = toColumn(fieldArr[1]);
			  if(index==0){
				  sb.append("  <id column=\""+columnStr+"\" jdbcType=\"BIGINT\" property=\""+fieldArr[1]+"\" />\r\n");
			  }else{
				  String jdbcType = "varchar";
				  if(fieldArr[0].equals("int")||fieldArr[0].equals("Integer")){
					  jdbcType = "Integer";
				  }else if(fieldArr[0].equals("long")||fieldArr[0].equals("Long")){
					  jdbcType = "bigInt";
				  }else if(fieldArr[0].equals("Date")||fieldArr[1].contains("Time")||fieldArr[1].contains("Date")){
					  jdbcType = "TIMESTAMP";
				  }
				  sb.append("  <result column=\""+columnStr+"\" jdbcType=\""+jdbcType.toUpperCase()+"\" property=\""+fieldArr[1]+"\" />\r\n");
			  }
			  index++;
		 }
		 sb.append("</resultMap>\r\n");
		 return sb.toString();
	}
	
	//生成删除语句
	public static String genDeleteMap(String tableNamePreFix,Class<?> clazz){
		 List<String> fieldList = BeanUtil.getBeanPropertyList(clazz);
		 String tableName =(tableNamePreFix+toColumn(clazz.getSimpleName())).toUpperCase();
		 StringBuffer sb = new StringBuffer();
		 sb.append("<delete id=\"deleteByPrimaryKey\" parameterType=\"java.lang.Long\">\r\n");
		 sb.append("   delete from "+tableName+"  where id = #{id,jdbcType=BIGINT}\r\n");
		 sb.append("</delete>\r\n");
		 return sb.toString();
	}
	
	//生成插入语句
	public static String genInsertMap(String tableNamePreFix,Class<?> clazz){
		 List<String> fieldList = BeanUtil.getBeanPropertyList(clazz);
		 String tableName =(tableNamePreFix+toColumn(clazz.getSimpleName())).toUpperCase();
		 StringBuffer sb = new StringBuffer();
		 sb.append("<insert id=\"insert\" parameterType=\""+clazz.getSimpleName().toUpperCase()+"\">\r\n");
		 StringBuffer columnAppend = new StringBuffer();
		 StringBuffer valuesAppend = new StringBuffer();
		 int index = 0;
		 String idFields = "";
		 for (String fields : fieldList) {
			  String[] fieldArr = fields.split("`");
			  if(index>0){
				  String jdbcType = "varchar";
				  if(fieldArr[0].equals("int")||fieldArr[0].equals("Integer")){
					  jdbcType = "Integer";
				  }else if(fieldArr[0].equals("long")||fieldArr[0].equals("Long")){
					  jdbcType = "bigInt";
				  }else if(fieldArr[0].equals("Date")||fieldArr[1].contains("Time")||fieldArr[1].contains("Date")){
					  jdbcType = "TIMESTAMP";
				  }
				  columnAppend.append("    "+toColumn(fieldArr[1])+",\r\n");
				  valuesAppend.append("    #{"+fieldArr[1]+",jdbcType="+jdbcType.toUpperCase()+"},\r\n");
			  }else{
				  idFields = fieldArr[1];
			  }
			  index++;
		 }
		 columnAppend.deleteCharAt(columnAppend.lastIndexOf(","));
		 valuesAppend.deleteCharAt(valuesAppend.lastIndexOf(","));
		 sb.append("  insert into "+tableName+"("+columnAppend.toString()+") values("+valuesAppend+")\r\n");
		 sb.append("</insert>\r\n");
		 return sb.toString();
	}
	
	//生成更新语句
	public static String genUpdateMap(String tableNamePreFix,Class<?> clazz){
		 List<String> fieldList = BeanUtil.getBeanPropertyList(clazz);
		 String tableName =(tableNamePreFix+toColumn(clazz.getSimpleName())).toUpperCase();
		 StringBuffer sb = new StringBuffer();
		 sb.append("<update id=\"updateByPrimaryKey\" parameterType=\""+clazz.getSimpleName().toUpperCase()+"\">\r\n");
		 StringBuffer setAppend = new StringBuffer();
		 sb.append("  update "+tableName+" set\r\n");
		 int index = 0;
		 String idFields = "";
		 for (String fields : fieldList) {
			  String[] fieldArr = fields.split("`");
			  if(index>0){
				  String jdbcType = "varchar";
				  if(fieldArr[0].equals("int")||fieldArr[0].equals("Integer")){
					  jdbcType = "Integer";
				  }else if(fieldArr[0].equals("long")||fieldArr[0].equals("Long")){
					  jdbcType = "bigInt";
				  }else if(fieldArr[0].equals("Date")||fieldArr[1].contains("Time")||fieldArr[1].contains("Date")){
					  jdbcType = "TIMESTAMP";
				  }
				  String column = toColumn(fieldArr[1]);
				  setAppend.append("    "+column+" = #{"+fieldArr[1]+",jdbcType="+jdbcType.toUpperCase()+"},\r\n");
			  }else{
				  idFields = fieldArr[1];
			  }
		      index++;
		 }
		 setAppend.deleteCharAt(setAppend.lastIndexOf(","));
		 sb.append(setAppend.toString());
		 sb.append("  where "+toColumn(idFields)+" = #{"+idFields+",jdbcType=BIGINT}\r\n");
		 sb.append("</update>\r\n");
		 return sb.toString();
	}
	
	//生成更新语句
	public static String genSelectByIdMap(String tableNamePreFix,Class<?> clazz){
		 List<String> fieldList = BeanUtil.getBeanPropertyList(clazz);
		 String tableName =(tableNamePreFix+toColumn(clazz.getSimpleName())).toUpperCase();
		 StringBuffer sb = new StringBuffer();
		 sb.append("<select id=\"selectByPrimaryKey\" parameterType=\"java.lang.Long\" resultMap=\"BaseResultMap\">\r\n");
		 StringBuffer columnAppend = new StringBuffer();
		 StringBuffer valuesAppend = new StringBuffer();
		 int index = 0;
		 String idFields = "";
		 for (String fields : fieldList) {
			  String[] fieldArr = fields.split("`");
			  if(index>0){
				  String jdbcType = "varchar";
				  if(fieldArr[0].equals("int")||fieldArr[0].equals("Integer")){
					  jdbcType = "Integer";
				  }else if(fieldArr[0].equals("long")||fieldArr[0].equals("Long")){
					  jdbcType = "bigInt";
				  }else if(fieldArr[0].equals("Date")||fieldArr[1].contains("Time")||fieldArr[1].contains("Date")){
					  jdbcType = "TIMESTAMP";
				  }
				  columnAppend.append("    "+toColumn(fieldArr[1])+",\r\n");
				  valuesAppend.append("    #{"+fieldArr[1]+",jdbcType="+jdbcType.toUpperCase()+"},\r\n");
			  }else{
				  idFields = fieldArr[1];
			  }
			  index++;
		 }
		 columnAppend.deleteCharAt(columnAppend.lastIndexOf(","));
		 valuesAppend.deleteCharAt(valuesAppend.lastIndexOf(","));
		 sb.append("  select "+columnAppend.toString()+" from "+tableName+" ");
		 sb.append("  where "+toColumn(idFields)+" = #{"+idFields+",jdbcType=BIGINT}\r\n");
		 sb.append("</select>\r\n");
		 return sb.toString();
	}
		
	
	public static String toColumn(String word) {
		StringBuffer sb = new StringBuffer();
		for (int i = 0; i < word.length(); i++) {
			char c = word.charAt(i);
			if (Character.isUpperCase(c)) {
				sb.append("_"+c);
			}else{
				sb.append(c);
			}
		}
		return sb.toString().toLowerCase();
	}
	
	public static void main(String[] args) {
		System.out.println(genBaseResultMap(LoanTransferDto.class));
		System.out.println(genDeleteMap("JGJ",LoanTransferDto.class));
		System.out.println(genInsertMap("JGJ",LoanTransferDto.class));
		System.out.println(genUpdateMap("JGJ",LoanTransferDto.class));
		System.out.println(genSelectByIdMap("JGJ",LoanTransferDto.class));
		//System.out.println(toColumn("loanType"));
	}

}

生成后的效果：

<delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
delete from JGJ_LOAN_TRANSFER_DTO where id = #{id,jdbcType=BIGINT}
</delete>

<insert id="insert" parameterType="LOANTRANSFERDTO">
insert into JGJ_LOAN_TRANSFER_DTO(    mid,
    loan_no,
    title,
    bid_count,
    bid_amount,
    rate,
    transfer_amount,
    loan_cycle,
    loan_cycle_attr,
    update_time,
    create_time
) values(    #{mid,jdbcType=BIGINT},
    #{loanNo,jdbcType=VARCHAR},
    #{title,jdbcType=VARCHAR},
    #{bidCount,jdbcType=BIGINT},
    #{bidAmount,jdbcType=BIGINT},
    #{rate,jdbcType=BIGINT},
    #{transferAmount,jdbcType=BIGINT},
    #{loanCycle,jdbcType=BIGINT},
    #{loanCycleAttr,jdbcType=INTEGER},
    #{updateTime,jdbcType=TIMESTAMP},
    #{createTime,jdbcType=TIMESTAMP}
)
</insert>

<update id="updateByPrimaryKey" parameterType="LOANTRANSFERDTO">
update JGJ_LOAN_TRANSFER_DTO set
    mid = #{mid,jdbcType=BIGINT},
    loan_no = #{loanNo,jdbcType=VARCHAR},
    title = #{title,jdbcType=VARCHAR},
    bid_count = #{bidCount,jdbcType=BIGINT},
    bid_amount = #{bidAmount,jdbcType=BIGINT},
    rate = #{rate,jdbcType=BIGINT},
    transfer_amount = #{transferAmount,jdbcType=BIGINT},
    loan_cycle = #{loanCycle,jdbcType=BIGINT},
    loan_cycle_attr = #{loanCycleAttr,jdbcType=INTEGER},
    update_time = #{updateTime,jdbcType=TIMESTAMP},
    create_time = #{createTime,jdbcType=TIMESTAMP}
where ltid = #{ltid,jdbcType=BIGINT}
</update>

<select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
select     mid,
    loan_no,
    title,
    bid_count,
    bid_amount,
    rate,
    transfer_amount,
    loan_cycle,
    loan_cycle_attr,
    update_time,
    create_time
from JGJ_LOAN_TRANSFER_DTO   where ltid = #{ltid,jdbcType=BIGINT}
</select>

分享到：

web开发定义统一返回值对象对象版 | Oracle SQL优化总结（很全面）一起来学习 ...

2016-07-27 21:08
浏览 3846
评论(0)
论坛回复 / 浏览 (0 / 2151)
分类:编程语言
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论