(i) Building a news database
Analyze the elements that make up each piece of news, mainly by news headlines, news content, picture address, connection address, news release time. And when you build the database. For processing needs, the ID number of the news must be added for identification. In addition, click Statistics can be added in order to understand what the reader is interested in. An Access database is an over time database that is ideal for use in the development phase, so. We construct a news database (Data.mdb) as follows
Table Data
NEWS_ID Long News Number
Category of News_class text News
News_class_name Text News category name
Title of News_title Text News
News_head Logic whether home display
The content of News_comment Comment News
Year of news_year Text news
month of News_month text news
Content of News_day Text news
News_time Text Update time
News_delete Logic Delete Flag
This table is built according to the above requirements, and when we are tested and stabilized, we can transfer the news database to SQL Server.
Out. Well, take this step down, we'll do a news management page, for layout and management convenience, we use
The frame structure makes the following surface pages. Webadmin.htm the main file for the framework.
"HTML"
"Head"
"Meta http-equiv=" Content-type "content=" text/html; charset=gb2312 ""
"title" Press release System Management page "/title"
Meta name= "generator" content= "Microsoft FrontPage 3.0"
"/head"
"Frameset framespacing=" 0 "rows=" *,14% "
"Frame name=" main "target=" footnotes "src=" webadmin.asp "scrolling=" Auto "
"Frame name=" footnotes "src=" delete.asp "scrolling=" Auto "
"Noframes"
"Body"
"P" This page uses frames, but your browser doesn ' t support them. '/P '
"/body"
"/noframes"
"/frameset"
"/html"
And the face contains the file is webadmin.asp this file. Mainly by it provides input news daily update interface, the code is as follows.
"HTML"
"Head"
"Meta http-equiv=" Content-type "content=" text/html; charset=gb2312 ""
"Style type=" Text/css "
《!--
. lh22px {font-size:12px;line-height:22px;font-family: Song body}
a {Text-decoration:none}
Body {line-height:18px;font-size:9pt;font-family: XXFarEastFont-Arial}
TD {Line-height:18px;font-size:9pt;font-family: Song body}
a:hover {color: #FF0000; Text-decoration:none}
--》
"/style"
"Base target=" Footnotes "
"title" Press release System Management page "/title"
"/head"
"Body topmargin=" 8 "leftmargin=" 8 "
"P align=" center "" Font face= "italics _gb2312" size= "6" color= "#FF0000" "strong" press release system Web Management page "/strong" "/font" "P"
"Div align=" Center "center"
"Table border=" 0 "width=" 100% "cellspacing=" 0 "cellpadding=" 0 "
"TR"
"TD Width=" 100% "" Form method= "POST" action= "addnew.asp"
"Table border=" 0 "width=" 100% "height=" 126 "cellpadding=" 0 "
"TR"
TD width= "100%" height= "9" colspan= "2" bgcolor= "#E7E7E7" "Div align=" Center "" Center "" p "" Font
Size= "3" "strong" add Daily news content "/strong" "/font" "/td"
"/TR"
TR align= "Center"
"TD width=" 15% "height=" 8 "bgcolor=" #E7E7E7 "" div align= "left" "P" News title: (Must) "/td"
"TD width=" 85% "height=" 8 "bgcolor=" #F9F9F9 "" div align= "left" "p" "Input type=" text "
Name= "title" size= "73" "/td"
"/TR"
TR align= "Center"
"TD width=" 15% "height=" bgcolor= "#E7E7E7" valign= "Top" "div align=" left "" p "news content: (MUST)"/td "
"TD width=" 85% "height=" bgcolor= "#F9F9F9"