Package org.qdao

Examples of org.qdao.TableDescriptor$ColumnDescription

33
34
35
36
37
38
39
40
41
42
43
    p.logicalName = "wamnet";
    p.description = "The WAMNET Project";

    Class<?> tableClazz = p.getClass();

    TableDescriptor tableDescriptor = getTableDescriptor(tableClazz);

    // output the table's descriptor
    print("TABLE'S NAME " + tableDescriptor.name +
        " \t TABLE'S DESCRIPTION " + tableDescriptor.description);
View Full Code Here
379
380
381
382
383
384
385
386
387
388
389
    }
  }

 
  public boolean drop(boolean cascade) {
    TableDescriptor table = dbEngine.getTableDescriptor(entity);
    if (cascade) {
      sql.append("DROP TABLE ").append(table.name).append(" CASCADE CONSTRAINTS");
    } else {
      sql.append("DROP TABLE ").append(table.name);
    }
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
  public static void print(Object o) {
    System.out.println(o);
  }

  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
406
407
408
409
410
411
412
413
414
415
416
    }
  }

 
  public boolean insert(T dto) {
    TableDescriptor table = dbEngine.getTableDescriptor(entity);
    boolean inserted = false;
    createInsertTigger(dto);
    try {
      prepare();
      prepareStatement(table, dto);
View Full Code Here
433
434
435
436
437
438
439
440
441
442
443
  }

 
  public boolean insert(List<?> dtos) {
    Iterator<?> iter = dtos.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
494
495
496
497
498
499
500
501
502
503
504
    logger.log(Level.WARNING, message);
  }

 
  public boolean exist() {
    TableDescriptor table = dbEngine.getTableDescriptor(entity);
    sql.append("select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = '")
    .append(dbEngine.getConfig().getSchema())
    .append("' and TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = '").append(table.name).append('\'');
    String result = null;
    try {
View Full Code Here
527
528
529
530
531
532
533
534
535
536
537
    return null != result && result.equalsIgnoreCase(table.name);
  }

 
  public boolean lock(boolean share) {
    TableDescriptor table = dbEngine.getTableDescriptor(entity);
    if (share)
      sql.append("LOCK TABLE ").append(table.name).append(" IN SHARE MODE");
    else
      sql.append("LOCK TABLE ").append(table.name).append(" IN EXCLUSIVE MODE");
    try {
View Full Code Here
552
553
554
555
556
557
558
559
560
561
562
    }
  }

 
  public boolean lock(int timeout) {
    TableDescriptor table = dbEngine.getTableDescriptor(entity);
    if (timeout <= 0)
      sql.append("SELECT * FROM ").append(table.name).append(" FOR UPDATE");
    else
      sql.append("SELECT * FROM ").append(table.name).append(" FOR UPDATE " + timeout);
    try {
View Full Code Here
582
583
584
585
586
587
588
589
590
591
592
    Class<?> clazz = key.getClass();
    if (entity != clazz) {
      // logWarning("Your data is wrong!");
      logWarning("数据不匹配!");
    }
    TableDescriptor table = dbEngine.getTableDescriptor(entity);
    sql.append("SELECT * 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
652
653
654
655
656
657
658
659
660
661
662
    Class<?> clazz = key.getClass();
    if (entity != clazz) {
      // logWarning("Your data is wrong!");
      logWarning("数据不匹配!");
    }
    TableDescriptor table = dbEngine.getTableDescriptor(entity);
    sql.append("SELECT * 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
TOP

Related Classes of org.qdao.TableDescriptor$ColumnDescription

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