dbquery.java

实习时做的人事系统

package com.personnel;

public class DBQuery {

	static public String SELECT_ALL_QUERY = "SELECT * FROM 员工信息;";

	static public String SELECT_TRAIN_ALL_QUERY = "SELECT * FROM 培训课程信息;";

	static public String SELECT_WANT_ALL_QUERY = "SELECT * FROM 招聘信息;";

	static public String SELECT_WANTER_ALL_QUERY = "SELECT * FROM 应聘人员;";

	static public String SELECT_DEPARTMENT_ALL_QUERY = "SELECT * FROM 部门信息;";

	static public String SELECT_FIRE_ALL_QUERY = "SELECT * FROM 人员录用;";

	static public String SELECT_PRIZE_ALL_QUERY = "SELECT * FROM 员工奖惩;";

	static public String SELECT_EXAM_ALL_QUERY = "SELECT * FROM 员工绩效考核;";

	static public String SELECT_POST_ALL_QUERY = "SELECT * FROM 职位信息;";

	static public String SELECT_EMPLOYEETRAIN_ALL_QUERY = "SELECT * FROM 员工培训;";
	
	static public String SELECT_ADMIN_ALL_QUERY = "SELECT * FROM admin;";

	static public String REPORT_EMPLOYEE = "SELECT 员工信息.员工号 AS 员工号,员工信息.姓名 AS 姓名,"
			+ "员工信息.性别 AS 性别,员工信息.职位 AS 职位,员工信息.职称 AS 职称,员工信息.聘用 AS 聘用,"
			+ "员工信息.联系电话 AS 联系电话,员工信息.入职日期 AS 入职日期,员工信息.基本工资 AS 基本工资,"
			+ "员工信息.学历 AS 学历,员工信息.身份证 AS 身份证,员工信息.籍贯 AS 籍贯,员工信息.婚姻状况 AS 婚姻状况,"
			+ "员工信息.在职状态 AS 在职状态,员工信息.离职日期 AS 离职日期,员工信息.联系地址 AS 联系地址,"
			+ "部门信息.部门名 AS 部门名 FROM 员工信息,部门信息 WHERE 员工信息.部门 = 部门信息.部门号 ;";
}