query2mysql.ini

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

FileTitle
Query2 Java Servlet Initialization-Environment File
dbDriver
org.gjt.mm.mysql.Driver
dbName
jdbc:mysql://localhost/PHONEBOOK/
dbUser

dbPwd

dbQueries
LOOKUP,RLOOKUP,DELETE,CHANGEVALUE,ADD
LOOKUP
SELECT TheNumber,TheAddr FROM PHONEBOOK WHERE TheName=?
RLOOKUP
SELECT TheName FROM PHONEBOOK WHERE TheNumber=?
DELETE
DELETE FROM PHONEBOOK WHERE TheName=?
CHANGEVALUE
UPDATE PHONEBOOK SET TheNumber=? WHERE TheName=?
ADD
INSERT INTO PHONEBOOK VALUES(?,?,?)