jfinal 生成实体类

叁歲伎倆 2022-04-25 01:30 476阅读 0赞 
  1. jfinal根据Generator生成器生成实体类：
  3. package com.ysd.test;
  4. import javax.sql.DataSource;
  6. import com.jfinal.kit.PathKit;
  7. import com.jfinal.plugin.activerecord.ActiveRecordPlugin;
  8. import com.jfinal.plugin.activerecord.generator.Generator;
  9. import com.jfinal.plugin.druid.DruidPlugin;
  10. import com.ysd.entity.ImsChatRoomcashsumLast;
  12. public class _JFinalDemoGenerator {
  13.     public static DataSource getDataSource() {
  14.         //PropKit.use("a_little_config.txt");
  15.         DruidPlugin druidPlugin = new DruidPlugin("jdbc:mysql://47.94.172.202/phpweizan", "temp1", "asdfghjkl");
  16.         druidPlugin.start();
  17.         ActiveRecordPlugin activeRecord = new ActiveRecordPlugin(druidPlugin);
  18.         activeRecord.addMapping("ims_chat_roomcashsum_last", "Id",ImsChatRoomcashsumLast.class);
  19.         //activeRecord.addMapping("Askers", "userId",Askers.class);
  21.         return druidPlugin.getDataSource();
  22.     }
  24.     public static void main(String[] args) {
  25.         // base model 所使用的包名
  26.         String baseModelPackageName = "com.ysd.entity";
  27.         // base model 文件保存路径
  28.         String baseModelOutputDir = PathKit.getWebRootPath() + "/src/main/java/com/ysd/entity";
  30.         // model 所使用的包名 (MappingKit 默认使用的包名)
  31.         String modelPackageName = "com.ysd.entity";
  32.         // model 文件保存路径 (MappingKit 与 DataDictionary 文件默认保存路径)
  33.         String modelOutputDir = PathKit.getWebRootPath() + "/src/main/java/com/ysd/entity";
  36.         // 创建生成器
  37.         //Generator generator = new Generator(getDataSource(), baseModelPackageName, baseModelOutputDir, modelPackageName, modelOutputDir);
  38.         //generator.setMetaBuilder(new _MetaBuilder(getDataSource()));
  39.         // 设置是否生成链式 setter 方法
  40.         //generator.setGenerateChainSetter(false);
  41.         // 添加不需要生成的表名
  42.         //generator.addExcludedTable("ims_chat_roomcashsum_last");
  44.         // 设置是否在 Model 中生成 dao 对象
  45.         //generator.setGenerateDaoInModel(true);
  46.         // 设置是否生成链式 setter 方法
  47.         //generator.setGenerateChainSetter(true);
  48.         // 设置是否生成字典文件
  49.         //generator.setGenerateDataDictionary(false);
  50.         // 设置需要被移除的表名前缀用于生成modelName。例如表名 "osc_user"，移除前缀 "osc_"后生成的model名为 "User"而非 OscUser
  51.         //generator.setRemovedTableNamePrefixes("t_");
  52.         // 生成
  53.         //generator.generate();
  54.     }
  55. }

jfinal不依靠Generator生成单独实体类

  1. package com.ysd.util;
  3. import java.io.BufferedWriter;
  4. import java.io.File;
  5. import java.io.FileWriter;
  6. import java.io.IOException;
  7. import java.sql.Connection;
  8. import java.sql.DriverManager;
  9. import java.sql.PreparedStatement;
  10. import java.sql.ResultSetMetaData;
  11. import java.sql.SQLException;
  12. import java.util.Vector;
  14. public class reflectBean {
  15.     private Connection connection;
  16.     private PreparedStatement UserQuery;
  17.     /*mysql url的连接字符串*/
  18.     private static String url = "jdbc:mysql://47.94.172.202/phpweizan?useUnicode=true&characterEncoding=utf-8&useOldAliasMetadataBehavior=true";
  19.     //账号
  20.     private static String user = "temp1";
  21.     //密码
  22.     private static String password = "asdfghjkl";
  23.     private Vector<String> vector = new Vector<String>();
  24.     //mysql jdbc的java包驱动字符串
  25.     private String driverClassName = "com.mysql.jdbc.Driver";
  26.     //数据库中的表名
  27.     String table = "core_admin";
  28.     //数据库的列名称
  29.     private String[] colnames; // 列名数组
  30.     //列名类型数组  
  31.     private String[] colTypes;
  32.     public reflectBean(){
  33.         try {//驱动注册
  34.             Class.forName(driverClassName);
  35.             if (connection == null || connection.isClosed())
  36.                 //获得链接
  37.                 connection = DriverManager.getConnection(url, user, password);
  38.         } catch (ClassNotFoundException ex) {
  39.                 ex.printStackTrace();
  40.                 System.out.println("Oh,not");
  41.             } catch (SQLException e) {
  42.                 e.printStackTrace();
  43.                 System.out.println("Oh,not");
  44.             }
  45.     }
  47.     public Connection getConnection() {
  48.         return connection;
  49.     }
  50.     public void setConnection(Connection connection) {
  51.         this.connection = connection;
  52.     }
  54.     public void doAction(){
  55.         String sql = "select * from "+table;
  56.         try {
  57.             PreparedStatement statement = connection.prepareStatement(sql);
  58.             //获取数据库的元数据 
  59.             ResultSetMetaData metadata = statement.getMetaData();
  60.             //数据库的字段个数
  61.             int len = metadata.getColumnCount();
  62.             //字段名称
  63.             colnames = new String[len+1];
  64.             //字段类型 --->已经转化为java中的类名称了
  65.             colTypes = new String[len+1];
  66.             for(int i= 1;i<=len;i++){
  67.                 //System.out.println(metadata.getColumnName(i)+":"+metadata.getColumnTypeName(i)+":"+sqlType2JavaType(metadata.getColumnTypeName(i).toLowerCase())+":"+metadata.getColumnDisplaySize(i));
  68.                 //metadata.getColumnDisplaySize(i);
  69.                 colnames[i] = metadata.getColumnName(i); //获取字段名称
  70.                 colTypes[i] = sqlType2JavaType(metadata.getColumnTypeName(i)); //获取字段类型    
  71.                 System.out.println(sqlType2JavaType(metadata.getColumnTypeName(i)));
  72.             }
  73.         } catch (SQLException e) {
  74.             e.printStackTrace();
  75.         }
  76.     }
  77.     /*
  78.      * mysql的字段类型转化为java的类型*/
  79.     private String sqlType2JavaType(String sqlType) {  
  80.         if(sqlType.equalsIgnoreCase("bit")){  
  81.             return "boolean";  
  82.         }else if(sqlType.equalsIgnoreCase("tinyint")){  
  83.             return "byte";  
  84.         }else if(sqlType.equalsIgnoreCase("smallint")){  
  85.             return "short";  
  86.         }else if(sqlType.equalsIgnoreCase("int")){  
  87.             return "Integer";  
  88.         }else if(sqlType.equalsIgnoreCase("bigint")){  
  89.             return "long";  
  90.         }else if(sqlType.equalsIgnoreCase("float")){  
  91.             return "float";  
  92.         }else if(sqlType.equalsIgnoreCase("decimal") || sqlType.equalsIgnoreCase("numeric")   
  93.                 || sqlType.equalsIgnoreCase("real") || sqlType.equalsIgnoreCase("money")   
  94.                 || sqlType.equalsIgnoreCase("smallmoney")){  
  95.             return "double";  
  96.         }else if(sqlType.equalsIgnoreCase("varchar") || sqlType.equalsIgnoreCase("char")   
  97.                 || sqlType.equalsIgnoreCase("nvarchar") || sqlType.equalsIgnoreCase("nchar")   
  98.                 || sqlType.equalsIgnoreCase("text")){  
  99.             return "String";  
  100.         }else if(sqlType.equalsIgnoreCase("datetime") ||sqlType.equalsIgnoreCase("date")){  
  101.             return "Date";  
  102.         }else if(sqlType.equalsIgnoreCase("image")){  
  103.             return "Blod";  
  104.         }  
  106.         return null;  
  107.     }
  108.     /*获取整个类的字符串并且输出为java文件
  109.      * */
  110.     public  StringBuffer getClassStr(){
  111.         //输出的类字符串
  112.         StringBuffer str = new StringBuffer("");
  113.         //获取表类型和表名的字段名
  114.         this.doAction();
  115.         //校验
  116.         if(null == colnames && null == colTypes) return null;
  117.         //拼接
  118.         str.append("public class "+table+" {\r\n");
  119.         //拼接属性
  120.         for(int index=1; index < colnames.length ; index++){
  121.             str.append(getAttrbuteString(colnames[index],colTypes[index]));
  122.         }
  123.         //拼接get，Set方法        
  124.         for(int index=1; index < colnames.length ; index++){
  125.             str.append(getGetMethodString(colnames[index],colTypes[index]));
  126.             str.append(getSetMethodString(colnames[index],colTypes[index]));
  127.         }
  128.         str.append("}\r\n");
  129.         //输出到文件中
  130.         File file = new File(table+".java");
  131.         BufferedWriter write = null;
  133.         try {
  134.             write = new BufferedWriter(new FileWriter(file));
  135.             write.write(str.toString());
  136.             write.close();
  137.         } catch (IOException e) {
  139.             e.printStackTrace();
  140.             if (write != null)
  141.                 try {
  142.                     write.close();
  143.                 } catch (IOException e1) {            
  144.                     e1.printStackTrace();
  145.                 }
  146.         }
  147.         return str;
  148.     }
  149.     /*
  150.      * 获取字段字符串*/
  151.     public StringBuffer getAttrbuteString(String name, String type) {
  152.         if(!check(name,type)) {
  153.             System.out.println("类中有属性或者类型为空");
  154.             return null;
  155.         };
  156.         String format = String.format("    private %s %s;\n\r", new String[]{type,name});
  157.         return new StringBuffer(format);
  158.     }
  159.     /*
  160.      * 校验name和type是否合法*/
  161.     public boolean check(String name, String type) {
  162.         if("".equals(name) || name == null || name.trim().length() ==0){
  163.             return false;
  164.         }
  165.         if("".equals(type) || type == null || type.trim().length() ==0){
  166.             return false;
  167.         }
  168.         return true;
  170.     }
  171.     /*
  172.      * 获取get方法字符串*/
  173.     private StringBuffer getGetMethodString(String name, String type) {
  174.         if(!check(name,type)) {
  175.             System.out.println("类中有属性或者类型为空");
  176.             return null;
  177.         };
  178.         String Methodname = "get"+GetTuoFeng(name);
  179.         String format = String.format("    public %s %s(){\n\r", new Object[]{type,Methodname});
  180.         format += String.format("        return this.%s;\r\n", new Object[]{name});
  181.         format += "    }\r\n";
  182.         return new StringBuffer(format);
  183.     }
  184.     //将名称首字符大写
  185.     private String GetTuoFeng(String name) {
  186.         name = name.trim();
  187.         if(name.length() > 1){
  188.             name = name.substring(0, 1).toUpperCase()+name.substring(1);
  189.         }else
  190.         {
  191.             name = name.toUpperCase();
  192.         }
  193.         return name;
  194.     }
  195.     /*
  196.      * 获取字段的get方法字符串*/
  197.     private Object getSetMethodString(String name, String type) {
  198.         /*if(!check(name,type)) {
  199.             System.out.println("类中有属性或者类型为空");
  200.             return null;
  201.         };*/
  202.         String Methodname = "set"+GetTuoFeng(name);
  203.         String format = String.format("    public void %s(%s %s){\n\r", new Object[]{Methodname,type,name});
  204.         format += String.format("        this.%s = %s;\r\n", new Object[]{name,name});
  205.         format += "    }\r\n";
  206.         return new StringBuffer(format);
  207.     }
  209.     public static void main(String[] args) {
  210.         reflectBean bean = new reflectBean();
  211.         System.err.println(bean.getClassStr());
  212.     }
  213. }

还有手写底层生成数据库中model，和dao的，找不到了，下次更新。。。。。

https://www.cnblogs.com/hwf2029/p/7810766.html 目前只找到了其它人 写的比较好的，我自己啊丢了，你们可以先借鉴下

发表评论

表情：
评论列表 （有 0 条评论，476人围观）

还没有评论，来说两句吧...

相关阅读

    相关 java实体类生成工具

    前言 原因是这样的，eclipse有那种生成实体类的插件，可是我感觉装来装去很麻烦，于是我想，干脆自己做一个生成实体类的工具吧，说做就做，然后就自己花了两个小时左右做出来

    ╰+攻爆jí腚メ╰+攻爆jí腚メ/ 0 赞/ 533 阅读