periodicaltable.java

java网站源代码,有数据库的操作代码,业务逻辑代码等内容

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

public class PerioDicalTable {
  public PerioDicalTable() {
  }

  public static final String TABLE_NAME = "PERIODICAL";

  public static final String COL_ID = "ID";
  public static final String COL_GUIDELINE_ID = "GUIDELINE_ID";
  public static final String COL_CREATEDATE = "CREATEDATE";
  public static final String COL_TDESCRIBE = "TDESCRIBE";
  public static final String COL_NAME = "NAME";

  public static final String FULL_COL_ID =
      TABLE_NAME + "." + COL_ID;
  public static final String FULL_COL_GUIDELINE_ID =
      TABLE_NAME + "." + COL_GUIDELINE_ID;
  public static final String FULL_COL_CREATEDATE =
      TABLE_NAME + "." + COL_CREATEDATE;
  public static final String FULL_COL_TDESCRIBE =
      TABLE_NAME + "." + COL_TDESCRIBE;
  public static final String FULL_COL_NAME =
      TABLE_NAME + "." + COL_NAME;

  public static final String sSQL = "SELECT "
                                    + FULL_COL_ID + " , "
                                    + FULL_COL_GUIDELINE_ID + " , "
                                    + FULL_COL_CREATEDATE + " , "
                                    + FULL_COL_TDESCRIBE + " , "
                                    + FULL_COL_NAME + " FROM "
                                    + TABLE_NAME;


}