CUBRID学习笔记 34 net参数化查询 cubrid教程示例

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34

using CUBRID.Data.CUBRIDClient;   namespace ParameterExample {     class Program     {         static void Main(string[] args)         {             CUBRIDConnectionStringBuilder sb = new CUBRIDConnectionStringBuilder("localhost", "demodb", "public", "", "33000");             using (CUBRIDConnection conn = new CUBRIDConnection(sb.GetConnectionString()))             {                 conn.Open();                 using (CUBRIDCommand cmd = new CUBRIDCommand("create table t(a int, b varchar(20))", conn))                 {                     cmd.ExecuteNonQuery();                 }                   using (CUBRIDCommand cmd = new CUBRIDCommand("insert into t values(?, ?)", conn))                 {                     CUBRIDParameter p1 = new CUBRIDParameter("?p1", CUBRIDDataType.CCI_U_TYPE_INT);                     p1.Value = 1;                     cmd.Parameters.Add(p1);                       CUBRIDParameter p2 = new CUBRIDParameter("?p2", CUBRIDDataType.CCI_U_TYPE_STRING);                     p2.Value = "abc";                     cmd.Parameters.Add(p2);                       cmd.ExecuteNonQuery();                 }                 conn.Close();             }         }     } }

　　

?

1	和net差不多,区别是 CUBRID.Data.CUBRIDClient封装了<br><br><br><br><br><br>

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

using System;   namespace System.Data {     // Summary:     //     Specifies the type of a parameter within a query relative to the System.Data.DataSet.     public enum ParameterDirection     {         // Summary:         //     The parameter is an input parameter.         Input = 1,         //         // Summary:         //     The parameter is an output parameter.         Output = 2,         //         // Summary:         //     The parameter is capable of both input and output.         InputOutput = 3,         //         // Summary:         //     The parameter represents a return value from an operation such as a stored         //     procedure, built-in function, or user-defined function.         ReturnValue = 6,     } }

?

1	<br><br><br><br><br>