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 ";
}