[Main Page]      [Literature]      [Software]      [People]      [Conferences]      [Courses]      [Web-DB]

 

UNIVERSITY OF PITTSBURGH
School of Information Sciences

INFSCI 2710 - Database Management

Stefan Brass

Web-DB Interfaces:   Example in dbCGI

See also: http://www.corvu.com.au/dbcgi/

Source File "db_query" (Standard HTML) 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<TITLE>Course Database (Query Form)</TITLE>
</HEAD>
<BODY>
<H1>Course Database (Query Form)</H1>
<FORM METHOD="post" ACTION="/cgi-bin/ora7dbcgi/course_print">
Please Enter Instructor Name: <INPUT NAME="Instructor" SIZE=20>
<INPUT TYPE=SUBMIT VALUE="Execute Query">
</FORM>
</BODY>
</HTML>

Source File "course_print" (with dbCGI-Commands) 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<TITLE>Course Database (Query Result)</TITLE>
</HEAD>
<BODY>
<H1>Courses of %[=Instructor%]</H1>
<sql init>
	ORACLE_HOME=opt/local/sources/packages/oracle/product/8.0.4
	ORACLE_SID=sis
</sql>
<sql connect conn1>
	USER=scott
	PASS=tiger
</sql>
<UL>
<sql format>
	<LI> %2d (%1d)
</sql>
<sql query conn1>
	SELECT CRN, Title
	FROM   Course
	WHERE  Name = %[=Instructor%]
</sql>
</UL>
<sql disconnect conn1>
</sql>
<sql uninit>
</sql>
</BODY>
</HTML>

Stefan Brass (sbrass@sis.pitt.edu), April 23, 1999

Original URL: http://www2.sis.pitt.edu/~sbrass/db/webdb2.html   [HTML 3.2 Checked]