Package cn.org.zeronote.orm

Examples of cn.org.zeronote.orm.ORMColumn

87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
    ins.append(tableName).append(" (");
    // INSERT
    Field[] fields = pojoClazz.getDeclaredFields();
    for (Field field : fields) {
      field.setAccessible(true);
      ORMColumn ormc = field.getAnnotation(ORMColumn.class);
      if (ormc != null) {
        Object val = field.get(pojo);
        if (val != null) {
          // 不是空才去设置
          ins.append(ormc.value()).append(", ");
          params.add(val);
          paramKeys.add("?");
        } else if (!"null".equalsIgnoreCase(ormc.defaultValue())) {
          // 是空，但是有默认值，则设置
          switch (ormc.defaultValueScope()) {
          case ALL:
          case INSERT:
            ins.append(ormc.value()).append(", ");
            Object value = ORMColumn.DEFAULT_DATE.equals(ormc.defaultValue()) ? new Date() : ormc.defaultValue();
            params.add(value);
            paramKeys.add("?");
            // 回写到pojo中
            try {
              if (value != null) {
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
        parentClz = parentClz.getSuperclass();
       
        fields = parentClz.getDeclaredFields();
        for (Field field : fields) {
          field.setAccessible(true);
          ORMColumn ormc = field.getAnnotation(ORMColumn.class);
          fieldsMap.put(field, ormc);
        }
      }
      // this class
      fields = clz.getDeclaredFields();
      for (Field field : fields) {
        field.setAccessible(true);
        ORMColumn ormc = field.getAnnotation(ORMColumn.class);
        fieldsMap.put(field, ormc);
        ORMCanUpdate ocu = field.getAnnotation(ORMCanUpdate.class);
        if (ocu != null) {
          // 只取一个，并且是最后找到的那个，po里只应该存在一个
          fieldsCanUpdateCache.put(clz, field);
        }
      }

    }
   
    // 创建Bean
    T bean = this.newInstance(clz);
    for (Field field : fieldsMap.keySet()) {
      ORMColumn ormc = fieldsMap.get(field);
      String value = ormc == null ? field.getName() : ormc.value();
      value = ignoreCase ? value.toLowerCase() : value;
      if (clList.keySet().contains(value)) {  // metadata中需要有
        try {
          Integer[] is = clList.get(value);
          field.set(bean, conversionType(getValue(rs, is[0], is[1], field.getType()), is[1], field.getType()));
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
54
   */
  public void find(Object... objs) throws IllegalArgumentException, IllegalAccessException, SQLException {
    Class<?> clz = objs[0].getClass();
    Field[] fields = clz.getDeclaredFields();
    for (Field field : fields) {
      ORMColumn oc = field.getAnnotation(ORMColumn.class);
      if (oc != null && oc.physicalPkFld() && oc.autoIncrement()) {
        // 找到最后一个自增id
        QueryRunner qr = new QueryRunner();
        Object identityVal = qr.query(conn, selectKey.getQuery(), new ScalarHandler<Object>());
        Long identity = NumberUtils.parseNumber(identityVal.toString(), Long.class);
       
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
 
  private boolean check(T t) throws IllegalArgumentException, IllegalAccessException {
    Field[] fields = pojoType.getDeclaredFields();
    for (Field field : fields) {
      field.setAccessible(true);
      ORMColumn ormc = field.getAnnotation(ORMColumn.class);
      if (ormc != null) {
        if (filter.get(ormc.value()) == null) {
          continue;
        }
        if (!field.get(t).equals(filter.get(isIgnoreCase() ? ormc.value().toLowerCase() : ormc.value()))) {
          return false;
        }
      }
    }
    return true;
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
   */
  private Map<String, Object> fieldArgsMap(Class<?> pojoType, Object pkVal, boolean usePhysicalPk) throws IllegalArgumentException, IllegalAccessException {
    Map<String, Object> delArgs = new HashMap<String, Object>();
    Field[] fields = pojoType.getDeclaredFields();
    for (Field f : fields) {
      ORMColumn ormc = f.getAnnotation(ORMColumn.class);
      if (ormc != null) {
        if (usePhysicalPk) {
          if (ormc.physicalPkFld()) {
            f.setAccessible(true);
            delArgs.put(f.getName(), pkVal);
          }
        } else {
          if (ormc.LogicPkFld()) {
            f.setAccessible(true);
            delArgs.put(f.getName(), pkVal);
          }
        }
       
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
   */
  private Map<String, Object> fieldArgsMap(Object pojo, boolean usePhysicalPk) throws IllegalArgumentException, IllegalAccessException {
    Map<String, Object> delArgs = new HashMap<String, Object>();
    Field[] fields = pojo.getClass().getDeclaredFields();
    for (Field f : fields) {
      ORMColumn ormc = f.getAnnotation(ORMColumn.class);
      if (ormc != null) {
        if (usePhysicalPk) {
          if (ormc.physicalPkFld()) {
            f.setAccessible(true);
            delArgs.put(f.getName(), f.get(pojo));
          }
        } else {
          if (ormc.LogicPkFld()) {
            f.setAccessible(true);
            delArgs.put(f.getName(), f.get(pojo));
          }
        }
       
View Full Code Here
180
181
182
183
184
185
186
187
188
189
190
191
192
193
    if (delArgs != null && !delArgs.isEmpty()) {
      del.append("WHERE ");
      for (String pk : delArgs.keySet()) {
        for (Field field : fields) {
          field.setAccessible(true);
          ORMColumn ormc = field.getAnnotation(ORMColumn.class);
          if (ormc != null && field.getName().equalsIgnoreCase(pk)) {
            // 是主键，作为条件
            del.append(ormc.value()).append("=? AND ");
            Object val = delArgs.get(pk);
            params.add(val);
          }
        }
      }
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
    Field[] fields = pojoClazz.getDeclaredFields();
    List<String> pks = null;
    if (usePhysicalPk) {
      pks = new ArrayList<String>();
      for (Field f : fields) {
        ORMColumn ormc = f.getAnnotation(ORMColumn.class);
        if (ormc != null && ormc.physicalPkFld()) {
          pks.add(ormc.value());
        }
      }
    } else {
      pks = new ArrayList<String>();
      for (Field f : fields) {
        ORMColumn ormc = f.getAnnotation(ORMColumn.class);
        if (ormc != null && ormc.LogicPkFld()) {
          pks.add(ormc.value());
        }
      }
    }
   
    for (Field field : fields) {
      field.setAccessible(true);
      ORMColumn ormc = field.getAnnotation(ORMColumn.class);
      // 主键不允许修改
      if (ormc != null && !pks.contains(ormc.value())) {
        Object val = field.get(pojo);
        if (val != null) {
          // 不是空才去设置
          if (ormc.append()) {
            upd.append(ormc.value()).append("=").append(ormc.value()).append("||?, ");  // XXX 只适合Oracle，需要方言支持
          } else {
            upd.append(ormc.value()).append("=?, ");
          }
          params.add(val);
        } else if (!"null".equalsIgnoreCase(ormc.defaultValue())) {
          // 是null，但是有默认值，则设置
          switch (ormc.defaultValueScope()) {
          case ALL:
          case UPDATE:
              if (ormc.append()) {
                          upd.append(ormc.value()).append("=").append(ormc.value()).append("||?, ");  // XXX 只适合Oracle，需要方言支持
                      } else {
                          upd.append(ormc.value()).append("=?, ");
                      }
             
                Object value = ORMColumn.DEFAULT_DATE.equals(ormc.defaultValue()) ? new Date() : ValueUtils.conversionType(ormc.defaultValue(), field.getType());
                        params.add(value);
            break;
          default:
            break;
          }
        }
      }
    }
    upd.replace(upd.length() - 2, upd.length(), " ");
    // WHERE
    if (pks != null && pks.size() > 0) {
      upd.append("WHERE ");
      for (String pk : pks) {
        for (Field field : fields) {
          field.setAccessible(true);
          ORMColumn ormc = field.getAnnotation(ORMColumn.class);
          if (ormc != null && ormc.value().equalsIgnoreCase(pk)) {
            // 是主键，作为条件
            upd.append(pk).append("=? AND ");
            Object val = field.get(pojo);
            params.add(val);
          }
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
    StringBuilder sql = new StringBuilder("SELECT ");
    // SELECT
    Field[] fields = pojoClazz.getDeclaredFields();
    for (Field field : fields) {
      field.setAccessible(true);
      ORMColumn ormc = getAnnotation(pojoClazz, field);
      if (ormc != null) {
        sql.append(ormc.value()).append(",");
      }
    }
    sql.replace(sql.length() - 1, sql.length(), " ");
    // FROM
    sql.append("FROM ").append(tableName).append(" ");
    // WHERE
    if (argsMap != null && argsMap.size() > 0) {
      sql.append("WHERE (");
      for (Field field : fields) {
        field.setAccessible(true);
        ORMColumn ormc = getAnnotation(pojoClazz, field);
        if (ormc != null) {
          Object[] val = argsMap.get(field.getName());
          if (val != null) {
            if (val.length > 1) {
              // 多参数
              sql.append("(");
              for (Object ovl : val) {
                sql.append(ormc.value()).append("=? OR ");
                Class<?> tc = field.getDeclaringClass();
                params.add(matchParam(ovl, tc));
              }
              sql.delete(sql.length() - 3, sql.length());
              sql.append(") AND ");
            } else {
              // 单参数
              sql.append(ormc.value()).append("=? AND ");
              Class<?> tc = field.getDeclaringClass();
              params.add(matchParam(val[0], tc));
            }
          }
        }
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
        if (fs == null) {
          fs = new HashMap<Field, ORMColumn>();
          Field[] fields = pojoClazz.getDeclaredFields();
          for (Field f : fields) {
            f.setAccessible(true);
            ORMColumn ormc = f.getAnnotation(ORMColumn.class);
            fs.put(f, ormc);
          }
          fieldsCache.put(clz, fs);
        }
      }
View Full Code Here
TOP

Related Classes of cn.org.zeronote.orm.ORMColumn

  • cn.org.zeronote.orm.dao.parser.SqlDelGenerator
  • cn.org.zeronote.orm.dao.parser.SqlInsGenerator
  • cn.org.zeronote.orm.dao.parser.SqlSelGenerator
  • cn.org.zeronote.orm.dao.parser.SqlUpdGenerator
  • cn.org.zeronote.orm.extractor.BaseRowProcessor
  • cn.org.zeronote.orm.extractor.IdentityFinder
  • cn.org.zeronote.orm.extractor.PojoFilterResultSetExtractor
    • 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.