アリンコネット – あるSEのログ2

------------------------------------------------------------------------------
CrystalMark Result
------------------------------------------------------------------------------
   Display Mode : 1024 x 768 32bit (ClearType) 

    CrystalMark :   88823 

[ ALU ]             25598
      Fibonacci :    9941
      Napierian :    4976
   Eratosthenes :    3656
      QuickSort :    7003
[ FPU ]             21080
        MikoFPU :     992
     RandMeanSS :   10607
            FFT :    4918
     Mandelbrot :    4541
[ MEM ]             17753
           Read : 8218.19 MB/s (  8218)
          Write : 2265.68 MB/s (  2265)
     Read/Write : 2235.04 MB/s (  2235)
          Cache : 50133.05 MB/s (  5013)
[ HDD ]             12291
           Read :   79.59 MB/s (  3183)
          Write :   80.16 MB/s (  3206)
 RandomRead512K :   43.32 MB/s (  1732)
RandomWrite512K :   75.25 MB/s (  3010)
 RandomRead 64K :    9.40 MB/s (   376)
RandomWrite 64K :   19.62 MB/s (   784)
[ GDI ]              2487
           Text :     525
         Square :     290
         Circle :    1472
         BitBlt :     200
[ D2D ]              8475
   Sprite    10 :  116.95 FPS  (    11)
   Sprite   100 :  111.28 FPS  (   111)
   Sprite   500 :  132.77 FPS  (   663)
   Sprite  1000 :  118.05 FPS  (  1180)
   Sprite  5000 :   62.67 FPS  (  3133)
   Sprite 10000 :   33.77 FPS  (  3377)
[ OGL ]              1139
  Scene 1 Score :    1091
  Lines (x1000) : ( 138861)
  Scene 1  CPUs : (     32)
  Scene 2 Score :      48
Polygons(x1000) : (    338)
  Scene 2  CPUs : (      1) 

------------------------------------------------------------------------------
System Information
------------------------------------------------------------------------------
             OS : Windows NT6.1 Ultimate Edition  [6.1 Build 7100]
   Display Mode : 1024 x 768 32bit 85Hz
         Memory : 2048 MB
        DirectX : 10.0
------------------------------------------------------------------------------
CPU
------------------------------------------------------------------------------
       CPU Name : Intel Xeon (Woodcrest)
  Vendor String : GenuineIntel
    Name String : Intel(R) Xeon(R) CPU            5160  @ 3.00GHz
       Platform : LGA771
       CPU Type : Original OEM processor
Number(Logical) : 2
         Family : 6
          Model : F
       Stepping : 6
        Feature : MMX SSE SSE2 SSE3 SSSE3 XD VT Intel 64
          Clock : 3000.88 MHz
      Data Rate :    QDR 

     L1 I-Cache :   32 KB
     L1 D-Cache :   32 KB
       L2 Cache : 4096 KB [Full:3000.88 MHz]
------------------------------------------------------------------------------
Device
------------------------------------------------------------------------------
        ChipSet : Intel 440BX/ZX/DX
          North : Intel 82443BX/ZX/DX
          South : Intel 82371AB/EB/MB (PIIX4)
          Video : VMware SVGA II
 IDE Controller :
------------------------------------------------------------------------------
HDD
------------------------------------------------------------------------------
Type Size    Model                                  ( Buffer Mode )

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using IBM.Data.DB2.iSeries;

namespace DB2Test
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            const string CN_STRING_DB2 = "DataSource=(ホスト名);USERID=(ユーザー名);PASSWORD=(パスワード);";

            StringBuilder sqlbldr = new StringBuilder();
            sqlbldr.AppendLine("select");
            sqlbldr.AppendLine("    COUNT(*)");
            sqlbldr.AppendLine("FROM");
            sqlbldr.AppendLine("    TESTLIB.TEST");


            using (iDB2Connection cn = new iDB2Connection(CN_STRING_DB2))
            {
                cn.Open();
                iDB2Command cmd = cn.CreateCommand();
                cmd.CommandText = sqlbldr.ToString();
                using (iDB2DataAdapter da = new iDB2DataAdapter(cmd))
                {
                    DataTable dt = new DataTable();
                    dt.Locale = System.Globalization.CultureInfo.InvariantCulture;
                    da.Fill(dt);

                    dataGridView1.DataSource = dt;
                }
            }
        }
    }
}

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using MySql.Data;
using MySql.Data.MySqlClient;

namespace MySqlTest
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {

            const string CN_STRING_MYSQL = "Persist Security Info=False;database=(インスタンス名);server=(サーバー);port=(ポート);user id=(ユーザー名);pwd=(パスワード)";

            System.Text.StringBuilder sqlbldr = new System.Text.StringBuilder();
            sqlbldr.AppendLine("select");
            sqlbldr.AppendLine("    COUNT(*)");
            sqlbldr.AppendLine("FROM");
            sqlbldr.AppendLine("    test");

            using (MySqlConnection cn = new MySqlConnection(CN_STRING_MYSQL))
            {
                cn.Open();
                MySqlCommand cmd = cn.CreateCommand();
                cmd.CommandText = sqlbldr.ToString();
                using (MySqlDataAdapter da = new MySqlDataAdapter(cmd))
                {
                    DataTable dt = new DataTable();
                    dt.Locale = System.Globalization.CultureInfo.InvariantCulture;
                    da.Fill(dt);

                    dataGridView1.DataSource = dt;
                }
            }

            
        }
    }
}