employeemanage.java

本系统是基于JAVA语言的办公系统

				anemployee.setPositionName(rs.getString("positionName"));
				anemployee.setTelephone(rs.getString("telephone"));
				anemployee.setEmail(rs.getString("email"));
				anemployee.setEditTime(rs.getString("editTime"));
				anemployee.setMemo(rs.getString("memo"));
				employeelist.addElement(anemployee);
			}
			rs.close();
			return true;
		}
		catch (SQLException e)
		{
			errorMessage = errorMessage + sqlStr + e.getMessage();
			System.out.println(e);
			return false;
		}
		   
/**
		//sql为倒序取值
		sqlStr = "select top " + pageSize + " * from employee ";
		if (searchZiduan.equals("") && !keyword.equals("") ) {
			if(page == 1) {
				sqlStr = sqlStr + "where employeeId like '%" + keyword + "%' or name like '%" + keyword + "%' or department like '%" + keyword + "%' order by employeeId desc";
			}else {
					sqlStr = sqlStr + "where employeeId like '%" +keyword+ "%' or name like '%" + keyword + "%' or department like '%" + keyword + "%' and employeeId not in ( select TOP " + (recordCount-pageSize * page) + " employeeId from employee ORDER BY employeeId ) and employeeId in " +
					"(select TOP " + (recordCount - pageSize * (page-1)) + " employeeId from employee order BY employeeId ) " + " order by empoyeeId desc";
			}		 
		}else if(!searchZiduan.equals("")) {
			if(page == 1) {
				sqlStr = sqlStr + "where " + searchZiduan + " like '%" + keyword + "%' order by employeeId desc";
			} else {
			  sqlStr = sqlStr + "where " + searchZiduan + " like '%" + keyword + "%' and employeeId not in ( select TOP " + (recordCount-pageSize * page ) +" employeeId from employee by employeeId ) and employeeId in " +
				"(select TOP " + (recordCount - pageSize * (page-1)) + " employeeId from employee ORDER BY employeeId )  order by employeeId desc";
			}		 
		}else if(searchZiduan.equals("") && keyword.equals("")) {
			if(page == 1) {
				sqlStr = sqlStr + "order by employeeId desc";
			} else {
				sqlStr = sqlStr + "where employeeId not in ( select TOP " + (recordCount-pageSize * page ) +" employeeId from employee order by employeeId ) and employeeId in " +
				"(select TOP " + (recordCount - pageSize * (page-1)) + " employeeId from employee ORDER BY employeeId )  order by employeeId desc";
			}		 
		}
		try
		{
			rs = stmt.executeQuery(sqlStr);
			employeelist = new Vector(rscount);
			while (rs.next())
			{
				employee anemployee = new employee();
				anemployee.setEmployeeId(rs.getString("employeeId"));
				anemployee.setName(rs.getString("name"));
				anemployee.setCardNumber(rs.getString("cardNumber"));
				anemployee.setNation(rs.getString("nation"));
				anemployee.setSex(rs.getString("sex"));
				anemployee.setBirthday(rs.getString("birthday"));
				anemployee.setGraduateSchool(rs.getString("graduateSchool"));
				anemployee.setSchoolRecord(rs.getString("schoolRecord"));
				anemployee.setDepartment(rs.getString("department"));
				anemployee.setPositionName(rs.getString("positionName"));
				anemployee.setTelephone(rs.getString("telephone"));
				anemployee.setEmail(rs.getString("email"));
				anemployee.setEditTime(rs.getString("editTime"));
				anemployee.setMemo(rs.getString("memo"));
				employeelist.addElement(anemployee);
			}
			rs.close();
			return true;
		}
		catch (SQLException e)
		{
			errorMessage = errorMessage + sqlStr + e.getMessage();
			System.out.println(e);
			return false;
		}
	**/	
	}

  //向数据库中图书表中插入一条新的记录
	public boolean insert() throws Exception {
		String editTime;
    Calendar cal=Calendar.getInstance(); 
    Integer y,m,d,h,mi,s;
    y=cal.get(Calendar.YEAR); 
    m=cal.get(Calendar.MONTH) + 1; 
    d=cal.get(Calendar.DATE); 
    h=cal.get(Calendar.HOUR_OF_DAY); 
    mi=cal.get(Calendar.MINUTE); 
    s=cal.get(Calendar.SECOND); 
    editTime = y+"年"+m+"月"+d+"日"+h+"时"+mi+"分"+s+"秒"; 
		sqlStr = "insert into employee values ('";
		sqlStr = sqlStr + strFormat.toSql(oneEmployee.getEmployeeId()) + "','";
		sqlStr = sqlStr + strFormat.toSql(oneEmployee.getName()) + "','";
	  sqlStr = sqlStr + strFormat.toSql(oneEmployee.getCardNumber()) + "','";
	  sqlStr = sqlStr + strFormat.toSql(oneEmployee.getNation()) + "','";
	  sqlStr = sqlStr + strFormat.toSql(oneEmployee.getSex()) + "','";
	  sqlStr = sqlStr + strFormat.toSql(oneEmployee.getBirthday()) + "','";
	  sqlStr = sqlStr + strFormat.toSql(oneEmployee.getGraduateSchool()) + "','";
	  sqlStr = sqlStr + strFormat.toSql(oneEmployee.getSchoolRecord()) + "','";
	  sqlStr = sqlStr + strFormat.toSql(oneEmployee.getDepartment()) + "','";
	  sqlStr = sqlStr + strFormat.toSql(oneEmployee.getPositionName()) + "','";
	  sqlStr = sqlStr + strFormat.toSql(oneEmployee.getTelephone()) + "','";
	  sqlStr = sqlStr + strFormat.toSql(oneEmployee.getEmail()) + "','";
	  sqlStr = sqlStr + strFormat.toSql(editTime) + "','";
	  sqlStr = sqlStr + strFormat.toSql(oneEmployee.getMemo()) + "')";
		try
		{
			stmt.execute(sqlStr);
			return true;
		}
		catch (SQLException sqle)
		{	
			errorMessage = errorMessage + sqlStr + sqle.getMessage();
			return false;
		}
	}
	
	//更新员工表中的一条记录
	public boolean update() throws Exception {
		sqlStr = "update employee set ";
		sqlStr = sqlStr + "name = '" + strFormat.toSql(oneEmployee.getName()) + "',";
		sqlStr = sqlStr + "cardNumber = '" + strFormat.toSql(oneEmployee.getCardNumber()) + "',";
		sqlStr = sqlStr + "nation = '" + strFormat.toSql(oneEmployee.getNation()) + "',";
		sqlStr = sqlStr + "sex = '" + strFormat.toSql(oneEmployee.getSex()) + "',";
		sqlStr = sqlStr + "birthday = '" + strFormat.toSql(oneEmployee.getBirthday()) + "',";
		sqlStr = sqlStr + "graduateSchool = '" + strFormat.toSql(oneEmployee.getGraduateSchool()) + "',";
		sqlStr = sqlStr + "schoolRecord = '" + strFormat.toSql(oneEmployee.getSchoolRecord()) + "',";
		sqlStr = sqlStr + "department = '" + strFormat.toSql(oneEmployee.getDepartment()) + "',";
		sqlStr = sqlStr + "positionName = '" + strFormat.toSql(oneEmployee.getPositionName()) + "',";
		sqlStr = sqlStr + "telephone = '" + strFormat.toSql(oneEmployee.getTelephone()) + "',";
		sqlStr = sqlStr + "email = '" + strFormat.toSql(oneEmployee.getEmail()) + "',";
		sqlStr = sqlStr + "memo = '" + strFormat.toSql(oneEmployee.getMemo()) + "' ";
		sqlStr = sqlStr + "where employeeId = '" + oneEmployee.getEmployeeId() + "'";
		System.out.println(sqlStr);
		try
		{		
			stmt.execute(sqlStr);
			return true;
		}
		catch (SQLException e)
		{
			errorMessage = sqlStr + e.getMessage();
			return false;
		}
	
	}

  //删除编号为employeeid的员工
	public boolean delete(String employeeId ) throws Exception {

		sqlStr = "delete from employee where employeeId = '"  + employeeId + "'" ;
		try
		{
			stmt.execute(sqlStr);
			return true;
		}
		catch (SQLException e)
		{
			System.out.println(e);
			return false;
		}
	}

  //得到编号为employeeId的员工信息并保存的employeelist向量数组中
	public boolean getOneEmployee(String newEmployeeId ) throws Exception {
		try
		{
			sqlStr="select * from employee where employeeId = '" + newEmployeeId + "'";
			rs = stmt.executeQuery(sqlStr);
			if (rs.next())
			{	
				employeelist = new Vector(1);
				employee oneEmployee = new employee();
				oneEmployee.setEmployeeId(rs.getString("employeeId"));
				oneEmployee.setName(rs.getString("name"));
				oneEmployee.setCardNumber(rs.getString("cardNumber"));
				oneEmployee.setNation(rs.getString("nation"));
				oneEmployee.setSex(rs.getString("sex"));
				oneEmployee.setBirthday(rs.getString("birthday"));
				oneEmployee.setGraduateSchool(rs.getString("graduateSchool"));
				oneEmployee.setSchoolRecord(rs.getString("schoolRecord"));
				oneEmployee.setDepartment(rs.getString("department"));
				oneEmployee.setPositionName(rs.getString("positionName"));
				oneEmployee.setTelephone(rs.getString("telephone"));
				oneEmployee.setEmail(rs.getString("email"));
				oneEmployee.setEditTime(rs.getString("editTime"));
				oneEmployee.setMemo(rs.getString("memo"));
				employeelist.addElement(oneEmployee);
			} else {
				rs.close();
				errorMessage = sqlStr;
				return false;
			}
			rs.close();
			return true;
		}
		catch (SQLException e)
		{
			errorMessage = sqlStr + e.getMessage();
			return false;
		}
		
	}

	public int getPage() {				//显示的页码
		return page;
	}
	public void setPage(int newpage) {
		page = newpage;
	}

	public int getPageSize(){			//每页显示的图书数
		return pageSize;
	}
	public void setPageSize(int newpsize) {
		pageSize = newpsize;
	}

	public int getPageCount() {				//页面总数
		return pageCount;
	}
	public void setPageCount(int newpcount) {
		pageCount = newpcount;
	}

	public long getRecordCount() {
		return recordCount;
	}
	public void setRecordCount(long newrcount) {
		recordCount= newrcount;
	}

};