departmenttable.java

来自「java网站源代码,有数据库的操作代码,业务逻辑代码等内容」· Java 代码 · 共 21 行

package com.itsv.gankao.database;
import java.sql.*;

public class DepartmentTable {
  public DepartmentTable() {
  }

  public static final String TABLE_NAME = "DEPARTMENT";

  public static final String COL_ID = "ID";
  public static final String COL_NAME = "NAME";

  public static final String FULL_COL_ID =
      TABLE_NAME + "." + COL_ID;
  public static final String FULL_COL_NAME =
      TABLE_NAME + "." + COL_NAME;

  public static final String wholeSql = "DISTINCT(" + FULL_COL_ID + ") , "
                                        + FULL_COL_NAME;

}