简单C#登录

 

后台代码

public String logion(String username, String pwd)
        {
            String constr = "数据库连接字符串";
            OracleConnection conn = new OracleConnection(constr);
            String iRet=null;
            try
            {
                conn.Open();
                OracleCommand cmd = new OracleCommand("mydemo01", conn); //mydemo01 存储过程名
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("username", username);
                cmd.Parameters.AddWithValue("usepwd", pwd);
                cmd.Parameters.Add("v_value",OracleType.Number ).Direction = ParameterDirection.Output;
                cmd.ExecuteNonQuery();
                iRet = cmd.Parameters["v_value"].Value.ToString();
                }
                catch (OracleException  ex)
                {
               
                }
                finally
                {
                    conn.Close();
                    conn = null;
                }
            if (iRet == "-1") return "请输入用户名或密码";
            if (iRet == "0") return "查无此用户";
            return "登陆成功";
        }

存储过程

create or replace procedure mydemo01(username in varchar,
                                     usepwd   in int,
                                     v_value  out number) as
begin
  if (username is null OR usepwd is null) then
    v_value := -1;
    else
      select count(1)
      into v_value
      from emp
     where uname = username
       and upwd = usepwd;
  end if;
end mydemo01;

数据库

create table emp (
 userid number not null,
uname varchar2(20) not null,
upwd varchar2(20) not null
)