/*
 * 定義儲屬性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 ";
}