scoretotletable.java

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

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

public class ScoreTotleTable {
  public ScoreTotleTable() {
  }

  public static final String TABLE_NAME = "SCORETOTLE";

  public static final String COL_PERIOD_ID = "PERIOD_ID";
  public static final String COL_DEP_ID = "DEP_ID";
  public static final String COL_PERSON_ID = "PERSON_ID";
  public static final String COL_TOTLESCORE = "TOTLESCORE";
  public static final String COL_TNAME = "TNAME";
  public static final String COL_SCORE = "SCORE";

  public static final String FULL_COL_PERIOD_ID =
      TABLE_NAME + "." + COL_PERIOD_ID;
  public static final String FULL_COL_DEP_ID =
      TABLE_NAME + "." + COL_DEP_ID;
  public static final String FULL_COL_PERSON_ID =
      TABLE_NAME + "." + COL_PERSON_ID;
  public static final String FULL_COL_TOTLESCORE =
      TABLE_NAME + "." + COL_TOTLESCORE;
  public static final String FULL_COL_TNAME =
      TABLE_NAME + "." + COL_TNAME;
  public static final String FULL_COL_SCORE =
      TABLE_NAME + "." + COL_SCORE;

  public static final String sSQL = "SELECT "
                                    + FULL_COL_PERIOD_ID + " , "
                                    + FULL_COL_DEP_ID + " , "
                                    + FULL_COL_PERSON_ID + " , "
                                    + FULL_COL_TOTLESCORE + " , "
                                    + FULL_COL_TNAME + " , "
                                    + FULL_COL_SCORE + " FROM "
                                    + TABLE_NAME;

}