qshell.ini

java xml开发指南（初学者推荐）Java Xml 编程指南书籍源码

FileTitle
The Bookstore's ShoppingCart Initialization-Environment File
dbOperation
InitDBHandler
dbDriver
sun.jdbc.odbc.JdbcOdbcDriver
dbName
jdbc:odbc:PHONEBOOK
dbQueries
AVAILABLE,COURSES,REPORTORDERS,ADDITEMS,DELETEITEMS,SETUPADD,SETUPDELETE,CRREGISTRATION,CRCOURSES,CRCOURSEBOOKS,CRCOURSEDATA,CRINVENTORY,CRORDERS
REPORTORDERS
SELECT O.ItemCode,ItemName,ItemPrice \
    FROM ORDERS O,INVENTORY I \
    WHERE O.ItemCode=I.ItemCode \
<myna:SUBST> \
  AND CustomerName='|dbUser|' ORDER BY ItemName \
</myna:SUBST>
ADDITEMS
INSERT INTO ORDERS \
<myna:SUBST>\
    VALUES('|dbUser|',?) \
</myna:SUBST>
DELETEITEMS
DELETE FROM ORDERS \
<myna:SUBST>\
    WHERE CustomerName='|dbUser|' AND ItemCode=? \
</myna:SUBST>
SETUPDELETE
<myna:SUBST>|REPORTORDERS|</myna:SUBST>
SETUPADD
SELECT Reg.SectionID,CBooks.ItemCode,ItemName,ItemPrice \
 FROM  COURSEBOOKS CBooks,INVENTORY Inv,REGISTRATION Reg WHERE \
  CBooks.ItemCode=Inv.ItemCode AND \
  Reg.SectionID=CBooks.SectionID AND \
<myna:SUBST> \
  Reg.StudentName='|dbUser|' \
</myna:SUBST>
AVAILABLE
SELECT Reg.SectionID,CBooks.ItemCode,ItemName,ItemPrice \
 FROM  COURSEBOOKS CBooks,INVENTORY Inv,REGISTRATION Reg WHERE \
  CBooks.ItemCode=Inv.ItemCode AND \
  Reg.SectionID=CBooks.SectionID AND \
<myna:SUBST> \
  Reg.StudentName='|dbUser|' AND \
  CBooks.ItemCode NOT IN \
     (SELECT ItemCode FROM ORDERS WHERE CustomerName='|dbUser|')\
</myna:SUBST>
COURSES
<myna:SUBST>SELECT * FROM REGISTRATION WHERE StudentName='|dbUser|'</myna:SUBST>
CRREGISTRATION
CREATE TABLE REGISTRATION (StudentName TEXT,SectionID TEXT)
CRCOURSES
CREATE TABLE COURSES (SectionID TEXT,CourseName TEXT)
CRCOURSEBOOKS
CREATE TABLE COURSEBOOKS ( SectionID TEXT, ItemCode TEXT)
CRCOURSEDATA
CREATE TABLE COURSEDATA (CourseName TEXT, Prerequisites TEXT, Description TEXT)
CRINVENTORY
CREATE TABLE INVENTORY (ItemCode TEXT, ItemName TEXT, ItemPrice TEXT)
CRORDERS
CREATE TABLE ORDERS (CustomerName TEXT,ItemCode TEXT)