心理医院网站优化服务商,网站收录了但是搜索不到,iis7 asp网站 503,外贸邦官网目录 1、修改Generate poJOs.groovy文件
2、idea中连接数据库
3、生成entity代码
4、查看生成的实体类 1、修改Generate poJOs.groovy文件
在项目下方点击Scratches and Consoles→ Extensions→ Database Tools and SQL箭头→schema→ Generate POJOs.groovy 替换为以下文…
目录 1、修改Generate poJOs.groovy文件
2、idea中连接数据库
3、生成entity代码
4、查看生成的实体类 1、修改Generate poJOs.groovy文件
在项目下方点击Scratches and Consoles→ Extensions→ Database Tools and SQL箭头→schema→ Generate POJOs.groovy 替换为以下文件直接可用
import com.intellij.database.model.DasTable
import com.intellij.database.model.ObjectKind
import com.intellij.database.util.Case
import com.intellij.database.util.DasUtilimport java.io.*
import java.text.SimpleDateFormat//自定义包名
packageName
typeMapping [//类型映射(~/(?i)tinyint|smallint|mediumint/) : Integer,(~/(?i)int/) : Long,(~/(?i)bool|bit/) : Boolean,(~/(?i)float|double|decimal|real/) : BigDecimal,(~/(?i)datetime|timestamp|date|time/) : Date,(~/(?i)blob|binary|bfile|clob|raw|image/): InputStream,(~/(?i)/) : String
]FILES.chooseDirectoryAndSave(Choose directory, Choose where to store generated files) { dir -SELECTION.filter { it instanceof DasTable it.getKind() ObjectKind.TABLE }.each { generate(it, dir) }
}def generate(table, dir) {def className javaName(table.getName(), true)def fields calcFields(table)packageName getPackageName(dir)PrintWriter printWriter new PrintWriter(new OutputStreamWriter(new FileOutputStream(new File(dir, className .java)), UTF-8))printWriter.withPrintWriter {out - generate(out, className, fields,table)}
}def getPackageName(dir) {return dir.toString().replaceAll(\\\\, .).replaceAll(/, .).replaceAll(^.*src(\\.main\\.java\\.)?, ) ;
}def generate(out, className, fields,table) {out.println package $packageNameout.println out.println import com.baomidou.mybatisplus.annotation.IdType;out.println import com.baomidou.mybatisplus.annotation.TableField;out.println import com.baomidou.mybatisplus.annotation.TableId;out.println import com.baomidou.mybatisplus.annotation.TableName;out.println(import lombok.EqualsAndHashCode;)out.println import lombok.experimental.Accessors;out.println import java.io.Serializable;out.println import lombok.Data;Set types new HashSet()fields.each() {types.add(it.type)}if (types.contains(Date)) {out.println import java.util.Date;}if (types.contains(InputStream)) {out.println import java.io.InputStream;}out.println out.println out.println EqualsAndHashCode(callSuper false)out.println Accessors(chain true)out.println TableName ( \table.getName() \ )out.println Dataout.println public class $className implements Serializable {out.println out.println genSerialID()fields.each() {out.println //添加字段注释if (isNotEmpty(it.commoent)) {out.println \t/**out.println \t * ${it.commoent.toString()}out.println \t */}if (it.annos ! ) out.println ${it.annos.replace([TableId], )}//显示变量out.println \tprivate ${it.type} ${it.name};}out.println out.println }
}def calcFields(table) {DasUtil.getColumns(table).reduce([]) { fields, col -def spec Case.LOWER.apply(col.getDataType().getSpecification())def typeStr typeMapping.find { p, t - p.matcher(spec).find() }.valuedef comm [colName : col.getName(),name : javaName(col.getName(), false),type : typeStr,commoent: col.getComment(),annos: \tTableField(value \col.getName()\)]if(id.equals(col.getName()))comm.annos comm.annos.toString().replace(TableField(value \id\),TableId(value \id\, type IdType.AUTO))fields [comm]}
}def javaClassName(str, capitalize) {def s com.intellij.psi.codeStyle.NameUtil.splitNameIntoWords(str).collect { Case.LOWER.apply(it).capitalize() }.join().replaceAll(/[^\p{javaJavaIdentifierPart}[_]]/, _)s s[1..s.size() - 1]capitalize || s.length() 1? s : Case.LOWER.apply(s[0]) s[1..-1]
}def javaName(str, capitalize) {def s com.intellij.psi.codeStyle.NameUtil.splitNameIntoWords(str).collect { Case.LOWER.apply(it).capitalize() }.join().replaceAll(/[^\p{javaJavaIdentifierPart}[_]]/, _)capitalize || s.length() 1? s : Case.LOWER.apply(s[0]) s[1..-1]
}def isNotEmpty(content) {return content ! null content.toString().trim().length() 0
}static String changeStyle(String str, boolean toCamel){if(!str || str.size() 1)return strif(toCamel){String r str.toLowerCase().split(_).collect{cc - Case.LOWER.apply(cc).capitalize()}.join()return r[0].toLowerCase() r[1..-1]}else{str str[0].toLowerCase() str[1..-1]return str.collect{cc - ((char)cc).isUpperCase() ? _ cc.toLowerCase() : cc}.join()}
}static String genSerialID()
{return \tprivate static final long serialVersionUID Math.abs(new Random().nextLong())L;
}
2、idea中连接数据库
找到idea的database添加一个data source我这里选择的是mysql 配置数据源地址、端口、用户密码、数据库名点击测试连接成功后点击ok即可看见数据库表信息 3、生成entity代码
1、选中要生成entity的数据库表右键tools→Scripted Extensions→Generate poJOs.groovy 2、选择生成的entity对应的目录 3、右下角会有提示已经生成 4、查看生成的实体类
