示例#1
0
  /**
   * 判断并返回表的sql id
   *
   * @param conn
   * @param detailInfoDto
   * @return
   */
  private static String getSEQID(
      Connection conn, GDAODetailInfoDto detailInfoDto, String tableSeq) {

    if (!CopyOfGDAOToolsUtil.isEmpty(tableSeq)) {
      try {
        executeSql(conn, "select PURCHASE." + tableSeq + ".NEXTVAL from DUAL");
        return tableSeq;
      } catch (SQLException e) {
        // e.printStackTrace();
      }
    }

    String seqID = "SEQ_" + detailInfoDto.getTableName() + "_ID";
    try {
      executeSql(conn, "select PURCHASE." + seqID + ".NEXTVAL from DUAL");
      return seqID;
    } catch (SQLException e) {
      // e.printStackTrace();
    }

    seqID = "SEQ_" + detailInfoDto.getClassName().toUpperCase() + "_ID";
    try {
      executeSql(conn, "select PURCHASE." + seqID + ".NEXTVAL from DUAL");
      return seqID;
    } catch (SQLException e1) {
      // e1.printStackTrace();
    }
    return null;
  }
示例#2
0
  /**
   * 获取生成DAO的详细信息 (字段,属性,类型)
   *
   * @param conn
   * @param tableName
   * @param sqlTypeProperties
   * @return
   * @throws Exception
   */
  public static GDAODetailInfoDto getGDAODetailInfo(
      Connection conn, String tableName, String tableSeq, Properties sqlTypeProperties)
      throws Exception {

    GDAODetailInfoDto detailInfoDto = new GDAODetailInfoDto();
    detailInfoDto.setTableName(tableName);
    detailInfoDto.setClassName(getClassName(tableName));

    String seqIdName = getSEQID(conn, detailInfoDto, tableSeq);

    if (seqIdName == null) {
      throw new Exception("表" + tableName + "的序列号无法获取");
    }

    detailInfoDto.setSeqIdName(seqIdName);

    final String executeSql = "select * from PURCHASE." + tableName;

    Statement statement = conn.createStatement();
    ResultSet resultSet = statement.executeQuery(executeSql);

    ResultSetMetaData metaData = resultSet.getMetaData();
    boolean pk_id = false;
    for (int i = 1; i <= metaData.getColumnCount(); i++) {
      ColumnInfoDto columnIDto = new ColumnInfoDto();
      columnIDto.setColumnName(metaData.getColumnName(i));
      columnIDto.setPropertyName(getPropertyName(metaData.getColumnName(i)));

      if (metaData.getColumnType(i) == 2) {
        // System.out.println(tableName + " : " + columnIDto.getColumnName() + " : " +
        // metaData.getScale(i) + " : " + metaData.getPrecision(i));
        if (metaData.getScale(i) > 0) {
          columnIDto.setSqlType(7);
          columnIDto.setJavaType(getColumnMethod(sqlTypeProperties, 7));
        } else if (metaData.getPrecision(i) > 10) {
          columnIDto.setSqlType(-5);
          columnIDto.setJavaType(getColumnMethod(sqlTypeProperties, -5));
        } else {
          columnIDto.setSqlType(4);
          columnIDto.setJavaType(getColumnMethod(sqlTypeProperties, 4));
        }
      } else {
        columnIDto.setSqlType(metaData.getColumnType(i));
        columnIDto.setJavaType(getColumnMethod(sqlTypeProperties, metaData.getColumnType(i)));
      }

      detailInfoDto.getColumnList().add(columnIDto);

      //			System.out.println(tableName + " : " + columnIDto.getColumnName() + " : " +
      // metaData.getScale(i) + " : " + columnIDto.getSqlType());

      String className = getColumnClassName(sqlTypeProperties, columnIDto.getSqlType());
      if (!detailInfoDto.getPackageNameList().contains(className) && !className.contains("lang")) {
        detailInfoDto.getPackageNameList().add(className);
      }
      // 判断表是否存在ID主键
      if (columnIDto.getPropertyName().equals("id")) {
        pk_id = true;
      }
    }

    // 主键不为ID的话,不能生成代码
    if (!pk_id) {
      throw new Exception("表" + tableName + "的主键不为ID,无法自动生成代码");
    }

    return detailInfoDto;
  }