Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
com.zengtengpeng.autoCode.create.BuildXml Maven / Gradle / Ivy
package com.zengtengpeng.autoCode.create;
import com.zengtengpeng.autoCode.enums.XmlElementType;
import com.zengtengpeng.autoCode.bean.BuildXmlBean;
import com.zengtengpeng.autoCode.config.AutoCodeConfig;
import com.zengtengpeng.autoCode.config.GlobalConfig;
import com.zengtengpeng.autoCode.utils.BuildUtils;
import com.zengtengpeng.autoCode.utils.MyStringUtils;
import com.zengtengpeng.jdbc.bean.Bean;
import com.zengtengpeng.jdbc.bean.BeanColumn;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
/**
* 创建xml
*/
@FunctionalInterface
public interface BuildXml {
/**
* 创建insert
*
* @return
*/
default BuildXml insert(AutoCodeConfig init,StringBuffer content) {
Bean bean = init.getBean();
BeanColumn beanColumn = bean.getPrimaryKey().get(0);
BuildXmlBean buildXmlBean=new BuildXmlBean();
buildXmlBean.setXmlElementType(XmlElementType.insert);
Map attr=new LinkedHashMap<>();
attr.put("id","insert");
attr.put("keyColumn",beanColumn.getJdbcName());
attr.put("keyProperty",beanColumn.getBeanName());
attr.put("useGeneratedKeys","true");
buildXmlBean.setAttributes(attr);
StringBuffer sql=new StringBuffer();
MyStringUtils.append(sql, "insert into %s (", 2, bean.getDataName());
bean.getAllColumns().forEach(t -> {
if (!t.getIdentity() && !"CURRENT_TIMESTAMP".equals(t.getDefaultValue())) {
MyStringUtils.append(sql, t.getJdbcName() + ",", 2);
}
});
sql.deleteCharAt(sql.length()-2);
MyStringUtils.append(sql, ")\n \t values (", 2);
bean.getAllColumns().forEach(t -> {
if (!t.getIdentity()&& !"CURRENT_TIMESTAMP".equals(t.getDefaultValue())) {
MyStringUtils.append(sql, " #{%s,jdbcType=%s},", 2, t.getBeanName(), t.getJdbcType_());
}
});
sql.deleteCharAt(sql.length()-2);
MyStringUtils.append(sql, ")\n", 2);
buildXmlBean.setSql(sql.toString());
content.append(BuildUtils.buildXml(buildXmlBean));
return this;
}
/**
* 创建delete
*
* @return
*/
default BuildXml deleteByPrimaryKey(AutoCodeConfig init,StringBuffer content) {
Bean bean = init.getBean();
BuildXmlBean buildXmlBean=new BuildXmlBean();
buildXmlBean.setXmlElementType(XmlElementType.delete);
Map attr=new LinkedHashMap<>();
attr.put("id","deleteByPrimaryKey");
buildXmlBean.setAttributes(attr);
StringBuffer sql=new StringBuffer();
MyStringUtils.append(sql, "delete from %s \n",2, bean.getDataName());
BeanColumn beanColumn = bean.getPrimaryKey().get(0);
MyStringUtils.append(sql, "where %s = #{%s} \n ",2, beanColumn.getJdbcName(), beanColumn.getBeanName());
buildXmlBean.setSql(sql.toString());
content.append(BuildUtils.buildXml(buildXmlBean));
return this;
}
/**
* 修改
*
* @return
*/
default BuildXml update(AutoCodeConfig init,StringBuffer content) {
Bean bean = init.getBean();
BuildXmlBean buildXmlBean=new BuildXmlBean();
buildXmlBean.setXmlElementType(XmlElementType.update);
Map attr=new LinkedHashMap<>();
attr.put("id","update");
buildXmlBean.setAttributes(attr);
StringBuffer sql=new StringBuffer();
MyStringUtils.append(sql, "update %s",2, bean.getDataName());
MyStringUtils.append(sql, "",2);
bean.getAllColumns().forEach(t -> {
if (!t.getKey()) {
if ("java.lang.String".equalsIgnoreCase(t.getBeanType())) {
MyStringUtils.append(sql, "%s = #{%s,jdbcType=%s}, ",3,
t.getBeanName(), t.getBeanName(), t.getJdbcName(), t.getBeanName(), t.getJdbcType_());
} else {
MyStringUtils.append(sql, "%s = #{%s,jdbcType=%s}, ",3,
t.getBeanName(), t.getJdbcName(), t.getBeanName(), t.getJdbcType_());
}
}
});
BeanColumn beanColumn = bean.getPrimaryKey().get(0);
MyStringUtils.append(sql, " ",2);
MyStringUtils.append(sql, "where %s=#{%s}",2, beanColumn.getJdbcName(), beanColumn.getBeanName());
buildXmlBean.setSql(sql.toString());
content.append(BuildUtils.buildXml(buildXmlBean));
return this;
}
/**
* 根据主键查询
*
* @return
*/
default BuildXml selectByPrimaryKey(AutoCodeConfig init,StringBuffer content) {
Bean bean = init.getBean();
BuildXmlBean buildXmlBean=new BuildXmlBean();
buildXmlBean.setXmlElementType(XmlElementType.select);
Map attr=new LinkedHashMap<>();
attr.put("id","selectByPrimaryKey");
attr.put("resultMap","BaseResultMap");
buildXmlBean.setAttributes(attr);
StringBuffer sql=new StringBuffer();
MyStringUtils.append(sql, "select",2);
bean.getAllColumns().forEach(t -> MyStringUtils.append(sql, "%s,",2, t.getJdbcName()));
sql.deleteCharAt(sql.length() - 2);
MyStringUtils.append(sql, "from %s",2, bean.getDataName());
BeanColumn beanColumn = bean.getPrimaryKey().get(0);
MyStringUtils.append(sql, "where %s = #{%s,jdbcType=%s}",2, beanColumn.getJdbcName(), beanColumn.getBeanName(), beanColumn.getJdbcType_());
buildXmlBean.setSql(sql.toString());
content.append(BuildUtils.buildXml(buildXmlBean));
return this;
}
/**
* 查询所有
*
* @return
*/
default BuildXml selectAll(AutoCodeConfig init,StringBuffer content) {
select("selectAll",init,content);
return this;
}
/**
* 根据条件查询
*
* @return
*/
default BuildXml selectByCondition(AutoCodeConfig init,StringBuffer content) {
select("selectByCondition", init,content);
return this;
}
default void select(String id, AutoCodeConfig init,StringBuffer content) {
Bean bean = init.getBean();
BuildXmlBean buildXmlBean=new BuildXmlBean();
buildXmlBean.setXmlElementType(XmlElementType.select);
Map attr=new LinkedHashMap<>();
attr.put("id",id);
attr.put("resultMap","BaseResultMap");
buildXmlBean.setAttributes(attr);
StringBuffer sql=new StringBuffer();
MyStringUtils.append(sql, "select",2);
bean.getAllColumns().forEach(t -> MyStringUtils.append(sql, "%s,",2, t.getJdbcName()));
sql.deleteCharAt(sql.length() - 2);
MyStringUtils.append(sql, "from %s",2, bean.getDataName(),bean.getDataName());
BeanColumn beanColumn = bean.getPrimaryKey().get(0);
MyStringUtils.append(sql, "",2);
BuildUtils.xmlWhere(bean, sql);
MyStringUtils.append(sql, " ",2);
MyStringUtils.append(sql, "\n" +
" \n" +
" ${orderByString}\n" +
" \n" +
" \n" +
" order by %s desc\n" +
" \n" +
" ",2, beanColumn.getJdbcName());
buildXmlBean.setSql(sql.toString());
content.append(BuildUtils.buildXml(buildXmlBean));
}
/**
* 创建之前的准备工作
*
* @return
*/
default BuildXml before(AutoCodeConfig init,StringBuffer content) {
GlobalConfig globalConfig = init.getGlobalConfig();
Bean bean = init.getBean();
MyStringUtils.append(content, "\n" +
"\n" +
"\n", globalConfig.getParentPack(), globalConfig.getPackageDao(), bean.getTableName(), globalConfig.getPackageDaoUp());
MyStringUtils.append(content, "\n",1, globalConfig.getParentPack(), globalConfig.getPackageBean(),
bean.getTableName());
for (BeanColumn allColumn : bean.getAllColumns()) {
if (allColumn.getKey()) {
MyStringUtils.append(content, " \n",1);
return this;
}
/**
* 创建之后的
*
* @return
*/
default BuildXml end(AutoCodeConfig init,StringBuffer content) {
content.append(" ");
return this;
}
/**
* 自定义sql
*/
List custom(AutoCodeConfig autoCodeConfig);
default String build(AutoCodeConfig autoCodeConfig) {
StringBuffer content=new StringBuffer();
BuildXml buildXml = before(autoCodeConfig,content).insert(autoCodeConfig,content).deleteByPrimaryKey(autoCodeConfig,content).
update(autoCodeConfig,content).selectByPrimaryKey(autoCodeConfig,content).selectAll(autoCodeConfig,content).selectByCondition(autoCodeConfig,content);
List custom = buildXml.custom(autoCodeConfig);
if(custom!=null){
custom.forEach(t-> content.append(BuildUtils.buildXml(t)).append("\n"));
}
buildXml.end(autoCodeConfig,content);
return content.toString();
}
}
