數據庫sql servel 2012版本，以下是腳本：

USE [master] GO /****** Object: Database [newsDB] Script Date: 2016/11/24 19:48:46 ******/ CREATE DATABASE [newsDB]CONTAINMENT = NONEON PRIMARY ( NAME = N'newsDB', FILENAME = N'E:\第二期\第六本書使用jsp-servlet開發新聞發布系統\newsDB.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )LOG ON ( NAME = N'newsDB_log', FILENAME = N'E:\第二期\第六本書使用jsp-servlet開發新聞發布系統\newsDB_log.ldf' , SIZE = 2048KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO ALTER DATABASE [newsDB] SET COMPATIBILITY_LEVEL = 110 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [newsDB].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [newsDB] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [newsDB] SET ANSI_NULLS OFF GO ALTER DATABASE [newsDB] SET ANSI_PADDING OFF GO ALTER DATABASE [newsDB] SET ANSI_WARNINGS OFF GO ALTER DATABASE [newsDB] SET ARITHABORT OFF GO ALTER DATABASE [newsDB] SET AUTO_CLOSE OFF GO ALTER DATABASE [newsDB] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [newsDB] SET AUTO_SHRINK OFF GO ALTER DATABASE [newsDB] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [newsDB] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [newsDB] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [newsDB] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [newsDB] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [newsDB] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [newsDB] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [newsDB] SET DISABLE_BROKER GO ALTER DATABASE [newsDB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [newsDB] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [newsDB] SET TRUSTWORTHY OFF GO ALTER DATABASE [newsDB] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [newsDB] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [newsDB] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [newsDB] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [newsDB] SET RECOVERY FULL GO ALTER DATABASE [newsDB] SET MULTI_USER GO ALTER DATABASE [newsDB] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [newsDB] SET DB_CHAINING OFF GO ALTER DATABASE [newsDB] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) GO ALTER DATABASE [newsDB] SET TARGET_RECOVERY_TIME = 0 SECONDS GO EXEC sys.sp_db_vardecimal_storage_format N'newsDB', N'ON' GO USE [newsDB] GO /****** Object: Table [dbo].[categoryTB] Script Date: 2016/11/24 19:48:49 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[categoryTB]([categoryID] [int] IDENTITY(1,1) NOT NULL,[categoryName] [nvarchar](20) NULL, PRIMARY KEY CLUSTERED ([categoryID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]GO /****** Object: Table [dbo].[comment] Script Date: 2016/11/24 19:48:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[comment]([commentID] [int] IDENTITY(1,1) NOT NULL,[cmmUser] [nvarchar](100) NOT NULL,[ip] [nvarchar](200) NULL,[cmmContent] [nvarchar](500) NOT NULL,[newsID] [int] NULL,[cmmDate] [datetime] NULL,CONSTRAINT [PK__comment__CDDE91BD902E47C5] PRIMARY KEY CLUSTERED ([commentID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]GO /****** Object: Table [dbo].[newsTb] Script Date: 2016/11/24 19:48:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[newsTb]([newsID] [int] IDENTITY(1,1) NOT NULL,[categoryID] [int] NOT NULL,[summary] [nvarchar](100) NULL,[title] [nvarchar](500) NULL,[content] [nvarchar](2000) NULL,[picPath] [nvarchar](100) NULL,[author] [nvarchar](20) NULL,[createDate] [datetime] NULL,[modifyDate] [datetime] NULL,CONSTRAINT [PK__newsTb__5218047EBE8FABDB] PRIMARY KEY CLUSTERED ([newsID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]GO /****** Object: Table [dbo].[users] Script Date: 2016/11/24 19:48:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[users]([userID] [int] IDENTITY(1,1) NOT NULL,[userName] [nvarchar](10) NOT NULL,[userPassword] [nvarchar](10) NOT NULL,[uRole] [nvarchar](10) NOT NULL, PRIMARY KEY CLUSTERED ([userID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]GO SET IDENTITY_INSERT [dbo].[categoryTB] ON INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (1, N'國內') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (1003, N'國外') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (1004, N'娛樂') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (1005, N'軍事') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (1006, N'國際') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (2001, N'大陸') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (2002, N'社會') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (2004, N'家庭') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (3001, N'安全') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (3002, N'八卦') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (3003, N'搞笑') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (3004, N'體育') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (3005, N'財經') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (3006, N'科技') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (3007, N'健康') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (3008, N'汽車') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (3009, N'教育') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (3010, N'房產') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (3011, N'家居') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (3012, N'旅游') INSERT [dbo].[categoryTB] ([categoryID], [categoryName]) VALUES (3013, N'文化') SET IDENTITY_INSERT [dbo].[categoryTB] OFF SET IDENTITY_INSERT [dbo].[comment] ON INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (1, N'李白', N'128.3.6.9', N'大花灑離開 復活點上課了河北科技的身份 辦法就打開發大水了蓮富大廈就蓮富大廈法律手段', 1, CAST(0x0000A62000000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (2, N'杜甫', N'127.0.0.1', N'分的范德薩發的肥嘟嘟放', 2007, CAST(0x0000A6C100000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (3, N'杜甫', N'127.0.0.1', N'發電發電發電對方', 1, CAST(0x0000A6C100000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (4, N'歐陽修', N'127.0.0.1', N'重復的數據庫 發動機開始 ', 2, CAST(0x0000A6C100000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (5, N'李白', N'127.0.0.1', N'重復的數據庫 發動機開始 ', 2, CAST(0x0000A6C100000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (6, N'杜甫', N'127.0.0.1', N'會盡快發大水合計罰款的回復的即可 回復你看得見 、V繁多 迸發出的 ', 1, CAST(0x0000A6C100000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (1002, N'歐陽修', N'127.0.0.1', N'dsad saf ds fdsa fds減肥了看電視 是打飛機李斯丹妮 了你的身份了看電視你， 積分魯大師 、非空 ', 1, CAST(0x0000A6C500000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (1003, N'柳宗元', N'127.0.0.1', N'規范放都是負數發電電風扇', 1, CAST(0x0000A6C500000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (1004, N'韓愈', N'127.0.0.1', N'當時當時的 當時', 1, CAST(0x0000A6C500000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (1005, N'孔子', N'127.0.0.1', N'煩人的放放的 發達地方 放的放到發達地方d 發達發達fd 發達fdfd、 ', 1, CAST(0x0000A6C500000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (1006, N'孟子', N'127.0.0.1', N'用戶感覺好GV加攻擊', 1, CAST(0x0000A6C500000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (1007, N'老子', N'127.0.0.1', N'熱熱熱爾 熱熱 熱', 1, CAST(0x0000A6C500000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (1008, N'兒子', N'127.0.0.1', N'大的地板上 表達方式不V繁多是表達式飛機表單V是廣東省分公司打工給對方V回家的房間的方法V的局部地方好地方還不減肥的 空間發的父節點放', 1, CAST(0x0000A6C500000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (1010, N'孫子', N'127.0.0.1', N'的方式放都是放都是發電都是對方對方發電對方防守對方對方防守', 1, CAST(0x0000A6C500000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (1013, N'大兒子', N'128.2.3.0', N'大都是大道薩達的撒打算', 1, CAST(0x0000A6C500000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (1014, N'范德薩發的', N'110.0.0.0', N'范德薩范德薩佛擋殺佛的范德薩發的對方都是', 1, CAST(0x0000A6B300000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (1016, N'爺爺', N'120.0.3.6', N'的寒酸的就卡薩每年大概換手機號果斷就是他', 1, CAST(0x0000A5A700000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (2002, N'ds ', N'127.0.0.1', N'的決賽了你，嗎后來看到還是 和第三課 電視劇阿里i你', 1, CAST(0x0000A6C700000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (2003, N'這家伙很懶什么都是', N'127.0.0.1', N'顛三倒四山東省啊', 1, CAST(0x0000A6C700000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (2004, N'這家伙很懶什么都是', N'127.0.0.1', N'顛三倒四山東省啊', 1, CAST(0x0000A6C700000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (2005, N'點睡', N'127.0.0.1', N'點睡大點睡', 1, CAST(0x0000A6C700000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (2006, N'這家伙很懶什么也沒留下', N'127.0.0.1', N'大點睡地方地方', 1, CAST(0x0000A6C700000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (2007, N'回復的即可', N'127.0.0.1', N'后臺核桃仁', 1, CAST(0x0000A6C800000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (2008, N'提供熱下', N'127.0.0.1', N'放到規定規范', 1, CAST(0x0000A6C800000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (2009, N'提供熱下', N'127.0.0.1', N'放到規定規范', 1, CAST(0x0000A6C800000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (2010, N'這家伙很懶什么也沒留下', N'127.0.0.1', N'點睡商店 ', 2010, CAST(0x0000A6C800000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (2011, N'這家伙很懶什么也沒留下', N'127.0.0.1', N'的薩達大的撒', 2, CAST(0x0000A6C800000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (2012, N'這家伙很懶什么也沒留下', N'127.0.0.1', N'飛灑', 7, CAST(0x0000A6C800000000 AS DateTime)) INSERT [dbo].[comment] ([commentID], [cmmUser], [ip], [cmmContent], [newsID], [cmmDate]) VALUES (2013, N'這家伙很懶什么也沒留下', N'127.0.0.1', N'動次打次', 1, CAST(0x0000A6C800000000 AS DateTime)) SET IDENTITY_INSERT [dbo].[comment] OFF SET IDENTITY_INSERT [dbo].[newsTb] ON INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (1, 1, N'重慶涉黑富豪', N'重慶涉黑富豪', N' 重慶涉黑富地方來撒會考了多少安備計劃的施工費V的風格的省略號V表達式覅偶 可憐的發揮GV吧,吧vfdsm,筆記就領導說會計法看了都急死了領導看見立刻就兩款發動機浪費大家來看解放東路科技管理開發的結果了看法都經歷過開發大路口及關聯方的空間及規范的刻錄機空間(∩_∩)規范公開了發動機跟對方可根據對方可垃圾離開股份的記錄卡國際法的離開家該兩款發動機克勞福德積分可憐的結果了發動機立刻感覺到了國家隊付款了覆蓋家里寬帶費價格兩款發動機來到看及規范的刻錄機兩個空房間路口附近的路口積分大家快來和規范的空間了肯定撒牡丹峰 快樂就好V空間的分布及護膚V免得你說吧山東礦機換膚 空間換地方風格的開獎號購房貸款了空間的發揮發到空間和給女方的空間很明白豪', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (7).jpg', N'李白', CAST(0x0000A50C0113A9A3 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (2, 1, N'民間投資', N'民間投資', N'民間投資問;到能否考慮的機會你顧慮就浪費的看見好看筆記題', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (24).jpg', N'杜甫', CAST(0x0000A50C01148708 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (3, 1, N'投資計劃', N'4萬投資計劃', N'發改委：剛發的廣泛地放到給對方覆蓋商店光碟伺服奮斗改變發大水覆蓋方式發布會覆蓋4萬投資計劃', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (35).jpg', N'歐陽修', CAST(0x0000A50C01148711 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (4, 1, N'河南鄉鎮政績報告', N'河南鄉鎮政績報告', N'河南鄉 換膚規范播放內部分工你發個你發個你的鎮政績報告', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'歐陽修', CAST(0x0000A50C01148711 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (7, 1003, N'9.4大閱兵', N'9.4大閱兵', N' 覆蓋 你發個非公開了就是沒你們認得里面開兩局層開始的回復V表單和好 卡洛斯的發揮你剛才44444', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'王二小', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (1001, 1004, N'的實打實地方是范德薩', N'也太容易', N' 途徑他已經一天', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'王帥帥', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (2001, 1003, N'付電費是打發斯蒂芬', N'一條', N'雨花臺劇嬰童今天又', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'李白', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (2002, 1004, N'打發第三方', N'以后突然', N'用就業推薦一套就一條語句', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'杜甫', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (2003, 1003, N'的方式放到', N'或與他人', N' 涂鴉添加他已經一而分為師傅的說法是大法官天', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'兒子', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (2004, 1004, N'范德薩范德薩', N'的猶太人的', N'有人討厭他然后又', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'付婷婷', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (2005, 1003, N'換膚核桃仁', N'臺一條人員和認同和認同', N'有人替換體育今天又交通工具', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'曹春喜', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (2006, 1004, N'他如何給他人', N'和規范的快樂', N'有人同意讓他與額', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'忘記康', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (2007, 1, N' 更好更符合規范你好', N'-放都是后果就發的是', N'后臺已經和他的音樂劇 今天要幾天', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'張思淼', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (2008, 1, N'和法國恢復到放到和法國和法國', N';gfdlpg換膚了法國和 ', N'和泰國人符合人體后突然的黃金耳朵聽人家', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'滿志鵬', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (2009, 1004, N'好更好放', N';非結構化咯規范吧', N'他育兒法國恢復到的返回給發個', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'張雪鵬', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (2010, 1003, N'回滾個奮斗和規范', N'好規范法規和規范', N'引入嬰童又突然讓他有人討厭', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'羅貫中', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (2011, 1, N' 不放過規范和規范和你姐夫哪個好大哥', N'太熱太熱特惠價格', N'太熱特容易特然', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'王安石', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (2012, 1, N'和規范和法國點發貨方共同的', N'巨人通知你和他', N'提供熱同個人提供人', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'曾工', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (2013, 1, N'案件的撒河南分開的是', N'好的撒即可拿到卡薩', N'的河南分開的是發布的數據庫 分讀書筆記 不付款了收到貨', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'蘇軾', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (3001, 1005, N'好的撒罰款或看電視', N'林丹出軌點擊可哦啊不回復看電視發貨的克里斯 ', N'放都是放都是開發大哈薩克分看電視呢接口', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'李白', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (4001, 0, N'上學難上學難想學男掃廁所', N'上學晚 ', N'會發生的范德薩康復還有誰開的發貨單上空間 富華大廈好水電費記錄都是 發揮空間的里放得開了h 年級GV地方離開的房間規范的法律GV到了就好放放 格蘭芬多非空放V快樂弗蘭克', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (31).jpg', N'雄雄', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (4004, 1005, N'而我而我而我熱熱我熱太熱提供熱人格二給對方固定覆蓋發達', N'問問二惡熱熱e', N'個地方給對方給對方固定固定gdsfgfd gsd發達gd放在、 好覆蓋來發揮各方面，你開發的，n nfgn 鋁合金每年浪費個何可 地方花了發過來沒結婚放gh▆?', N'C:\apache-tomcat-7.0.70\webapps\newsMange\adminManage\theme-1.epf', N'雄雄', CAST(0x0000A50C011534B8 AS DateTime), CAST(0x0000A50C011534B8 AS DateTime)) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (4005, 3002, N'多喝水就愛看愛好的時間看復活點就開始', N'淘寶購物', N'附近的克里斯就看到了附近代課老師減肥了看電視健康路附近的思考了', N'C:\apache-tomcat-7.0.70\webapps\newsMange\adminManage\theme-1.epf', N'雄雄', NULL, NULL) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (4006, 2001, N'的空間撒大家了撒嬌了的撒加兩塊', N'的哈薩克 ', N'減肥了第四家里好看的是科技翻譯的大富科技要發給ID快遞費跟對方即可就到了后來客戶客戶反饋 空間及關聯方的好看呢空間V很快就發到你 接口', N'C:\apache-tomcat-7.0.70\webapps\newsMange\adminManage\theme-1.epf', N'白居易', NULL, NULL) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (4007, 1, N'科學發展觀科學發展觀科學發展觀', N'科學發展觀', N'科學發展觀科學發展觀科學發展觀科學發展觀科學發展觀', N'C:\apache-tomcat-7.0.70\webapps\newsMange\adminManage\theme-1.epf', N'', NULL, NULL) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (4008, 2002, N'論三個代表 論三個代表 論三個代表 論三個代表 ', N'論三個代表 ', N'論三個代表 論三個代表 論三個代表 論三個代表 論三個代表 論三個代表 ', N'C:\apache-tomcat-7.0.70\webapps\newsMange\adminManage\clgjxnuobhi.jpg', N'', NULL, NULL) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (4009, 1004, N'大神教你個 還打算價格十多個號', N'測試修改圖平安', N'家大薩洛克的集散地看打了卡就上課了愛上了看見大家的思考薩克了解到來看撒嬌的快樂撒看來大家撒開了家了空間的綠卡時間來看驚呆了卡薩', N'C:\apache-tomcat-7.0.70\webapps\newsMange\adminManage\psb (3).jpg', N'毛寧', NULL, NULL) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (4010, 1004, N'隨便添加一條新聞，測試修改', N'隨便添加一條新聞', N'隨便添加一條新聞，測試修改，有圖片，修改圖片看看能不能把成功！', N'C:\apache-tomcat-7.0.70\webapps\newsMange\adminManage\85ec844e7eafc40cdfb111ca5955026f_big.jpg', N'李白', NULL, NULL) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (4011, 1006, N'而我我是爾大廈的撒多個覆蓋非官方的', N'熱污染費而我的方式', N'發格式的風格的風格的發生過個地方覆蓋地方黑白覆蓋固定 ', N'C:\apache-tomcat-7.0.70\webapps\newsMange\adminManage\psb (8).jpg', N'蘇洵', NULL, NULL) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (5007, 3003, N'2016的第一場雪2016的第一場雪', N'2016的第一場雪', N'2016的第一場雪2016的第一場雪2016的第一場雪2016的第一場雪2016的第一場雪2016的第一場雪', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (10).jpg', N'老子', NULL, NULL) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (5008, 3001, N'2015年的第一場雪2015年的第一場雪2015年的第一場雪2015年的第一場雪', N'2015年的第一場雪', N'2015年的第一場雪2015年的第一場雪2015年的第一場雪2015年的第一場雪2015年的第一場雪2015年的第一場雪2015年的第一場雪', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (6).jpg', N'孫子', NULL, NULL) INSERT [dbo].[newsTb] ([newsID], [categoryID], [summary], [title], [content], [picPath], [author], [createDate], [modifyDate]) VALUES (5009, 1, N'大花灑講課費客戶端發看電視', N'1124上課', N'飛灑吉林省地方就接口環境開發大及地方環保艱苦奮斗吧盡快答復 ，被對方即可國家大事vbsd,ndf寶馬，換個看，嗎發貨快點父類，看好聚會的 離開 ', N'C:\apache-tomcat-7.0.70\webapps\newsManageServlet\adminManage\psb (15).jpg', N'精武門', NULL, NULL) SET IDENTITY_INSERT [dbo].[newsTb] OFF SET IDENTITY_INSERT [dbo].[users] ON INSERT [dbo].[users] ([userID], [userName], [userPassword], [uRole]) VALUES (1, N'admin', N'admin', N'管理員') INSERT [dbo].[users] ([userID], [userName], [userPassword], [uRole]) VALUES (2, N'111', N'111', N'普通用戶') INSERT [dbo].[users] ([userID], [userName], [userPassword], [uRole]) VALUES (4, N'222', N'222', N'管理員') INSERT [dbo].[users] ([userID], [userName], [userPassword], [uRole]) VALUES (1001, N'112', N'112', N'普通用戶') INSERT [dbo].[users] ([userID], [userName], [userPassword], [uRole]) VALUES (1002, N'444', N'4444', N'普通用戶') INSERT [dbo].[users] ([userID], [userName], [userPassword], [uRole]) VALUES (2001, N'444', N'444', N'普通用戶') INSERT [dbo].[users] ([userID], [userName], [userPassword], [uRole]) VALUES (2002, N'555', N'555', N'普通用戶') SET IDENTITY_INSERT [dbo].[users] OFF USE [master] GO ALTER DATABASE [newsDB] SET READ_WRITE GO

總結

以上是生活随笔為你收集整理的新闻发布项目——数据库脚本（直接导入即可）的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。