예제 #1
0
        static void TestQuery()
        {
            try
            {
                CubridConnection con = new CubridConnection();
                con.ConnectionString = "server=localhost;database=testdb;port=30000;user=dba;password="******"SELECT * FROM t";
                CubridCommand cmd = new CubridCommand(sql, con);
                DbDataReader reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    Console.Write(reader.GetInt32(0) + " | ");
                    Console.Write(reader.GetString(1) + " | ");
                    Console.Write(reader.GetString(2) + " | ");
                    Console.Write(reader.GetFloat(3) + " | ");
                    Console.Write(reader.GetDouble(4) + " | ");
                    Console.WriteLine(reader.GetDateTime(5));
                }

                cmd.Close();
                con.Close();
            }
            catch (CubridException e)
            {
                Console.WriteLine(e);
            }
        }
예제 #2
0
        static void TestSimple()
        {
            try
            {
                CubridConnection con = new CubridConnection();
                con.ConnectionString = "server=localhost;database=testdb;port=30000;user=dba;password="******"CREATE TABLE t(a int, b char(10), c string, d float, e double, f date)";
                CubridCommand command = new CubridCommand(sql, con);
                command.ExecuteNonQuery();

                command.Close();
                con.Close();
            }
            catch (CubridException e)
            {
                Console.WriteLine(e);
            }
        }
예제 #3
0
        static void TestStoredProcedure()
        {
            try
            {
                CubridConnection con = new CubridConnection();
                con.ConnectionString = "server=localhost;database=testdb;port=30000;user=dba;password="******"CREATE FUNCTION sp1(a int) RETURN string AS LANGUAGE JAVA NAME 'SpTest.test1(int) return java.lang.String'";
                CubridCommand cmd = new CubridCommand(sql, con);
                cmd.ExecuteNonQuery();
                cmd.Close();

                sql = "? = CALL sp1(?)";
                cmd = new CubridCommand(sql, con);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add();
                cmd.Parameters[0].Direction = ParameterDirection.Output;
                cmd.Parameters[0].DbType = DbType.String;

                cmd.Parameters.Add(12345678);
                cmd.Parameters[1].DbType = DbType.Int32;

                cmd.ExecuteNonQuery();
                Console.WriteLine("result: " + cmd.Parameters[0].Value);
                cmd.Close();

                sql = "DROP FUNCTION sp1";
                cmd = new CubridCommand(sql, con);
                cmd.ExecuteNonQuery();
                cmd.Close();

                con.Close();
            }
            catch (CubridException e)
            {
                Console.WriteLine(e);
            }
        }
예제 #4
0
        static void TestTransaction()
        {
            DbTransaction tran = null;

            try
            {
                CubridConnection con = new CubridConnection();
                con.ConnectionString = "server=localhost;database=testdb;port=30000;user=dba;password="******"INSERT INTO t VALUES(?, ?, ?, ?, ?, ?)";
                CubridCommand cmd = new CubridCommand(sql, con);

                cmd.Parameters.Add(1);
                cmd.Parameters[0].DbType = DbType.Int32;

                cmd.Parameters.Add("cubrid");
                cmd.Parameters[1].DbType = DbType.String;

                cmd.Parameters.Add(CubridDataType.String);
                cmd.Parameters[2].Value = "ado.net provider";

                cmd.Parameters.Add(3.14f);
                cmd.Parameters[3].DbType = DbType.Single;

                cmd.Parameters.Add(3.14159253637283645);
                cmd.Parameters[4].DbType = DbType.Double;

                cmd.Parameters.Add(new DateTime());
                cmd.Parameters[5].DbType = DbType.Date;

                cmd.ExecuteNonQuery();

                cmd.Parameters[0].Value = 2;
                cmd.Parameters[1].Value = "open";
                cmd.Parameters[2].Value = "source";
                cmd.Parameters[3].Value = 735626.34f;
                cmd.Parameters[4].Value = 8373625.383635235373;
                cmd.Parameters[5].Value = new DateTime(2008, 12, 24);

                cmd.ExecuteNonQuery();
                tran.Commit();

                cmd.Close();
                con.Close();
            }
            catch (CubridException e)
            {
                tran.Rollback();
                Console.WriteLine(e);
            }
        }
예제 #5
0
        static void TestStoredProcedureResultSet()
        {
            try
            {
                CubridConnection con = new CubridConnection();
                con.ConnectionString = "server=localhost;database=testdb;port=30000;user=dba;password="******"CREATE FUNCTION sp2() RETURN cursor AS LANGUAGE JAVA NAME 'SpTest.test2() return java.sql.ResultSet'";
                CubridCommand cmd = new CubridCommand(sql, con);
                cmd.ExecuteNonQuery();
                cmd.Close();

                sql = "? = CALL sp2()";
                cmd = new CubridCommand(sql, con);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add(CubridDataType.ResultSet);
                cmd.Parameters[0].Direction = ParameterDirection.Output;

                cmd.ExecuteNonQuery();

                DbDataReader reader = (DbDataReader)cmd.Parameters[0].Value;

                while (reader.Read())
                {
                    Console.Write(reader.GetInt32(0) + " | ");
                    Console.Write(reader.GetString(1) + " | ");
                    Console.Write(reader.GetString(2) + " | ");
                    Console.Write(reader.GetFloat(3) + " | ");
                    Console.Write(reader.GetDouble(4) + " | ");
                    Console.WriteLine(reader.GetDateTime(5));
                }

                cmd.Close();

                sql = "DROP FUNCTION sp2";
                cmd = new CubridCommand(sql, con);
                cmd.ExecuteNonQuery();
                cmd.Close();

                con.Close();
            }
            catch (CubridException e)
            {
                Console.WriteLine(e);
            }
        }