sqlsentence.java

办公自动化系统,有人事资源管理模块,考勤管理,审批管理,权限设定等.

package com.lovo.dao.mjy;

public class SqlSentence {
	/**
	 * ��sql����װ��4�õ���
	 */
	public static final String SQL_SELECT_PIM = "select a.name,c.depName,e.postName,b.startTime,b.overTime,b.leaveConfirm,b.overTime-b.startTime from t_basicinfo a,t_leave b,t_department c,t_workinfo d, t_position e where a.Id=b.empId and b.empId=d.empId and c.depId=d.Department and d.position=e.postID and a.Id=? limit?,?;";

	public static final String SQL_SELECT_ALL = "select a.name,a.gongling,a.tanqin,a.year from t_basicinfo a limit ?,?;";

	public static final String SQL_UPDATE = "update t_basicinfo a set a.gongling=20,a.tanqin=20;";

	public static final String SQL_COUNTA = "select a.year,count(*) as count from t_basicinfo a GROUP BY a.year;";

	public static final String SQL_COUNTB = "select count(*) as count from t_basicinfo a,t_leave b,t_department c,t_workinfo d, t_position e where a.Id=b.empId and b.empId=d.empId and c.depId=d.Department and d.position=e.postID and a.Id=? limit?,?;";

	public static final String SQL_UPTADA_YEAR = "update t_basicinfo a set a.year=?;";

}