ＤＢアプリテストのページ　一件・一件検索のソース


<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=x-sjis">
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>

<LINK REL="stylesheet" TYPE="text/css" HREF="_Themes/sumipntg/THEME.CSS" VI6.0THEME="墨絵">
<LINK REL="stylesheet" TYPE="text/css" HREF="_Themes/sumipntg/GRAPH0.CSS" VI6.0THEME="墨絵">
<LINK REL="stylesheet" TYPE="text/css" HREF="_Themes/sumipntg/COLOR0.CSS" VI6.0THEME="墨絵">
<LINK REL="stylesheet" TYPE="text/css" HREF="_Themes/sumipntg/CUSTOM.CSS" VI6.0THEME="墨絵"></HEAD>
<BODY>

<P align=center><FONT color=black
face="">一件、一件データを確認する</FONT></P>

<P align=center>
<TABLE align=center border=1 cellPadding=1 cellSpacing=1 width=75%>

<TR>
<TD>
<DIV align=right>ＩＤ　</DIV></TD>
<TD>
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=18
id=Textbox4 style="HEIGHT: 18px; LEFT: 0px; TOP: 0px; WIDTH: 120px"
width=120>
<PARAM NAME="_ExtentX" VALUE="3175">
<PARAM NAME="_ExtentY" VALUE="476">
<PARAM NAME="id" VALUE="Textbox4">
<PARAM NAME="ControlType" VALUE="0">
<PARAM NAME="Lines" VALUE="3">
<PARAM NAME="DataSource" VALUE="Recordset1">
<PARAM NAME="DataField" VALUE="ID">
<PARAM NAME="Enabled" VALUE="-1">
<PARAM NAME="Visible" VALUE="-1">
<PARAM NAME="MaxChars" VALUE="20">
<PARAM NAME="DisplayWidth" VALUE="20">
<PARAM NAME="Platform" VALUE="1">
<PARAM NAME="LocalPath" VALUE="">

</OBJECT>
-->
<script language="JavaScript" src="_ScriptLibrary/EventMgr.HTM"></script>
<script language="JavaScript" src="_ScriptLibrary/TextBox.HTM"></script>
<SCRIPT LANGUAGE=JavaScript>
function _initTextbox4()
{
Textbox4.setStyle(TXT_TEXTBOX);
Textbox4.setDataSource(Recordset1);
Textbox4.setDataField('ID');
Textbox4.setMaxLength(20);
Textbox4.setColumnCount(20);
}
CreateTextbox('Textbox4', _initTextbox4, null);
</script>

<!--METADATA TYPE="DesignerControl" endspan-->
</TD></TR>
<TR>
<TD>
<DIV align=right>パスワード　</DIV></TD>
<TD>
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0"
id=Textbox1 style="LEFT: 0px; TOP: 0px">
<PARAM NAME="_ExtentX" VALUE="3175">
<PARAM NAME="_ExtentY" VALUE="476">
<PARAM NAME="id" VALUE="Textbox1">
<PARAM NAME="ControlType" VALUE="0">
<PARAM NAME="Lines" VALUE="3">
<PARAM NAME="DataSource" VALUE="Recordset1">
<PARAM NAME="DataField" VALUE="pass">
<PARAM NAME="Enabled" VALUE="-1">
<PARAM NAME="Visible" VALUE="-1">
<PARAM NAME="MaxChars" VALUE="20">
<PARAM NAME="DisplayWidth" VALUE="20">
<PARAM NAME="Platform" VALUE="1">
<PARAM NAME="LocalPath" VALUE="">

</OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript>
function _initTextbox1()
{
Textbox1.setStyle(TXT_TEXTBOX);
Textbox1.setDataSource(Recordset1);
Textbox1.setDataField('pass');
Textbox1.setMaxLength(20);
Textbox1.setColumnCount(20);
}
CreateTextbox('Textbox1', _initTextbox1, null);
</script>

<!--METADATA TYPE="DesignerControl" endspan-->
</TD></TR>
<TR>
<TD>
<DIV align=right>氏名　</DIV></TD>
<TD>
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0"
id=Textbox2 style="LEFT: 0px; TOP: 0px">
<PARAM NAME="_ExtentX" VALUE="3175">
<PARAM NAME="_ExtentY" VALUE="476">
<PARAM NAME="id" VALUE="Textbox2">
<PARAM NAME="ControlType" VALUE="0">
<PARAM NAME="Lines" VALUE="3">
<PARAM NAME="DataSource" VALUE="Recordset1">
<PARAM NAME="DataField" VALUE="氏名">
<PARAM NAME="Enabled" VALUE="-1">
<PARAM NAME="Visible" VALUE="-1">
<PARAM NAME="MaxChars" VALUE="20">
<PARAM NAME="DisplayWidth" VALUE="20">
<PARAM NAME="Platform" VALUE="1">
<PARAM NAME="LocalPath" VALUE="">

</OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript>
function _initTextbox2()
{
Textbox2.setStyle(TXT_TEXTBOX);
Textbox2.setDataSource(Recordset1);
Textbox2.setDataField('氏名');
Textbox2.setMaxLength(20);
Textbox2.setColumnCount(20);
}
CreateTextbox('Textbox2', _initTextbox2, null);
</script>

<!--METADATA TYPE="DesignerControl" endspan-->
</TD></TR>
<TR>
<TD>
<DIV align=right>性別　</DIV></TD>
<TD>
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=18
id=Textbox5 style="HEIGHT: 18px; LEFT: 0px; TOP: 0px; WIDTH: 66px"
width=66>
<PARAM NAME="_ExtentX" VALUE="1746">
<PARAM NAME="_ExtentY" VALUE="476">
<PARAM NAME="id" VALUE="Textbox5">
<PARAM NAME="ControlType" VALUE="0">
<PARAM NAME="Lines" VALUE="3">
<PARAM NAME="DataSource" VALUE="Recordset1">
<PARAM NAME="DataField" VALUE="性別">
<PARAM NAME="Enabled" VALUE="-1">
<PARAM NAME="Visible" VALUE="-1">
<PARAM NAME="MaxChars" VALUE="20">
<PARAM NAME="DisplayWidth" VALUE="11">
<PARAM NAME="Platform" VALUE="1">
<PARAM NAME="LocalPath" VALUE="">

</OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript>
function _initTextbox5()
{
Textbox5.setStyle(TXT_TEXTBOX);
Textbox5.setDataSource(Recordset1);
Textbox5.setDataField('性別');
Textbox5.setMaxLength(20);
Textbox5.setColumnCount(11);
}
CreateTextbox('Textbox5', _initTextbox5, null);
</script>

<!--METADATA TYPE="DesignerControl" endspan-->
<FONT face=""
size=2>True=男　False=女</FONT>
</TD></TR>
<TR>
<TD>
<DIV align=right>職業　</DIV></TD>
<TD>
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0"
id=Textbox3 style="LEFT: 0px; TOP: 0px">
<PARAM NAME="_ExtentX" VALUE="3175">
<PARAM NAME="_ExtentY" VALUE="476">
<PARAM NAME="id" VALUE="Textbox3">
<PARAM NAME="ControlType" VALUE="0">
<PARAM NAME="Lines" VALUE="3">
<PARAM NAME="DataSource" VALUE="Recordset1">
<PARAM NAME="DataField" VALUE="職業">
<PARAM NAME="Enabled" VALUE="-1">
<PARAM NAME="Visible" VALUE="-1">
<PARAM NAME="MaxChars" VALUE="20">
<PARAM NAME="DisplayWidth" VALUE="20">
<PARAM NAME="Platform" VALUE="1">
<PARAM NAME="LocalPath" VALUE="">


</OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript>
function _initTextbox3()
{
Textbox3.setStyle(TXT_TEXTBOX);
Textbox3.setDataSource(Recordset1);
Textbox3.setDataField('職業');
Textbox3.setMaxLength(20);
Textbox3.setColumnCount(20);
}
CreateTextbox('Textbox3', _initTextbox3, null);
</script>

<!--METADATA TYPE="DesignerControl" endspan-->
</TD></TR></TABLE></P>

<P align=center>
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:58F3D268-FEDF-11D0-9C7F-0060081840F3" height=27
id=RecordsetNavbar1 style="HEIGHT: 27px; LEFT: 0px; TOP: 0px; WIDTH: 214px"
width=214>
<PARAM NAME="_ExtentX" VALUE="4075">
<PARAM NAME="_ExtentY" VALUE="714">
<PARAM NAME="id" VALUE="RecordsetNavbar1">
<PARAM NAME="Platform" VALUE="1">
<PARAM NAME="DataSource" VALUE="Recordset1">
<PARAM NAME="UpdateOnMove" VALUE="0">
<PARAM NAME="FirstCaption" VALUE=" |< ">
<PARAM NAME="MoveFirst" VALUE="-1">
<PARAM NAME="FirstImage" VALUE="0">
<PARAM NAME="PrevCaption" VALUE=" < ">
<PARAM NAME="MovePrev" VALUE="-1">
<PARAM NAME="PrevImage" VALUE="0">
<PARAM NAME="NextCaption" VALUE=" > ">
<PARAM NAME="MoveNext" VALUE="-1">
<PARAM NAME="NextImage" VALUE="0">
<PARAM NAME="LastCaption" VALUE=" >| ">
<PARAM NAME="MoveLast" VALUE="-1">
<PARAM NAME="LastImage" VALUE="0">
<PARAM NAME="Alignment" VALUE="1">
<PARAM NAME="LocalPath" VALUE="">

</OBJECT>
-->
<script language="JavaScript" src="_ScriptLibrary/Button.HTM"></script>
<script language="JavaScript" src="_ScriptLibrary/RSNavBar.HTM"></script>
<SCRIPT LANGUAGE=JavaScript>
function _initRecordsetNavbar1()
{
RecordsetNavbar1.setAlignment(1);
RecordsetNavbar1.setButtonStyles(170);
RecordsetNavbar1.updateOnMove = false;
RecordsetNavbar1.setDataSource(Recordset1);
RecordsetNavbar1.getButton(0).value = ' |< ';
RecordsetNavbar1.getButton(1).value = ' < ';
RecordsetNavbar1.getButton(2).value = ' > ';
RecordsetNavbar1.getButton(3).value = ' >| ';
}
CreateRecordsetNavbar('RecordsetNavbar1', _initRecordsetNavbar1, null);
</script>

<!--METADATA TYPE="DesignerControl" endspan-->
<BR><BR><A
href="http://sim2/test3/db index.htm"><FONT color=blue face=""
size=2>DBアプリテストのページに戻る</FONT></A></P>

</BODY>
</HTML>
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:9CF5D7C2-EC10-11D0-9862-0000F8027CA0" id=Recordset1 style="LEFT: 0px; TOP: 0px">
<PARAM NAME="ExtentX" VALUE="15874">
<PARAM NAME="ExtentY" VALUE="2090">
<PARAM NAME="State" VALUE="(TCConn=\qConnection1\q,TCDBObject=\qTables\q,TCDBObjectName=\quser1\q,TCControlID_Unmatched=\qRecordset1\q,TCPPConn=\qConnection1\q,RCDBObject=\qRCDBObject\q,TCPPDBObject=\qTables\q,TCPPDBObjectName=\quser1\q,TCCursorType=\q3\s-\sStatic\q,TCCursorLocation=\q3\s-\sUse\sclient-side\scursors\q,TCLockType=\q3\s-\sOptimistic\q,TCCacheSize_Unmatched=\q10\q,TCCommTimeout_Unmatched=\q10\q,CCPrepared=0,CCAllRecords=1,TCNRecords_Unmatched=\q10\q,TCODBCSyntax_Unmatched=\q\q,TCHTargetPlatform=\q\q,TCHTargetBrowser_Unmatched=\qClient\s(IE\s4.0\sDHTML)\q,TCTargetPlatform=\qInherit\sfrom\spage\q,RCCache=\qRCBookPage\q,CCOpen=1,GCParameters=(Rows=0))"></OBJECT>
-->
<SCRIPT LANGUAGE="JavaScript" src="_ScriptLibrary/Recordset.HTM"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript">
function _initRecordset1()
{
Recordset1.setRecordSource('DBQ=A:\\test3\\data\\test3_db.mdb;DefaultDir=A:\\test3\\data;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;;User Id=admin;PASSWORD=', 'Select * from `user1`');
Recordset1.open();

}
CreateRecordset('Recordset1', _initRecordset1, null);
</SCRIPT>

<!--METADATA TYPE="DesignerControl" endspan-->


Ｍｏｎｊｙｏ　ホームページにもどる 　　ＡＳＰでつくるインターネットＷｅｂ本屋さんのページにもどる