实验报告三层架构.doc

《实验报告三层架构.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、.软件开发环境与工具实验报告题目：三层架构实验序号：实验4学号：姓名：班级：日期：范文..一、实验目的通过本次实验，了解了三层架构实验的具体步骤和方法，掌握了实验的具体内容。二、实验原理设计一个模拟登录界面，通过登录（姓名与密码）进入用户管理界面。用户管理界面创建四个用户操作功能，浏览.修改.新增.删除。并将操作中数据变化同步到数据库，实现数据库与用户管理的同步一体化。三、实验过程核心代码ImportsSystem.Data.SqlClientPublicClassUserDaoPublicconnAsNewSqlConnecti

2、onPublicFunctiongetData()AsDataSetDimdsAsNewDataSetconn.ConnectionString="server=100.100.28.24;uid=sa;pwd=root;database=test"conn.Open()DimseAsString="select*fromuserMessage"Console.WriteLine(se)DimdaAsNewSqlDataAdapter(se,conn)da.Fill(ds,"userMessage")conn.Close()Ret

3、urndsEndFunctionPublicFunctionupdate(ByValuserIdAsString,ByValpasswordAsString,ByValoldUserIdAsString)AsIntegerDimconnAsNewSqlConnectionconn.ConnectionString="server=100.100.28.24;uid=sa;pwd=root;database=test"conn.Open()范文..DimupdateStringAsString="UPDATEuserMessages

4、etuserId='"&userId&"',password='"&password&"'whereuserId='"&oldUserId&"'"Console.WriteLine(updateString)DimcommandAsSqlCommand=NewSqlCommand(updateString,conn)DimresultAsInteger=command.ExecuteNonQuery()conn.Close()ReturnresultEndFunctionPublicFunctioninsert(ByValuser

5、IDAsString,ByValpasswordAsString)AsIntegerDimconnAsNewSqlConnectionconn.ConnectionString="server=100.100.28.24;uid=sa;pwd=root;database=test"conn.Open()DiminsertStringAsString="insertintouserMessagevalues('"&userID&"','"&password&"')"Console.WriteLine(insertString)Dim

6、commandAsSqlCommand=NewSqlCommand(insertString,conn)DimresultAsInteger=command.ExecuteNonQuery()conn.Close()ReturnresultEndFunctionPublicFunctiondelete(ByValuserIdAsString)AsBooleanDimconnAsNewSqlConnectionconn.ConnectionString="server=100.100.28.24;uid=sa;pwd=root;da

7、tabase=test"conn.Open()DiminsertStringAsString="DELETEfromuserMessagewhereuserId=('"&userId&"')"DimcommandAsSqlCommand=NewSqlCommand(insertString,conn)DimresultAsInteger=command.ExecuteNonQuery()conn.Close()ReturnresultEndFunctionPublicFunctiongetUserPassword(ByValuse

8、rName)AsStringConsole.WriteLine("UserDao")DimdataAsDataSetDimpasswordAsString=""data=getData()'Console.WriteLine(userName)Fo