一、建立数据表
--
==================================
-- ==================================
-- TABLE NAME: E_PHOTO
-- AUTHOR:XIAOPENG CHENG
-- CREATE DATE: 2006-11-1
-- DESCRIPTION:SAVE PHTO INFORMATION
-- ==================================
-- ==================================
if exists ( select * from sysobjects where id = object_id ( ' dbo.E_PHOTO ' ))
drop table dbo.E_PHOTO
GO
create table E_PHOTO
(
USER_NAME NVARCHAR ( 40 ) NOT NULL , -- USER NAME
PHOTO_TYPE_ID int NOT NULL , -- PHOTO TYPE
PHOTO_ID NVARCHAR ( 30 ) NOT NULL , -- PHOTO NAME
PHOTO IMAGE NOT NULL , -- PHOTO INFORMATION
PHOTO_DESC NVARCHAR ( 3000 ), -- PHOTO DESCRIPTION INFORMATION
UPLOAD_DATE SMALLDATETIME , -- UPLOAD DATE
CONSTRAINT PHOTO PRIMARY KEY ( USER_NAME ,PHOTO_ID,PHOTO_TYPE_ID) -- PRIMARY KEY
)
GO
-- ==================================
-- ==================================
-- TABLE NAME: E_PHOTO_TYPE
-- AUTHOR:XIAOPENG CHENG
-- CREATE DATE: 2006-11-3
-- DESCRIPTION:SAVE PHTO TYPE INFORMATION
-- ==================================
-- ==================================
if exists ( select * from sysobjects where id = object_id ( ' dbo.E_PHOTO_TYPE ' ))
drop table dbo.E_PHOTO_TYPE
GO
create table E_PHOTO_TYPE
(
USER_NAME NVARCHAR ( 40 ) NOT NULL , -- USER NAME
PHOTO_TYPE_CODE int identity ( 1 , 1 ) NOT NULL , -- PHOTO TYPE CODE
PHOTO_TYPE_NAME NVARCHAR ( 30 ) NOT NULL , -- PHOTO TYPE NAME
IF_USING INT DEFAULT 0 , -- IF USING //USING:0;NOT USING 1;
CONSTRAINT PHOTO_TYPE PRIMARY KEY ( USER_NAME ,PHOTO_TYPE_CODE) -- PRIMARY KEY
)
GO
-- ==================================
-- TABLE NAME: E_PHOTO
-- AUTHOR:XIAOPENG CHENG
-- CREATE DATE: 2006-11-1
-- DESCRIPTION:SAVE PHTO INFORMATION
-- ==================================
-- ==================================
if exists ( select * from sysobjects where id = object_id ( ' dbo.E_PHOTO ' ))
drop table dbo.E_PHOTO
GO
create table E_PHOTO
(
USER_NAME NVARCHAR ( 40 ) NOT NULL , -- USER NAME
PHOTO_TYPE_ID int NOT NULL , -- PHOTO TYPE
PHOTO_ID NVARCHAR ( 30 ) NOT NULL , -- PHOTO NAME
PHOTO IMAGE NOT NULL , -- PHOTO INFORMATION
PHOTO_DESC NVARCHAR ( 3000 ), -- PHOTO DESCRIPTION INFORMATION
UPLOAD_DATE SMALLDATETIME , -- UPLOAD DATE
CONSTRAINT PHOTO PRIMARY KEY ( USER_NAME ,PHOTO_ID,PHOTO_TYPE_ID) -- PRIMARY KEY
)
GO
-- ==================================
-- ==================================
-- TABLE NAME: E_PHOTO_TYPE
-- AUTHOR:XIAOPENG CHENG
-- CREATE DATE: 2006-11-3
-- DESCRIPTION:SAVE PHTO TYPE INFORMATION
-- ==================================
-- ==================================
if exists ( select * from sysobjects where id = object_id ( ' dbo.E_PHOTO_TYPE ' ))
drop table dbo.E_PHOTO_TYPE
GO
create table E_PHOTO_TYPE
(
USER_NAME NVARCHAR ( 40 ) NOT NULL , -- USER NAME
PHOTO_TYPE_CODE int identity ( 1 , 1 ) NOT NULL , -- PHOTO TYPE CODE
PHOTO_TYPE_NAME NVARCHAR ( 30 ) NOT NULL , -- PHOTO TYPE NAME
IF_USING INT DEFAULT 0 , -- IF USING //USING:0;NOT USING 1;
CONSTRAINT PHOTO_TYPE PRIMARY KEY ( USER_NAME ,PHOTO_TYPE_CODE) -- PRIMARY KEY
)
GO
二、建立页面,对图片类型进行分类
由于本人,在上传图片时,对图片进行了分类,因此当用户进行图片浏览的时候,对图片进行了分类,当用户单击“ALL Photo”时,将在另外的一个页面进行显示,以下是进行图片类型分类的HTML页面代码:
<%
...