CREATE TABLE SCOTT.ADMIN ("NAME" VARCHAR2(20) NOT NULL,
"PASSWORD" VARCHAR2(20) NOT NULL) TABLESPACE "EXAMPLE"
2、创建验证用户登录的存储过程
CREATE OR REPLACE PROCEDURE "SCOTT"."P_LOGIN" (v_Name varchar2,
v_Password varchar2,b_Passed out char) as
n_Count number;
begin
select count(*) into n_Count from admin where name=v_Name and password=v_Password;
if n_Count > 0 then
b_Passed:='1';
else
b_Passed:='0';
end if;
end;
3、在Sql Plus等sql工具中使用PL/SQL测试存储过程是否可用:
set serveroutput on;
declare
v_Name varchar2(20);
v_password varchar(20);
b_Passed char(1);
begin
v_Name:='mxh';
v_Password:='mxh';
p_Login(v_Name,v_Password,b_Passed);
if b_Passed ='1' then
DBMS_OUTPUT.PUT_LINE('SUCCESS');
end if;
end;
4、创建一个登录窗口,实验C#对存储过程的调用:
(1)编写数据访问类,用于访问和操作数据库:
//DataAccess.cs
using System;
using System.Data;
using System.Data.OracleClient;
namespace OraLoginProcedure
{
public class DataAccess
{
private string connStr="data source=yourdb;User Id=scott;Password=scott;";
private OracleConnection conn=null;
public DataAccess()
{
}
public DataAccess(string strConnection)
{
this.connStr=strConnection;
}