query2mysql.ini

来自「java xml开发指南（初学者推荐）Java Xml 编程指南书籍源码」· INI 代码 · 共 23 行

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(?,?,?)