Icontem

File: demo/demo.html

Recommend this page to a friend!
  Classes of Alexey Znaev  >  XBSDB  >  demo/demo.html  >  Download  
File: demo/demo.html
Role: Example script
Content type: text/plain
Description: Demo page
Class: XBSDB
Manipulate arrays with an SQL-like language
Author: By
Last change: changed access
Date: 8 years ago
Size: 5,793 bytes
 

Contents

Class file image Download
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!--
///////////////////////////////////////////////////////////////////////////
//
//    XBSDB - Cross-Browser JavaScript Database library
//    Copyright (C) 2010 Alexey A.Znayev
//
//    This file is part of XBSDB demo.
//
//    Alexey A.Znayev, znaeff@mail.ru
//
///////////////////////////////////////////////////////////////////////////
-->
<HTML>
<HEAD>
<TITLE>XBSDB JavaScript Database library demo page</TITLE>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<SCRIPT type="text/javascript" language="JavaScript1.5" src="../lib-js/xbseparser.js"></SCRIPT>
<SCRIPT type="text/javascript" language="JavaScript1.5" src="../lib-js/xbskey.js"></SCRIPT>
<SCRIPT type="text/javascript" language="JavaScript1.5" src="../lib-js/xbstable.js"></SCRIPT>
<SCRIPT type="text/javascript" language="JavaScript1.5" src="../lib-js/xbsdb.js"></SCRIPT>
<SCRIPT type="text/javascript" language="JavaScript1.5" src="../lib-js/xbsdb_en.js"></SCRIPT>
<SCRIPT type="text/javascript" language="JavaScript1.5" src="demo.js"></SCRIPT>
<SCRIPT type="text/javascript" language="JavaScript1.5" src="table1.js"></SCRIPT>
<SCRIPT type="text/javascript" language="JavaScript1.5" src="table2.js"></SCRIPT>
<SCRIPT type="text/javascript" language="JavaScript1.5" src="table3.js"></SCRIPT>
<LINK type="text/css" rel="StyleSheet" href="demo.css">
</HEAD>
<BODY onload="InitDemoPage('en');">

<CENTER>
<TABLE width="100%">
<TR>
<TD width="50%" class="h" style="text-align:left;">
<B>XBSDB JavaScript Database library demo page</B>
</TD>
<TD width="10%" class="h" style="text-align:right;">
Last result 
</TD>
<TD width="40%" class="h">
<TABLE width="100%" class="r">
<TR>
<TD class="r" id="result_text" width="70%">
</TD>
<TD class="r" id="result_time" width="30%">
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</CENTER>

<BR>

<TABLE width="100%">
<TR>
<TD id="tables_number" width="10%">
Tables in database <B>0</B>
</TD>
<TD width="80%" style="text-align:center;">
<INPUT id="load_table1" type="button" value="Load table1" onClick="ButtonTableLoadClick('table1');">
<INPUT id="drop_table1" type="button" value="Drop table1" onClick="ButtonTableDropClick('table1');" disabled>
<INPUT id="dump_table1" type="button" value="Dump table1" onClick="ButtonTableDumpClick('table1');" disabled>
<BR>
<INPUT id="load_table2" type="button" value="Load table2" onClick="ButtonTableLoadClick('table2');">
<INPUT id="drop_table2" type="button" value="Drop table2" onClick="ButtonTableDropClick('table2');" disabled>
<INPUT id="dump_table2" type="button" value="Dump table2" onClick="ButtonTableDumpClick('table2');" disabled>
<BR>
<INPUT id="load_table3" type="button" value="Load table3" onClick="ButtonTableLoadClick('table3');">
<INPUT id="drop_table3" type="button" value="Drop table3" onClick="ButtonTableDropClick('table3');" disabled>
<INPUT id="dump_table3" type="button" value="Dump table3" onClick="ButtonTableDumpClick('table3');" disabled>
</TD>
<TD width="10%">
</TD>
</TR>
</TABLE>

<BR>

Current table
<SELECT id="table_select" onchange="MakeTableChanged(this.value);" disabled style="width:200px;">
<OPTION>no tables available
</SELECT>
<SPAN id="table_descr"></SPAN>

<BR>
<BR>

<TABLE width="100%" class="r">
<TR>
<TD width="50%" class="r" style="text-align:center; vertical-align:top;">
<TABLE width="100%">
<TR>
<TD>
Structure
</TD>
</TR>
<TR>
<TD id="structure_table_place">
</TD>
</TR>
</TABLE>
</TD>
<TD width="50%" class="r" style="text-align:center; vertical-align:top;">
<TABLE>
<TR>
<TD id="indexes_number">
Indexes
</TD>
</TR>
<TR>
<TD id="indexes_table_place">
</TD>
</TR>
<TR>
<TD>
<INPUT type="text" id="index_add" size="70" value="" disabled>
<INPUT type="button" id="button_index_add" value="Add" onclick="ButtonAddClick();" disabled>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>

<BR>

Query
<SELECT id="action_select" onchange="MakeTableActionActive(this.selectedIndex);" disabled>
<OPTION>Select
<OPTION>SelectToRecordSet
<OPTION>Update
<OPTION>Insert
<OPTION>Delete
</SELECT>

<BR>
<BR>

<TABLE width="100%" class="r">
<TR>
<TD width="100%" class="r"  style="text-align:center;">

<TABLE width="100%">

<TR>
<TD style="text-align:right;">
Fields
</TD>
<TD>
<INPUT type="text" id="query_fields" value="" disabled style="width:80%;"> by spaces
</TD>
<TD style="text-align:right;">
Values
</TD>
<TD colspan="3">
<INPUT type="text" id="query_values" value="" disabled style="width:80%;"> by spaces
</TD>
</TR>

<TR>
<TD style="text-align:right;">
Where
</TD>
<TD colspan="5">
<INPUT type="text" id="query_where" value="" disabled style="width:90%;"> expression
</TD>
</TR>

<TR>
<TD width="5%" style="text-align:right;">
Order by
</TD>

<TD width="45%">
<INPUT type="text" id="query_order_by" value="" disabled style="width:50%;"> expression
<INPUT type="checkbox" id="query_order_by_desc" disabled> <LABEL for="query_order_by_desc">descent</LABEL>
</TD>

<TD width="5%" style="text-align:right;">
Group by
</TD>

<TD width="20%">
<INPUT type="text" id="query_group_by" value="" disabled style="width:50%;"> expression
</TD>

<TD width="5%" style="text-align:right;">
Limit
</TD>

<TD width="20%">
<INPUT type="text" id="query_limit" value="" disabled style="width:50%;"> number
</TD>
</TR>
</TABLE>

</TD>
</TR>
</TABLE>

<BR>

<CENTER>
<INPUT type="button" id="button_go" value="Make query" onClick="ButtonGoClick();" disabled>
</CENTER>

<HR>

Result

<CENTER>
<P id="result_info_place">
</P>

<P id="pager_info_place">
</P>
</CENTER>

<HR>

</BODY>
</HTML>