java 实现 axis2 webservice

// Decompiled by Jad v1.5.8e2. Copyright 2001 Pavel Kouznetsov. // Jad home page: http://kpdus.tripod.com/jad.html // Decompiler options: packimports(3) fieldsfirst ansi space // Source File Name: EmployeeManager.java package com.hisoft.employee.service; import java.io.IOException; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.text.ParsePosition; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; import org.apache.log4j.ConsoleAppender; import org.apache.log4j.Level; import org.apache.log4j.Logger; import org.apache.log4j.PatternLayout; import org.apache.log4j.RollingFileAppender; import org.apache.log4j.SimpleLayout; import com.hisoft.employee.common.ClientIp; import com.hisoft.employee.common.ConfProp; import com.hisoft.employee.common.SessionFactory; // Referenced classes of package com.hisoft.employee.service: // Employee public class EmployeeManager { private static final Logger logger = Logger.getLogger(EmployeeManager.class); String currentIp; public EmployeeManager() { currentIp = ClientIp.getClientIp(); } private void initLog4j() { try { PatternLayout layout = new PatternLayout(); SimpleLayout simpleLayout = new SimpleLayout(); layout.setConversionPattern("[%-5p]%d{yyyy-MM-dd HH:mm:ss} :%l%m%n"); RollingFileAppender rollingFileAppender = new RollingFileAppender( layout, "\\logs\\EmployeeWebService.log"); rollingFileAppender.setMaxFileSize("10000KB"); ConsoleAppender stdout = new ConsoleAppender(simpleLayout); logger.setLevel(Level.WARN); logger.addAppender(rollingFileAppender); logger.addAppender(stdout); } catch (Exception e) { System.out.println(e.getMessage()); } } private boolean checkApprovedIp() { try { initLog4j(); int i; @SuppressWarnings("rawtypes") List list = ConfProp.getConfProp(); String currentIp = ClientIp.getClientIp(); for (i = 0; i < list.size(); i++) { if (((String) list.get(i)).equals(currentIp)) { break; } } if (i == list.size()) { logger.warn("checkApprovedIp() --" + currentIp + "-- no Visit webservice permision"); return false; } logger.warn("checkApprovedIp() --" + currentIp + "-- Visit webservice"); return true; } catch (IOException e) { e.printStackTrace(); } return false; } public Employee[] findEmployeeByName(String name) { if (!checkApprovedIp()) return null; logger.warn((new StringBuilder("findEmployeeByName(String name) --")) .append(currentIp).append("-- Visit webservice,name=").append(name) .toString()); ArrayList<Employee> list = new ArrayList<Employee>(); try { SessionFactory.conn2Sql(); Statement stmt = SessionFactory.connection.createStatement(); String strSQL = "SELECT TOP 10 EMPLOYEE_NUMBER,EMPLOYEE_NAME,EMAIL,OU_NAME,LEAVE_DATE,ORGINAL_ID "; strSQL = (new StringBuilder(String.valueOf(strSQL))) .append("FROM CUX_EMPLOYEE_INFO_VALUE_VL LEFT JOIN CUX_ORG_VALUE_VL ON ORGANIZATION_ID=OU_ID ") .toString(); strSQL = (new StringBuilder(String.valueOf(strSQL))) .append("where EMPLOYEE_NAME LIKE '%") .append(name.toUpperCase()).append("%'").toString(); Employee employee; System.out.println(strSQL); for (ResultSet rset = stmt.executeQuery(strSQL); rset.next(); list .add(employee)) { employee = new Employee(); employee.setMail(rset.getString("EMAIL")); employee.setName(rset.getString("EMPLOYEE_NAME")); employee.setNumber(rset.getString("EMPLOYEE_NUMBER")); employee.setOrgName(rset.getString("OU_NAME")); employee.setLeaveDate(rset.getDate("LEAVE_DATE")); employee.setOrginalId(rset.getString("ORGINAL_ID")); } logger.warn((new StringBuilder("findEmployeeByName(")).append(name) .append(") --").append(currentIp) .append("-- Visit webservice,result size=").append(list.size()) .toString()); } catch (SQLException e) { e.printStackTrace(); } return (Employee[]) list.toArray(new Employee[0]); } public Employee[] findActiveEmployeeByName(String name) { if (!checkApprovedIp()) return null; logger.warn((new StringBuilder( "findActiveEmployeeByName(String name) --")).append(currentIp) .append("-- Visit webservice,name=").append(name).toString()); ArrayList<Employee> list = new ArrayList<Employee>(); try { SessionFactory.conn2Sql(); Statement stmt = SessionFactory.connection.createStatement(); String strSQL = "SELECT TOP 10 EMPLOYEE_NUMBER,EMPLOYEE_NAME,EMAIL,OU_NAME,LEAVE_DATE,ORGINAL_ID "; strSQL = (new StringBuilder(String.valueOf(strSQL))) .append("FROM CUX_EMPLOYEE_INFO_VALUE_VL LEFT JOIN CUX_ORG_VALUE_VL ON ORGANIZATION_ID=OU_ID ") .toString(); strSQL = (new StringBuilder(String.valueOf(strSQL))) .append("where LEAVE_DATE is null and EMPLOYEE_NAME LIKE '%") .append(name.toUpperCase()).append("%'").toString(); Employee employee; for (ResultSet rset = stmt.executeQuery(strSQL); rset.next(); list .add(employee)) { employee = new Employee(); employee.setMail(rset.getString("EMAIL")); employee.setName(rset.getString("EMPLOYEE_NAME")); employee.setNumber(rset.getString("EMPLOYEE_NUMBER")); employee.setOrgName(rset.getString("OU_NAME")); employee.setLeaveDate(rset.getDate("LEAVE_DATE")); employee.setOrginalId(rset.getString("ORGINAL_ID")); } logger.warn((new StringBuilder("findActiveEmployeeByName(")) .append(name).append(") --").append(currentIp) .append("-- Visit webservice,result size=").append(list.size()) .toString()); } catch (SQLException e) { e.printStackTrace(); } return (Employee[]) list.toArray(new Employee[0]); } public static Date strToDateLong(String strDate) { SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd"); ParsePosition pos = new ParsePosition(0); Date strtodate = formatter.parse(strDate, pos); return strtodate; } public Employee[] findEmployeeByNumber(String number) { if (!checkApprovedIp()) return null; logger.warn((new StringBuilder("findEmployeeByNumber(String number) --")).append(currentIp).append("-- Visit webservice,number=").append(number).toString()); ArrayList<Employee> list = new ArrayList<Employee> (); try { SessionFactory.conn2Sql(); Statement stmt = SessionFactory.connection.createStatement(); String strSQL = "SELECT TOP 10 EMPLOYEE_NUMBER,EMPLOYEE_NAME,EMAIL,OU_NAME,LEAVE_DATE,ORGINAL_ID "; strSQL = (new StringBuilder(String.valueOf(strSQL))).append("FROM CUX_EMPLOYEE_INFO_VALUE_VL LEFT JOIN CUX_ORG_VALUE_VL ON ORGANIZATION_ID=OU_ID ").toString(); strSQL = (new StringBuilder(String.valueOf(strSQL))).append("where EMPLOYEE_NUMBER LIKE '%").append(number.toUpperCase()).append("%'").toString(); Employee employee; for (ResultSet rset = stmt.executeQuery(strSQL); rset.next(); list.add(employee)) { employee = new Employee(); employee.setMail(rset.getString("EMAIL")); employee.setName(rset.getString("EMPLOYEE_NAME")); employee.setNumber(rset.getString("EMPLOYEE_NUMBER")); employee.setOrgName(rset.getString("OU_NAME")); employee.setLeaveDate(strToDateLong(rset.getDate("LEAVE_DATE")+"")); employee.setOrginalId(rset.getString("ORGINAL_ID")); } logger.warn((new StringBuilder("findEmployeeByNumber(")).append(number).append(") --").append(currentIp).append("-- Visit webservice,result size=").append(list.size()).toString()); } catch (SQLException e) { e.printStackTrace(); } return (Employee[])list.toArray(new Employee[0]); } public Employee[] findActiveEmployeeByNumber(String number) { if (!checkApprovedIp()) return null; logger.warn((new StringBuilder( "findActive