package com.cn.util;
import java.lang.reflect.Field;
import org.apache.log4j.Logger;
import com.cn.model.credit.VehicleLicenseInfo;
/**
* 自动生成mybatis的XML文件
* */
public class AutoCreateXML {
//日志
private static final Logger LOGGER &＃61; Logger.getLogger(AutoCreateXML.class);
/**
* &＃64;param args
*/
public static void main(String[] args) {
//
printGenerate(new MsgInfo(),"");
printGenerate(new VehicleLicenseInfo(),"");
}
public static void printGenerate(Object model,String prefix){
LOGGER.debug(generteXmlQueryPage(model,prefix)&＃43;"\n");
LOGGER.debug(generateXmlFindById(model,prefix)&＃43;"\n");
LOGGER.debug(generateXmlSave(model,prefix)&＃43;"\n");
LOGGER.debug(generateXmlUpdate(model,prefix)&＃43;"\n");
LOGGER.debug(generateXmlDelete(model,prefix));
}
/**生成XML add*/
public static String generateXmlSave(Object model,String prefix){
String simpleName&＃61;model.getClass().getSimpleName();//类名
String upperSimpleName &＃61; simpleName.replaceFirst(simpleName.substring(0, 1), simpleName.substring(0, 1).toUpperCase());
String add&＃61;"\n";
add&＃43;&＃61;"
\n";
add&＃43;&＃61;"INSERT INTO "&＃43;prefix&＃43;getColumnName(upperSimpleName).toUpperCase().substring(1)&＃43;"\n(\n";
String fields&＃61;"";
String names&＃61;"";
Field[] field &＃61; model.getClass().getDeclaredFields(); //获取实体类的所有属性&＃xff0c;返回Field数组
for(int j&＃61;0 ; j
String name &＃61; field[j].getName(); //获取属性的名字
fields&＃43;&＃61;getColumnName(name);
if(name.contains("Date")||name.contains("Term")||name.contains("birthday")){
names&＃43;&＃61;"TO_DATE(#{"&＃43;name&＃43;"},&＃39;yyyy-mm-dd&＃39;)";
}else if(name.contains("Time")){
names&＃43;&＃61;"TO_DATE(#{"&＃43;name&＃43;"},&＃39;yyyy-mm-dd hh24:mi:ss&＃39;)";
}else {
names&＃43;&＃61;"#{"&＃43;name&＃43;"}";
}
if(j
fields&＃43;&＃61;",\n";
names&＃43;&＃61;",\n";
}
}
add&＃43;&＃61;fields.toUpperCase()&＃43;"\n)\nVALUES\n(\n"&＃43;names&＃43;"\n)\n";
return add;
}
/**生成XML update*/
public static String generateXmlUpdate(Object model,String prefix){
String simpleName&＃61;model.getClass().getSimpleName();
String upperSimpleName &＃61; simpleName.replaceFirst(simpleName.substring(0, 1), simpleName.substring(0, 1).toUpperCase());
String update&＃61;"\n";
update&＃43;&＃61;"
\n";
update&＃43;&＃61;"UPDATE "&＃43;prefix&＃43;getColumnName(upperSimpleName).toUpperCase().substring(1)&＃43;" \nSET \n";
update&＃43;&＃61;"\n";
Field[] field &＃61; model.getClass().getDeclaredFields(); //获取实体类的所有属性&＃xff0c;返回Field数组
for(int j&＃61;1 ; j
String name &＃61; field[j].getName(); //获取属性的名字
update&＃43;&＃61;"\n";
if(name.contains("Date")||name.contains("Term")||name.contains("birthday")){
update&＃43;&＃61;getColumnName(name).toUpperCase()&＃43;"&＃61;TO_DATE(#{"&＃43;name&＃43;"},&＃39;yyyy-mm-dd&＃39;)";
}else if(name.contains("Time")){
update&＃43;&＃61;getColumnName(name).toUpperCase()&＃43;"&＃61;TO_DATE(#{"&＃43;name&＃43;"},&＃39;yyyy-mm-dd hh24:mi:ss&＃39;)";
}else {
update&＃43;&＃61;getColumnName(name).toUpperCase()&＃43;"&＃61;#{"&＃43;name&＃43;"}";
}
if(j
update&＃43;&＃61;",";
}
update&＃43;&＃61;"\n\n";
}
update&＃43;&＃61;"\n";
update&＃43;&＃61;" WHERE ID&＃61;#{id}\n";
return update;
}
/**生成XML findById*/
public static String generateXmlFindById(Object model,String prefix){
String simpleName&＃61;model.getClass().getSimpleName();
String upperSimpleName &＃61; simpleName.replaceFirst(simpleName.substring(0, 1), simpleName.substring(0, 1).toUpperCase());
String findById&＃61;"\n";
findById&＃43;&＃61;"
";
return findById;
}
/**生成XML 根据条件分页查询*/
public static String generteXmlQueryPage(Object model,String prefix){
String simpleName&＃61;model.getClass().getSimpleName();
String upperSimpleName &＃61; simpleName.replaceFirst(simpleName.substring(0, 1), simpleName.substring(0, 1).toUpperCase());
String queryObjectPage&＃61;"\n";
queryObjectPage&＃43;&＃61;"
";
return queryObjectPage;
}
/**生成XML delete*/
public static String generateXmlDelete(Object model,String prefix){
String simpleName&＃61;model.getClass().getSimpleName();
String upperSimpleName &＃61; simpleName.replaceFirst(simpleName.substring(0, 1), simpleName.substring(0, 1).toUpperCase());
String del&＃61;"\n";
del&＃43;&＃61;"
\n";
del&＃43;&＃61;"DELETE FROM "&＃43;prefix&＃43;getColumnName(upperSimpleName).toUpperCase().substring(1)&＃43;" WHERE ID &＃61; #{id}\n";
del&＃43;&＃61;"";
return del;
}
/**逆向转换字符串*/
public static String getColumnName(String field){
field&＃61;field.replaceAll("A", "_A");
field&＃61;field.replaceAll("B", "_B");
field&＃61;field.replaceAll("C", "_C");
field&＃61;field.replaceAll("D", "_D");
field&＃61;field.replaceAll("E", "_E");
field&＃61;field.replaceAll("F", "_F");
field&＃61;field.replaceAll("G", "_G");
field&＃61;field.replaceAll("H", "_H");
field&＃61;field.replaceAll("I", "_I");
field&＃61;field.replaceAll("J", "_J");
field&＃61;field.replaceAll("K", "_K");
field&＃61;field.replaceAll("L", "_L");
field&＃61;field.replaceAll("M", "_M");
field&＃61;field.replaceAll("N", "_N");
field&＃61;field.replaceAll("O", "_O");
field&＃61;field.replaceAll("P", "_P");
field&＃61;field.replaceAll("Q", "_Q");
field&＃61;field.replaceAll("R", "_R");
field&＃61;field.replaceAll("S", "_S");
field&＃61;field.replaceAll("T", "_T");
field&＃61;field.replaceAll("U", "_U");
field&＃61;field.replaceAll("V", "_V");
field&＃61;field.replaceAll("W", "_W");
field&＃61;field.replaceAll("X", "_X");
field&＃61;field.replaceAll("Y", "_Y");
field&＃61;field.replaceAll("Z", "_Z");
return field;
}
}
使用该方法生成xml文件时要注意变量以及数据库字段命名格式
![[大整数乘法] java代码实现](https://img1.php1.cn/3cd4a/24c6f/9f3/0133bb25da242824.jpeg)
京公网安备 11010802041100号