Package org.exoplatform.services.database.annotation

Examples of org.exoplatform.services.database.annotation.TableField

95
96
97
98
99
100
101
102
103
104
105
106
107
108
      ResultSetMetaData rsmd = resultSet.getMetaData();
      int numberOfColumns = rsmd.getColumnCount();
      for (int i = 1; i <= numberOfColumns; i++)
      {
         String name = rsmd.getColumnName(i);
         TableField tableField = searchTableField(tableFields, name);
         if (tableField == null)
            continue;
         String fieldName = tableField.field().length() == 0 ? tableField.name() : tableField.field();
         Field field = getField(clazz, fieldName);
         if (field == null)
            continue;
         ReflectionUtil.setValue(bean, field, getValue(rsmd.getColumnType(i), resultSet, name));
      }
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
60
      TableField[] fields = table.field();

      StringBuilder query = new StringBuilder("SELECT ");
      for (int i = 0; i < fields.length; i++)
      {
         TableField field = fields[i];
         query.append(field.name());
         if (i != fields.length - 1)
            query.append(", ");
      }
      query.append(" FROM ").append(table.name());
      if (id > -1)
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
79
      TableField[] fields = table.field();

      StringBuilder query = new StringBuilder("UPDATE ").append(table.name()).append(" SET ");
      for (int i = 0; i < fields.length; i++)
      {
         TableField field = fields[i];
         query.append(field.name()).append(" = '$").append(field.name()).append('\'');
         if (i != fields.length - 1)
            query.append(", ");
         else
            query.append(" WHERE ID = $id");
      }
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
97
      TableField[] fields = table.field();

      StringBuilder query = new StringBuilder("INSERT INTO ").append(table.name()).append("(ID, ");
      for (int i = 0; i < fields.length; i++)
      {
         TableField field = fields[i];
         query.append(field.name());
         if (i != fields.length - 1)
            query.append(", ");
         else
            query.append(") VALUES($id, ");
      }
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
124
      TableField[] fields = table.field();

      StringBuilder query = new StringBuilder("UPDATE ").append(table.name()).append(" SET ");
      for (int i = 0; i < fields.length; i++)
      {
         TableField field = fields[i];
         query.append(field.name()).append(" = ?");
         if (i != fields.length - 1)
            query.append(", ");
         else
            query.append(" WHERE ID = ").append(id);
      }
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
143
      TableField[] fields = table.field();

      StringBuilder query = new StringBuilder("INSERT INTO ").append(table.name()).append("(ID, ");
      for (int i = 0; i < fields.length; i++)
      {
         TableField field = fields[i];
         query.append(field.name());
         if (i != fields.length - 1)
            query.append(", ");
      }
      query.append(") VALUES(").append(id).append(", ");
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
      builder.append("CREATE TABLE ").append(table.name()).append(" (");
      appendId(builder);
      TableField[] fields = table.field();
      for (int i = 0; i < fields.length; i++)
      {
         TableField field = fields[i];
         String fieldType = field.type();
         if ("string".equals(fieldType))
         {
            appendStringField(field, builder);
         }
         else if ("int".equals(fieldType))
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
68
      builder.append("CREATE TABLE ").append(table.name()).append(" (");
      appendId(builder);
      TableField[] fields = table.field();
      for (int i = 0; i < fields.length; i++)
      {
         TableField field = fields[i];
         String fieldType = field.type();
         if ("string".equals(fieldType))
         {
            appendStringField(field, builder);
         }
         else if ("int".equals(fieldType))
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
107
108
      ResultSetMetaData rsmd = resultSet.getMetaData();
      int numberOfColumns = rsmd.getColumnCount();
      for (int i = 1; i <= numberOfColumns; i++)
      {
         String name = rsmd.getColumnName(i);
         TableField tableField = searchTableField(tableFields, name);
         if (tableField == null)
            continue;
         String fieldName = tableField.field().length() == 0 ? tableField.name() : tableField.field();
         Field field = getField(clazz, fieldName);
         if (field == null)
            continue;
         ReflectionUtil.setValue(bean, field, getValue(rsmd.getColumnType(i), resultSet, name));
      }
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
      builder.append("CREATE TABLE ").append(table.name()).append(" (");
      appendId(builder);
      TableField[] fields = table.field();
      for (int i = 0; i < fields.length; i++)
      {
         TableField field = fields[i];
         String fieldType = field.type();
         if ("string".equals(fieldType))
         {
            appendStringField(field, builder);
         }
         else if ("int".equals(fieldType))
View Full Code Here
TOP

Related Classes of org.exoplatform.services.database.annotation.TableField

  • org.exoplatform.services.database.QueryBuilder
  • org.exoplatform.services.database.ReflectionMapper
  • org.exoplatform.services.database.StandardSQLTableManager
    • 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.