internal static void createDto(string path, string package, string basePackage, string tableName, string comment, string className, DataTable dt)
{
string firstClassName = className.Substring(0, 1).ToLower() + className.Substring(1);
StringBuilder sb = new StringBuilder();
sb.Append("package ").Append(package).Append(";").Append("\r\n\r\n");
sb.Append("import ").Append("java.io.Serializable;").Append("\r\n");
//sb.Append("/**").Append("\r\n");
//sb.Append(" * ").Append(comment).Append("\r\n");
//sb.Append(" * @creator 赵志豪\r\n");
//sb.Append(" * @create-time ").Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).Append("\r\n");
//sb.Append(" * @email ").Append("*****@*****.**").Append("\r\n");
//sb.Append(" * @version 1.0").Append("\r\n");
//sb.Append(" */").Append("\r\n");
sb.Append("public class ").Append(className).Append("Dto extends BaseDto<" + className + ">").Append(" implements Serializable {").Append("\r\n");
sb.Append("\t").Append("private static final long serialVersionUID = 7904053207325003853L;").Append("\r\n\r\n");
foreach (DataRow row in dt.Rows)
{
string dataTypeResult = DataTypeMapping.getDataType(row["dataType"].ToString());
//if(dataTypeResult == "String"){
string fieldName = row["fieldName"].ToString();
string firstFieldName = fieldName.Substring(0, 1).ToLower() + fieldName.Substring(1);
sb.Append("\t").Append("/** ").Append(row["comment"].ToString()).Append(" */").Append("\r\n");
sb.Append("\t").Append("private ").Append(dataTypeResult).Append(" ").Append(firstFieldName).Append(";").Append("\r\n");;
//}
}
sb.Append("\r\n");
//get set 封装
foreach (DataRow row in dt.Rows)
{
string dataTypeResult = DataTypeMapping.getDataType(row["dataType"].ToString());
//if (dataTypeResult == "String")
//{
string fieldName = row["fieldName"].ToString();
string firstFieldName = fieldName.Substring(0, 1).ToLower() + fieldName.Substring(1);
//get
sb.Append("\t").Append("/** ").Append(row["comment"].ToString()).Append(" */").Append("\r\n");
sb.Append("\t").Append("public ").Append(dataTypeResult).Append(" get").Append(fieldName).Append("(){").Append("\r\n");
sb.Append("\t\t").Append("return this.").Append(firstFieldName).Append(";").Append("\r\n");
sb.Append("\t").Append("}").Append("\r\n\r\n");
//set
sb.Append("\t").Append("/** ").Append(row["comment"].ToString()).Append(" */").Append("\r\n");
sb.Append("\t").Append("public ").Append("void").Append(" set").Append(fieldName).Append("(String ").Append(firstFieldName).Append("){").Append("\r\n");
sb.Append("\t\t").Append("this.").Append(firstFieldName).Append(" = ").Append(firstFieldName).Append(";").Append("\r\n");
sb.Append("\t").Append("}").Append("\r\n\r\n");
//}
}
sb.Append("}");
CodeGenerationFactory.write(path + "\\" + className + "Dto.java", path, sb.ToString());
}
internal static void createPojo(string path, string package, string basePackage, string tableName, string comment, string className, DataTable dt)
{
string firstClassName = className.Substring(0, 1).ToLower() + className.Substring(1);
StringBuilder sb = new StringBuilder();
sb.Append("package ").Append(package).Append(";").Append("\r\n\r\n");
sb.Append("import ").Append(" java.io.Serializable;").Append("\r\n\r\n");
sb.Append("import ").Append(" io.swagger.annotations.ApiModel;").Append("\r\n\r\n");
sb.Append("import ").Append(" io.swagger.annotations.ApiModelProperty;").Append("\r\n\r\n");
sb.Append("import java.util.Date;").Append("\r\n");
//sb.Append("/**").Append("\r\n");
//sb.Append(" * ").Append(comment).Append("\r\n");
//sb.Append(" * @creator 赵志豪\r\n");
//sb.Append(" * @create-time ").Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).Append("\r\n");
//sb.Append(" * @email ").Append("*****@*****.**").Append("\r\n");
//sb.Append(" * @version 1.0").Append("\r\n");
//sb.Append(" */").Append("\r\n");
sb.Append("@ApiModel").Append("\r\n");
sb.Append("public class ").Append(className).Append(" implements Serializable {").Append("\r\n");
sb.Append("\t").Append("private static final long serialVersionUID = 1L;").Append("\r\n\r\n");
foreach (DataRow row in dt.Rows)
{
string dataTypeResult = DataTypeMapping.getDataType(row["dataType"].ToString());
string fieldName = row["fieldName"].ToString();
string firstFieldName = fieldName.Substring(0, 1).ToLower() + fieldName.Substring(1);
sb.Append("\t").Append("/** ").Append(row["comment"].ToString()).Append(" */").Append("\r\n");
sb.Append("\t").Append("@ApiModelProperty(value = ").Append("\"" + row["comment"].ToString() + "\")").Append("\r\n");
sb.Append("\t").Append("private ").Append(dataTypeResult).Append(" ").Append(firstFieldName).Append(";").Append("\r\n");
}
sb.Append("\r\n");
foreach (DataRow row in dt.Rows)
{
string dataTypeResult = DataTypeMapping.getDataType(row["dataType"].ToString());
string fieldName = row["fieldName"].ToString().Substring(0, 1).ToUpper() + row["fieldName"].ToString().Substring(1);
string firstFieldName = fieldName.Substring(0, 1).ToLower() + fieldName.Substring(1);
//get
sb.Append("\t").Append("/** ").Append(row["comment"].ToString()).Append(" */").Append("\r\n");
sb.Append("\t").Append("public ").Append(dataTypeResult).Append(" get").Append(fieldName).Append("(){").Append("\r\n");
sb.Append("\t\t").Append("return this.").Append(firstFieldName).Append(";").Append("\r\n");
sb.Append("\t").Append("}").Append("\r\n\r\n");
//set
sb.Append("\t").Append("/** ").Append(row["comment"].ToString()).Append(" */").Append("\r\n");
sb.Append("\t").Append("public ").Append("void").Append(" set").Append(fieldName).Append("(").Append(dataTypeResult).Append(" ").Append(firstFieldName).Append("){").Append("\r\n");
sb.Append("\t\t").Append("this.").Append(firstFieldName).Append(" = ").Append(firstFieldName).Append(";").Append("\r\n");
sb.Append("\t").Append("}").Append("\r\n\r\n");
}
sb.Append("}");
CodeGenerationFactory.write(path + "\\" + className + ".java", path, sb.ToString());
}
internal static void createVo(string path, string package, string basePackage, string tableName, string comment, string className, DataTable dt)
{
string firstClassName = className.Substring(0, 1).ToLower() + className.Substring(1);
StringBuilder sb = new StringBuilder();
sb.Append("package ").Append(package).Append(";").Append("\r\n\r\n");
sb.Append("import ").Append("java.io.Serializable;").Append("\r\n");
sb.Append("import com.fasterxml.jackson.databind.annotation.JsonSerialize;").Append("\r\n");
sb.Append("import io.swagger.annotations.ApiModel;").Append("\r\n");
sb.Append("import lombok.AllArgsConstructor;").Append("\r\n");
sb.Append("import lombok.Builder;").Append("\r\n");
sb.Append("import lombok.Data;").Append("\r\n");
sb.Append("import lombok.NoArgsConstructor;").Append("\r\n");
sb.Append("import lombok.Builder;").Append("\r\n");
sb.Append("import io.swagger.annotations.ApiModelProperty;");
//sb.Append("/**").Append("\r\n");
//sb.Append(" * ").Append(comment).Append("\r\n");
//sb.Append(" * @creator 赵志豪\r\n");
//sb.Append(" * @create-time ").Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).Append("\r\n");
//sb.Append(" * @email ").Append("*****@*****.**").Append("\r\n");
//sb.Append(" * @version 1.0").Append("\r\n");
//sb.Append(" */").Append("\r\n");
sb.Append("@Builder").Append("\r\n");
sb.Append("@Data").Append("\r\n");
sb.Append("@NoArgsConstructor").Append("\r\n");
sb.Append("@AllArgsConstructor").Append("\r\n");
sb.Append("@JsonSerialize(include = JsonSerialize.Inclusion.NON_NULL)").Append("\r\n");
sb.Append("@ApiModel").Append("\r\n");
sb.Append("public class ").Append(className).Append("Vo ").Append(" implements Serializable {").Append("\r\n");
sb.Append("\t").Append("private static final long serialVersionUID = 7904053207325003853L;").Append("\r\n\r\n");
foreach (DataRow row in dt.Rows)
{
string dataTypeResult = DataTypeMapping.getDataType(row["dataType"].ToString());
//if(dataTypeResult == "String"){
string fieldName = row["columnName"].ToString();
sb.Append("\t").Append("/** ").Append(row["comment"].ToString()).Append(" */").Append("\r\n");
sb.Append("\t").Append("@ApiModelProperty(value = ").Append("\"" + row["comment"].ToString() + "\")").Append("\r\n");
sb.Append("\t").Append("private ").Append(dataTypeResult).Append(" ").Append(fieldName).Append(";").Append("\r\n");;
//}
}
sb.Append("\r\n");
sb.Append("}");
CodeGenerationFactory.write(path + "\\" + className + "Vo.java", path, sb.ToString());
}
private void Main_Load(object sender, EventArgs e)
{
DataTypeMapping.initDataMap();
String path = @"dataList.txt";
dataList = Read(path);
foreach (DataModel data in dataList)
{
this.cbb_huihuaList.Items.Add(data);
}
this.cbb_huihuaList.DisplayMember = "ShowText";
this.cbb_huihuaList.ValueMember = "Item";
this.dgv_column_info.AutoGenerateColumns = false;
this.dgv_tables_info.AutoGenerateColumns = false;
this.dgv_tables_info.Columns[0].ReadOnly = true;
this.dgv_column_info.Columns[0].ReadOnly = true;
}
public static void createDao(string path, string package, string basePackage, string tableName, string comment, string className, DataTable dt)
{
string firstClassName = className.Substring(0, 1).ToLower() + className.Substring(1);
StringBuilder sb = new StringBuilder();
sb.Append("package ").Append(package).Append(";").Append("\r\n\r\n");
sb.Append("import ").Append("java.util.List;").Append("\r\n");
sb.Append("import ").Append("org.apache.ibatis.annotations.Param;").Append("\r\n");
sb.Append("import ").Append("org.apache.ibatis.session.RowBounds;").Append("\r\n");
sb.Append("import ").Append("org.springframework.stereotype.Repository;").Append("\r\n\r\n");
sb.Append("import ").Append(basePackage).Append(".entity.").Append(className).Append(";").Append("\r\n");
sb.Append("import ").Append(basePackage).Append(".model.").Append(className).Append("Condition;").Append("\r\n");
//sb.Append("/**").Append("\r\n");
//sb.Append(" * ").Append(comment).Append("\r\n");
//sb.Append(" * @creator 赵志豪\r\n");
//sb.Append(" * @create-time ").Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).Append("\r\n");
//sb.Append(" * @email ").Append("*****@*****.**").Append("\r\n");
//sb.Append(" * @version 1.0").Append("\r\n");
//sb.Append(" */").Append("\r\n");
sb.Append("@Repository(\"" + firstClassName + "DaoImpl\")").Append("\r\n");
sb.Append("public interface I").Append(className).Append("Dao{").Append("\r\n\r\n");
//查询所有数据
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 查询所有").Append(comment).Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append("List<").Append(className).Append("> list" + className + "All();").Append("\r\n\r\n");
//查询总数
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 查询总数").Append("\r\n");
sb.Append("\t *").Append("@param condition 查询条件类").Append("\r\n");
sb.Append("\t *").Append("@return 总条数").Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append("int get" + className + "ByPageCount").Append("(@Param(\"condition\") " + className + "Model condition);").Append("\r\n\r\n");
//查询分页数据
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 分页查询").Append("\r\n");
sb.Append("\t *").Append("@param bounds RowBounds对象").Append("\r\n");
sb.Append("\t *").Append("@param condition 查询条件类").Append("\r\n");
sb.Append("\t *").Append("@return 总条数").Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append("List<").Append(className).Append("> list").Append(className).Append("ByPage(@Param(\"condition\") ").Append(className).Append("Model condition").Append(",RowBounds bounds);").Append("\r\n\r\n");
string resultDataType = "Long";
foreach (DataRow row in dt.Rows)
{
string fieldName = row["fieldName"].ToString().Substring(0, 1).ToUpper() + row["fieldName"].ToString().Substring(1);
if (fieldName == "Id")
{
resultDataType = DataTypeMapping.getDataType(row["dataType"].ToString());
break;
}
}
//根据ID查询
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 根据ID查询").Append("\r\n");
sb.Append("\t *").Append("@param id 主键").Append("\r\n");
sb.Append("\t *").Append("@return ").Append(comment).Append("\r\n");;
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append(className).Append(" get" + className + "ById").Append("(@Param(\"id\") " + resultDataType + " id);").Append("\r\n\r\n");
//新增
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 新增").Append("\r\n");
sb.Append("\t *").Append("@param item ").Append(comment).Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append("void add(").Append(className).Append(" item);").Append("\r\n\r\n");
//批量新增
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 批量新增").Append("\r\n");
sb.Append("\t *").Append("@param List ").Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append("void batchInsert(").Append("List<" + className + "> arrayList);").Append("\r\n\r\n");
//修改
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 修改").Append("\r\n");
sb.Append("\t *").Append("@param item ").Append(comment).Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append("void update(").Append(className).Append(" item);").Append("\r\n\r\n");
//删除
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 删除").Append("\r\n");
sb.Append("\t *").Append("@param item ").Append(comment).Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append("void delByIds(").Append("List<" + resultDataType + "> ids);").Append("\r\n\r\n");
sb.Append("}").Append("\r\n");
//生成
CodeGenerationFactory.write(path + "\\I" + className + "Dao.java", path, sb.ToString());
}
internal static void createService(string path, string package, string basePackage, string tableName, string comment, string className, DataTable dt)
{
string[] packages = basePackage.Split('.');
string packageComBase = "";
for (int i = 0; i < 2; i++)
{
packageComBase += packages[i] + ".";
}
string firstClassName = className.Substring(0, 1).ToLower() + className.Substring(1);
StringBuilder sb = new StringBuilder();
sb.Append("package ").Append(package).Append(";").Append("\r\n\r\n");
sb.Append("import ").Append("java.util.List;").Append("\r\n");
sb.Append("import ").Append(packageComBase).Append("base.page.PageResult;").Append("\r\n");
sb.Append("import ").Append(basePackage).Append(".entity.").Append(className).Append(";").Append("\r\n");
sb.Append("import ").Append(basePackage).Append(".dto.").Append(className).Append("Dto;").Append("\r\n");
//sb.Append("/**").Append("\r\n");
//sb.Append(" * ").Append(comment).Append("\r\n");
//sb.Append(" * @creator 赵志豪\r\n");
//sb.Append(" * @create-time ").Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).Append("\r\n");
//sb.Append(" * @email ").Append("*****@*****.**").Append("\r\n");
//sb.Append(" * @version 1.0").Append("\r\n");
//sb.Append(" */").Append("\r\n");
sb.Append("public interface I").Append(className).Append("Service{").Append("\r\n\r\n");
//查询所有数据
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 查询所有").Append(comment).Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append("List<").Append(className).Append("> list" + className + "All();").Append("\r\n\r\n");
//根据条件查询
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 根据条件查询").Append(comment).Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append("List<").Append(className).Append("> list" + className + "ByCondition").Append("(" + className + "Dto condition);").Append("\r\n\r\n");
//查询总数
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 查询总数").Append("\r\n");
sb.Append("\t *").Append("@param condition 查询条件类").Append("\r\n");
sb.Append("\t *").Append("@return 总条数").Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append("int get" + className + "ByPageCount").Append("(" + className + "Dto condition);").Append("\r\n\r\n");
//分页方法
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 分页查询").Append("\r\n");
sb.Append("\t *").Append("@param pageResult 分页对象").Append("\r\n");
sb.Append("\t *").Append("@param condition 查询条件类").Append("\r\n");
sb.Append("\t *").Append("@return 总条数").Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append("void list").Append(className).Append("ByPage(").Append(className).Append("Dto condition);").Append("\r\n\r\n");
string resultDataType = "Long";
foreach (DataRow row in dt.Rows)
{
string fieldName = row["fieldName"].ToString().Substring(0, 1).ToUpper() + row["fieldName"].ToString().Substring(1);
if (fieldName == "Id")
{
resultDataType = DataTypeMapping.getDataType(row["dataType"].ToString());
break;
}
}
//根据ID查询
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 根据ID查询").Append("\r\n");
sb.Append("\t *").Append("@param id 主键").Append("\r\n");
sb.Append("\t *").Append("@return ").Append(comment).Append("\r\n");;
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append(className).Append(" get" + className + "ById").Append("(" + resultDataType + " id);").Append("\r\n\r\n");
//新增
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 新增").Append("\r\n");
sb.Append("\t *").Append("@param item ").Append(comment).Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append(className).Append(" add(").Append(className).Append(" item);").Append("\r\n\r\n");
//批量新增
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 批量新增").Append("\r\n");
sb.Append("\t *").Append("@param List ").Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append("void batchInsert(").Append("List<" + className + "> arrayList);").Append("\r\n\r\n");
//修改
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 修改").Append("\r\n");
sb.Append("\t *").Append("@param item ").Append(comment).Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append(className).Append(" update(").Append(className).Append(" item);").Append("\r\n\r\n");
//删除
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 删除").Append("\r\n");
sb.Append("\t *").Append("@param item ").Append(comment).Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t").Append("void delByIds(").Append("List<" + resultDataType + "> ids);").Append("\r\n\r\n");
sb.Append("}");
CodeGenerationFactory.write(path + "\\I" + className + "Service.java", path, sb.ToString());
}
internal static void createServiceImpl(string path, string package, string basePackage, string tableName, string comment, string className, DataTable dt)
{
string[] packages = basePackage.Split('.');
string packageComBase = "";
for (int i = 0; i < 2; i++)
{
packageComBase += packages[i] + ".";
}
string firstClassName = className.Substring(0, 1).ToLower() + className.Substring(1);
StringBuilder sb = new StringBuilder();
sb.Append("package ").Append(package).Append(";").Append("\r\n\r\n");
sb.Append("import ").Append("java.util.List;").Append("\r\n");
sb.Append("import javax.annotation.Resource;").Append("\r\n");
sb.Append("import org.springframework.stereotype.Service;").Append("\r\n");;
sb.Append("import org.springframework.transaction.annotation.Transactional;").Append("\r\n\r\n");
sb.Append("import org.apache.ibatis.session.RowBounds;").Append("\r\n");
sb.Append("import ").Append(packageComBase).Append("base.page.PageResult;").Append("\r\n");
sb.Append("import ").Append(basePackage).Append(".service.").Append("I").Append(className).Append("Service;").Append("\r\n");
sb.Append("import ").Append(basePackage).Append(".entity.").Append(className).Append(";").Append("\r\n");
sb.Append("import ").Append(basePackage).Append(".dto.").Append(className).Append("Dto;").Append("\r\n");
sb.Append("import ").Append(basePackage).Append(".dao.").Append("I").Append(className).Append("Dao;").Append("\r\n");
//sb.Append("/**").Append("\r\n");
//sb.Append(" * ").Append(comment).Append("\r\n");
//sb.Append(" * @creator 赵志豪\r\n");
//sb.Append(" * @create-time ").Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).Append("\r\n");
//sb.Append(" * @email ").Append("*****@*****.**").Append("\r\n");
//sb.Append(" * @version 1.0").Append("\r\n");
//sb.Append(" */").Append("\r\n");
sb.Append("@Service(\"" + firstClassName + "ServiceImpl\")").Append("\r\n");
sb.Append("@Transactional(value = \"transactionManager\")").Append("\r\n");
sb.Append("public class ").Append(className).Append("ServiceImpl implements I").Append(className).Append("Service{").Append("\r\n\r\n");
sb.Append("\t@Resource(name = \"" + firstClassName + "DaoImpl\")").Append("\r\n");
sb.Append("\tprivate I").Append(className).Append("Dao ").Append(firstClassName).Append("Dao;").Append("\r\n\r\n\r\n\r\n");
//查询所有数据
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 查询所有").Append(comment).Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t@Override").Append("\r\n");
sb.Append("\t").Append("public List<").Append(className).Append("> list" + className + "All(){").Append("\r\n");
sb.Append("\t\t").Append("return ").Append(firstClassName).Append("Dao.list").Append(className).Append("All();").Append("\r\n");
sb.Append("\t").Append("}").Append("\r\n\r\n");
//根据条件查询
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 根据条件查询").Append(comment).Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t@Override").Append("\r\n");
sb.Append("\t").Append("public ").Append("List<").Append(className).Append("> list" + className + "ByCondition").Append("(" + className + "Dto condition){").Append("\r\n");
sb.Append("\t\t").Append("return ").Append(firstClassName).Append("Dao.list").Append(className).Append("ByPage(condition,null);").Append("\r\n");
sb.Append("\t}").Append("\r\n");
//查询总数
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 查询总数").Append("\r\n");
sb.Append("\t *").Append("@param condition 查询条件类").Append("\r\n");
sb.Append("\t *").Append("@return 总条数").Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t@Override").Append("\r\n");
sb.Append("\t").Append("public int get" + className + "ByPageCount").Append("(" + className + "Dto condition){").Append("\r\n");
sb.Append("\t\t").Append("return ").Append(firstClassName).Append("Dao.get").Append(className).Append("ByPageCount(condition);").Append("\r\n");
sb.Append("\t").Append("}").Append("\r\n\r\n");
//分页方法
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 分页查询").Append("\r\n");
sb.Append("\t *").Append("@param pageResult 分页对象").Append("\r\n");
sb.Append("\t *").Append("@param condition 查询条件类").Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t@Override").Append("\r\n");
sb.Append("\t").Append("public void list").Append(className).Append("ByPage(").Append(className).Append("Dto condition){").Append("\r\n");
sb.Append("\t\t").Append("int rows = ").Append(firstClassName).Append("Dao.get").Append(className).Append("ByPageCount(condition);").Append("\r\n");
sb.Append("\t\t").Append("pageResult.setRows(rows);").Append("\r\n");
sb.Append("\t\t").Append("RowBounds rowBounds = new RowBounds(condition.pageResult.getCurrentPageIndex(),condition.pageResult.getPageSize());").Append("\r\n");
sb.Append("\t\t").Append("List<").Append(className).Append("> list = ").Append(firstClassName).Append("Dao.list").Append(className).Append("ByPage(condition,rowBounds);").Append("\r\n");
sb.Append("\t\t").Append("pageResult.setResult(list);").Append("\r\n");
sb.Append("\t").Append("}").Append("\r\n\r\n");
string resultDataType = "Long";
foreach (DataRow row in dt.Rows)
{
string fieldName = row["fieldName"].ToString().Substring(0, 1).ToUpper() + row["fieldName"].ToString().Substring(1);
if (fieldName == "Id")
{
resultDataType = DataTypeMapping.getDataType(row["dataType"].ToString());
break;
}
}
//根据ID查询
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 根据ID查询").Append("\r\n");
sb.Append("\t *").Append("@param id 主键").Append("\r\n");
sb.Append("\t *").Append("@return ").Append(comment).Append("\r\n");;
sb.Append("\t */").Append("\r\n");
sb.Append("\t@Override").Append("\r\n");
sb.Append("\t").Append("public ").Append(className).Append(" get" + className + "ById").Append("(" + resultDataType + " id){").Append("\r\n");
sb.Append("\t\t").Append("return ").Append(firstClassName).Append("Dao.get").Append(className).Append("ById(id);").Append("\r\n");
sb.Append("\t").Append("}").Append("\r\n\r\n");
//新增
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 新增").Append("\r\n");
sb.Append("\t *").Append("@param item ").Append(comment).Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t@Override").Append("\r\n");
sb.Append("\t").Append("public ").Append(className).Append(" add(").Append(className).Append(" item){").Append("\r\n");
sb.Append("\t\t").Append(firstClassName).Append("Dao.add(item);").Append("\r\n");
sb.Append("\t\t").Append("return item;").Append("\r\n");
sb.Append("\t").Append("}").Append("\r\n\r\n");
//批量新增
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 批量新增").Append("\r\n");
sb.Append("\t *").Append("@param List ").Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t@Override").Append("\r\n");
sb.Append("\t").Append("public void").Append(" batchInsert(").Append("List<" + className + "> arrayList){").Append("\r\n\r\n");
sb.Append("\t\t").Append(firstClassName).Append("Dao.batchInsert(arrayList);").Append("\r\n");
sb.Append("\t").Append("}").Append("\r\n\r\n");
//修改
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 修改").Append("\r\n");
sb.Append("\t *").Append("@param item ").Append(comment).Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t@Override").Append("\r\n");
sb.Append("\t").Append("public ").Append(className).Append(" update(").Append(className).Append(" item){").Append("\r\n");
sb.Append("\t\t").Append(firstClassName).Append("Dao.update(item);").Append("\r\n");
sb.Append("\t\t").Append("return item;").Append("\r\n");
sb.Append("\t").Append("}").Append("\r\n\r\n");
//删除
sb.Append("\t/**").Append("\r\n");
sb.Append("\t * 删除").Append("\r\n");
sb.Append("\t *").Append("@param item ").Append(comment).Append("\r\n");
sb.Append("\t */").Append("\r\n");
sb.Append("\t@Override").Append("\r\n");
sb.Append("\t").Append("public void").Append(" delByIds(List<" + resultDataType + "> ids){").Append("\r\n");
sb.Append("\t\t").Append(firstClassName).Append("Dao.delByIds(ids);").Append("\r\n");
sb.Append("\t").Append("}").Append("\r\n\r\n");
sb.Append("}");
CodeGenerationFactory.write(path + "\\" + className + "ServiceImpl.java", path, sb.ToString());
}
internal static void createMapper(string path, string package, string basePackage, string tableName, string comment, string className, DataTable dt)
{
string firstClassName = className.Substring(0, 1).ToLower() + className.Substring(1);
string entityPackage = package.Substring(0, package.LastIndexOf(".")) + ".entity.";
StringBuilder sb = new StringBuilder();
sb.Append("<?xml version=\"1.0\" encoding=\"UTF-8\" ?>").Append("\r\n");
sb.Append("<!DOCTYPE mapper PUBLIC \"-//mybatis.org//DTD Mapper 3.0//EN\" ").Append("\"http://mybatis.org/dtd/mybatis-3-mapper.dtd\">").Append("\r\n");
sb.Append("<mapper namespace=\"" + package + ".I" + className + "Dao\">").Append("\r\n");
sb.Append("\t").Append("<resultMap type=\"" + entityPackage + className + "\" id=\"" + firstClassName + "ResultMap\" >").Append("\r\n");
foreach (DataRow row in dt.Rows)
{
string fieldName = row["fieldName"].ToString();
string firstFieldName = fieldName.Substring(0, 1).ToLower() + fieldName.Substring(1);
sb.Append("\t\t").Append("<!-- " + row["comment"] + " -->").Append("\r\n");
sb.Append("\t\t").Append("<result property=\"" + firstFieldName + "\" column=\"" + row["columnName"].ToString() + "\" />").Append("\r\n");
}
sb.Append("\t").Append("</resultMap>").Append("\r\n\r\n\r\n");
sb.Append("\t").Append("<sql id=\"allColumnSql\">").Append("\r\n");
for (int i = 0; i < dt.Rows.Count - 1; i++)
{
sb.Append("\t\t").Append("o." + dt.Rows[i]["columnName"].ToString() + ",").Append("\r\n");
}
sb.Append("\t\t").Append("o." + dt.Rows[dt.Rows.Count - 1]["columnName"].ToString()).Append("\r\n");
sb.Append("\t").Append("</sql>").Append("\r\n\r\n\r\n");
sb.Append("\t").Append("<sql id=\"searchConditionSql\">").Append("\r\n");
foreach (DataRow row in dt.Rows)
{
string dataTypeResult = DataTypeMapping.getDataType(row["dataType"].ToString());
if (dataTypeResult == "String")
{
string fieldName = row["fieldName"].ToString();
string firstFieldName = fieldName.Substring(0, 1).ToLower() + fieldName.Substring(1);
sb.Append("\t\t").Append("<if test=\"condition." + firstFieldName + " != null and condition." + firstFieldName + " != ''\">").Append("\r\n");
sb.Append("\t\t\t").Append("AND o.").Append(row["columnName"].ToString()).Append(" like '%${condition.").Append(firstFieldName).Append("}%'").Append("\r\n");
sb.Append("\t\t").Append("</if>").Append("\r\n");
}
}
sb.Append("\t").Append("</sql>").Append("\r\n\r\n");
//查询全部
sb.Append("\t").Append("<select id=\"list" + className + "All\" resultMap=\"" + firstClassName + "ResultMap\">").Append("\r\n");
sb.Append("\t\t").Append("SELECT <include refid=\"allColumnSql\"/>").Append("\r\n");
sb.Append("\t\t").Append("FROM " + tableName + " o").Append("\r\n");
sb.Append("\t").Append("</select>").Append("\r\n\r\n");
//查询总数
sb.Append("\t").Append("<select id=\"get" + className + "ByPageCount\" resultType=\"int\">").Append("\r\n");
sb.Append("\t\t").Append("SELECT count(1)").Append("\r\n");
sb.Append("\t\t").Append("FROM " + tableName + " o").Append("\r\n");
sb.Append("\t\t").Append("WHERE 1=1 <include refid=\"searchConditionSql\"/>").Append("\r\n");
sb.Append("\t").Append("</select>").Append("\r\n\r\n");
//查询数据
sb.Append("\t").Append("<select id=\"list" + className + "ByPage\" resultMap=\"" + firstClassName + "ResultMap\">").Append("\r\n");
sb.Append("\t\t").Append("SELECT <include refid=\"allColumnSql\"/>").Append("\r\n");
sb.Append("\t\t").Append("FROM " + tableName + " o").Append("\r\n");
sb.Append("\t\t").Append("WHERE 1=1 <include refid=\"searchConditionSql\"/>").Append("\r\n");
sb.Append("\t").Append("</select>").Append("\r\n\r\n");
//根据ID获取数据
sb.Append("\t").Append("<select id=\"get" + className + "ById\" resultMap=\"" + firstClassName + "ResultMap\">").Append("\r\n");
sb.Append("\t\t").Append("SELECT <include refid=\"allColumnSql\"/>").Append("\r\n");
sb.Append("\t\t").Append("FROM " + tableName + " o").Append("\r\n");
sb.Append("\t\t").Append("WHERE o.ID = #{id}").Append("\r\n");
sb.Append("\t").Append("</select>").Append("\r\n\r\n");
//新增
sb.Append("\t").Append("<insert id=\"add\" parameterType=\"" + entityPackage + className + "\"").Append(" useGeneratedKeys=\"true\" keyProperty=\"id\">").Append("\r\n");
sb.Append("\t\t").Append("INSERT INTO ").Append(tableName).Append("\r\n");
sb.Append("\t\t").Append("(").Append("\r\n");
sb.Append("\t\t").Append("<trim suffixOverrides=\",\"").Append(">").Append("\r\n");
for (int i = 1; i < dt.Rows.Count; i++)
{
DataRow row = dt.Rows[i];
string fielName = row["fieldName"].ToString();
string firstFielName = fielName.Substring(0, 1).ToLower() + fielName.Substring(1);
sb.Append("\t\t").Append("<if test=\"" + firstFielName + " != null \">").Append("\r\n");
sb.Append("\t\t").Append(row["columnName"].ToString()).Append(",").Append("\r\n");
sb.Append("\t\t").Append("</if>").Append("\r\n");
}
sb.Append("\t\t").Append("</trim>").Append("\r\n");
sb.Append("\t\t").Append(")").Append("\r\n");
sb.Append("\t\t").Append("VALUES").Append("\r\n");
sb.Append("\t\t").Append("(").Append("\r\n");
sb.Append("\t\t").Append("<trim suffixOverrides=\",\"").Append(">").Append("\r\n");
for (int i = 1; i < dt.Rows.Count; i++)
{
DataRow row = dt.Rows[i];
string fielName = row["fieldName"].ToString();
string firstFielName = fielName.Substring(0, 1).ToLower() + fielName.Substring(1);
sb.Append("\t\t").Append("<if test=\"" + firstFielName + " != null \">").Append("\r\n");
sb.Append("\t\t").Append("#{").Append(firstFielName).Append("}").Append(",").Append("\r\n");
sb.Append("\t\t").Append("</if>").Append("\r\n");
}
sb.Append("\t\t").Append("</trim>").Append("\r\n");
string fielNameLast = dt.Rows[dt.Rows.Count - 1]["fieldName"].ToString();
string firstFielNameLast = fielNameLast.Substring(0, 1).ToLower() + fielNameLast.Substring(1);
sb.Append("\t\t").Append(")").Append("\r\n");
sb.Append("\t").Append("</insert>").Append("\r\n\r\n");
//批量新增
sb.Append("\t").Append("<insert id=\"batchInsert\" >").Append("\r\n");
sb.Append("\t\t").Append("INSERT INTO ").Append(tableName).Append("\r\n");
sb.Append("\t\t").Append("(").Append("\r\n");
for (int i = 1; i < dt.Rows.Count - 1; i++)
{
DataRow row = dt.Rows[i];
sb.Append("\t\t").Append(row["columnName"].ToString()).Append(",").Append("\r\n");
}
sb.Append("\t\t").Append(dt.Rows[dt.Rows.Count - 1]["columnName"].ToString()).Append("\r\n");
sb.Append("\t\t").Append(")").Append("\r\n");
sb.Append("\t\t").Append("VALUES").Append("\r\n");
sb.Append("\t\t").Append("<foreach collection=\"list\" index=\"index\" item=\"item\" separator=\",\">").Append("\r\n");
sb.Append("\t\t").Append("(").Append("\r\n");
for (int i = 1; i < dt.Rows.Count - 1; i++)
{
DataRow row = dt.Rows[i];
string fielName = row["fieldName"].ToString();
string firstFielName = fielName.Substring(0, 1).ToLower() + fielName.Substring(1);
sb.Append("\t\t").Append("#{item.").Append(firstFielName).Append("}").Append(",").Append("\r\n");
}
fielNameLast = dt.Rows[dt.Rows.Count - 1]["fieldName"].ToString();
firstFielNameLast = fielNameLast.Substring(0, 1).ToLower() + fielNameLast.Substring(1);
sb.Append("\t\t").Append("#{item.").Append(firstFielNameLast).Append("}").Append("\r\n");
sb.Append("\t\t").Append(")").Append("\r\n");
sb.Append("\t\t").Append("</foreach>").Append("\r\n");;
sb.Append("\t").Append("</insert>").Append("\r\n\r\n");
//修改
sb.Append("\t").Append("<update id=\"update\" parameterType=\"" + entityPackage + className + "\">").Append("\r\n");
sb.Append("\t\t").Append("UPDATE ").Append(tableName).Append("\r\n");
sb.Append("\t\t").Append("<trim prefix=\"set\" suffixOverrides=\",\">").Append("\r\n");
for (int i = 1; i < dt.Rows.Count; i++)
{
DataRow row = dt.Rows[i];
string fielName = row["fieldName"].ToString();
string firstFielName = fielName.Substring(0, 1).ToLower() + fielName.Substring(1);
sb.Append("\t\t").Append("<if test=\"" + firstFielName + " != null \">").Append("\r\n");
sb.Append("\t\t").Append(row["columnName"].ToString()).Append(" = ").Append("#{" + firstFielName + "}").Append(",").Append("\r\n");
sb.Append("\t\t").Append("</if>").Append("\r\n");
}
sb.Append("\t\t").Append("</trim>").Append("\r\n");
sb.Append("\t\t").Append("WHERE ID = #{id}").Append("\r\n");
sb.Append("\t").Append("</update>").Append("\r\n\r\n");
//删除
sb.Append("\t").Append("<delete id=\"delByIds\">").Append("\r\n");
sb.Append("\t\t").Append("DELETE FROM ").Append(tableName).Append("\r\n");
sb.Append("\t\t").Append("WHERE ID IN").Append("\r\n");
sb.Append("\t\t").Append("<foreach collection=\"list\" index=\"index\" item=\"item\" open=\"(\" separator=\",\" close=\")\">").Append("\r\n");
sb.Append("\t\t\t").Append("#{item}").Append("\r\n");;
sb.Append("\t\t").Append("</foreach>").Append("\r\n");;
sb.Append("\t").Append("</delete>").Append("\r\n\r\n");
sb.Append("</mapper>");
CodeGenerationFactory.write(path + "\\I" + className + "Mapper.xml", path, sb.ToString());
}
