实现基本的购物车功能。

eclipse+sqlserver2005

1.主要强调了购物车的业务逻辑。

2，利用javabean封装。比较适合jsp初学者。

3.简洁实用。可以在此基础上开发更加复杂功能的购物网站。



数据库建立

create database shop_db

go

use shop_db

go

create table t_sp

(

　　s_id int identity(1,1) primary key,

　　s_name varchar(20) not null,

　　s_price money not null

)

go

insert into t_sp values( IBM笔记本电脑 , 19999 )

insert into t_sp values( Hp商务笔记本电脑 , 8666 )

insert into t_sp values( 精通JSP技术 , 236 )

insert into t_sp values( ASP.NET高级应用 , 156 )

insert into t_sp values( J2EE高级开发 , 126 )

insert into t_sp values( 华硕笔记本电脑 , 6789 )

go

select * from t_sp

go-The realization of the basic shopping cart functionality. eclipse+ sqlserver20051. the main emphasis on the shopping cart business logic. 2, the use of JavaBean package. Jsp are more suitable for beginners. 3. Concise and practical. On this basis can the development of more complex functional shopping site. Database create database shop_dbgouse shop_dbgocreate table t_sp (s_id int identity (1,1) primary key, s_name varchar (20) not null, s_price money not null) goinsert into t_sp values (IBM notebook computer, 19999) insert into t_sp values (Hp Business Notebook, 8666) insert into t_sp values (proficient in JSP technology, 236) insert into t_sp values (ASP.NET advanced applications, 156) insert into t_sp values (J2EE Senior Developer, 126) insert into t_sp values (ASUS notebook computers, 6789) goselect* from t_spgo