OleDbDAL/userinfo.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using ClothesShop.DBUtility;
using System.Data;
using System.Data.OleDb;

namespace ClothesShop.OleDbDAL
{
    public class userinfo : ClothesShop.IDAL.Iuserinfo
    {
        /// <summary>
        /// 创建一个新用户
        /// </summary>
        /// <param name="username">用户名称</param>
        /// <param name="password">用户密码</param>
        /// <param name="email">电子邮件</param>
        /// <param name="question">密码问题</param>
        /// <param name="answer">问题答案</param>
        /// <returns></returns>
        public int createUser(string username, string password,int power, string email, string question, string answer)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("insert into userinfo ([username],[password],[power],email,question,answer) values ");
            sb.Append(" (@username,@password,@power,@email,@question,@answer)");
            OleDbParameter[] param = 
                                    {
                                        OleDbHelper.GetParameter("@username",OleDbType.Char,50,"[username]",username),
                                        OleDbHelper.GetParameter("@password",OleDbType.Char,50,"[password]",password),
                                         OleDbHelper.GetParameter("@power",OleDbType.Integer,4,"[power]",power),
                                        OleDbHelper.GetParameter("@email",OleDbType.Char,50,"email",email),
                                        OleDbHelper.GetParameter("@question",OleDbType.Char,50,"question",question),
                                        OleDbHelper.GetParameter("@answer",OleDbType.Char,50,"answer",answer)
                                    };
            return OleDbHelper.ExecuteSql(sb.ToString(), param);
        }

        /// <summary>
        /// 获得一个用户资料
        /// </summary>
        /// <param name="userid"></param>
        /// <returns></returns>
        public DataTable getUser(int userid)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("select [userid],[username],[password],[power],email,question,answer ");
            sb.Append("from userinfo where [userid]=@userid");
            OleDbParameter[] param = { OleDbHelper.GetParameter("@userid", OleDbType.Integer, 4, "[userid]", userid) };
            return OleDbHelper.ExecuteDt(sb.ToString(), param);
        }

        /// <summary>
        /// 获得一个用户资料
        /// </summary>
        /// <param name="userid"></param>
        /// <returns></returns>
        public DataTable getUser(string username)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("select [userid],[password],[username],[power],email,question,answer ");