scoretable.java

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

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

public class ScoreTable {
  public ScoreTable() {
  }

  public static final String TABLE_NAME = "SCORE_TABLE";

  public static final String COL_ID = "ID";
  public static final String COL_PERSON_ID = "PERSON_ID";
  public static final String COL_SCORE_STYLE = "SCORE_STYLE";
  public static final String COL_WHOLE_SCORE = "WHOLE_SCORE";
  public static final String COL_QUERY_SCORE = "QUERY_SCORE";
  public static final String COL_PERIOD_ID = "PERIOD_ID";
  public static final String COL_GUIDELINE_ID = "GUIDELINE_ID";

  public static final String FULL_COL_ID =
      TABLE_NAME + "." + COL_ID;
  public static final String FULL_COL_PERSON_ID =
      TABLE_NAME + "." + COL_PERSON_ID;
  public static final String FULL_COL_SCORE_STYLE =
      TABLE_NAME + "." + COL_SCORE_STYLE;
  public static final String FULL_COL_WHOLE_SCORE =
      TABLE_NAME + "." + COL_WHOLE_SCORE;
  public static final String FULL_COL_QUERY_SCORE =
      TABLE_NAME + "." + COL_QUERY_SCORE;
  public static final String FULL_COL_PERIOD_ID =
      TABLE_NAME + "." + COL_PERIOD_ID;
  public static final String FULL_COL_GUIDELINE_ID =
      TABLE_NAME + "." + COL_GUIDELINE_ID;

  public static final String sSQL = "SELECT "
                                    + FULL_COL_ID + " , "
                                    + FULL_COL_PERSON_ID + " , "
                                    + FULL_COL_SCORE_STYLE + " , "
                                    + FULL_COL_WHOLE_SCORE + " , "
                                    + FULL_COL_QUERY_SCORE + " , "
                                    + FULL_COL_PERIOD_ID + " , "
                                    + FULL_COL_GUIDELINE_ID + " FROM "
                                    + TABLE_NAME;



}