C#新闻发布系统.docx
- 文档编号:5363278
- 上传时间:2022-12-15
- 格式:DOCX
- 页数:35
- 大小:149.58KB
C#新闻发布系统.docx
《C#新闻发布系统.docx》由会员分享,可在线阅读,更多相关《C#新闻发布系统.docx(35页珍藏版)》请在冰豆网上搜索。
C#新闻发布系统
usingSystem;
usingSystem.Data;
usingSystem.Configuration;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.HtmlControls;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Xml.Linq;
///
///News的摘要说明
///
publicclassNewss
{
publicNewss()
{
this.newsdate=DateTime.Now.ToLongDateString();
}
privatestringnewstitle;
///
///新闻类别ID
///
publicstringsNewstitle
{
get{returnnewstitle;}
set{newstitle=value;}
}
privatestringnewsdate;
///
///系统时间
///
publicstringsNewsdate
{
get{returnnewsdate;}
set{newsdate=value;}
}
privatestringnewskey;
///
///关键字
///
publicstringsNewskey
{
get{returnnewskey;}
set{newskey=value;}
}
privatestringcontent;
///
///新闻内容
///
publicstringsContent
{
get{returncontent;}
set{content=value;}
}
privateintuserid;
publicintiUserid
{
get{returnuserid;}
set{userid=value;}
}
privatestringnewsid;
///
///新闻ID
///
publicstringsNewsid
{
get{returnnewsid;}
set{newsid=value;}
}
}
数据库的链接
usingSystem;
usingSystem.Data;
usingSystem.Configuration;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.HtmlControls;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Xml.Linq;
usingSystem.Data.SqlClient;
///
///DBHelper的摘要说明
///
publicclassDBHelper
{
privatestaticstringconnectionstring=@"server=.;Database=News_Manages;uid=sa;pwd=372115";
//Database=你的数据库名uid数据库账号pwd你数据库账号密码
publicstaticSqlConnectionGetConnection()
{
SqlConnectioncon=newSqlConnection();
con.ConnectionString=connectionstring;
returncon;
}
}
NewsDao数据处理层
usingSystem;
usingSystem.Data;
usingSystem.Configuration;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.HtmlControls;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Xml.Linq;
usingSystem.Data.SqlClient;
usingSystem.Collections.Generic;
///
///NewsDao的摘要说明
///
publicclassNewsDao
{
privateSqlConnectioncon=null;
publicNewsDao(SqlConnectioncon)
{
this.con=con;
}
privatestaticstringAddNewxw=@"INSERTINTONews([newstitleid],[newsdate],[newskey],[newscontent],[userid])
VALUES(@newstitleid,@newsdate,@newskey,@content,@userid)";
publicintAddNew(Newssns)
{
intresult=1;
SqlCommandcmd=newSqlCommand();
cmd.CommandText=AddNewxw;
cmd.Connection=con;
cmd.Parameters.AddWithValue("@newstitleid",ns.sNewstitle);
cmd.Parameters.AddWithValue("@newskey",ns.sNewskey);
cmd.Parameters.AddWithValue("@newsdate",ns.sNewsdate);
cmd.Parameters.AddWithValue("@content",ns.sContent);
cmd.Parameters.AddWithValue("@userid",ns.iUserid);
try
{
result=cmd.ExecuteNonQuery();
}
catch(Exceptione)
{
result=0;
}
finally
{
cmd.Dispose();
}
returnresult;
}
privatestaticstringSelectid=@"selectnewsid,newstitleidfromNews";
///
///查找新闻标题
///
///
publicList
{
List
SqlCommandcmd=newSqlCommand();
SqlDataReaderdr=null;
cmd.CommandText=Selectid;
cmd.Connection=con;
try
{
dr=cmd.ExecuteReader();
while(dr.Read())
{
Newssns=newNewss();
ns.sNewsid=dr["newsid"].ToString();
ns.sNewstitle=dr["newstitleid"].ToString();
result.Add(ns);
}
}
catch(Exceptione)
{
System.Diagnostics.Debug.Write(e.Message);
}
finally
{
cmd.Dispose();
}
returnresult;
}
privatestaticstringSelectrn=@"selecttop10newscontent,newstitleidfromNewswherenewsid=@newsid";
///
///查找新闻标题和内容
///
///
publicList
{
List
SqlCommandcmd=newSqlCommand();
SqlDataReaderdr=null;
cmd.CommandText=Selectrn;
cmd.Connection=con;
cmd.Parameters.AddWithValue("@newsid",number);
try
{
dr=cmd.ExecuteReader();
while(dr.Read())
{
Newssns=newNewss();
ns.sContent=dr["newscontent"].ToString();
ns.sNewstitle=dr["newstitleid"].ToString();
result.Add(ns);
}
}
catch(Exceptione)
{
System.Diagnostics.Debug.Write(e.Message);
}
finally
{
cmd.Dispose();
}
returnresult;
}
}
用户类:
usingSystem;
usingSystem.Data;
usingSystem.Configuration;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.HtmlControls;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Xml.Linq;
///
///User的摘要说明
///
publicclassUser
{
publicUser()
{
this.username="";
this.userpassword="";
}
privatestringusername;
///
///用户名
///
publicstringsUsername
{
get{returnusername;}
set{username=value;}
}
privatestringuserpassword;
///
///用户密码!
///
publicstringsUserpassword
{
get{returnuserpassword;}
set{userpassword=value;}
}
privatestringuserid;
///
///id
///
publicstringsUserid
{
get{returnuserid;}
set{userid=value;}
}
}
用户dao数据处理层
usingSystem;
usingSystem.Data;
usingSystem.Configuration;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.HtmlControls;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Xml.Linq;
usingSystem.Data.SqlClient;
usingSystem.Collections.Generic;
///
///UserDao的摘要说明
///
publicclassUserDao
{
privateSqlConnectioncon=null;
publicUserDao(SqlConnectioncon)
{
this.con=con;
}
privatestaticstringAddNewxw=@"INSERTINTOUsers([username],[userpasswird])VALUES(@username,@pw)";
///
///增加
///
///
///
publicintAddNew(Userus)
{
intresult=1;
SqlCommandcmd=newSqlCommand();
cmd.CommandText=AddNewxw;
cmd.Connection=con;
cmd.Parameters.AddWithValue("@username",us.sUsername);
cmd.Parameters.AddWithValue("@pw",us.sUserpassword);
try
{
result=cmd.ExecuteNonQuery();
}
catch(SqlExceptione)
{
}
finally
{
cmd.Dispose();
}
returnresult;
}
privatestaticstringSelectDenglu=@"selectcount(*)fromUserswhere[username]=@usernameand[userpasswird]=@password";
///
///密码查询
///
///
///
///
publicintFindZh(stringname,stringpwd)
{
intresult=0;
SqlCommandcmd=newSqlCommand();
cmd.CommandText=SelectDenglu;
cmd.Connection=con;
cmd.Parameters.AddWithValue("@username",name);
cmd.Parameters.AddWithValue("@password",pwd);
try
{
result=(Int32)cmd.ExecuteScalar();
}
catch(Exceptione)
{
System.Diagnostics.Debug.Write(e.Message);
}
finally
{
cmd.Dispose();
}
returnresult;
}
privatestaticstringSelectid=@"select*fromUserswhere[username]=@usernameand[userpasswird]=@password";
///
///密码查询
///
///
///
///
publicstringFindID(stringname,stringpwd)
{
stringresult="";
SqlCommandcmd=newSqlCommand();
SqlDataReaderdr=null;
cmd.CommandText=Selectid;
cmd.Connection=con;
cmd.Parameters.AddWithValue("@username",name);
cmd.Parameters.AddWithValue("@password",pwd);
try
{
dr=cmd.ExecuteReader();
while(dr.Read())
{
result=dr["userid"].ToString();
}
}
catch(Exceptione)
{
System.Diagnostics.Debug.Write(e.Message);
}
finally
{
cmd.Dispose();
}
returnresult;
}
}
首页查询标题的
<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="Default.aspx.cs"Inherits="_Default"%>
DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""http:
//www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
//www.w3.org/1999/xhtml">
RepeaterID="Repeater1"runat="server"> HyperLinkID="jh"runat="server"NavigateUrl='<%#"neirong.aspx? id="+Eval("newsid")%>'><%#Eval("newstitleid")%> HyperLink>
Repeater>