constants.java

一个管理系统 用java作的

/*
 *  僔僗僥儉丂丂丗 嶳廏HR僔僗僥儉奐敪
 *  僒僽僔僗僥儉丗 WEB僔僗僥儉
 *
 *   VER    丂曄峏擔     丂晹壽      扴摉幰  丂曄峏撪梕
 *  -----------------------------------------------------------------
 *  V1.00 丂丂${date} (ShanXiu丂Soft)  Tuwenjie   弶斉
 *
 *       (C) Copyright SHANXIU CORPORATION 2006
 *                     All Rights Reserved.
 *
 */


package net.shanxiu.HR.entity;

/**
 * Constants
 */

/******************************************************************************
 * 僋儔僗偺奣梫丗store the contants         
 * 
 * @author  嶌惉幰 tuwenjie
 * @version 1.0
*******************************************************************************
 */
public class Constants {
    
    public static final int    PAGENUM       = 10;
    
    public static final int    YEAR_NUM      = 1900;
    
    public static final int    MONTH_BEGIN   = 1;
    
    public static final int    MONTH_END     = 12;
    
    public static final int    DAY_BEGIN     = 1;
    
    public static final int    DAY_END       = 31;
    
    public static final String YEAR           = "year";
    
    public static final String MONTH          = "month";
    
    public static final String DAY            = "day";
    
    public static final String USER           = "logon_user";
    
    public static final String MANAGER        = "1";
    
    public static final String EMPLOYER       = "0";
    
    public static final String OTHER          = "2";
    
    public static final String EMP_KEY        = "detailVo";
    
    public static final String ADMIN_KEY      = "m_detailVo";
    
    public static final String SQLSTMT_KEY    = "sqlstatement";
    
    public static final String SEARCH_KEY     = "ResultVo";
    
    public static final String A_DYNAMIC_KEY  = "a_resultDepVo";
    
    public static final String M_DYNAMIC_KEY  = "m_resultDepVo";
    
    public static final String Q_DYNAMIC_KEY  = "q_resultDepVo";
    
    public static final String SQL_ALL_EMP    = "select * from emp as e";
    
    public static final String SQL_DEP        = "select dep_id,dep_name from dep as d";
    
    public static final String SQL_DELETE     = "delete from emp where id = ";
    
    public static final String SQL_HEAD_ALL   = "select * from(select name,id,in_time,sex,dep_name,e.dep_ID from emp as e,dep as d where e.dep_ID=d.dep_ID)as w ";
    
    public static final String SQL_HEAD_COUNT = "select count(*) from(select name,id,in_time,sex,dep_name,e.dep_ID from emp as e,dep as d where e.dep_ID=d.dep_ID)as w ";
    
    public static final String SQL_EMP        = "select * from(select name,id,sex,dep_name,birthday,grade,born_in,polity,telephone from emp as e,dep as d where e.dep_id=d.dep_id)as w where id = ";
    
    public static final String SQL_ADMIN      = "select * from(select name,id,sex,dep_name,birthday,grade,born_in,polity,telephone,address,number,get_marry,in_time,out_time,salary,guard,manager,password from emp as e,dep as d where e.dep_id=d.dep_id)as w where id = ";
}