Package org.qdao

Examples of org.qdao.TableDescriptor

30
31
32
33
34
35
36
37
38
39
40
   * @param tableClazz
   * @return 2010/02/25 10:41:42
   */
  public static TableDescriptor getTableDescriptor(Class<?> tableClazz) {
    // TODO : use reflect to get annotation from table class
    TableDescriptor tableDescriptor = new TableDescriptor();

    Table table = (Table) tableClazz.getAnnotation(Table.class);
    if (table != null) {
      tableDescriptor.name = table.name();
      tableDescriptor.description = table.description();
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
    StringBuffer buf = getSQLTigger();
    System.out.println(buf);
  }

  private static StringBuffer getSQLTigger() {
    TableDescriptor table = getTableDescriptor(Program.class);
    StringBuffer buf = new StringBuffer("CREATE TABLE ");
    buf.append(table.name + "(\r\n");
    for (int i = 0; i < table.columns.length; i++) {
      buf.append("\t" + table.columns[i].name + ' ')
          .append(table.columns[i].type)
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
    }
    return buf;
  }

  public static TableDescriptor getTableDescriptor(Class<?> tableClazz) {
    TableDescriptor tableDescriptor = new TableDescriptor();

    Table table = (Table) tableClazz.getAnnotation(Table.class);
    if (table != null) {
      tableDescriptor.name = table.name();
      tableDescriptor.description = table.description();
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
    close();
    return result;
  }

  public Integer count() {
    TableDescriptor table = dbEngine.getTableDescriptor(entity);
    int result = -1;
    sql.append("SELECT COUNT(*) FROM ").append(table.name);
    try {
      prepare();
      rs = pstmt.executeQuery();
View Full Code Here
138
139
140
141
142
143
144
145
146
147
148
    return result;
  }

 
  public Integer count(String sqlPart) {
    TableDescriptor table = dbEngine.getTableDescriptor(entity);
    int result = -1;
    sql.append("SELECT COUNT(*) FROM ").append(table.name).append(" WHERE 1 = 1 AND ").append(sqlPart);
    try {
      pstmt = getDBEngine().getConnection().prepareStatement(sql.toString());
      rs = pstmt.executeQuery();
View Full Code Here
161
162
163
164
165
166
167
168
169
170
171
    return result;
  }

 
  public boolean create() {
    TableDescriptor table = dbEngine.getTableDescriptor(entity);
    sql.append(SQLTigger.getMySqlCreateTigger(table));
    try {
      pstmt = getDBEngine().getConnection().prepareStatement(sql.toString());
      pstmt.executeUpdate();
      return true;
View Full Code Here
193
194
195
196
197
198
199
200
201
202
203
    if (entity != clazz) {
      // logWarning("Your data is wrong!");
      logWarning("数据部匹配!");
      return false;
    }
    TableDescriptor table = dbEngine.getTableDescriptor(entity);
    sql.append("DELETE FROM ").append(table.name).append(" WHERE ");
    for (int i = 0; i < table.primaryKeys.length; i++) {
      if (i != table.primaryKeys.length - 1) {
        sql.append(table.primaryKeys[i]).append(" = ? AND ");
      } else
View Full Code Here
254
255
256
257
258
259
260
261
262
263
264
  public boolean deletePart(String sqlPart) {
    return delete0(sqlPart);
  }

  private boolean delete0(String sqlPart) {
    TableDescriptor table = dbEngine.getTableDescriptor(entity);
    int result = -1;
    sql.append("DELETE FROM ").append(table.name).append(" WHERE ").append(sqlPart);
    try {
      pstmt = getDBEngine().getConnection().prepareStatement(sql.toString());
      result = pstmt.executeUpdate();
View Full Code Here
279
280
281
282
283
284
285
286
287
288
289
  }

 
  public boolean delete(List<T> datas) {
    Iterator<?> iter = datas.iterator();
    TableDescriptor table = dbEngine.getTableDescriptor(entity);
    Field[] fs = entity.getDeclaredFields();
    if (fs.length != table.columns.length) {
      // logger.log(Level.WARNING,
      // "The object's fields can not match the table's columns!");
      logWarning(" 插入的数据项与表中的项不匹配");
View Full Code Here
356
357
358
359
360
361
362
363
364
365
366
    }
  }

 
  public boolean drop() {
    TableDescriptor table = dbEngine.getTableDescriptor(entity);
    sql.append("DROP TABLE ").append(table.name);
    try {
      prepare();
      pstmt.executeUpdate();
      return true;
View Full Code Here
TOP

Related Classes of org.qdao.TableDescriptor

  • org.qdao.implement.mysql.MySqlEntityDao
  • org.qdao.implement.oracle.OracleEntityDao
  • org.qdao.model.Program
  • org.qdao.model.Project
  • org.qdao.util.SQLTigger
    • 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.