java校园摄影爱好者交流网站毕业设计程序

USE [master] GO CREATE DATABASE [jspmxysyahzjlwzhsg7581X1B6] GO USE [jspmxysyahzjlwzhsg7581X1B6] GO CREATE TABLE [dbo].[allusers] ( [ID] [int] IDENTITY (1, 1) NOT NULL ,[username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[pwd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[cx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL DEFAULT ('普通管理员') ,[addtime] [datetime] DEFAULT (getdate()) ) ON [PRIMARY] GO insert into allusers(username,pwd,cx) values('hsg','hsg','超级管理员') CREATE TABLE [dbo].[dx] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [leibie] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [content] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO insert into dx(leibie,content) values('系统公告','<P>&nbsp;&nbsp;&nbsp; 欢迎大家登陆我站，我站主要是为广大朋友精心制作的一个系统，希望大家能够在我站获得一个好心情，谢谢！</P><P>&nbsp;&nbsp;&nbsp; 自强不息，海纳百川，努力学习！</P>') insert into dx(leibie,content) values('系统简介','<p>以人为本：公司的软、硬环境的设计和管理都应满足人性化的要求，让人性化的关怀触手可及。</p><p>公司精神:团队精神 创新精神 挑战精神 奉献精神</p><p>企业宗旨：诚信为本，稳健经营</p><p>企业价值观：与客户同忧乐</p>') insert into dx(leibie,content) values('关于我们','&nbsp; &nbsp; 本公司坚持走:以质量求生存,以科技求发展,重合同守信用的道路,生产经营得到迅速发展。我们将以优质的产品和最完善的售后服务来真诚与各界朋友开展广泛的合作,共同创造一个美好的未来!<br /> <br /> 公司行为准则:忠信仁义，以人为本。 <br /> 忠：即忠诚， 包括三重含义：企业忠于国家、忠于民族；企业忠于客户；员工忠于企业。 <br /> 信：即诚信，做企业要立足根本道德、信义，要诚实、讲信用。 <br /> 仁：即仁爱，上司对下属要仁爱、体贴，同事之间要关怀、友爱。 <br /> 义：即大义，公司在与合作伙伴、客户的交往过程中，不做损人利己的事，维护自己利益的前提是不损害他人利益；对民族、社会要共襄义举，要识大义，明是非。 <br />') insert into dx(leibie,content) values('联系方式','联系人：xxxxxxxx<br /> 电话：0000-0000000<br /> 手机：010000000000<br /> 传真：0000-0000000<br /> 邮件：xxxxxxxx@163.com<br /> 地址：您公司的地址<br /> 网址：http://www.xxxx.com<br />') CREATE TABLE [dbo].[youqinglianjie] ( [ID] [int] IDENTITY (1, 1) NOT NULL ,[wangzhanmingcheng] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,[wangzhi] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,[logo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[addtime] [datetime] DEFAULT (getdate()) ) ON [PRIMARY] GO insert into youqinglianjie(wangzhanmingcheng,wangzhi,logo) values('百度','http://www.baidu.com','upload/baidu.jpg') insert into youqinglianjie(wangzhanmingcheng,wangzhi,logo) values('谷歌','http://www.google.cn','upload/google.jpg') insert into youqinglianjie(wangzhanmingcheng,wangzhi,logo) values('新浪','http://www.sina.com','upload/sina.jpg') insert into youqinglianjie(wangzhanmingcheng,wangzhi,logo) values('雅虎','http://www.yahoo.cn','upload/yahoo.jpg') insert into youqinglianjie(wangzhanmingcheng,wangzhi,logo) values('腾讯','http://www.qq.com','upload/qq.jpg') CREATE TABLE [dbo].[xinwentongzhi] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [biaoti] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL , [leibie] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [neirong] [text] COLLATE Chinese_PRC_CI_AS NULL , [tianjiaren] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL DEFAULT ('hsg'), [shouyetupian] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [dianjilv] [int], [zhaiyao] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [addtime] [datetime] DEFAULT (getdate()) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO insert into xinwentongzhi(biaoti,leibie,neirong,tianjiaren,shouyetupian,dianjilv) values('变幻图1','变幻图','无','hsg','upload/1.jpg','1') insert into xinwentongzhi(biaoti,leibie,neirong,tianjiaren,shouyetupian,dianjilv) values('变幻图2','变幻图','无','hsg','upload/2.jpg','1') insert into xinwentongzhi(biaoti,leibie,neirong,tianjiaren,shouyetupian,dianjilv) values('变幻图3','变幻图','无','hsg','upload/3.jpg','1') insert into xinwentongzhi(biaoti,leibie,neirong,tianjiaren,shouyetupian,dianjilv) values('变幻图4','变幻图','无','hsg','upload/4.jpg','1') insert into xinwentongzhi(biaoti,leibie,neirong,tianjiaren,shouyetupian,dianjilv) values('变幻图5','变幻图','无','hsg','upload/5.jpg','1') CREATE TABLE [dbo].[yonghuzhuce] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [yonghuming] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [mima] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [xingming] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [xingbie] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL , [chushengnianyue] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [QQ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [youxiang] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [dianhua] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [shenfenzheng] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [touxiang] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [dizhi] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL , [beizhu] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [addtime] [datetime] DEFAULT (getdate()) , [issh] [varchar] (2) default ('否') , ) ON [PRIMARY] GO insert into yonghuzhuce(yonghuming,mima,xingming,xingbie,chushengnianyue,QQ,youxiang,dianhua,shenfenzheng,touxiang,dizhi,beizhu,issh) values('555','555','何升高','男','2012-07-08','429489354','gsgs@163.com','13186835580','52353253262','upload/yhtx1.jpg','龙港龙翔路1170号','mfgmfgmfg','是') insert into yonghuzhuce(yonghuming,mima,xingming,xingbie,chushengnianyue,QQ,youxiang,dianhua,shenfenzheng,touxiang,dizhi,beizhu,issh) values('leejie','leejie','李龙','男','2012-05-21','851781333','fege@126.com','63474337','623632153','upload/yhtx2.jpg','温州飞翔路2号','htrjrtjr','是') insert into yonghuzhuce(yonghuming,mima,xingming,xingbie,chushengnianyue,QQ,youxiang,dianhua,shenfenzheng,touxiang,dizhi,beizhu,issh) values('mygod','mygod','陈德才','男','2012-02-02','870538338','gshf@yahoo.com','9696556','33253636','upload/yhtx3.jpg','杭州四季青广场3号','hdhffd','是') insert into yonghuzhuce(yonghuming,mima,xingming,xingbie,chushengnianyue,QQ,youxiang,dianhua,shenfenzheng,touxiang,dizhi,beizhu,issh) values('xwxxmx','xwxxmx','吴江','女','2012-03-14','609577616','jrjtr@163.com','34437754','215323262','upload/yhtx4.jpg','上海浦东区22号','gfdhth','是') CREATE TABLE [dbo].[liuyanban] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [cheng] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [xingbie] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL , [QQ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [youxiang] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [dianhua] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [neirong] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [addtime] [datetime] DEFAULT (getdate()) , [huifuneirong] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[pinglun] ( [ID] [int] IDENTITY (1, 1) NOT NULL ,[xinwenID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[pinglunneirong] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,[pinglunren] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[pingfen] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[biao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[addtime] [datetime] DEFAULT (getdate()) ) ON [PRIMARY] GO CREATE TABLE [dbo].[shoucangjilu]( [ID] [int] IDENTITY(1,1) NOT NULL, [username] [varchar](50) NULL, [xwid] [varchar](50) NULL, [ziduan] [varchar](50) NULL, [biao] [varchar](50) NULL, [addtime] [datetime] DEFAULT (getdate()) ) ON [PRIMARY] GO insert into xinwentongzhi(biaoti,leibie,neirong,tianjiaren,shouyetupian,dianjilv) values('关于钱库广播电视站评选先进单位、先进个人和优秀中层干部的通知','摄影资讯','<DIV align=center>&nbsp;</DIV> <DIV align=center>&nbsp;</DIV> <DIV align=center>&nbsp;</DIV> <DIV align=center>&nbsp;</DIV> <DIV align=center>苍钱广电<B>〔2009〕1</B>号</DIV> <DIV>&nbsp;</DIV