//實現翻頁功能
function goPage(pageno) {
if(document.all["pageNo"])
{
document.all["pageNo"].value=pageno;
form1.submit();
}
}
//查詢鈕功能實現
function bookquery()
{
var questValue= showModalDialog("query.asp",window,"dialogWidth=328px;dialogHeight=150px;dialogTop=300;dialogLeft=300;help=no;status=no;scrollBar=no");
if(questValue==undefined||questValue==""){
document.all("isquery").value="no";
document.all("isquery").value="";
return false; }
var a=questValue.split("|");
document.all("cd_b_no").value=a[0];
document.all("cd_b_name").value=a[1];
document.all("cd_b_state").value=a[2];
document.all("isquery").value="yes";
document.all["form1"].submit();
}
//書籍類別鈕功能實現
function booktype()
{
var questvalue=showModalDialog("tslb.asp",window,"dialogWidth=150px;dialogHeight=180px;dialogTop=247;dialogLeft=850;help=no;status=no;scrollBar=yes");
if (questvalue==undefined)
{document.all("tslb").value="";}
else
{document.all("tslb").value=questvalue;}
}
//刪除按鈕功能實現
function delrecord(){
var str0="'"+document.all("bh").value+"'"
if(confirm("你確定要刪除圖書編號為【"+str0+"】的此筆資料嗎?")){
document.all["operate"].value="delete";
document.all["form1"].submit();
}}
//表單賦值
function getValues(valueStr)
{
if (document.all["addnew"].value =="新增"){
var arrTmp;
arrTmp=valueStr.split("|");
document.all["bh"].value=arrTmp[0];
document.all["isbn"].value=arrTmp[1];
document.all["tm"].value=arrTmp[2];
document.all["sjmc"].value=arrTmp[3];
document.all["cbs"].value=arrTmp[4];
document.all["zz"].value=arrTmp[5];
document.all["dj"].value=arrTmp[6];
document.all["gsrq"].value=arrTmp[7];
document.all["tslb"].value=arrTmp[8];
document.all["tss"].value=arrTmp[9];
document.all["sj"].value=arrTmp[10];
document.all["tszt"].value=arrTmp[11];
document.all["jdr"].value=arrTmp[12];
document.all["jdrq"].value=arrTmp[13];
document.all["xgr"].value=arrTmp[14];
document.all["xgrq"].value=arrTmp[15];
document.all["bz"].value=arrTmp[16];
}
}
//判斷是否為空
function isempty(pyname,zwname) {
if((document.all(pyname).value)==""){
alert("注意,"+ zwname +"欄位不能為空,請填寫完整!");
document.all(pyname).focus();
return true;
}
else
return false;
}
//變色
function changecolor(id,mode) {
id=eval(id);
if(mode==1) {
id.style.background="#99ccFF";
id.style.color="#ff0000";
id.style.cursor="hand";
}
if(mode==0) {
id.style.background="#FFFFFF";
id.style.color="#000000";
id.style.cursor="hand"
}
}
//檢查日期格式
function isnotdate(pyname,zwname){
for(var i=0;i<document.all(pyname).value.length;i++) {
if (document.all(pyname).value.charCodeAt(i)>=128){
alert(zwname+"欄必須為ASCII數字字符!");
document.all[pyname].value=""
document.all(pyname).focus();
return true}}
if (document.all(pyname).value.length>10)
{alert(zwname+"欄以年/月/日之格式輸入[如:2000/1/1],請正確填寫!");
document.all[pyname].value=""
document.all(pyname).focus();
return true}
var reg2= /^(/d{4})//(/d{1,2})//(/d{1,2})$/;
var temp;
if (document.all(pyname).value.match(reg2)!=null){
temp=document.all(pyname).value.match(reg2);
var newdate=new Date(temp[1],(parseInt(temp[2])-1).toString(),temp[3]);
var now= new Date()
if (parseInt(temp[1])<1000 ||parseInt(temp[1])>parseInt(now.getYear()))
{
alert(zwname+"欄不容許出現那樣的年份(應為1000-本年)請正確填寫!");
document.all[pyname].value=""
document.all(pyname).focus();
return true}
if (parseInt(temp[2])>12)
{
alert(zwname+"欄月份輸入錯誤,請正確填寫!");
document.all[pyname].value=""
document.all(pyname).focus();
return true}
if (parseInt(newdate.getDate())!=parseInt(temp[3]))
{
alert(zwname+"欄日輸入錯誤,請正確填寫!");
document.all[pyname].value=""
document.all(pyname).focus();
return true}
}else{
alert(zwname+"欄日期輸入錯誤,請正確填寫!");
document.all[pyname].value=""
document.all(pyname).focus();
return true;}
return false;
}
//判斷是否為數字
function isnotnumberstring(pyname,zwname) {
if (isempty(pyname,zwname)){
return true
}else{
for(var i=0;i<document.all(pyname).value.length;i++) {
if (document.all(pyname).value.charCodeAt(i)>=128){
alert(zwname+"欄必須為ASCII數字字符!");
document.all[pyname].value=""
document.all(pyname).focus();
return true}}
var reg=/^[-|+]{0,1}/d+(/./d+){0,1}$/;
if(document.all(pyname).value.match(reg)==null){
alert(zwname+"欄必須為數字字符!");
document.all[pyname].value=""
document.all(pyname).focus();
return true}
}}
//新增存儲按鈕功能實現
function addrecord(newbh)
{
if (document.all["addnew"].value=="新增"){
var rq=new Date()
document.all['operate'].value="addnew";
document.all["addnew"].value="存儲";
document.all["modify"].value="取消";
document.all["bh"].value=newbh;
document.all["isbn"].value="";
document.all["tm"].value="";
document.all["sjmc"].value="";
document.all["cbs"].value="";
document.all["zz"].value="";
document.all["dj"].value="";
document.all["gsrq"].value="";
document.all["tslb"].value="";
document.all["tss"].value="";
document.all["sj"].value="";
document.all["tszt"].value="在庫";
document.all["jdr"].value="";
document.all["jdrq"].value=rq.getYear()+"/"+parseInt(rq.getMonth()+1).toString()+"/"+rq.getDate();
document.all["xgr"].value="";
document.all["xgrq"].value=rq.getYear()+"/"+parseInt(rq.getMonth()+1).toString()+"/"+rq.getDate();
document.all["bz"].value="";
document.all["bh"].readOnly=true;
document.all["isbn"].readOnly=false;
document.all["tm"].readOnly=false;
document.all["sjmc"].readOnly=false;
document.all["cbs"].readOnly=false;
document.all["zz"].readOnly=false;
document.all["dj"].readOnly=false;
document.all["gsrq"].readOnly=false;
document.all["tslb"].readOnly=false;
document.all["tss"].readOnly=false;
document.all["sj"].readOnly=false;
document.all["tszt"].disabled=false;
document.all["jdr"].readOnly=false;
document.all["jdrq"].readOnly=false;
document.all["xgr"].readOnly=false;
document.all["xgrq"].readOnly=false;
document.all["bz"].readOnly=false;
document.all["tslbb"].disabled=false;
document.all["firstpage"].disabled=true;
document.all["uppage"].disabled=true;
document.all["downpage"].disabled=true;
document.all["lastpage"].disabled=true;
document.all["query"].disabled=true;
document.all["delete"].disabled=true;
document.all["back"].disabled=true;
}else{
if(isempty("isbn","ISBN"))
return false;
if(isnotnumberstring("tm","條碼"))
return false;
if(isempty("sjmc","書籍名稱"))
return false;
if(isempty("cbs","出版社"))
return false;
if(isempty("zz","作者"))
return false;
if(isnotnumberstring("dj","單價"))
return false;
if(isempty("gsrq","購書日期"))
return false;
if(isnotdate("gsrq","購書日期"))
return false;
if(isempty("tslb","圖書類別"))
return false;
if(isempty("tss","圖書室"))
return false;
if(isempty("tszt","圖書狀態"))
return false;
if(isnotdate("jdrq","建檔日期"))
return false;
if(isnotdate("xgrq","修改日期"))
return false;
if(document.all["bz"].value.length>200)
{document.all["bz"].value=""
document.all["bz"].focus();
alert("備注內容不充許超過200個字符!")
return false}
alert("通過驗証,此圖書信息已保存到數據庫中!");
var str0="'"+(document.all["bh"].value)+"'"
var str1="'"+document.all["isbn"].value+"'"
var str2="'"+document.all["tm"].value+"'"
var str3="'"+document.all["sjmc"].value+"'"
var str4="'"+document.all["cbs"].value+"'"
var str5="'"+document.all["zz"].value+"'"
var str6=parseFloat(document.all["dj"].value)
var str7="'"+document.all["gsrq"].value+"'"
var str8="'"+document.all["tslb"].value+"'"
var str9="'"+document.all["tss"].value+"'"
var str10="'"+document.all["sj"].value+"'"
var str11="'"+document.all["tszt"].value+"'"
var str12="'"+document.all["jdr"].value+"'"
var str13="'"+document.all["jdrq"].value+"'"
var str14="'"+document.all["xgr"].value+"'"
var str15="'"+document.all["xgrq"].value+"'"
var str16="'"+document.all["bz"].value+"'"
var updatestr="update lftu08B_book set ISBN="+str1+","+"barcode="+str2+","+"b_name="+str3+","+"pblsh="+str4+","+"writer="+str5+","+"price="+str6+","+"buy_date="+str7+","+"b_type="+str8+","+"library_no="+str9+","+"SJ="+str10+","+"b_state="+str11+","+"Bd_man="+str12+","+"Bd_date="+str13+","+"e_man="+str14+","+"e_date="+str15+","+"meno="+str16+"where b_no="+str0
var insertstr="insert into lftu08B_book (b_no,ISBN,barcode,b_name,pblsh,writer,price,buy_date,b_type,library_no,SJ,b_state,Bd_man,Bd_date,e_man,e_date,meno) Values ("+str0+","+str1+","+str2+","+str3+","+str4+","+str5+","+str6+","+str7+","+str8+","+str9+","+str10+","+str11+","+str12+","+str13+","+str14+","+str15+","+str16+")"
oper=document.all["operate"].value
if(oper=="update"){
document.all["updatestr"].value=updatestr}
if (oper=="addnew"){
document.all["insertstr"].value=insertstr;}
document.all["addnew"].value="新增";
document.all["modify"].value="修改";
document.all["bh"].readOnly=true;
document.all["isbn"].readOnly=true;
document.all["tm"].readOnly=true;
document.all["sjmc"].readOnly=true;
document.all["cbs"].readOnly=true;
document.all["zz"].readOnly=true;
document.all["dj"].readOnly=true;
document.all["gsrq"].readOnly=true;
document.all["tslb"].readOnly=true;
document.all["tss"].readOnly=true;
document.all["sj"].readOnly=true;
document.all["jdr"].readOnly=true;
document.all["jdrq"].readOnly=true;
document.all["xgr"].readOnly=true;
document.all["xgrq"].readOnly=true;
document.all["bz"].readOnly=true;
document.all["tszt"].disabled=false;
document.all["tslbb"].disabled=true;
document.all["query"].disabled=false;
document.all["delete"].disabled=false;
document.all["back"].disabled=false;
document.all["form1"].submit();
}
}
//修改取消按鈕功能實現
function oprateconcel(valueStr)
{
if(document.all["addnew"].value =="新增")//修改
{
var rq=new Date()
document.all["operate"].value="update";
document.all["addnew"].value = "存儲";
document.all["modify"].value = "取消";
document.all["bh"].readOnly=true;
document.all["isbn"].readOnly=false;
document.all["tm"].readOnly=false;
document.all["sjmc"].readOnly=false;
document.all["cbs"].readOnly=false;
document.all["zz"].readOnly=false;
document.all["dj"].readOnly=false;
document.all["gsrq"].readOnly=false;
document.all["tslb"].readOnly=false;
document.all["tslbb"].disabled=false;
document.all["tss"].readOnly=false;
document.all["sj"].readOnly=false;
document.all["tszt"].disabled=false;
document.all["jdr"].readOnly=false;
document.all["jdrq"].readOnly=false;
document.all["xgr"].readOnly=false;
document.all["xgrq"].readOnly=false;
document.all["xgrq"].value=rq.getYear()+"/"+parseInt(rq.getMonth()+1).toString()+"/"+rq.getDate();
document.all["bz"].readOnly=false;
document.all["tslbb"].disabled=false;
document.all["firstpage"].disabled=true;
document.all["uppage"].disabled=true;
document.all["downpage"].disabled=true;
document.all["lastpage"].disabled=true;
document.all["query"].disabled=true;
document.all["delete"].disabled=true;
document.all["back"].disabled=true;
}
else//取消
{
document.all['operate'].value="query";
document.all["addnew"].value="新增";
document.all["modify"].value="修改";
document.all["bh"].readOnly=true;
document.all["isbn"].readOnly=true;
document.all["tm"].readOnly=true;
document.all["sjmc"].readOnly=true;
document.all["cbs"].readOnly=true;
document.all["zz"].readOnly=true;
document.all["dj"].readOnly=true;
document.all["gsrq"].readOnly=true;
document.all["tslb"].readOnly=true;
document.all["tss"].readOnly=true;
document.all["sj"].readOnly=true;
document.all["jdr"].readOnly=true;
document.all["jdrq"].readOnly=true;
document.all["xgr"].readOnly=true;
document.all["xgrq"].readOnly=true;
document.all["bz"].readOnly=true;
document.all["tszt"].disabled=true;
document.all["tslbb"].disabled=true;
document.all["query"].disabled=false;
document.all["delete"].disabled=false;
document.all["back"].disabled=false;
document.all["form1"].submit();
}
}
<script language="javascript">
//用 javascript 寫服務器端連接數据庫的代碼示例
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; "
+"Password=; Initial Catalog=pubs");
var rs = new ActiveXObject("ADODB.Recordset");
var sql="select * from authors";
rs.open(sql, conn);
shtml = "<table width='100%' border=1>";
shtml +="<tr bgcolor='#f4f4f4'><td>au_id</td><td>au_lname</td><td>au_fname</td><td>phone</td><td>address</td><td> city</td><td>state</td><td>zip</td></tr>";
while(!rs.EOF)
{
shtml += "<tr><td>" + rs("au_id") + "</td><td>" + rs("au_lname") + "</td><td>" + rs("au_fname") + "</td><td>" + rs("phone") + "</td><td>" + rs("address") + "</td><td>" + rs("city") + "</td><td>" + rs("state") + "</td><td>" + rs("zip") + "</td></tr>";
rs.moveNext;
}
shtml += "</table>";
document.write(shtml);
rs.close();
rs = null;
conn.close();
conn = null;
</script>
<input type=text name=re_name style="width:100px;height:21px;font-size:10pt;"><span style="width:18px;border:0px solid red;"><select name="r00" style="margin-left:-100px;width:118px; background-color:#FFEEEE;" onChange="document.all.re_name.value=this.value;">
<option value="1">11111111<option>
<option value="2">222222</option>
<option value="3">333333</option>
</select>
</span>
<html>
<head>
<title>Cookies</title>
<script src="lib_cookie.js">
</script>
</head>
<body>
<h2>Set Cookie</h2>
<form name="setcooky">
Name: <input type="text" size="30" name="setcooky_name">
Value: <input type="text" size="30" name="setcooky_value">
<input type=button value="Set Cookie"
οnclick="set_cookie(setcooky_name.value, setcooky_value.value);
alert('The cookie /'' + setcooky_name.value + '/', with value /'' + setcooky_value.value + '/', has been set.')"
</form>
<hr>
<h2>Get Cookie</h2>
<form name="getcooky">
<ul>
<li>Name: <input type="text" size="30" name="getcooky_name">
<input type=button value="Get Cookie Value"
οnclick="getcooky_value.value=get_cookie(getcooky_name.value)">
Value: <input type="text" size="30" name="getcooky_value">
<br><br>
<li><input type=button value="Get document.cookie" onClick="alert(document.cookie)">
</ul>
</form>
<hr>
<h2>Delete Cookie</h2>
<form name="delcooky">
Name: <input type="text" size="30" name="delcooky_name">
<input type=button value="Delete Cookie"
οnclick="del_cookie(delcooky_name.value);
alert('The cookie /'' + delcooky_name.value + '/' has been deleted.')"
</form>
</body>
</html>
<!-- ads begin -->
</noscript>
<!-- -->
</noscript>
<SCRIPT TYPE="text/javascript" LANGUAGE="JavaScript">
<!--
// set expiration to 3 minutes
var expiration = new Date(); expiration.setTime(expiration.getTime() + 180000);
function getCookie(name){
var cname = name + "=";
var dc = document.cookie;
if (dc.length != 0) {
begin = dc.indexOf(cname);
if (begin != -1) {
begin += cname.length;
end = dc.indexOf(";", begin);
if (end == -1) end = dc.length;
return unescape(dc.substring(begin, end));
}
}
return null;
}
function setCookie(name, value, expires) {
document.cookie = name + "=" + escape(value) +
((expires == null) ? "" : "; expires=" + expires.toGMTString()) +
"; path=/";
}
var xtpop;
function popWin() {
setCookie('Visits', 1, expiration);
xtpop = window.open("http://clickit.go2net.com/adclick?cid=197064&area=va.dir.edu&site=va&shape=exitpopup&keyword=exitpopup","xtpop","width=700,height=560,toolbar,scrollbars,menubar,resizable,top=100,left=100");
xtpop.blur();
setTimeout("xtpop.blur();",20);
setTimeout("xtpop.blur();",100);
self.focus();
}
var visitsCookie = getCookie('Visits');
if (visitsCookie == null) popWin();
// -->
</SCRIPT>
<SCRIPT LANGUAGE="JavaScript">
<!--
browser = (((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) >= 2 )) || ((navigator.appName == "Microsoft Internet Explorer") && (parseInt(navigator.appVersion) >= 2 )));
browser4 = (((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) >= 4 )) || ((navigator.appName == "Microsoft Internet Explorer") && (parseInt(navigator.appVersion) >= 4 )));
if (browser4) {
if (!self.url) {
self.url = '';
}
if (parent.name != 'test') {
test = window.open("http://adincl.gopher.com/adpopup?site=VA&border=1&area=DIR.EDU&sizerepopup=1", "test", "resizable=yes,width=528,height=200,scrollbars");
}
} else if (browser) {
if (!self.url) {
self.url = '';
}
if (parent.name != 'test') {
test = window.open("http://adincl.gopher.com/adpopup?site=VA&shape=banner&border=1&area=DIR.EDU", "test", "resizable=yes,width=528,height=200,scrollbars");
}
}
//-->
</SCRIPT>
<!-- ads end -->