userdb.cs

运用ASP.NET开发的一个同学录系统

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace DBHelper
{
	/// <summary>
	/// Summary description for UserDB.
	/// </summary>
	public class UserDB
	{
		private const string SQL_INSERT_SIGNON = "INSERT INTO SignOn VALUES (@UserId, @Password)";
		private const string PARM_USER_ID = "@UserId";
		private const string PARM_PASSWORD = "@Password";
		private const string PARM_EMAIL = "@Email";

		public void AddUser(String sUserName,String sPassword,String sEmail)
		{
			switch(DBHelper.DBType.ToLower())
			{
				case "sql":
				{
					SqlParameter[] addUserParams = GetAddUserParameters();

					addUserParams[0].Value = sUserName;
					addUserParams[1].Value = sPassword;
					addUserParams[2].Value = sEmail;

					using(SqlConnection conn = new SqlConnection(DBHelper.SQLCONNENTSTRING))
					{
						conn.Open();
						using(SqlTransaction trans = conn.BeginTransaction())
						{
							try
							{
								SQLHelper.ExecuteNonQuery(trans,CommandType.Text,SQL_INSERT_SIGNON,addUserParams);
								trans.Commit();
							}
							catch
							{
								trans.Rollback();
								throw;
							}
						}
					}
					break;
				}
				case "oracle":
				{
					//
					break;
				}
				default:
				{
					break;
				}
			}
		}

		private static SqlParameter[] GetAddUserParameters() 
		{
			SqlParameter[] parms = SQLHelper.GetCachedParameters(SQL_INSERT_SIGNON);

			if (parms == null) 
			{
				parms = new SqlParameter[] {
											   new SqlParameter(PARM_USER_ID, SqlDbType.VarChar, 80),
											   new SqlParameter(PARM_PASSWORD, SqlDbType.VarChar, 80),
											   new SqlParameter(PARM_EMAIL,SqlDbType.VarChar,100)};

				SQLHelper.CacheParameters(SQL_INSERT_SIGNON, parms);
			}

			return parms;
		}
	}
}