Package com.jeecms.cms.entity.back

Examples of com.jeecms.cms.entity.back.CmsField

49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
  public List<CmsField> listFields(String tablename) {
    String sql = " desc  " + tablename;
    List<CmsField> fields = new ArrayList<CmsField>();
    SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
    while (set.next()) {
      CmsField field = new CmsField();
      field.setName(set.getString(1));
      field.setFieldType(set.getString(2));
      field.setNullable(set.getString(3));
      field.setFieldProperty(set.getString(4));
      field.setFieldDefault(set.getString(5));
      field.setExtra(set.getString(6));
      fields.add(field);
    }
    return fields;
  }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
    String sql = "select column_name,column_type,column_default,column_key,column_comment,is_nullable,extra from columns where table_schema='"
        + db + "' and table_name='" + tablename + "'";
    List<CmsField> fields = new ArrayList<CmsField>();
    SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
    while (set.next()) {
      CmsField field = new CmsField();
      field.setName(set.getString(1));
      field.setFieldType(set.getString(2));
      field.setFieldDefault(set.getString(3));
      field.setFieldProperty(set.getString(4));
      field.setComment(set.getString(5));
      field.setNullable(set.getString(6));
      field.setExtra(set.getString(7));
      fields.add(field);
    }
    return fields;
  }
View Full Code Here
TOP

Related Classes of com.jeecms.cms.entity.back.CmsField

  • com.jeecms.cms.dao.assist.impl.CmsDataBackDaoImpl
  • com.jeecms.cms.dao.assist.impl.CmsDataDaoImpl
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.