?? constants.java
字號:
/*
* 定義儲屬性key常量的java文件,以提高整個系統的獨立性
*/
package com.dao;
import java.io.Serializable;
public class Constants implements Serializable {
/**
*
*/
private static final long serialVersionUID = 1L;
/*
* 用于分頁顯示中的每頁顯示顯示的數量
*/
public static final int PAGE_LENGTH = 6;
/*
* 分頁查詢中要用的sql語句
*/
public static final String Product_sql1 = "SELECT top ";
public static final String Product_sql2 = " ID, pname, introduce, temperature, pressure, imagepath FROM ";
public static final String Product_sql3 = " WHERE ID>(SELECT MAX(ID) from (SELECT top ";
public static final String Product_sql4 = " ID FROM ";
public static final String Product_sql5 = " ) as aaa) ORDER BY ID";
public static final String Honour_sql1 = "SELECT top ";
public static final String Honour_sql2 = " ID, title, imagepath FROM ";
public static final String Honour_sql3 = " WHERE ID>(SELECT MAX(ID) FROM (SELECT top ";
public static final String Honour_sql4 = " ID FROM ";
public static final String Honour_sql5 = " ) as aaa) ORDER BY ID";
public static final String Instructor_sql1 = "SELECT top ";
public static final String Instructor_sql2 = " ID, title, imagepath FROM ";
public static final String Instructor_sql3 = " WHERE ID>(SELECT MAX(ID) FROM (SELECT top ";
public static final String Instructor_sql4 = " ID FROM ";
public static final String Instructor_sql5 = " ) as aaa) ORDER BY ID";
/*
* 數據庫名稱
*/
public static final String Products = " tb_products ";
public static final String Honour = " tb_Honour ";
public static final String Instructor = " tb_instructor ";
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -