Struts1.2+Tomcat5.5网上购物系统

自己学习Struts时练习做的一个网上购物系统，用JNDI配置了Oracle数据库，基本上实现了增加，修改,查询的基本功能。 环境：Struts1.2.8+Oracle10.2+Tomcat5.5 {建表用的SQL文 Create Table　USER_INFO( userID Varchar2(50) Constraint PK Primary Key, userName Varchar2(50) , passWord Varchar2(50), address Varchar2(50) ); Insert into USER_INFO(userID,userName,passWord,address) Values('307002','guowei','ibms','xian'); Create Table PRODUCT_INFO( productID Varchar2(50) Primary Key, productName Varchar2(50), price varchar2(50) ); Insert into PRODUCT_INFO(productID,productName,price) Values('000001','book','30'); Create Table BOUGHT_PRODUCT( userID Varchar2(50), productID Varchar2(50), quantity Number, Constraint FK_userID Foreign Key(userID) References USER_INFO(userID), Constraint FK_productID Foreign Key(productID) References PRODUCT_INFO(productID) ); Insert into BOUGHT_PRODUCT(userID,productID,quantity) Values('307002','000001',100); }