Package com.jeecms.cms.entity.back

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

20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
    String sql = "select table_name,table_comment,engine,table_rows,auto_increment from tables where table_schema='"
        + db + "'";
    List<CmsTable> tables = new ArrayList<CmsTable>();
    SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
    while (set.next()) {
      CmsTable table = new CmsTable();
      table.setName(set.getString(1));
      table.setComment(set.getString(2).split(";")[0]);
      table.setEngine(set.getString(3));
      table.setRows(set.getInt(4));
      table.setAuto_increment(set.getInt(5));
      tables.add(table);
    }
    return tables;
  }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
    String sql = "select table_name,table_comment,engine,table_rows,auto_increment from tables where table_schema='"
        + db + "' and table_name='" + tablename + "'";
    List<CmsTable> tables = new ArrayList<CmsTable>();
    SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
    while (set.next()) {
      CmsTable table = new CmsTable();
      table.setName(set.getString(1));
      table.setComment(set.getString(2).split(";")[0]);
      table.setEngine(set.getString(3));
      table.setRows(set.getInt(4));
      table.setAuto_increment(set.getInt(5));
      tables.add(table);
    }
    if (tables.size() > 0) {
      return tables.get(0);
    }else{
View Full Code Here
TOP

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

  • 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.