mysql for循环动态字段名_动态获取数据库表中的字段名

public static MapgetEmployeeValue(PortletRequest portletRequest, Long employeeId)throwsPortalException, SystemException {

Map entityValueMap = null;long companyId =PortalUtil.getCompanyId(portletRequest);if (employeeId > 0){

Employee employee=EmployeeLocalServiceUtil.getEmployee(employeeId);if (employee != null){

List companyColumns =CompanyColumnDefinitionLocalServiceUtil

.searchByTableName(companyId, TableConst.CRM_Employee,true);

entityValueMap= new HashMap();for(CompanyColumnDefinition companyColumn : companyColumns) {

String columnName=companyColumn.getColumnName();if (columnName.equals("employeeName")) {

entityValueMap.put(columnName, employee.getEmployeeName());

}else if (columnName.equals("employeeNo")) {

entityValueMap.put(columnName, employee.getEmployeeNo());

}else if (columnName.equals("employeeAge")) {

entityValueMap.put(columnName, employee.getEmployeeAge()!= 0

? String.valueOf(employee.getEmployeeAge()) : "");

}else if (columnName.equals("employeeSex")) {

entityValueMap.put(columnName, employee.getEmployeeSex());

}else if (columnName.equals("identityCard")) {

entityValueMap.put(columnName, employee.getIdentityCard());

}else if (columnName.equals("nation")) {

entityValueMap.put(columnName, employee.getNation());

}else if (columnName.equals("category")) {

entityValueMap.put(columnName, employee.getCategory());

}else if (columnName.equals("policitalStatus")) {

entityValueMap.put(columnName, employee.getPolicitalStatus());

}else if (columnName.equals("isMarry")) {

entityValueMap.put(columnName, employee.getIsMarry());

}else if (columnName.equals("employeeType")) {

entityValueMap.put(columnName, employee.getEmployeeType());

}else if (columnName.equals("mobilePhone")) {

entityValueMap.put(columnName, employee.getMobilePhone());

}else if (columnName.equals("workPhone")) {

entityValueMap.put(columnName, employee.getWorkPhone());

}else if (columnName.equals("email")) {

entityValueMap.put(columnName, employee.getEmail());

}else

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值