資源簡介
實際工作中,我們經(jīng)常需要根據(jù)數(shù)據(jù)庫的表結(jié)構(gòu)來寫對應(yīng)的實體類,如果數(shù)據(jù)庫字段比較多,手工去寫實體類既浪費時間,還容易出錯。其實像這種一一對應(yīng)關(guān)系的一般都有工具來幫我們完成。本工具就是用來根據(jù)數(shù)據(jù)庫的表結(jié)構(gòu)來生成對應(yīng)實體類的,希望能為你們的開發(fā)帶來方便。

代碼片段和文件信息
<#include?“/java_copyright.include“>
<#assign?className?=?table.className>???
<#assign?classNameLower?=?className?uncap_first>???
package?${basepackage}.dao;
<#include?“/java_imports.include“>
import?static?cn.org.rapid_framework.util.objectUtils.*;
import?org.springframework.stereotype.Repository;
@Repository
public?class?${className}Dao?extends?baseHibernateDao<${className}${table.idColumn.javaType}>{
public?Class?getEntityClass()?{
return?${className}.class;
}
public?Page?findPage(${className}Query?query)?{
????????//XsqlBuilder?syntaxplease?see?http://code.google.com/p/rapid-xsqlbuilder
????????//?[column]為字符串拼接?{column}為使用占位符.?[column]為使用字符串拼接如username=‘[username]‘偷懶時可以使用字符串拼接?
????????//?[column]?為PageRequest的屬性
String?sql?=?“select?t?from?${className}?t?where?1=1?“
<#list?table.columns?as?column>
?? <#if?column.isNotIdOrVersionField>
?? <#if?column.isDateTimeColumn>
+?“/~?and?t.${column.columnNameLower}?>=?{${column.columnNameLower}Begin}?~/“
+?“/~?and?t.${column.columnNameLower}?<=?{${column.columnNameLower}End}?~/“
<#else>
?? +?“/~?and?t.${column.columnNameLower}?=?{${column.columnNameLower}}?~/“
?? #if>
#if>
#list>
+?“/~?order?by?[sortColumns]?~/“;
????????//生成sql2的原因是為了不喜歡使用xsqlbuilder的同學(xué),請修改生成器模板,刪除本段的生成
????????StringBuilder?sql2?=?new?StringBuilder(“select?t?from?${className}?t?where?1=1?“);
????????<#list?table.columns?as?column>
????????<#if?column.isDateTimeColumn>
????????if(isNotEmpty(query.get${column.columnName}Begin()))?{
????????????sql2.append(“?and??t.${column.columnNameLower}?>=?:${column.columnNameLower}Begin?“);
????????}
????????if(isNotEmpty(query.get${column.columnName}End()))?{
????????????sql2.append(“?and??t.${column.columnNameLower}?<=?:${column.columnNameLower}End?“);
????????}
????????<#else>
????????if(isNotEmpty(query.get${column.columnName}()))?{
????????????sql2.append(“?and??t.${column.columnNameLower}?=?:${column.columnNameLower}?“);
????????}
????????#if>
????????#list>
????????if(isNotEmpty(query.getSortColumns()))?{
????????????sql2.append(“?order?by?:sortColumns?“);
????????}
????????
return?pageQuery(sqlquery);
}
<#list?table.columns?as?column>
<#if?column.unique?&&?!column.pk>
public?${className}?getBy${column.columnName}(${column.javaType}?v)?{
return?(${className})?findByProperty(“${column.columnNameLower}“v);
}
#if>
#list>
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-11-05?10:15??實體類\
?????目錄???????????0??2016-04-11?19:43??實體類\rapid-generator\
?????文件?????4942352??2015-11-05?10:14??實體類\rapid-generator.zip
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\hibernate\
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\hibernate\java_src\
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\hibernate\java_src\${ba
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\hibernate\java_src\${ba
?????文件????????2612??2010-06-29?16:11??實體類\rapid-generator\bak\hibernate\java_src\${ba
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\hibernate\java_src\${ba
?????文件????????6234??2010-07-20?14:36??實體類\rapid-generator\bak\hibernate\java_src\${ba
?????文件????????1625??2010-06-24?10:26??實體類\rapid-generator\bak\hibernate\java_src\${ba
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\hibernate\other\
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\hibernate\other\java_hibernate_xm
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\hibernate\other\java_hibernate_xm
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\hibernate\other\java_hibernate_xm
?????文件????????2929??2010-06-18?00:23??實體類\rapid-generator\bak\hibernate\other\java_hibernate_xm
?????文件????????4138??2010-07-20?14:36??實體類\rapid-generator\bak\hibernate\other\java_hibernate_xm
?????文件????????1335??2010-06-24?10:26??實體類\rapid-generator\bak\hibernate\other\java_hibernate_xm
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\ibatis\
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\ibatis\java_src\
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\ibatis\java_src\${ba
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\ibatis\java_src\${ba
?????文件????????1012??2010-06-03?14:21??實體類\rapid-generator\bak\ibatis\java_src\${ba
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\ibatis\java_src\${ba
?????文件????????4050??2010-06-24?10:26??實體類\rapid-generator\bak\ibatis\java_src\${ba
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\ibatis\java_src\${ba
?????文件????????4735??2010-07-13?22:41??實體類\rapid-generator\bak\ibatis\java_src\${ba
?????文件?????????344??2010-06-03?14:21??實體類\rapid-generator\bak\ibatis\java_src\${ba
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\springmvc_rest\
?????目錄???????????0??2015-08-15?20:01??實體類\rapid-generator\bak\springmvc_rest\java_src\
............此處省略91個文件信息
評論
共有 條評論