簡易在線留言板（上）

本文章屬于原創(chuàng)，如若轉(zhuǎn)載請標(biāo)明出處：
http://blog.csdn.net/FlorenceZKY/article/details/74295704
?本系統(tǒng)開發(fā)的是一個(gè)極簡易的三層架構(gòu)的在線留言板。系統(tǒng)的開發(fā)軟件是Visual Studio2013，開發(fā)環(huán)境是Windows7，瀏覽器是Chrome（谷歌瀏覽器）。

一、數(shù)據(jù)庫

1、數(shù)據(jù)庫目錄

?該數(shù)據(jù)庫建立在由學(xué)校提供的服務(wù)器上，鏈接代碼在接下來的代碼中說明。

2、數(shù)據(jù)庫表設(shè)計(jì)

?Users表(用戶表，標(biāo)注：user不能作為表名和屬性名，因?yàn)閡ser是關(guān)鍵字，這里容易出錯(cuò)。)

?Mess表(留言表)

二、項(xiàng)目設(shè)計(jì)

1、項(xiàng)目目錄

2、項(xiàng)目簡要說明

(1)實(shí)體層Entity：User.cs、EntBlog.cs
(2)數(shù)據(jù)訪問層Dal：SQLHelper.cs、DalUser.cs、DalBlog.cs
(3)業(yè)務(wù)邏輯層Bll：bllUsers.cs、bllBlog.cs
(4)客戶端：WebApp：
?①CSS文件：
? pic照片文件

? ②母版頁：Main.Master(當(dāng)時(shí)是作業(yè)要求，但是我只是設(shè)置了一個(gè)空的母版頁，所以這個(gè)文件存不存在都無所謂)
? ③主界面：index.aspx
?④登錄、注冊、修改密碼界面：Login.aspx、Register.aspx、UpdatePassword.aspx
? ⑤管理員界面：AdminPage.aspx、AdminUserPage.aspx
? ⑥普通用戶界面：EditBlog.aspx、MyBlog.aspx

3、代碼內(nèi)容

(1)Entity層：
Users.cs(實(shí)體用戶)

using System; using System.Collections.Generic; using System.Linq; using System.Text;namespace Entity {public class EntUsers{public string Username{get;set; }public String Password{get;set;}} }

Mess.cs(實(shí)體留言)

using System; using System.Collections.Generic; using System.Linq; using System.Text;namespace Entity {public class EntBlog{public string Username{get;set;}public string Message{get;set;}public DateTime Time{get;set;}} }

Dal層：
SqlHelper.cs

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.SqlClient; using System.Configuration;namespace Dal {public static class SqlHelper{private static string strCn = ConfigurationManager.ConnectionStrings["AppConn"].ConnectionString;public static SqlDataReader ExecuteReader(string strSql, params SqlParameter[] pms){try{SqlConnection cn = new SqlConnection(strCn);cn.Open();SqlDataReader dtr = null;using (SqlCommand cmd = new SqlCommand(strSql, cn)){if (pms != null) cmd.Parameters.AddRange(pms);dtr = cmd.ExecuteReader(CommandBehavior.CloseConnection);//查找完成后關(guān)閉連接}return dtr;}catch (Exception ex){throw ex;}}public static object ExecuteScalar(string strSql, params SqlParameter[] pms){try{object obj = null;using (SqlConnection cn = new SqlConnection(strCn)){cn.Open();using (SqlCommand cmd = new SqlCommand(strSql, cn)){if (pms != null) cmd.Parameters.AddRange(pms);obj = cmd.ExecuteScalar();}}return obj;}catch (Exception ex){throw ex;}}public static int ExecuteNonQuery(string strSql, params SqlParameter[] pms){try{int intResult = 0;using (SqlConnection cn = new SqlConnection(strCn)){cn.Open();using (SqlCommand cmd = new SqlCommand(strSql, cn)){if (pms != null) cmd.Parameters.AddRange(pms);intResult = cmd.ExecuteNonQuery();}}return intResult;}catch (Exception ex){throw ex;}}public static DataSet ExecuteQuery(string strSql){using (SqlConnection cn = new SqlConnection(strCn)){DataSet ds = new DataSet();try{cn.Open();using (SqlCommand cmd = new SqlCommand(strSql, cn)){SqlDataAdapter da = new SqlDataAdapter(cmd);da.Fill(ds, "ds");}}catch (Exception ex){throw ex;}return ds;}}} }

DalUser.cs(用戶數(shù)據(jù)訪問層)

using System; using System.Collections.Generic; using System.Linq; using System.Text; using Entity; using System.Data; using System.Data.SqlClient;namespace Dal {public class DalUsers{public bool Create(EntUsers Users, out string strMsg)//創(chuàng)建用戶{bool blnRet = false;try {StringBuilder sb = new StringBuilder(1024);sb.Append("INSERT INTO Users");sb.Append("(Username,Password)");sb.Append("Values (@Username,@Password)");SqlParameter[] pms = new SqlParameter[2];pms[0] = new SqlParameter("@Username", Users.Username);pms[1] = new SqlParameter("@Password", Users.Password);blnRet = SqlHelper.ExecuteNonQuery(sb.ToString(), pms) > 0;strMsg = blnRet ? "成功創(chuàng)建：“" + Users.Username + " ”用戶！" : "用戶添加失敗！請檢查書寫！ ";}catch (Exception ex){strMsg = "數(shù)據(jù)操作錯(cuò)誤：" + ex.Message;}return blnRet;}public bool Exists(string Username, out string strMsg)//檢查是否存在用戶{bool blnRet = false;try{StringBuilder sb = new StringBuilder(1024);sb.Append("SELECT COUNT(*) AS cnt ");sb.Append("FROM Users ");sb.Append("WHERE (Username= @Username) ");SqlParameter[] pms = new SqlParameter[1];pms[0] = new SqlParameter("@Username", Username);blnRet = (int)SqlHelper.ExecuteScalar(sb.ToString(), pms) > 0;strMsg = "";}catch (Exception ex){strMsg = "操作錯(cuò)誤：" + ex.Message;}return blnRet;}public bool Login(EntUsers Users, out string strMsg)//用戶登錄{bool blnRet = false;try{StringBuilder sb = new StringBuilder(1024);sb.Append("SELECT * ");sb.Append("FROM Users ");sb.Append("WHERE (Username = @Username) AND (Password = @Password) ");SqlParameter[] pms = new SqlParameter[2];pms[0] = new SqlParameter("@Username", Users.Username);pms[1] = new SqlParameter("@Password", Users.Password);object obj = SqlHelper.ExecuteScalar(sb.ToString(), pms);if (obj != null)blnRet = true;strMsg = "";}catch (Exception ex){strMsg = "數(shù)據(jù)操作錯(cuò)誤：" + ex.Message;}return blnRet;}public bool Update(EntUsers Users, out string strMsg)//更新用戶信息（修改密碼）{bool blnRet = false;try { StringBuilder sb = new StringBuilder(1024);sb.Append("UPDATE Users ");sb.Append("SET Password = @Password ");sb.Append("WHERE (Username = @Username) ");SqlParameter[] pms = new SqlParameter[2];pms[0] = new SqlParameter("@Password", Users.Password);pms[1] = new SqlParameter("@Username", Users.Username);blnRet = SqlHelper.ExecuteNonQuery(sb.ToString(), pms) > 0;strMsg = blnRet ? "密碼修改成功成功！" : "密碼修改失敗，請檢查是否有錯(cuò)！";}catch (Exception ex){strMsg = "數(shù)據(jù)操作錯(cuò)誤：" + ex.Message;}return blnRet;}} }

DalBlog.cs(留言數(shù)據(jù)訪問層)

using System; using System.Collections.Generic; using System.Linq; using System.Text; using Entity; using System.Data; using System.Data.SqlClient;namespace Dal {public class DalBlog{public bool Create(EntBlog Blog, out string strMsg)//創(chuàng)建留言{bool blnRet = false;try{StringBuilder sb = new StringBuilder(1024);sb.Append("INSERT INTO Mess");sb.Append("(Username,Mess,Time)");sb.Append("Values (@Username,@Mess,@Time)");SqlParameter[] pms = new SqlParameter[3];pms[0] = new SqlParameter("@Username", Blog.Username);pms[1] = new SqlParameter("@Mess", Blog.Message);pms[2] = new SqlParameter("@Time", Blog.Time);blnRet = SqlHelper.ExecuteNonQuery(sb.ToString(), pms) > 0;strMsg = blnRet ? "成功發(fā)布您的留言！" : "發(fā)布失敗，請過一會再發(fā)布！ ";}catch (Exception ex){strMsg = "數(shù)據(jù)操作錯(cuò)誤：" + ex.Message;}return blnRet;}} }

Bll層：
bllUser.cs（用戶邏輯業(yè)務(wù)層）

using System; using System.Collections.Generic; using System.Linq; using System.Text; using Entity; using Dal; using System.Data; using System.Data.SqlClient;namespace Bll {public class bllUsers{private DalUsers dal = new DalUsers();public bool Create(EntUsers users,out string strMsg)//創(chuàng)建用戶{bool blnRet = false;//檢查Username有沒重名if (dal.Exists(users.Username, out strMsg))strMsg = (strMsg.Length > 0) ? strMsg : "創(chuàng)建失敗！已有用戶名稱： " + users.Username;elseblnRet = dal.Create(users, out strMsg);return blnRet;}public bool Login(EntUsers users,out string strMsg)//用戶登錄{bool blnRet = dal.Login(users, out strMsg);strMsg = (blnRet) ? "OK" : ((strMsg.Length > 0) ? strMsg : "登錄出錯(cuò)！請檢查用戶名和密碼輸入是否正確！");return blnRet;}public bool Update(EntUsers users,out string strMsg)//更新密碼{return dal.Update(users,out strMsg);}} }

bllBlog.cs（留言業(yè)務(wù)邏輯層）

using System; using System.Collections.Generic; using System.Linq; using System.Text; using Entity; using Dal; using System.Data; using System.Data.SqlClient;namespace Bll {public class bllBlog{private DalBlog dal=new DalBlog();public bool Create(EntBlog entBlog, out string strMsg){bool blnRet=false;blnRet = dal.Create(entBlog, out strMsg);return blnRet;}} }

此處內(nèi)容太多，為了容易查看，請看我博客的 簡易在線留言板（中）。。。

總結(jié)

以上是生活随笔為你收集整理的简易在线留言板（上）——树洞留言板的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。