Java && C#

//數據庫中對于時間的查詢操作
public static String getDateSql(Date sDate, String dateType) {
?? ??? ?String start = sDate.getYear() + 1900 + "-" + (sDate.getMonth() + 1)
?? ??? ??? ??? ?+ "-" + sDate.getDate() + " 00:00:00";
?? ??? ?String end = sDate.getYear() + 1900 + "-" + (sDate.getMonth() + 1)
?? ??? ??? ??? ?+ "-" + sDate.getDate() + " 23:59:59";
?? ??? ?String sql = " and " + dateType + " >= TO_DATE('" + start
?? ??? ??? ??? ?+ "','YYYY-MM-DD HH24:MI:SS') and " + dateType
?? ??? ??? ??? ?+ " <= TO_DATE('" + end
?? ??? ??? ??? ?+ "','YYYY-MM-DD HH24:MI:SS') order by " + dateType;
?? ??? ?return sql;
?? ?}

//Java SWT中對于文本框只能輸入數字的限制
/**
??? ?* 數字校驗
??? ?*
??? ?* @param text
??? ?*/
??? private void checkNumber(Text text) {
??? ??? text.addVerifyListener(new VerifyListener() {
??? ??? ??? public void verifyText(VerifyEvent e) {
??? ??? ??? ??? e.doit = ("0123456789.".indexOf(e.text) >= 0);
??? ??? ??? ??? if (e.keyCode == SWT.BS || e.keyCode == SWT.DEL
??? ??? ??? ??? ??? ??? || e.keyCode == SWT.HOME || e.keyCode == SWT.END)
??? ??? ??? ??? ??? e.doit = true;
??? ??? ??? }
??? ??? });
??? }

//對于一些復雜的查詢時可以用HashMap來處理
private String getHql(List<Long> respList,List<Long> customerList, Map<String, Object> map){
??? ??? String hql = " from CrmFeedBack t where 1=1";
??? ??? Object key, value;
??? ??? if (respList != null && respList.size() > 0) {
??? ??? ??? hql += " and t.resp_Idx in (";
??? ??? ??? for (Long id : respList) {
??? ??? ??? ??? hql += id + ",".trim();
??? ??? ??? }
??? ??? ??? hql += ")";
??? ??? ??? hql = hql.replace(",)", ")");
??? ??? }
??? ??? if (customerList != null && customerList.size() > 0) {
??? ??? ??? hql += " and t.client_Name in (";
??? ??? ??? for (Long id : customerList) {
??? ??? ??? ??? hql += id + ",".trim();
??? ??? ??? }
??? ??? ??? hql += ")";
??? ??? ??? hql = hql.replace(",)", ")");
??? ??? }
??? ??? if (map != null && map.size() > 0) {
??? ??? ??? Iterator it = map.entrySet().iterator();
??? ??? ??? while (it.hasNext()) {
??? ??? ??? ??? Map.Entry entry = (Map.Entry) it.next();
??? ??? ??? ??? key = entry.getKey();
??? ??? ??? ??? value = entry.getValue();
??? ??? ??? ??? if (key.equals("resp_Idx") || key.equals("priority")) {
??? ??? ??? ??? ??? hql += " and t." + key + "= " + value;
??? ??? ??? ??? } else {
??? ??? ??? ??? ??? hql += " and t." + key + " like '%" + value + "%'";
??? ??? ??? ??? }
??? ??? ??? }
??? ??? }
??? ??? return hql;
}

///////////////
?? /**
??? ?* Creates the initial layout for a page.
??? ?*/
??? public void createInitialLayout(IPageLayout layout) {
??? ??? String editorArea = layout.getEditorArea();
??? ??? layout.setEditorAreaVisible(false);
??? ??? IFolderLayout left = layout.createFolder("left", IPageLayout.LEFT,
??? ??? ??? ??? 0.2f, editorArea);
??? ??? left.addView(MyTreeView.ID);
??? ??? left.addView(NavigationView.ID);
??? ??? IFolderLayout right = layout.createFolder("right", IPageLayout.RIGHT,
??? ??? ??? ??? 0.8f, editorArea);
??? ??? right.addView(MyTableView.ID);
??? ??? addFastViews(layout);
??? ??? addViewShortcuts(layout);
??? ??? addPerspectiveShortcuts(layout);
??? }
//得到系統文件夾的方法
??? Image image=PlatformUI.getWorkbench().getSharedImages().getImage(
??? ??? ??? ??? ISharedImages.IMG_OBJ_FOLDER);

private?bool IsNumeric(string str)?
{??
?? System.Text.RegularExpressions.Regex reg
?????? = new System.Text.RegularExpressions.Regex(@"^[-]?\d+[.]?\d*$");??
?? return reg.IsMatch(str);?
}

MarQuee的用法