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"));
}
}
生成后的效果：
<resultMap id="BaseResultMap" type="LOANTRANSFERDTO">
<id column="ltid" jdbcType="BIGINT" property="ltid" />
<result column="mid" jdbcType="BIGINT" property="mid" />
<result column="loan_no" jdbcType="VARCHAR" property="loanNo" />
<result column="title" jdbcType="VARCHAR" property="title" />
<result column="bid_count" jdbcType="BIGINT" property="bidCount" />
<result column="bid_amount" jdbcType="BIGINT" property="bidAmount" />
<result column="rate" jdbcType="BIGINT" property="rate" />
<result column="transfer_amount" jdbcType="BIGINT" property="transferAmount" />
<result column="loan_cycle" jdbcType="BIGINT" property="loanCycle" />
<result column="loan_cycle_attr" jdbcType="INTEGER" property="loanCycleAttr" />
<result column="update_time" jdbcType="TIMESTAMP" property="updateTime" />
<result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
</resultMap>
<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>
相关推荐
javabean转换xml映射文件工具，可用于castor框架。JDK6编译、运行。
mybatis逆向生成javaBean_generatorSqlmapCustom。代码生成
0、根据表可以单独生成javaBean后缀可以自定义 1、工具本身是非常简单的，每个人都能做就是使用模板替换生成相应文件 2、工具主要针对SpringMvc+Mybatis注解+Mysql生成对象，dao、sqlDao、interface、实现接口 3、...
xml文件与javabean之间的转换，javabean生成xml文件，再将xml文件转换成javabean，输出到控制台上
mybatis逆向生成javaBean 命令生成
JavaBean和xml转换demoJavaBean和xml转换demoJavaBean和xml转换demoJavaBean和xml转换demo
java工程，搭建好数据库后，简单修改xml配置文件就可以直接运行，得到想要的对应数据库字段的javabean对象
NULL 博文链接：https://luyuwww.iteye.com/blog/1988355
mybatis 自动生成DAO，XML和javaBean类的工具。 mybatis-generator-core-1.3.2-bundle.zip
将JavaBean对象与Json字符串相互转换，将Java集合与Json字符串集合相互转换。
通过java解析上传文件，判断文件类型(excel或者csv)，将解析后的数据映射到javabean，从而可以进一步操作，入库或者增添数据
mybatis-generator javabean 自动生成mapper.xml ,dao 及 po
找的例子，大概改了改，没怎么做封装，能用的用吧
JavaBean与反射
实现javabean转换xml，以及xml转换javabean,，尤其是做数据对接时，使用webservice时，很方便
xml与JavaBean互相转换的好工具---Xstream,能够很方便的实现xml与JavaBean之间的转换，这在系统之间进行信息交互是非常方便的
简易通过的java和javabean互换
轻松的实现javaBean到XML的转换，和XML到javaBean的转换
1.通过Java反射机制获取JavaBean对象。 2.通过JavaBean全路径字符串获取JavaBean对象。 3.获取JavaBean注解信息
mybatis逆向生成javaBean_generatorSqlmapCustom，解压后倒入工程即可使用