-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2010 年 02 月 06 日 08:20
-- 服务器版本: 5.0.51
-- PHP 版本: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- 数据库: `sh_shopping`
--
-- --------------------------------------------------------
--
-- 表的结构 `member`
--
CREATE TABLE IF NOT EXISTS `member` (
`id` int(11) NOT NULL,
`username` varchar(255) default NULL,
`password` varchar(255) default NULL,
`realname` varchar(255) character set utf8 collate utf8_bin default NULL,
`tel` varchar(255) default NULL,
`address` varchar(255) character set utf8 collate utf8_bin default NULL,
`zip` varchar(255) default NULL,
`email` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- 导出表中的数据 `member`
--
INSERT INTO `member` (`id`, `username`, `password`, `realname`, `tel`, `address`, `zip`, `email`) VALUES
(2, 'wangjianlin', '198517', '汪建林', '13558690869', '四川达州', '635217', 'wangjianlin1985@126.com');
-- --------------------------------------------------------
--
-- 表的结构 `orders`
--
CREATE TABLE IF NOT EXISTS `orders` (
`id` int(11) NOT NULL,
`orderno` varchar(255) default NULL,
`userid` int(11) default NULL,
`realname` varchar(255) character set utf8 collate utf8_bin default NULL,
`address` varchar(255) character set utf8 collate utf8_bin default NULL,
`zip` varchar(255) default NULL,
`tel` varchar(255) default NULL,
`payment` varchar(255) character set utf8 collate utf8_bin default NULL,
`email` varchar(255) default NULL,
`memo` varchar(255) character set utf8 collate utf8_bin default NULL,
`price` double default NULL,
`time` varchar(255) default NULL,
`tag` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- 导出表中的数据 `orders`
--
INSERT INTO `orders` (`id`, `orderno`, `userid`, `realname`, `address`, `zip`, `tel`, `payment`, `email`, `memo`, `price`, `time`, `tag`) VALUES
(1, 'wangjianlin0206021952', 2, '汪建林', '四川达州', '635217', '13558690869', '货到付款', 'wangjianlin1985@126.com', '备注', 3600, '2010-02-06 02:19', 0),
(2, 'wangjianlin0206032328', 2, '汪建林', '四川达州', '635217', '13558690869', '邮政汇款', 'wangjianlin1985@126.com', 'en', 3600, '2010-02-06 03:23', 0);
-- --------------------------------------------------------
--
-- 表的结构 `product`
--
CREATE TABLE IF NOT EXISTS `product` (
`id` int(11) NOT NULL,
`sortid` int(11) default NULL,
`name` varchar(255) character set utf8 collate utf8_bin default NULL,
`price` double default NULL,
`saleprice` double default NULL,
`descript` varchar(255) character set utf8 collate utf8_bin default NULL,
`contents` varchar(255) character set utf8 collate utf8_bin default NULL,
`saledate` varchar(255) default NULL,
`salecount` int(11) default NULL,
`image` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- 导出表中的数据 `product`
--
INSERT INTO `product` (`id`, `sortid`, `name`, `price`, `saleprice`, `descript`, `contents`, `saledate`, `salecount`, `image`) VALUES
(1, 1, '炫彩 DDR', 105, 100, 'kingmax 炫彩 DDR', 'kingmax 炫彩 DDR', '2009-2-5', 5, 'pic/sp.jpg'),
(2, 2, '诺顿2009防火墙', 3600, 3500, '诺顿2008防火墙', '诺顿2008防火墙', '2010-2-3', 5, 'pic/115X150.gif');
-- --------------------------------------------------------
--
-- 表的结构 `shopcart`
--
CREATE TABLE IF NOT EXISTS `shopcart` (
`id` int(11) NOT NULL,
`orderid` int(11) default NULL,
`productid` int(11) default NULL,
`count` int(11) default NULL,
`price` double default NULL,
PRIMARY KEY (`id`),
KEY `FKEB71EB1678885056` (`productid`),
KEY `FKEB71EB163D3C0DAF` (`productid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- 导出表中的数据 `shopcart`
--
INSERT INTO `shopcart` (`id`, `orderid`, `productid`, `count`, `price`) VALUES
(1, 1, 2, 1, 3500),
(2, 1, 1, 2, 100),
(3, 2, 1, 1, 100),
(4, 2, 2, 1, 3500);
-- --------------------------------------------------------
--
-- 表的结构 `sort`
--
CREATE TABLE IF NOT EXISTS `sort` (
`id` int(11) NOT NULL,
`name` varchar(255) character set utf8 collate utf8_bin default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- 导出表中的数据 `sort`
--
INSERT INTO `sort` (`id`, `name`) VALUES
(1, '硬件外设'),
(2, '软件速递');
JAVA struts+hibernate实现的网络购物系统.rar （122个子文件） 
DAOperate.class 5KB CreateOrderAction.class 5KB BuyAction.class 3KB SearchAction.class 3KB Order.class 3KB DelOrderAction.class 3KB ModifyUserInfoAction.class 3KB RegistAction.class 3KB LoginAction.class 3KB UpdateShopCartAction.class 2KB OrderListAction.class 2KB Product.class 2KB Member.class 2KB DetailAction.class 2KB HibernateUtil.class 2KB FirstAction.class 2KB ClearShopCartAction.class 2KB ShopCart.class 1KB ExitAction.class 1KB Constants.class 1KB MyRequestProcessor.class 998B Sort.class 726B .classpath 2KB css.css 585B .cvsignore 7B Thumbs.db 8KB
115X150.gif 13KB main.gif 1KB ttt.gif 1KB reg.gif 572B lookbcar.gif 554B relbcar.gif 489B gobuy.gif 479B login.gif 429B 1right.gif 386B ok.gif 309B serarch.gif 281B seperator.gif 221B fu.gif 191B more.gif 174B order.gif 129B promo_list_top.gif 124B main_head_menu002.gif 112B main_head_menu001.gif 111B main_head_menu005.gif 111B main_head_menu004.gif 109B dot.gif 83B gwzn1.gif 59B new4.gif 59B DAOperate.java 6KB CreateOrderAction.java 4KB SearchAction.java 3KB BuyAction.java 2KB ModifyUserInfoAction.java 2KB LoginAction.java 2KB RegistAction.java 2KB Order.java 2KB UpdateShopCartAction.java 2KB DelOrderAction.java 2KB Product.java 2KB OrderListAction.java 1KB HibernateUtil.java 1KB FirstAction.java 1KB Member.java 1KB DetailAction.java 1KB Constants.java 1022B ClearShopCartAction.java 997B ExitAction.java 786B ShopCart.java 758B MyRequestProcessor.java 582B Sort.java 302B
运行界面.jpg 70KB IBMT43HH6.jpg 6KB SONYA21C.jpg 6KB sp.jpg 6KB IBMT43BB4.jpg 6KB IBMT43CH8.jpg 6KB HPNC4200.jpg 6KB left.jsp 8KB cashOk.jsp 8KB listMain.jsp 7KB detail.jsp 6KB main.jsp 6KB modifyUser.jsp 5KB orderOk.jsp 5KB registMain.jsp 4KB basket.jsp 4KB cash.jsp 4KB loginOkLeft.jsp 3KB basketOk.jsp 3KB orderDisplay.jsp 2KB payMethod.jsp 2KB wrong.jsp 1KB bottom.jsp 1KB right.jsp 1KB top.jsp 1KB index.jsp 885B default.jsp 392B error.jsp 320B MANIFEST.MF 39B共 122 条
- 1
- 2
资源评论
