JavaScript驗證

<script type="text/javascript">
??? /*密碼*/
??? function password()
??? {
??????? var password = document.getElementById("password").value;
??????? var ts = document.getElementById("tsPassword");
??????? if (password.length > 18 || password.length < 6 && password.length > 0)
??????? {
??????????? ts.innerHTML = "密碼為6到18位字符";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else if (password === "")
??????? {
??????????? ts.innerHTML = "請輸入您的密碼";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else
??????? {
??????????? ts.innerHTML = "密碼格式正確";
??????????? ts.style.color = "#049b07";
??????????? $("#submitError").css("display", "none");
??????????? return true;
??????? }
??? }
??? /*確認密碼*/
??? function confirmPassword()
??? {
??????? var password = document.getElementById("password").value;
??????? var confirmPassword = document.getElementById("confirmPassword").value;
??????? var ts = document.getElementById("tsConfirmPassword");
??????? if (password !== confirmPassword && confirmPassword != "")
??????? {
??????????? ts.innerHTML = "兩次密碼不一致";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else if (confirmPassword === "")
??????? {
??????????? ts.innerHTML = "請再次輸入您的密碼";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else
??????? {
??????????? ts.innerHTML = "密碼確認通過!";
??????????? ts.style.color = "#049b07";
??????????? $("#submitError").css("display", "none");
??????????? return true;
??????? }
??? }
??? /*姓名*/
??? function username()
??? {
??????? var username = document.getElementById("username").value;
??????? var ts = document.getElementById("tsUsername");
??????? var verc = !(/^[A-Za-z\u4E00-\uFA29]{2,20}$/.test(username));

??????? if (verc && username !== "")
??????? {
??????????? ts.innerHTML = "真實姓名只能含漢字、大寫字母，且至少兩個字";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
? ? ? ? else if (username === "")
??????? {
??????????? ts.innerHTML = "請填寫您的姓名";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else
??????? {
??????????? ts.innerHTML = "姓名格式正確!";
??????????? ts.style.color = "#049b07";
??????????? $("#submitError").css("display", "none");
??????????? return true;
??????? }
??? }
??? /*手機*/
??? function?mobile()
??? {
??????? var?mobile?= document.getElementById("mobile").value;
??????? var ts = document.getElementById("tsMobile");
??????? var verc = !(/^(13[0-9]|15[0|3|6|7|8|9]|18[8|9])\d{8}$/.test(mobile));
??????? if (verc &&?mobile?!== "")
??????? {
??????????? ts.innerHTML = "手機號碼為純數字，長度11位";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else if (mobile?=== "")
??????? {
??????????? ts.innerHTML = "請輸入您的手機號碼";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else
??????? {
??????????? ts.innerHTML = "手機號碼可以使用!";
??????????? ts.style.color = "#049b07";
??????????? $("#submitError").css("display", "none");
??????????? return true;
??????? }
??? }
??? /*電話*/
??? function telephone()
??? {
??????? var telephone = document.getElementById("telephone").value;
??????? var ts = document.getElementById("tsTelephone");
??????? var verc = !(/(^[0-9]{3,4}\-[0-9]{3,8}$)|(^[0-9]{3,8}$)|(^\([0-9]{3,4}\)[0-9]{3,8}$)|(^0{0,1}13[0-9]{9}$)/.test(telephone));

??????? if (telephone.length < 8 || verc && telephone !== "")
??????? {
??????????? ts.innerHTML = "電話碼為純數字，長度8位";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else if (telephone === "")
??????? {
??????????? ts.innerHTML = "請輸入您的電話號碼";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else
??????? {
??????????? ts.innerHTML = "電話號碼可以使用!";
??????????? ts.style.color = "#049b07";
??????????? $("#submitError").css("display", "none");
??????????? return true;
??????? }
??? }
??? /*電子郵件*/
??? function email()
??? {
??????? var email = document.getElementById("email").value;
??????? var ts = document.getElementById("tsEmail");
??????? var verc = !(/^[\w\-\_\.u4e00-\u9fa5]+@[\w\-\_u4e00-\u9fa5]+(\.[\w\-\_u4e00-\u9fa5]+)+$/.test(email));
??????? if (verc && email !== "")
??????? {
??????????? ts.innerHTML = "Email格式不正確";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else if (email === "")
??????? {
??????????? ts.innerHTML = "請輸入您的郵箱";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else
??????? {
??????????? if (CheckUser(document.getElementById("ctl00_ContentPlaceHolder1_txtEmailAddress")))
??????????? {
??????????????? ts.innerHTML = "此郵箱可以使用!";
??????????????? ts.style.color = "#049b07";
??????????????? $("#submitError").css("display", "none");
??????????????? return true;
??????????? }
??????? }
??? }
??? /*提交*/
??? function submit()
??? {
??????? $("#submitError").css("display", "none");
??????? if (password() && confirmPassword() && username() && mobile() && telephone() && email())
??????? {
??????????? return true;
??????? }
??????? else
??????? {
??????????? $("#submitError").css("display", "inline");
??????????? return false;
??????? }
??? }

</script>?

?

PS：應用于企業帶駕后臺系統

?

<script type="text/javascript">
??? /*EMAIL*/
??? function checkemail()
??? {
??????? var email = document.getElementById("ctl00_ContentPlaceHolder1_txtEmailAddress").value;
??????? var ts = document.getElementById("check_email");
??????? illegalemail = !(/^[\w\-\_\.u4e00-\u9fa5]+@[\w\-\_u4e00-\u9fa5]+(\.[\w\-\_u4e00-\u9fa5]+)+$/.test(email));
??????? if (illegalemail && email !== "")
??????? {
??????????? ts.innerHTML = "Email格式不正確";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else if (email === "")
??????? {
??????????? ts.innerHTML = "請輸入您的郵箱";
??????????? ts.style.color = "#666";
??????????? return false;
??????? }
??????? else
??????? {
??????????? if (CheckUser(document.getElementById("ctl00_ContentPlaceHolder1_txtEmailAddress")))
??????????? {
??????????????? ts.innerHTML = "此郵箱可以使用!";
??????????????? ts.style.color = "#049b07";
??????????????? return true;
??????????? }
??????????? // ts.innerHTML ="此郵箱可以使用!";
??????????? // ts.style.color="#049b07";
??????????? // return true;
??????? }
??? }
??? /*賬戶密碼*/
??? function checkpassword()
??? {
??????? var postcode = document.getElementById("ctl00_ContentPlaceHolder1_txtPassword").value;
??????? var ts = document.getElementById("check_password");
??????? /*var reg1=!(/^[1-9]\d{5}(?!d)$/.test(postcode));*/
??????? if (postcode.length > 18 || postcode.length < 6 && postcode.length > 0)
??????? {
??????????? ts.innerHTML = "密碼為6到18位字符";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else if (postcode === "")
??????? {
??????????? ts.innerHTML = "請輸入您的密碼";
??????????? ts.style.color = "#666";
??????????? return false;
??????? }
??????? else
??????? {
??????????? ts.innerHTML = "密碼格式正確!";
??????????? ts.style.color = "#049b07";
??????????? return true;
??????? }
??? }
??? /*密碼確認*/
??? function checkyzmm()
??? {
??????? var mima = document.getElementById("ctl00_ContentPlaceHolder1_txtPassword").value;
??????? var mima1 = document.getElementById("ctl00_ContentPlaceHolder1_txtRePass").value;
??????? var ts = document.getElementById("yzts");
??????? if (mima !== mima1 && mima1 !== "")
??????? {
??????????? ts.innerHTML = "兩次密碼不一致!";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? /*else if(mima1.length < 6 || mima1.length > 18)
??????? {
??????? ts.innerHTML ="密碼不能少于6位,大于18位!";
??????? ts.style.color="#ff0000";
??????? return false;
??????? }*/
??????? else if (mima1 === "")
??????? {
??????????? ts.innerHTML = "請再次輸入您的密碼";
??????????? ts.style.color = "#666";
??????????? return false;
??????? }
??????? else
??????? {
??????????? ts.innerHTML = "密碼確認通過!";
??????????? ts.style.color = "#049b07";
??????????? return true;
??????? }
??? }
??? /*手機號碼*/
??? function checkcellphone()
??? {
??????? var cellphone = document.getElementById("ctl00_ContentPlaceHolder1_txtCellPhone").value;
??????? var ts = document.getElementById("check_cellphone");
??????? var reg1 = !(/^1[35]\d{9}$/.test(cellphone));
??????? if (reg1 && cellphone !== "")
??????? {
??????????? ts.innerHTML = "手機號碼為純數字，長度11位。";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else if (cellphone === "")
??????? {
??????????? ts.innerHTML = "請輸入您的手機號碼！";
??????????? ts.style.color = "#666";
??????????? return false;
??????? }
??????? else
??????? {
??????????? if (CheckPhone(document.getElementById("ctl00_ContentPlaceHolder1_txtCellPhone")))
??????????? {
??????????????? ts.innerHTML = "電話號碼可以使用!";
??????????????? ts.style.color = "#049b07";
??????????????? return true;
??????????? }
??????????? // ts.innerHTML ="電話號碼可以使用!";
??????????? // ts.style.color="#049b07";
??????????? // return true;
??????? }
??? }
??? /*駕照*/
??? //function jiaz(){
??? // var yeardd = document.getElementById ("ctl00_ContentPlaceHolder1_ddlYear").value;
??? // var monthdd = document.getElementById ("ctl00_ContentPlaceHolder1_ddlMouth").value;
??? // var nojiaz=document.getElementById("ctl00_ContentPlaceHolder1_nojiaz");
??? // var after=document.getElementById("ctl00_ContentPlaceHolder1_after");
??? // var ts=document.getElementById("jiazhaotime");
??? // if(nojiaz.checked==false&&(yeardd==""||monthdd=="")&&after.checked==false){
??? // ts.innerHTML ="請選擇駕照領取時間！";
??? // ts.style.color="#666";
??? // return false;
??? // }
??? // if(nojiaz.checked==true||(yeardd!=""&&monthdd!="")||after.checked==true){
??? // ts.innerHTML ="請選擇駕照領取時間！";
??? // ts.style.color="#aaa";
??? // return true;
??? // }
??? //
??? // }
??? function jiaz()
??? {
??????? var yeardd = document.getElementById("ctl00_ContentPlaceHolder1_ddlYear").value;
??????? var monthdd = document.getElementById("ctl00_ContentPlaceHolder1_ddlMouth").value;
??????? //var nojiaz=document.getElementById("nojiaz");
??????? //var after=document.getElementById("after");
??????? var ts = document.getElementById("jiazhaotime");
??????? if (yeardd === "" || monthdd === "")
??????? {
??????????? ts.innerHTML = "請選擇駕照領取時間";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else
??????? {
??????????? ts.innerHTML = "請選擇駕照領取時間";
??????????? ts.style.color = "#aaa";
??????????? return true;
??????? }
??? }
??? /*用戶名*/
??? function username()
??? {
??????? var name = document.getElementById("ctl00_ContentPlaceHolder1_txtFname").value;
??????? var ts = document.getElementById("inputusername");
??????? if (name === "")
??????? {
??????????? ts.innerHTML = "請填寫用戶名";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
??????? else
??????? {
??????????? ts.innerHTML = ""
??????????? return true;
??????? }
??? }
??? /*真實姓名*/?
??? function truename()
??? {
??????? var username = document.getElementById("ctl00_ContentPlaceHolder1_txtFname").value;
??????? var ts = document.getElementById("check_realname");
??????? var reg1 = !(/^[A-Z\u4E00-\uFA29]{2,20}$/.test(username));
??????? if (reg1 && username !== "")
??????? {
??????????? ts.innerHTML = "真實姓名只能含漢字、大寫字母,且至少兩個字";
??????????? ts.style.color = "#ff0000";
??????????? return false;
??????? }
? ? ? ? else if (username === "")
??????? {
??????????? ts.innerHTML = "請填寫您的姓名";
??????????? ts.style.color = "#666";
??????????? return false;
??????? }
??????? else
??????? {
??????????? ts.innerHTML = " ";
??????????? ts.style.color = "#666";
??????????? return true;
??????? }
??? }
??? /*證件號碼*/
??? function checkvoucher()
??? {
??????? var name = document.getElementById("ctl00_ContentPlaceHolder1_txtIdCardNo").value;
??????? var ts = document.getElementById("check_voucher");
??????? if (name === "")
??????? {
??????????? ts.innerHTML = "請輸入您的證件號碼";
??????????? ts.style.color = "#666";
??????????? return false;
??????? }
??????? else
??????? {
??????????? ts.innerHTML = ""
??????????? return true;
??????? }
??? }
??? function submi()
??? {
??????? if (checkemail() && checkpassword() && checkyzmm() && checkcellphone() && jiaz() && truename() && checkvoucher())
??????? {
??????????? parent.document.getElementById("ctl00_ContentPlaceHolder1_btnSubmit").disabled = false;
??????????? return true;
??????? }
??????? else
??????? {
??????????? parent.document.getElementById("ctl00_ContentPlaceHolder1_btnSubmit").disabled = true;
??????????? return false;
??????? }
??? }
??? function CheckUser(txtUser)
??? {
??????? var ts = document.getElementById("check_email");
??????? var user_name = txtUser.value;
??????? if (user_name !== "")
??????? {
??????????? var out = GetXmlResponse("clubregister.aspx?cu=" + user_name);
??????????? if (out === 'Y')
??????????? {
??????????????? ts.innerHTML = "郵箱已存在";
??????????????? ts.style.color = "#ff0000";
??????????????? // document.getElementById("ctl00_ContentPlaceHolder1_btnSubmit").disabled=true;
??????????????? return false;
??????????? }
??????????? else
??????????? {
??????????????? return true;
??????????? }
??????? }
??? }
??? function CheckPhone(txtPhone)
??? {
??????? var ts = document.getElementById("check_cellphone");
??????? var user_name = txtPhone.value;
??????? if (user_name !== "")
??????? {
??????????? var out = GetXmlResponse("clubregister.aspx?phone=" + user_name);
??????????? if (out === 'Y')
??????????? {
??????????????? ts.innerHTML = "手機已存在";
??????????????? ts.style.color = "#ff0000";
??????????????? // document.getElementById("ctl00_ContentPlaceHolder1_btnSubmit").disabled=true;
??????????????? return false;
??????????? }
??????????? else
??????????? {
??????????????? return true;
??????????? }
??????? }
??? }
</script>

?

PS：提取于嗨友會注冊頁

?

/*身份證*/
var vcity = { 11: "北京", 12: "天津", 13: "河北", 14: "山西", 15: "內蒙古",
??? 21: "遼寧", 22: "吉林", 23: "黑龍江", 31: "上海", 32: "江蘇",
??? 33: "浙江", 34: "安徽", 35: "福建", 36: "江西", 37: "山東", 41: "河南",
??? 42: "湖北", 43: "湖南", 44: "廣東", 45: "廣西", 46: "海南", 50: "重慶",
??? 51: "四川", 52: "貴州", 53: "云南", 54: "西藏", 61: "陜西", 62: "甘肅",
??? 63: "青海", 64: "寧夏", 65: "新疆", 71: "臺灣", 81: "香港", 82: "澳門", 91: "國外"
};

checktheform = function()
{
??? var card = document.getElementById('code').value;
??? var ts = document.getElementById("code");
??? //是否為空
??? if (card === '')
??? {
??????? ts.style.border = "solid 1px #ff0000";
??????? document.getElementById('code').focus;
??????? return false;
??? }
??? //校驗長度，類型
??? if (isCardNo(card) === false)
??? {
??????? ts.style.border = "solid 1px #ff0000";
??????? document.getElementById('code').focus;
??????? return false;
??? }
??? //檢查省份
??? if (checkProvince(card) === false)
??? {
??????? ts.style.border = "solid 1px #ff0000";
??????? document.getElementById('code').focus;
??????? return false;
??? }
??? //校驗生日
??? if (checkBirthday(card) === false)
??? {
??????? ts.style.border = "solid 1px #ff0000";
??????? document.getElementById('code').focus();
??????? return false;
??? }
??? //檢驗位的檢測
??? if (checkParity(card) === false)
??? {
??????? ts.style.border = "solid 1px #ff0000";
??????? document.getElementById('code').focus();
??????? return false;
??? }
??? ts.style.border = "solid 1px #049b07";
??? return true;
};


//檢查號碼是否符合規范，包括長度，類型
isCardNo = function(card)
{
??? //身份證號碼為15位或者18位，15位時全為數字，18位前17位為數字，最后一位是校驗位，可能為數字或字符X
??? var reg = /(^\d{15}$)|(^\d{17}(\d|X)$)/;
??? if (reg.test(card) === false)
??? {
??????? return false;
??? }

??? return true;
};

//取身份證前兩位,校驗省份
checkProvince = function(card)
{
??? var province = card.substr(0, 2);
??? if (vcity[province] == undefined)
??? {
??????? return false;
??? }
??? return true;
};

//檢查生日是否正確
checkBirthday = function(card)
{
??? var len = card.length;
??? //身份證15位時，次序為省（3位）市（3位）年（2位）月（2位）日（2位）校驗位（3位），皆為數字
??? if (len === '15')
??? {
??????? var re_fifteen = /^(\d{6})(\d{2})(\d{2})(\d{2})(\d{3})$/;
??????? var arr_data = card.match(re_fifteen);
??????? var year = arr_data[2];
??????? var month = arr_data[3];
??????? var day = arr_data[4];
??????? var birthday = new Date('19' + year + '/' + month + '/' + day);
??????? return verifyBirthday('19' + year, month, day, birthday);
??? }
??? //身份證18位時，次序為省（3位）市（3位）年（4位）月（2位）日（2位）校驗位（4位），校驗位末尾可能為X
??? if (len === '18')
??? {
??????? var re_eighteen = /^(\d{6})(\d{4})(\d{2})(\d{2})(\d{3})([0-9]|X)$/;
??????? var arr_data = card.match(re_eighteen);
??????? var year = arr_data[2];
??????? var month = arr_data[3];
??????? var day = arr_data[4];
??????? var birthday = new Date(year + '/' + month + '/' + day);
??????? return verifyBirthday(year, month, day, birthday);
??? }
??? return false;
};

//校驗日期
verifyBirthday = function(year, month, day, birthday)
{
??? var now = new Date();
??? var now_year = now.getFullYear();
??? //年月日是否合理
??? if (birthday.getFullYear() === year && (birthday.getMonth() + 1) === month && birthday.getDate() === day)
??? {
??????? //判斷年份的范圍（3歲到100歲之間)
??????? var time = now_year - year;
??????? if (time >= 3 && time <= 100)
??????? {
??????????? return true;
??????? }
??????? return false;
??? }
??? return false;
};

//校驗位的檢測
checkParity = function(card)
{
??? //15位轉18位
??? card = changeFivteenToEighteen(card);
??? var len = card.length;
??? if (len === '18')
??? {
??????? var arrInt = new Array(7, 9, 10, 5, 8, 4, 2, 1, 6, 3, 7, 9, 10, 5, 8, 4, 2);
??????? var arrCh = new Array('1', '0', 'X', '9', '8', '7', '6', '5', '4', '3', '2');
??????? var cardTemp = 0, i, valnum;
??????? for (i = 0; i < 17; i++)
??????? {
??????????? cardTemp += card.substr(i, 1) * arrInt[i];
??????? }
??????? valnum = arrCh[cardTemp % 11];
??????? if (valnum === card.substr(17, 1))
??????? {
??????????? return true;
??????? }
??????? return false;
??? }
??? return false;
};

//15位轉18位身份證號
changeFivteenToEighteen = function(card)
{
??? if (card.length === '15')
??? {
??????? var arrInt = new Array(7, 9, 10, 5, 8, 4, 2, 1, 6, 3, 7, 9, 10, 5, 8, 4, 2);
??????? var arrCh = new Array('1', '0', 'X', '9', '8', '7', '6', '5', '4', '3', '2');
??????? var cardTemp = 0, i;
??????? card = card.substr(0, 6) + '19' + card.substr(6, card.length - 6);
??????? for (i = 0; i < 17; i++)
??????? {
??????????? cardTemp += card.substr(i, 1) * arrInt[i];
??????? }
??????? card += arrCh[cardTemp % 11];
??????? return card;
??? }
??? return card;
};

轉載于:https://www.cnblogs.com/mixzo/p/4213436.html

本文來自互聯網用戶投稿，該文觀點僅代表作者本人，不代表本站立場。本站僅提供信息存儲空間服務，不擁有所有權，不承擔相關法律責任。
如若轉載，請注明出處：http://www.pswp.cn/news/273457.shtml
繁體地址，請注明出處：http://hk.pswp.cn/news/273457.shtml
英文地址，請注明出處：http://en.pswp.cn/news/273457.shtml

如若內容造成侵權/違法違規/事實不符，請聯系多彩編程網進行投訴反饋email:809451989@qq.com，一經查實，立即刪除！

相關文章

mysql數據庫根據上傳的經緯度計算距離

mysql數據庫根據上傳的經緯度計算距離

select 6371.393*ACOS(COS(RADIANS(latitude))*COS(RADIANS(47.02))*COS(RADIANS(longitude)-RADIANS(114.100))SIN(RADIANS(latitude))*SIN(RADIANS(47.02))) as distancefrom location
閱讀更多...
emacs配置

emacs配置

; 指針顏色設置為白色(set-cursor-color "white");; 鼠標顏色設置為白色(set-mouse-color "white") ;; 從color-theme中獲取;; 網上下載color-theme.el&#xff0c;放到加載路徑(&#xff0f;usr/share/emacs/site-lisp )下;; M-x color-theme-select,鼠標…
閱讀更多...
自然連接（NATURAL JOIN）

自然連接（NATURAL JOIN）

自然連接&#xff08;NATURAL JOIN&#xff09;是一種特殊的等價連接&#xff0c;它將表中具有相同名稱的列自動進行記錄匹配。自然連接不必指定任何同等連接條件。圖9.9給出了典型的自然連接示意圖。 圖9.9 自然連接 自然連接自動判斷相同名稱的列&#xff0c;而后形成匹配。…
閱讀更多...
iis express8 自動關閉

iis express8 自動關閉

引用&#xff1a;http://www.cnblogs.com/chunCui/p/3522619.html 問題&#xff1a;最近使用vs2013開發個web &#xff0c; 每次調試結束時iis express 8 也會自動關閉 解決方法&#xff1a;web項目-屬性-web-調試器-只選中ASP.Net就可以了 轉載于:https://www.cnblogs.com/qqq…
閱讀更多...
自連接

自連接

9.3 表的連接類型 9.3.1 自連接 自連接是指表與其自身進行連接&#xff0c;這就需要用到前面介紹的表別名。下面通過一個具體實例來講解自連接的應用。 實例5 自連接的使用方法 查詢成績中存在不及格課程的學生的姓名、所在系、所有的課程及成績信息。如果采用前面介紹的…
閱讀更多...
從此記錄

從此記錄

從此記錄工作、學習、生活的那些事兒&#xff01;轉載于:https://www.cnblogs.com/alwaysjava/p/4221362.html
閱讀更多...
LIKE運算符

LIKE運算符

6.5 使用LIKE進行模糊查詢 當只知道部分字符串時&#xff0c;可使用LIKE運算符來查詢數據庫&#xff0c;找出與其相關的整個字符串。因此&#xff0c;當把關鍵字LIKE用在WHERE子句中時&#xff0c;可以比較兩個字符串的部分匹配。當對字符串內容有些印象&#xff0c;但并不知…
閱讀更多...
AND運算符

AND運算符

6.2 組合查詢條件 在前一章提到的WHERE子句進行查詢時&#xff0c;WHERE子句后面的搜索條件只是單一的。實際上&#xff0c;可以通過布爾運算符AND和OR&#xff0c;將多個單獨的搜索條件結合在一個WHERE子句中&#xff0c;形成一個復合的搜索條件。當對復合搜索條件求值時&a…
閱讀更多...
Cron表達式【一】

Cron表達式【一】

Cron表達式【一】 Cron表達式被用來配置CronTrigger實例。 Cron表達式是一個由 7個子表達式組成的字符串。每個子表達式都描述了一個單獨的日程細節。這些子表達式用空格分隔&#xff0c;分別表示&#xff1a; 1. Seconds 秒 2. Minutes 分鐘 3. Hours 小時 4. Day-of-Month 月…
閱讀更多...
OR運算符

OR運算符

6.2.2 OR運算符 OR運算符表示“或”的關系。當可能有多個條件為True&#xff0c;但只要有一個為True就滿足搜索要求時&#xff0c;可以使用OR運算符來組合搜索條件。OR在結合兩個布爾表達式時&#xff0c;只要其中一個條件為True時&#xff0c;便傳回True。OR運算符的真值表…
閱讀更多...
Java基礎---網絡編程

Java基礎---網絡編程

第一講 概述 1、網絡模型&#xff1a;OSI參考模型和TCP/IP參考模型 圖示&#xff1a; 一般來說開發處于傳輸層和網際層&#xff0c;應用層為&#xff1a;FTP和HTTP協議等&#xff0c;傳輸層為&#xff1a;UDP和TCP等&#xff0c;網際層為&#xff1a;IP。 通常用戶操作的是…
閱讀更多...
AND、OR運算符的組合使用

AND、OR運算符的組合使用

6.2.3 AND、OR運算符的組合使用 在WHERE子句中&#xff0c;通過AND、OR運算符可以同時連接多個條件&#xff0c;當然AND、OR運算符也可以同時使用。但是當AND、OR運算符同時存在時&#xff0c;其優先級如何確定呢&#xff1f;與大多數語言一樣&#xff0c;SQL語言認為AND運算…
閱讀更多...
Nginx配置指定媒體類型文件強制下載

Nginx配置指定媒體類型文件強制下載

由于業務需要&#xff0c;在點擊顯示鏈接&#xff08;如www.xxx.com/2015-01-15/xxx.png&#xff09;顯示媒體資源&#xff08;如圖片、視頻、音頻、文檔&#xff09;&#xff0c;而在點擊下載鏈接&#xff08;如www.xxx.com/2015-01-15/xxx.png?downloadtrue&#xff09;請求…
閱讀更多...
IN運算符的使用

IN運算符的使用

6.3 IN運算符 在查詢中&#xff0c;有時只要滿足多個條件中的一個條件即可&#xff0c;如查詢地址在北京、上海或者重慶的學生信息&#xff0c;這時候可以使用IN運算符。 6.3.1 IN運算符的使用 IN運算符允許根據一行記錄中&#xff0c;是否有一列包括在一系列值之中&#…
閱讀更多...
app后端設計（php）

app后端設計（php）

來源&#xff1a;http://blog.csdn.net/column/details/mobilebackend.html?page1 做了3年app相關的系統架構&#xff0c;api設計&#xff0c;先后在3個創業公司中工作&#xff0c;經歷過手機網頁端&#xff0c;android客戶端&#xff0c;iphone客戶端&#xff0c;現在從事日p…
閱讀更多...
NOT運算符與運算符

NOT運算符與運算符

6.4.2 NOT運算符與<>運算符 對于簡單的條件查詢&#xff0c;NOT運算符與<>運算符的功能幾乎沒有什么區別&#xff0c;那么NOT運算符的優勢體現在哪里呢&#xff1f;答案是它可以與其他運算符組合使用&#xff0c;這一點是<>運算符所不能實現的。在6.4.1節已…
閱讀更多...
bootstrap-wysiwyg 結合 base64 解碼 .net bbs 圖片操作類 （三） 圖片裁剪

bootstrap-wysiwyg 結合 base64 解碼 .net bbs 圖片操作類 （三） 圖片裁剪

官方的例子 是 長方形的。 我這里 用于 正方形的頭像 所以 做如下 修改 #preview-pane .preview-container {width: 73px;height: 73px;overflow: hidden;} 可惜很莫名奇妙的是 有的時候 他自動把圖片 變小了&#xff0c;而且針對的都是 小圖&#xff0c;大圖 都顯示正常 發現…
閱讀更多...
“%”通配符

“%”通配符

6.5.2 “%”通配符 在SQL語言中最常用的通配符可能就是“%”了&#xff0c;它表示任意字符的匹配&#xff0c;且不計字符的多少。下面通過幾個典型實例來說明“%”通配符的使用。 1&#xff0e;開頭&#xff0f;結尾匹配 從COURSE表中查詢所有以“計算機”開頭的所有課程的…
閱讀更多...
Wireshark基本介紹和學習TCP三次握手

Wireshark基本介紹和學習TCP三次握手

Wireshark基本介紹和學習TCP三次握手 原文&#xff1a;http://www.cnblogs.com/TankXiao/archive/2012/10/10/2711777.html wireshark介紹 wireshark的官方下載網站&#xff1a; http://www.wireshark.org/ wireshark是非常流行的網絡封包分析軟件&#xff0c;功能十分強大。可…
閱讀更多...
“_”通配符

“_”通配符

6.5.3 “_”通配符 “_”通配符的功能與“%”通配符基本相同&#xff0c;只是它只表示任意一個字符的匹配。當然&#xff0c;要表示兩個字符的匹配&#xff0c;就需要使用兩個“_”通配符&#xff0c;即寫成“__”。 只有在用戶確定所要查詢的字符串的個數&#xff0c;只是不…
閱讀更多...
最新文章

Copyright @ 2022~2023