using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.OracleClient; namespace CallStoredProcedure { /* * 创建新Passport的存储过程 */ class RegisterAccount { private OracleConnection conn = null; private OracleCommand cmd = null; /// <summary>初始化参数 /// </summary> /// <param name="passPort"></param> /// <param name="passWord"></param> /// <param name="ipAddress"></param> private void InitParam(string passPort, string passWord) { Console.WriteLine("创建-> Account:" + passPort + "/t Password:" + passWord); logger.Info("创建-> Account:" + passPort + "/t Password:" + passWord); //返回值 cmd.Parameters.Add("result", OracleType.Number); cmd.Parameters["result"].Direction = ParameterDirection.ReturnValue; //帐号 cmd.Parameters.Add("s_account", OracleType.VarChar); cmd.Parameters["s_account"].Direction = ParameterDirection.Input; cmd.Parameters["s_account"].Value = passPort; //密码 /*固定值不变了*/ cmd.Parameters.Add("s_password", OracleType.VarChar); cmd.Parameters["s_password"].Direction = ParameterDirection.Input; cmd.Parameters["s_password"].Value = passWord; } /// <summary>添加帐号 /// </summary> /// <param name="accountName">要添加的帐号名</param> /// <returns></returns> public void RegisterAccounts(List<string> accountName) { /*连接数据库*/ var mConn = "Data Source=passport;User Id=passportdba;Password=passportdba;"; conn = new OracleConnection(mConn); try { conn.Open(); //Oracle数据库Function var queryString = "paysys.account"; cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = queryString;//声明存储过程名 cmd.Connection = conn; InitParam("BBB123456",123456); cmd.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.Message); } finally { conn.Close(); } } } }