基于Java的宠物销售管理系统的设计与实现毕业设计程序

USE [master] GO CREATE DATABASE [jspmbyslympglxthsg8713AE96] GO USE [jspmbyslympglxthsg8713AE96] 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('系统简介','系统简介') 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], [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/1333961148718.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/1333963398718.gif','温州飞翔路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/1333963445546.gif','杭州四季青广场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/1333963661093.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 insert into xinwentongzhi(biaoti,leibie,neirong,tianjiaren,shouyetupian,dianjilv) values('安理会一致通过叙决议 美国鹰派认为于事无补','站内新闻','<P style="TEXT-INDENT: 30px; MARGIN: 0px 3px 15px">【环球时报综合报道】“一致!联合国安理会表决通过叙利亚决议!”德国《图片报》28日以此为题写道，事情发生非常快：短短3分钟，安理会就一致通过叙利亚决议。而此前，联合国安理会各成员国已经争议了两年多。现在，联合国重新变得强大，各国代表互相拍肩膀表示祝贺。</P> <P style="TEXT-INDENT: 30px; MARGIN: 0px 3px 15px">在表决中，15个安理会成员国一致支持决议内容，俄罗斯、中国等安理会五大常任理事国都投了赞成票。该决议打破了联合国在叙利亚问题上长达两年半的僵局。英国广播公司称，此前5个具有否决权的联合国代表的谈判陷入僵局，两个阵营的观点相差甚远，而且双方都不愿意做出真正的让步。俄罗斯和中国过去两年中3次动用否决权。美国国务卿克里称，“安理会的决议表明，如果我们为了共同利益撇开政治争论，我们仍有能力做成‘大事’”。</P> <P style="TEXT-INDENT: 30px; MARGIN: 0px 3px 15px">对于协议的达成，国际社会普遍表示欢迎。联合国秘书长潘基文在投票结束后说：“今天这一历史性的决议是长期以来关于叙利亚的第一个令人充满希望的消息。”他敦促叙政府“忠实且毫不迟疑地”执行这项决议，并宣布将于11月中旬在日内瓦举行新一轮的叙利亚问题和平会谈。美国总统奥巴马表示，安理会通过叙利亚化武决议案是重大成果和国�