posts - 66,comments - 41,trackbacks - 0
Computerworld在对多位IT高管进行调查之后,得出了2012 最需要IT技能,不过由于调查范围不够大,可能会出现偏差,仅供参考。

1)编程及应用开发:需求从2010年的44%上升到2012年的61%。
2)项目管理:不仅仅管理人才监管项目,还需要洞察用户需求并转述给其他IT员工,包括需求日益增加的商业分析师。
3)服务台支持/技术支持:随着移动操作系统的发展,需求随之增加
4) 网络设计:这类需求部分归结于虚拟化及云计算的发展,相关人员最好具有虚拟系统及思杰系统经验的人。
5) 商务智能(Business Intelligence):这类需求大部分归因于企业日益将重心从节省成本转向技术投资。
6) 数据中心:虚拟化及云技术也排在其后
7) Web 2.0:围绕社交媒体的技术需求将会增加,Net,AJAX及PHP作关键后端技术,HTML,XML,CSS,Flash及Javascript作前端支持。
8) 安全:2010年需求为32%,现在有所下降,但由于日趋严重的安全问题,许多人又将此提到一个新的高度
9 )电信:对IP电话技术人员的需求也相当大,尤其是对Cisco IPCC电话中心系统熟悉的人。
posted @ 2012-01-10 20:45 kylixlu 阅读(200) | 评论 (0)编辑 收藏

The Oracle TO_CHAR(datetime, fmt) function converts datetime values to a string in the format specified by the fmt option.

MySQL has the DATE_FORMAT function that allows datetime values converting to a string in the specified format.

SQLWays converts the Oracle TO_CHAR function to the MySQL DATE_FORMAT function and converts elements of format string from Oracle to corresponding specifier in MySQL as specified in the following table.

TABLE 56. Conversion of Oracle TO_CHAR(datetime) with format string to MySQL

Mapping of datetime format specifiers between MySQL and Oracle
MySQL
Oracle (independently from register)
Description
%a
DY
Abbreviated weekday name (Sun..Sat)
%b
MON
Abbreviated month name (Jan..Dec)
%D
-
Day of the month with English suffix (0th, 1st, 2nd, 3rd, etc.)
%d
%e
DD
 
Day of the month, numeric ((00..31) and (0..31))
%j
DDD
Day of year (001..366)
%m
%c
MM
Month, numeric ((00..12) and (0..12))
%M
MONTH
Month name (January..December)
%f
-
Microseconds (000000..999999)
%i
MI
Minutes, numeric (00..59)
%h
%I
%l
HH
HH12
Hour ((01..12) and (1..12))
%H
%k
HH24
Hour ((00..23) and (0..23))
%p
AM
PM
AM or PM
%r
-
Time, 12-hour (hh:mm:ss followed by AM or PM)
%S
%s
SS
Seconds ((00..59) and (0..59))
%T
-
Time, 24-hour (hh:mm:ss)
%u
WW
IW
Week (00..53), where Monday is the first day of week
%U
-
Week (00..53), where Sunday is the first day of week
%V
-
Week (01..53), where Sunday is the first day of week, used with %X
%v
WW
IW
Week (01..53), where Monday is the first day of week, used with %x
%W
DAY
Weekday name (Sunday..Saturday)
%w
-
Day of the week (0=Sunday .. 6=Saturday)
%X
-
Year for the week, where Sunday is the first day of the week, numeric 4 digits; used with %V
%x
-
Year for the week, where Monday is the first day of the week, numeric 4 digits; used with %v
%Y
YYYY
SYYYY
IYYY
Year, numeric, 4 digits
%y
YY
IYY
Year, numeric, 2 digits
-
J
Julian day; the number of days since January 1, 4712 BC.
-
Q
Quarter of year (1, 2, 3, 4; JAN-MAR = 1).
-
RR
Given a year with 2 digits:
· If the year is <50 and the last 2 digits of the current year are >=50, then the first 2 digits of the returned year are 1 greater than the first 2 digits of the current year.
· If the year is >=50 and the last 2 digits of the current year are <50, then the first 2 digits of the returned year are 1 less than the first 2 digits of the current year.
-
RRRR
Round year. Accepts either 4-digit or 2-digit input. If 2-digit, provides the same return as RR. If you don't want this functionality, then simply enter the 4-digit year.
-
W
Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh.
-
SSSSS
Seconds past midnight (0 - 86399).
-
X
Local radix character.
-
Y,YYY
Year with comma in the position.
-
YEAR
SYEAR
Year, spelled out; "S" prefixes BC dates with "-".
-
YYY
3 digits of year.
-
Y
1 digit of year.
-
IY
2 digits of ISO year.
-
I
1 digit of ISO year.
-
AD
A.D.
AD indicator with or without periods.
-
BC
B.C.
BC indicator with or without periods.
-
CC
SCC
One greater than the first two digits of a four-digit year; "S" prefixes BC dates with "-".
For example, '20' from '1900'.
-
D
Day of week (1 - 7).
-
A.M.
P.M.
Meridian indicator with periods.
-
TZH
Time zone hour.
-
TZM
Time zone minute.
-
TZR
Time zone region information.
-
RM
 
TABLE 57. Example of Conversion
Oracle
MySQL
create procedure sp_to_char_date_format
as
begin
-- GET ACTUAL TIME AND DATE
select to_char(sysdate,'DD-MON-YYYY:HH24:MI')
from dual;
end;
create procedure sp_to_char_date_format()
begin
-- GET ACTUAL TIME AND DATE
select DATE_FORMAT(CURRENT_TIMESTAMP, '%e-%M-
%Y:%H:%i') from dual;
end;

posted @ 2010-04-22 17:00 kylixlu 阅读(1194) | 评论 (0)编辑 收藏
近日在项目中写了个OPhone 调用Webservice的工具类,主要是使用了KSoap2来实现的,代码如下:

 1package com.ictehi.ophone.util;   
 2  
 3import java.io.IOException;   
 4import java.util.Iterator;   
 5import java.util.Map;   
 6  
 7import org.ksoap2.SoapEnvelope;   
 8import org.ksoap2.SoapFault;   
 9import org.ksoap2.serialization.SoapObject;   
10import org.ksoap2.serialization.SoapSerializationEnvelope;   
11import org.ksoap2.transport.AndroidHttpTransport;   
12import org.ksoap2.transport.HttpTransportSE;   
13import org.xmlpull.v1.XmlPullParserException;   
14  
15import android.util.Log;   
16  
17public class WSUtils {   
18  
19    public WSUtils() {   
20    }
   
21       
22    /**  
23     * @author Eric.Lu  
24     * @param endPoint  
25     * @param methodName  
26     * @param params  
27     * @param wsdl  
28     * @return SoapObject  
29     */
  
30    public static SoapObject callWS(String nameSpace, String methodName,   
31            Map params, String wsdl) {   
32  
33        final String SOAP_ACTION=nameSpace+methodName;   
34        SoapObject request = new SoapObject(nameSpace, methodName);   
35        SoapObject soapResult=null;   
36           
37        if(params !=null && !params.isEmpty()){   
38            for(Iterator it=params.entrySet().iterator();it.hasNext();){//遍历MAP   
39                Map.Entry<String, Object> e=(Map.Entry<String, Object>) it.next();   
40                request.addProperty(e.getKey().toString(),e.getValue());   
41            }
   
42        }
   
43           
44            /**  
45             * 设置Soap版本  
46             * 类型:VER1.0,VER1.1,VER1.2  
47             */
  
48            // SoapSerializationEnvelope envelope=new SoapSerializationEnvelope(SoapEnvelope.VER10);//SOAP 1.0   
49            SoapSerializationEnvelope envelope = new SoapSerializationEnvelope(SoapEnvelope.VER11);// SOAP 1.1   
50            // SoapSerializationEnvelope envelope=new SoapSerializationEnvelope(SoapEnvelope.VER12);//SOAP 1.2   
51               
52            envelope.dotNet=true;//是否是dotNet WebService   
53            envelope.bodyOut = request;   
54  
55//          HttpTransportSE ht = new HttpTransportSE(wsdl);   
56            AndroidHttpTransport androidHT=new  AndroidHttpTransport(wsdl);    
57            try {   
58//              ht.call(SOAP_ACTION, envelope);   
59                androidHT.call(SOAP_ACTION,envelope);   
60            }
 catch (IOException e) {   
61                Log.e("IOException:", e.getMessage());   
62            }
 catch (XmlPullParserException e1) {   
63                Log.e("XmlPullParserException", e1.getMessage());   
64            }
   
65            try {   
66                soapResult=(SoapObject)envelope.getResponse();   
67            }
 catch (SoapFault e) {   
68                Log.e("SoapFault",e.getMessage());   
69            }
   
70        return soapResult;   
71    }
   
72}
  
73
74
75本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/kylixlu/archive/2010/03/12/5372846.aspx
调用这个工具类的方法如下:
 1HashMap<String, Object> params = new HashMap<String, Object>();      
 2        params.put("theCityName", peoples[position]);      
 3        String wsdl = "webservice的wsdl地址";      
 4        String nameSpace = "wsdl中的namespace";      
 5        String methodName = "方法名";//      
 6        // SoapObject result = WSUtils.callWS(nameSpace, methodName,      
 7        // wsdl,peoples[position]);      
 8        SoapObject result = WSUtils.callWS(nameSpace, methodName, params, wsdl);    
 9
10
11本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/kylixlu/archive/2010/03/12/5372846.aspx
posted @ 2010-03-24 09:23 kylixlu 阅读(800) | 评论 (0)编辑 收藏
     摘要: 系统架构设计师考试大纲 一、考试说明: 1.考试目标        考试合格人员应能够根据系统需求规格说明书,结合应用领域和技术发 展的实际情况,考虑有关约束条件,设计正确、合理的软件架构,确保系统架构具有良好的特性;能够对项目睥系统架构进行描述、分析、设计与评估;能够按照相 关标准编写相应的设计文档;能够与系统分析师、项目管理...  阅读全文
posted @ 2010-03-09 13:28 kylixlu 阅读(278) | 评论 (0)编辑 收藏
<?xml version="1.0" encoding="UTF-8"?>
<license>
    
<terms>
        
<issued_to>rapidhorse.com.cn</issued_to>
        
<license_identifier>SN732563653</license_identifier>
        
<edition>enterprise</edition>
        
<evaluation>N</evaluation>
        
<start_date>12/13/2007</start_date>
        
<expiration>5/29/2099</expiration>
        
<full_test_director>500</full_test_director>
        
<additional_defects>500</additional_defects>
        
<tolerance>0%</tolerance>
        
<requirements>Y</requirements>
        
<advanced_reports>Y</advanced_reports>
        
<business_process_testing>500</business_process_testing>
        
<version_control>Y</version_control>
        
<dashboard>Y</dashboard>
    
</terms>
    
<Signature>lA0FAVrF+UTDW2qVIDjVPCSpPKRUpKcoTO8/GI95D1RLIzQAq/8mv+HnIGQ0Grv9am8QKHfncRsARR153QxqKw==</Signature>
</license>
posted @ 2010-02-24 17:24 kylixlu 阅读(265) | 评论 (1)编辑 收藏
仅列出标题  下一页