2010年2月24日随笔档案 - kylixlu

2010年2月24日

2012 IT热门人才需求类型盘点

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) | 编辑收藏

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

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 %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))
%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))
%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;

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来实现的，代码如下:

package com.ictehi.ophone.util;
2

import java.io.IOException;
4

import java.util.Iterator;
5

import java.util.Map;
6

import org.ksoap2.SoapEnvelope;
8

import org.ksoap2.SoapFault;
9

import org.ksoap2.serialization.SoapObject;
10

import org.ksoap2.serialization.SoapSerializationEnvelope;
11

import org.ksoap2.transport.AndroidHttpTransport;
12

import org.ksoap2.transport.HttpTransportSE;
13

import org.xmlpull.v1.XmlPullParserException;
14

import android.util.Log;
16

public class WSUtils {
18

public WSUtils() {
20

}
21

/**
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

final String SOAP_ACTION=nameSpace+methodName;
34

SoapObject request = new SoapObject(nameSpace, methodName);
35

SoapObject soapResult=null;
36

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

/**
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

envelope.dotNet=true;//是否是dotNet WebService
53

envelope.bodyOut = request;
54

// 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

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/kylixlu/archive/2010/03/12/5372846.aspx

调用这个工具类的方法如下：

HashMap<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

本文来自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) | 编辑收藏

Quality Center 9.0 Lincense

<?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 阅读(266) | 评论 (1) | 编辑收藏

常用链接

留言簿

随笔分类

随笔档案

文章分类

文章档案

相册

搜索

最新评论

阅读排行榜

评论排行榜