SET DEFINE OFF; SELECT 'D&G' FROM DUAL;OR
SELECT 'D&'||'G' FROM DUAL;
$.fn.serializeObject = function() { var o = {}; var a = this.serializeArray(); $.each(a, function() { if (o[this.name]) { if (!o[this.name].push) { o[this.name] = [o[this.name]]; } o[this.name].push(this.value || ''); } else { o[this.name] = this.value || ''; } }); return o; };
$(document).ready(function(){ var data = $("#message").metadata(); var i; for(i in data){ $("#message").append("<div>"+i+"="+data[i]+"</div>"); } });
<div id="message" class="mess {firstName:'Bruce',lastName:'Tsai'}"></div>
(function(){ $("#form01").validate({ debug: true // 除錯模式 }); $("#form02").validate({ rules: { cellphone: { // form.name required: true, digits: true, minlength: 5 } }, messages: { cellphone: { // form.name required: "請填寫電話!", digits: "請填寫電話號碼!", minlength: $.format("至少填入 {0} 個數值") // 對應驗證的參數 } }, debug: true }); $("#form03").validate({ submitHandler: function(form){ alert("Age1 value : " + $("#age1").val()); form.submit(); //$(form).ajaxSubmit(); }, invalidHandler: function(form, validator){ var errors = validator.numberOfInvalids(); alert($.format("錯誤數 : {0}", errors)); } }); $("#form04").validate(); $("#testemail1").rules("add", {required:true}); $("#form05").validate(); // 新增驗證規則, 作法一 $.validator.methods.lessThanSquare = function(value, element, param){ // @value 輸入的值 // @element 驗證的目標元件 // @param 設定規則時的參數 return value * value < param; }; // 新增驗證規則, 作法二 $.validator.addMethod("testSocialId", function(value, element, param){ return /\w\d{9}/.test(value); }, "身份證號驗證錯誤"); $("#form06").validate({ rules: { number2: { required: true, digits: true, lessThanSquare: 100 }, socialid: { required: true, testSocialId: true } }, messages: { number2: { lessThanSquare: "數值錯誤" } } }); $("#form07").validate({ rules: { address: { required: "#requiredaddresscheck:checked" } } }); })();
NicEdit 授權方式 http://nicedit.com/license.php CLEditor 授權方式 You may use CLEditor under the terms of either the MIT License or the GNU General Public License (GPL) Version 2. CKEditor 可與 CKFinder 整合 授權方式 http://ckeditor.com/license Cross-Browser Rich Text Editor (RTE) 授權方式 http://creativecommons.org/licenses/by/2.5/ TinyMCE - Javascript WYSIWYG Editor 授權方式(LGPL) http://tinymce.moxiecode.com/license.php
SELECT s.role_id, s.role_name, s.role_base_on, b.role_name role_base_on_name FROM m_usr_role s LEFT JOIN m_usr_role b ON b.role_id = s.role_base_on
ROLE_ID ROLE_NAME ROLE_BASE_ON ROLE_BASE_ON_NAME ------------------------------------ -------------------------------------------------- ------------------------------------ -------------------------------------------------- system.administrator 系統管理員 common.logon.user 登入帳號 85e9953c-00fd-4a0c-979c-7a41bd3f085a 初學者 231570cd-832f-40e3-b198-fb2336245926 訪客 868a17dd-7d21-48a6-b2d5-f9a80313414a 初級專家 85e9953c-00fd-4a0c-979c-7a41bd3f085a 初學者 3e9a45b1-82f5-49df-8be6-d67df54760c9 中級專家 868a17dd-7d21-48a6-b2d5-f9a80313414a 初級專家 bd6eb9b1-05a3-4059-bc99-90258a7e8d86 高級專家 3e9a45b1-82f5-49df-8be6-d67df54760c9 中級專家 886cd029-db55-48ca-8835-d9c2e02fccad 初級顧問 bd6eb9b1-05a3-4059-bc99-90258a7e8d86 高級專家 0dec42e1-7de3-4a67-be15-97fbea759771 中級顧問 886cd029-db55-48ca-8835-d9c2e02fccad 初級顧問 f5648453-32a5-42c3-8ec1-3b31d0d812fd 高級顧問 0dec42e1-7de3-4a67-be15-97fbea759771 中級顧問 231570cd-832f-40e3-b198-fb2336245926 訪客 common.logon.user 登入帳號 10 個資料列已選取
SELECT role_id, role_name, role_base_on FROM m_usr_role START WITH role_name = '高級顧問' CONNECT BY PRIOR role_base_on = role_id
ROLE_ID ROLE_NAME ROLE_BASE_ON ------------------------------------ -------------------------------------------------- ------------------------------------ f5648453-32a5-42c3-8ec1-3b31d0d812fd 高級顧問 0dec42e1-7de3-4a67-be15-97fbea759771 0dec42e1-7de3-4a67-be15-97fbea759771 中級顧問 886cd029-db55-48ca-8835-d9c2e02fccad 886cd029-db55-48ca-8835-d9c2e02fccad 初級顧問 bd6eb9b1-05a3-4059-bc99-90258a7e8d86 bd6eb9b1-05a3-4059-bc99-90258a7e8d86 高級專家 3e9a45b1-82f5-49df-8be6-d67df54760c9 3e9a45b1-82f5-49df-8be6-d67df54760c9 中級專家 868a17dd-7d21-48a6-b2d5-f9a80313414a 868a17dd-7d21-48a6-b2d5-f9a80313414a 初級專家 85e9953c-00fd-4a0c-979c-7a41bd3f085a 85e9953c-00fd-4a0c-979c-7a41bd3f085a 初學者 231570cd-832f-40e3-b198-fb2336245926 231570cd-832f-40e3-b198-fb2336245926 訪客 8 個資料列已選取reference : Start with connect by prior 階層式查詢用法
public class ErrorHandler implements Thread.UncaughtExceptionHandler { @Override public void uncaughtException(Thread t, Throwable e) { System.err.printf("Thread ID : %s%n", t.getId()); System.err.printf("Message : %s%n", e.getMessage()); } public static void main(String[] args) { // register handler Thread.setDefaultUncaughtExceptionHandler(new ErrorHandler()); // throw error throw new RuntimeException("My exception!"); } }
import java.io.IOException; public class ExecuteDosCommand { public static void main(String[] args) throws IOException, InterruptedException { String cmd = null; try { String s = "command.exe"; Runtime.getRuntime().exec(s); cmd = s; } catch (Exception ex) { // ex.printStackTrace(); } try { String s = "cmd.exe"; Runtime.getRuntime().exec(s); cmd = s; } catch (Exception ex) { // ex.printStackTrace(); } String s = String.format("%s /C start %s", cmd, "c:\\新增文字文件.txt"); System.err.println(s); Runtime.getRuntime().exec(s); } }