Course Web Pages - Spring 2012 - LIBR 242-01/10 Greensheet - Sample Codes
LIBR 242
Database Management
Sample Codes
Dr. Geoffrey Z. Liu
E-mail
Course Links Greensheet Course Calendar Group Project Individual Assignment |
Resources D2L D2L Tutorial SLIS e-Bookstore |
LIBR 242 Resources Online Resources Bibliography Sample Codes |
SQL Codes
- Creating/deleting tables in a database
- Entering/deleting records into a table
- Querying a database (tables in fact) with SELECT
- Creating and using a VIEW for record manipulation
- Simple Demo of SQL+ scripting
XML Basics
xSQL Servlet
Web Database Access through xSQL
- Querying database with xml-embedded xSQL (.xsql file)
- Sample FORM codes (.html file)
- Sample xSQL action handler (.xsql file)
- Sample stylesheet (.xsl file) for transformation (canonical -> HTML)
- Sample stylesheet (.xsl file) for transformation (canonical -> XML)
- Inserting data/records gathered from HTML form (.xsql file)
- Sample FORM codes (.html file)
- Sample xSQL action handler (.xsql file)
- Sample stylesheet (.xsl file) for transformation
- Sample stylesheet (.xsl file) for feedback
- Updating a record in a table with new field value(s)
- Sample FORM codes (.html file)
- Sample xSQL action handler (.xsql file)
- Sample stylesheet (.xsl file) for transformation
- Sample stylesheet (.xsl file) for feedback
- Deleting rows/records from table (.xsql file)