1、1.选择 文件-新建-项目2.选择 其它项目类型-Visual Studio解决方案3.在解决方案所在的文件夹中创建以下文件夹: Bin:存放生成的可执行文件 Documents:存放所用到的文档 Library:存放用到的第三方控件 Setup:存放用于安装的最终程序及其相关文件 UnitTest:存放测试代码4.准备以下文件放到相应的文件夹中:在Library文件夹中建立SQLite文件夹,从SQLite的官方网站下载sqlite-netFx40-binary-Win32-2010-1.0.84.0.zip文件,解压缩后将其中的4个文件SQLite.Designer.dll、SQLite.
2、Interop.dll、System.Data.SQLite.dll和System.Data.SQLite.Linq.dll拷贝到SQLite文件夹待用;在Bin文件夹下面创建Database文件夹,并利用sqliteadmin在其中创建一个SQLite数据库文件MyFirstDB.s3db(或用代码创建),其中包含一个表:表中admin密码为lcb,aaa密码为123,bbb密码为空在Bin文件夹下面创建配置文件MyConfig.INI:5.右键单击右图中的“解决方案MyFirstSolution(0个项目)”-添加-新建项目,建立如右图所示5个Project;其中Common、DAL、Mo
3、del和BLL项目类型为“类库”,UI的项目类型为“Windows应用程序”;右键单击“MyFirstSolution.UI”设定UI为“启动项目”,该项目名称变为黑体显示。6.添加引用(右键单击“引用”-“添加引用”):BLL引用DAL和ModelDAL引用Common和Library文件夹中的3个dll文件: SQLite.Designer.dll、System.Data.SQLite.dll和System.Data.SQLite.Linq.dllModel引用Common和DALUI引用Common、BLL和Model,还必须将Library文件夹中的SQLite.Interop.dll
4、文件复制到Bin文件夹中添加引用的同时,项目间的依赖关系也就发生了变化,随之改变的是项目的编译顺序。7.填写Common的代码:修改Class1.cs的名称为CodeProcess.cs,并输入其代码实现Base64的编码和解码功能添加IniClass类实现对INI文件的读写操作添加MyConfig类调用IniCalss类实现对配置文件MyConfig.INI的读写操作8.填写DAL的代码添加数据集UserDataSet,建立表Users,结构同SQLite数据库中的表Users将类Class.cs改名为MyDbHelper.cs,并输入它的代码实现数据库的操作:连接,查询,修改9.填写Mod
5、el的代码:修改类Class1.cs为User.cs,并填写其代码实现利用DAL提供的功能从数据库中获取数据,并将需要保存的数据写入数据库(具体项目中,可以单个修改/保存,也应该可以批量修改/保存)以属性的形式向上层提供数据10.填写BLL的代码:修改Class1.cs类为UserManager.cs类,并填写代码实现对用户信息的管理:获取数据,校验密码,修改密码11.填写UI的内容:添加Form的界面元素添加Form_Load的代码根据配置文件的内容设置界面元素需要的话,实现自动登录功能添加Button_Click点击事件的处理代码检验登录帐号和密码记录登录状态到配置文件中调试过程及实验结果
6、总结 本次试验主要考察的是三层架构开发模式,即表示层、业务逻辑层、数据访问层。通过本次试验对三层架构开发模式有了新的认识,不再是仅仅局限于课本上枯燥的知识,本次实验后有了更加生动的认识。附录UI部分代码:using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using MyFirstSolution.
7、BLL;using MyFirstSolution.Common;namespace MyFirstSolution.UI public partial class Form1 : Form private String count = null; private String pass = null; private int autoLogin=1; /ini文?件t路径? String file = .MyConfig.ini; MyConfig opIni; public Form1() InitializeComponent(); private void login_Click(ob
8、ject sender, EventArgs e) this.count = this.counter.Text.ToString(); this.pass = this.password.Text.ToString(); if (this.auto.Checked) opIni = new MyConfig(this.file); opIni.setLoginName(this.count); opIni.setLoginPassWord(this.pass); opIni.setAutoLogin(1); else opIni.setLoginName(); opIni.setLoginP
9、assWord( opIni.setAutoLogin(0); UserManager um = new UserManager(this.count); if (um.checkPass(this.pass) MessageBox.Show(登?录?成功| else 失骸?败悒? private void Form1_Load(object sender, EventArgs e) this.count = opIni.getLoginName(); this.pass = opIni.getLoginPassword(); this.autoLogin = opIni.getAutoLog
10、in(); /this.autoLogin=opIni.get if (this.autoLogin = 1) this.auto.Checked = true; this.counter.Text = this.count; this.password.Text = this.pass; else if (this.autoLogin = 0) this.auto.Checked = false;BLL部分代码using MyFirstSolution.Model;namespace MyFirstSolution.BLL public class UserManager User use;
11、 String name; public UserManager(String name) this.name = name; public Boolean checkPass(String pass) use=new User(name); if (pass = use.getPass() return true; return false;Modelde 的代码using MyFirstSolution.DAL;namespace MyFirstSolution.Model public class User MyDbHelper md; String count; public User
12、(string count) this.count = count; public String getPass() md = new MyDbHelper(); return md.getPassword(count);DAL的代码using System.Data.SQLite;namespace MyFirstSolution.DAL public class MyDbHelper public SQLiteConnection GetCon() string strFilePath = Data Source=C:UsersCODERDesktopTestSolutionbinData
13、baseMyFirstDB.s3db SQLiteConnection sqliteCon = new SQLiteConnection(strFilePath); return sqliteCon; public String getPassword(String name) String pass; SQLiteConnection con = GetCon(); con.Open(); String sqlstr = select Password from userInfo where Account= + name + SQLiteCommand cmd = con.CreateCo
14、mmand(); cmd.CommandText = sqlstr; SQLiteDataReader reader = cmd.ExecuteReader(); reader.Read(); pass = reader0.ToString(); return pass;Common的代码1.base64编码namespace MyFirstSolution.Common public class CodeProcess public string EncodeBase64(string code) byte bytes = Encoding.Default.GetBytes(code); s
15、tring str = Convert.ToBase64String(bytes); return str; public string DecodeBase64(string code) byte outputb = Convert.FromBase64String(code); string orgStr = Encoding.Default.GetString(outputb); return orgStr;2.读取ini文件using System.Runtime.InteropServices; class IniClass private string fileName; DllI
16、mport(kernel32) private static extern int GetPrivateProfileInt( string lpAppName, string lpKeyName, int nDefault, string lpFileName ); private static extern int GetPrivateProfileString( string lpAppName, string lpKeyName, string lpDefault, StringBuilder lpReturnedString, int nSize, string lpFileName
17、 private static extern bool WritePrivateProfileString( string lpAppName,string lpKeyName,string lpString, string lpFileName public void IniFile(string filename) fileName = filename; public int GetInt(string section, string key, int def) return GetPrivateProfileInt(section, key, def, fileName); publi
18、c string GetString(string section, string key, string def) StringBuilder temp = new StringBuilder(1024); GetPrivateProfileString(section, key, def, temp, 1024, fileName); return temp.ToString(); public void WriteInt(string section, string key, int iVal) WritePrivateProfileString(section, key, iVal.T
19、oString(), fileName); public void WriteString(string section, string key, string strVal) WritePrivateProfileString(section, key, strVal, fileName); public void DelKey(string section, string key) WritePrivateProfileString(section, key, null, fileName); public void DelSection(string section) WritePriv
20、ateProfileString(section, null, null, fileName);3.操作INI文件 public class MyConfig String filename ; String loginName; String loginPassword; int autologin; String ConnectString; CodeProcess cp = new CodeProcess(); public MyConfig(String filename) this.filename = filename; public string getLoginName() I
21、niClass ini = new IniClass(); ini.IniFile(filename); this.loginName = ini.GetString(Login, LoginName没?找到? return loginName; public string getLoginPassword() this.loginPassword = ini.GetString(LoginPassword return cp.DecodeBase64(loginPassword); /return loginPassword; public int getAutoLogin() this.a
22、utologin = ini.GetInt(AutoLogin, 1); return autologin; public string getConnectString() this.ConnectString = ini.GetString(DatabaseConnectString return ConnectString; public void setLoginName(String name) ini.WriteString(, name); public void setLoginPassWord(String pass) String enPass = cp.EncodeBase64(pass);, enPass); public void setAutoLogin(int autologin) ini.WriteInt(, autologin);