【论文写作】课程指导平台的开发中系统部分代码如何写
4《数据库原理及应用技术》课程指导平台功能模块具体实现
4.1 用户登录认证部分代码
// 数据库连接操作帮助类
public sealed class SqlHelper
{
// 执行数据库读取
public static SqlDataReaderExecuteReader(string connectionString,CommandType commandType, stringcommandText)
{
return ExecuteReader(connectionString, commandType,commandText, (SqlParameter[])null);
}
// 执行数据库读取
public static SqlDataReaderExecuteReader(string connectionString,CommandType commandType, stringcommandText, paramsSqlParameter[]commandParameters)
{
if (connectionString == null || connectionString.Length == 0) throw newArgumentNullException("connectionString");
SqlConnection connection = null;
try
{
// 新建一个数据库连接实例
connection = newSqlConnection(connectionString);
// 建立连接
connection.Open();
returnExecuteReader(connection,null, commandType,commandText, commandParameters,SqlConnectionOwnership.Internal);
}
catch
{
if (connection != null)
// 关闭数据库连接
connection.Close();
throw;
}
}
}
// 验证用户登录类
public class CheckUserLogin{
SqlConnection conn;
public CheckUserLogin()
{
//读取web.config里面的数据库连接字串并new一个SqlConnection实例
conn =
new
SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnStr"].ToString());
}
//取得用户密码
public string getPassword(string user_no, stringrole)
{
string password = String.Empty;
SqlDataReader dr = null;
if (role == "stu")
{
dr = SqlHelper.ExecuteReader(conn,CommandType.Text, "select passwordfrom DB_STU where stu_id =" + user_no);
}
…………………………..
return password; }
}
4.2 学生作业修改功能部分代码
