constants.java

用SPRING做的一个企业信息系统网站

package com.enterpriseweb.util;

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 = "product";
	public static final String Honour = "honour ";
	public static final String Instructor = "instructor ";
}