博客园-msn㊣Microshaoft.comnaIBnaiM nOracle (大舌头) I Love download EditPlus.v3.11(340)!

X509 static RSACryptoServiceProvider 高并发加解密

Microshaoft — Fri, 19 Jun 2009 08:24:00 GMT


/*
makecert.exe -n "CN=Microshaoft X509 Test - A" -sky exchange -pe -sv a.pvk a.cer
pvk2pfx.exe -pvk a.pvk -spc a.cer -pfx a.pfx -f -po 123
makecert.exe -n "CN=Microshaoft X509 Test - B" -sky exchange -pe -sv b.pvk b.cer
pvk2pfx.exe -pvk b.pvk -spc b.cer -pfx b.pfx -f -po abc
*/
namespace ConsoleApplication
{
    using System;
    using System.IO;
    using System.Text;
    using System.Threading;
    using System.Security.Cryptography;
    using System.Security.Cryptography.X509Certificates;
    public class Class1
    {
        static void Main(string[] args)
        {
            encryptorPrivateKeyPfxProvider = encryptorPrivateKeyPfx.PrivateKey as RSACryptoServiceProvider;
            encryptorPublicKeyCerProvider = encryptorPublicKeyCer.PublicKey.Key as RSACryptoServiceProvider;
            decryptorPublicKeyCerProvider = decryptorPublicKeyCer.PublicKey.Key as RSACryptoServiceProvider;
            decryptorPrivateKeyPfxProvider = decryptorPrivateKeyPfx.PrivateKey as RSACryptoServiceProvider;
            for (int i = 0 ; i < 2000 ; i++)
            {
                ThreadStart ts = new ThreadStart(Run);
                Thread t = new Thread(ts);
                t.Name = _ThreadID.ToString();
                _ThreadID ++;
                t.Start();
                //Run();
            }
        
        }
        private static volatile int _ThreadID = 0;
        private static object _syncLockObject = new object();
        private static X509Certificate2 encryptorPrivateKeyPfx = new X509Certificate2(@"a.pfx", "123");
        private static X509Certificate2 encryptorPublicKeyCer = new X509Certificate2(@"a.cer");
        private static X509Certificate2 decryptorPublicKeyCer = new X509Certificate2(@"b.cer");
        private static X509Certificate2 decryptorPrivateKeyPfx = new X509Certificate2(@"b.pfx", "abc");
        private static RSACryptoServiceProvider encryptorPrivateKeyPfxProvider = null;
        private static RSACryptoServiceProvider encryptorPublicKeyCerProvider = null;
        private static RSACryptoServiceProvider decryptorPublicKeyCerProvider = null;
        private static RSACryptoServiceProvider decryptorPrivateKeyPfxProvider = null;
        static void Run()
        {
            //
            // TODO: 在此处添加代码以启动应用程序
            //
            string s = "原明文原明文原明文原明文原明文原明文原明文原明文原明文";
            byte[] data = Encoding.UTF8.GetBytes(s);
            byte[] signature;
            bool DoOAEPadding = false;
            bool verifyed = false;
///            X509Certificate2 encryptorPrivateKeyPfx = null;
///            X509Certificate2 encryptorPublicKeyCer = null;
///            X509Certificate2 decryptorPublicKeyCer = null;
///            X509Certificate2 decryptorPrivateKeyPfx = null;
            try
            {
///                encryptorPrivateKeyPfx = new X509Certificate2(@"a.pfx", "123");
///                encryptorPublicKeyCer = new X509Certificate2(@"a.cer");
///                decryptorPublicKeyCer = new X509Certificate2(@"b.cer");
///                decryptorPrivateKeyPfx = new X509Certificate2(@"b.pfx", "abc");
                //using (RSACryptoServiceProvider decryptorPublicKeyCerProvider = decryptorPublicKeyCer.PublicKey.Key as RSACryptoServiceProvider)
                {
                    //加密
                    data = decryptorPublicKeyCerProvider.Encrypt(data, DoOAEPadding);
                }
                byte[] hash = new SHA1CryptoServiceProvider().ComputeHash(data);
                //using (RSACryptoServiceProvider encryptorPrivateKeyPfxProvider = encryptorPrivateKeyPfx.PrivateKey as RSACryptoServiceProvider)
                {
                    //签名
                    signature = encryptorPrivateKeyPfxProvider.SignHash(hash, "SHA1");
                }
                //using (RSACryptoServiceProvider encryptorPublicKeyCerProvider = encryptorPublicKeyCer.PublicKey.Key as RSACryptoServiceProvider)
                {
                    //验签
                    verifyed = encryptorPublicKeyCerProvider.VerifyHash(hash, "SHA1", signature);
                }
                //using (RSACryptoServiceProvider decryptorPrivateKeyPfxProvider = decryptorPrivateKeyPfx.PrivateKey as RSACryptoServiceProvider)
                {
                    //解密
                    data = decryptorPrivateKeyPfxProvider.Decrypt(data, DoOAEPadding);
                }
                s = Encoding.UTF8.GetString(data);
                Console.WriteLine("{0},{1},{2}", Thread.CurrentThread.Name, verifyed, s);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.ToString());
            }
            finally
            {
///                if (encryptorPrivateKeyPfx != null)
///                {
///                    encryptorPrivateKeyPfx.Reset();
///                }
///                if (encryptorPublicKeyCer != null)
///                {
///                    encryptorPublicKeyCer.Reset();
///                }
///                if (decryptorPublicKeyCer != null)
///                {
///                    decryptorPublicKeyCer.Reset();
///                }
            }
        }
    }
}

--------------------------
新闻：IBM发布全球首款开源智能编译器
网站导航: 博客园首页新闻 .NET频道社区博问闪存找找看

EditPlus 于 2009-06-02 升级到 v3.11(340)

Microshaoft — Mon, 08 Jun 2009 15:35:00 GMT

What's
Version 3.11(Build 340)

* 'Send PWD after each interval' FTP option.
* Allows custom file filter on the Directory Window.
* 'Save current file' option for user tool setting.
* 'FTP account' option on the Project dialog box.
* 'Directory name' option in the Project dialog box.
* Upload dialog box accepts drag and drop.
* 'Undo/Redo All' commands ('Edit'->'Clipboard').
* 'Delete Empty Lines' command ('Edit'->'Delete').
* 'Delete Duplicated Lines' command ('Edit'->'Delete').
* Supports syntax highlighting of backup files.
* Allows multiple selections on the Output Window.
* 'Import/Export' button on the 'Set Directories' dialog box.
* Adds color option for the Cliptext/directory window.
* Increases user tool button to 20.
* Toolbar button for 'Close Others'.

* Cancel button on the FTP transfer screen works immediately.
* Directory Window did not work with certain file extensions.
* Displays 'Remove Leading Spaces' command in the popup menu too.

--------------------------
新闻：IE颓势不减微软下月公布最新浏览器架构
网站导航: 博客园首页新闻 .NET频道社区博问闪存找找看

EncodingHelper Identify Encoding by BOM

Microshaoft — Sat, 23 May 2009 05:26:00 GMT


namespace Microshaoft
{
    using System.IO;
    using System.Text;
    using System.Collections.Generic;
    public static class EncodingHelper
    {
        public static Encoding IdentifyEncoding
                                    (
                                        Stream stream
                                        , Encoding defaultEncoding
                                        , Encoding[] identifyEncodings
                                    )
        {
            byte[] data = StreamDataHelper.ReadDataToBytes(stream);
            return IdentifyEncoding
                        (
                            data
                            , defaultEncoding
                            , identifyEncodings
                        );
        }
        public static Encoding IdentifyEncoding
                                    (
                                        Stream stream
                                        , Encoding defaultEncoding
                                    )
        {
            byte[] data = StreamDataHelper.ReadDataToBytes(stream);
            return IdentifyEncoding
                        (
                            data
                            , defaultEncoding
                        );
        }
        public static Encoding IdentifyEncoding
                                    (
                                        byte[] data
                                        , Encoding defaultEncoding
                                    )
        {
            EncodingInfo[] encodingInfos = Encoding.GetEncodings();
            List<Encoding> list = new List<Encoding>();
            foreach (EncodingInfo info in encodingInfos)
            {
                Encoding e = info.GetEncoding();
                if (e.GetPreamble().Length > 0)
                {
                    list.Add(e);
                    System.Console.WriteLine(e.EncodingName);
                }
            }
            Encoding[] encodings = new Encoding[list.Count];
            list.CopyTo(encodings);
            return IdentifyEncoding
                        (
                            data
                            , defaultEncoding
                            , encodings
                        );
        }
        public static Encoding IdentifyEncoding
                                    (
                                        byte[] data
                                        , Encoding defaultEncoding
                                        , Encoding[] identifyEncodings
                                    )
        {
            Encoding encoding = defaultEncoding;
            foreach (Encoding e in identifyEncodings)
            {
                byte[] buffer = e.GetPreamble();
                int l = buffer.Length;
                if (l == 0)
                {
                    continue;
                }
                bool flag = false;
                for (int i = 0; i < l; i++)
                {
                    if (buffer[i] != data[i])
                    {
                        flag = true;
                        break;
                    }
                }
                if (flag)
                {
                    continue;
                }
                else
                {
                    encoding = e;
                }
            }
            return encoding;
        }
    }
}
namespace Microshaoft
{
    using System.IO;
    public static class StreamDataHelper
    {
        public static byte[] ReadDataToBytes(Stream stream)
        {
            byte[] buffer = new byte[64 * 1024];
            MemoryStream ms = new MemoryStream();
            int r = 0;
            int l = 0;
            long position = -1;
            if (stream.CanSeek)
            {
                position = stream.Position;
                stream.Position = 0;
            }
            while (true)
            {
                r = stream.Read(buffer, 0, buffer.Length);
                if (r > 0)
                {
                    l += r;
                    ms.Write(buffer, 0, r);
                }
                else
                {
                    break;
                }
            }
            byte[] bytes = new byte[l];
            ms.Position = 0;
            ms.Read(bytes, 0, (int) l);
            ms.Close();
            ms.Dispose();
            ms = null;
            if (position >= 0)
            {
                stream.Position = position;
            }
            return bytes;
        }
    }
}

--------------------------
新闻：竞争日趋激烈微软欲借 Windows 7 扭转战局
网站导航: 博客园首页新闻 .NET频道社区博问闪存找找看

FindPrivateKey X509

Microshaoft — Tue, 19 May 2009 15:02:00 GMT


namespace Microsoft.ChannelSDK.Tools.FindPrivateKey
{
    using System;
    using System.IO;
    using System.Security.Cryptography.X509Certificates;
    using System.Runtime.InteropServices;
    class FindPrivateKey
    {
        static void PrintHelp()
        {
            Console.WriteLine("FindPrivateKey helps user to find the location of the Private Key file of a X.509 Certificate.");
            Console.WriteLine("Usage: FindPrivateKey   [{ {-n } | {-t } } [-f | -d | -a]]");
            Console.WriteLine("        subject name of the certificate");
            Console.WriteLine("         thumbprint of the certificate (use certmgr.exe to get it)");
            Console.WriteLine("       -f            output file name only");
            Console.WriteLine("       -d            output directory only");
            Console.WriteLine("       -a            output absolute file name");
            Console.WriteLine("e.g. FindPrivateKey My CurrentUser -n \"CN=John Doe\"");
            Console.WriteLine("e.g. FindPrivateKey My LocalMachine -t \"03 33 98 63 d0 47 e7 48 71 33 62 64 76 5c 4c 9d 42 1d 6b 52\" -a");
        }
        static void Main(string[] args)
        {            
            if (args.Length < 2 || args.Length == 3 || args.Length > 5 
                || (args.Length > 2 && args[2] != "-n" && args[2] != "-t")
                || (args.Length == 5 && args[4] != "-f" && args[4] != "-d" && args[4] != "-a"))
            {
                PrintHelp();
                return;
            }
            try
            {
                StoreName storeName = (StoreName)Enum.Parse(typeof(StoreName), args[0], true);
                StoreLocation storeLocation = (StoreLocation)Enum.Parse(typeof(StoreLocation), args[1], true);
                X509Certificate2 cert;
                if (args.Length > 2)
                {
                    // insert a comma followed by a space for store.Certificates.Find(findType, key, false) 
                    // to successful find the certificate
                    string key = args[3];
                    string[] keys = key.Split(',');
                    key = string.Empty;
                    for (int i = 0; i < keys.Length; i++)
                    {
                        key += keys[i];
                        if ( i != keys.Length -1 )
                         key += ", ";
                    }
                    if (args[2] == "-n")
                        cert = LoadCertificate(storeName, storeLocation, key, X509FindType.FindBySubjectDistinguishedName);
                    else
                        cert = LoadCertificate(storeName, storeLocation, key, X509FindType.FindByThumbprint);
                }
                else
                {
                    cert = SelectCertificate(storeName, storeLocation);
                    if (cert == null)
                        return;
                }
                string privateKeyFile = GetKeyFileName(cert);
                string privateKeyDirectory = GetKeyFileDirectory(privateKeyFile);
                if (args.Length == 5)
                {
                    if (args[4] == "-f")
                        Console.WriteLine(privateKeyFile);
                    else if (args[4] == "-d")
                        Console.WriteLine(privateKeyDirectory);
                    else
                        Console.WriteLine("a:{0}\\{1}", privateKeyDirectory, privateKeyFile);
                }
                else
                {
                    Console.WriteLine("Private key directory:");
                    Console.WriteLine(privateKeyDirectory);
                    Console.WriteLine("Private key file name:");
                    Console.WriteLine(privateKeyFile);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("FindPrivateKey failed for the following reason:");
                Console.WriteLine(ex.Message);
                Console.WriteLine("\nUse /? option for help");
            }
        }
        static X509Certificate2 SelectCertificate(StoreName storeName, StoreLocation storeLocation)
        {
            X509Certificate2 result;
            X509Store store = new X509Store(storeName, storeLocation);
            store.Open(OpenFlags.ReadOnly);
            try
            {
                X509Certificate2Collection matches;
                matches = X509Certificate2UI.SelectFromCollection(store.Certificates, "Select certificate", "Select the certificate to find the location of the associated private key file:", X509SelectionFlag.SingleSelection);
                if (matches.Count != 1)
                    result = null;
                else
                    result = matches[0];
            }
            finally
            {
                store.Close();
            }
            return result;
        }
        static X509Certificate2 LoadCertificate(StoreName storeName, StoreLocation storeLocation, string key, X509FindType findType)
        {
            X509Certificate2 result;
            X509Store store = new X509Store(storeName, storeLocation);
            store.Open(OpenFlags.ReadOnly);
            try
            {
                X509Certificate2Collection matches;
                matches = store.Certificates.Find(findType, key, false);
                if (matches.Count > 1)
                    throw new InvalidOperationException(String.Format("More than one certificate with key '{0}' found in the store.", key));
                if (matches.Count == 0)
                    throw new InvalidOperationException(String.Format("No certificates with key '{0}' found in the store.", key));
                result = matches[0];
            }
            finally
            {
                store.Close();
            }
            return result;
        }
        static string GetKeyFileName(X509Certificate2 cert)
        {
            IntPtr            hProvider     = IntPtr.Zero; // CSP handle
            bool              freeProvider  = false;       // Do we need to free the CSP ?
            uint               acquireFlags  = 0;
            int                  _keyNumber = 0;
            string              keyFileName = null;
            byte[]              keyFileBytes = null;
            //
            // Determine whether there is private key information available for this certificate in the key store
            //
            if ( CryptAcquireCertificatePrivateKey(cert.Handle,
                acquireFlags,
                IntPtr.Zero,
                ref hProvider,
                ref _keyNumber,
                ref freeProvider) )
            {
                IntPtr pBytes  = IntPtr.Zero; // Native Memory for the CRYPT_KEY_PROV_INFO structure
                int    cbBytes = 0;           // Native Memory size
                try
                {
                    if ( CryptGetProvParam(hProvider, CryptGetProvParamType.PP_UNIQUE_CONTAINER, IntPtr.Zero, ref cbBytes, 0) )
                    {
                        pBytes = Marshal.AllocHGlobal(cbBytes);
                        if ( CryptGetProvParam(hProvider, CryptGetProvParamType.PP_UNIQUE_CONTAINER, pBytes, ref cbBytes, 0) )
                        {
                            keyFileBytes = new byte[cbBytes];
                            Marshal.Copy(pBytes,keyFileBytes,0,cbBytes);
                            // Copy eveything except tailing null byte
                            keyFileName = System.Text.Encoding.ASCII.GetString(keyFileBytes, 0, keyFileBytes.Length-1);
                        }
                    }        
                }
                finally
                {
                    if ( freeProvider )
                        CryptReleaseContext(hProvider,0);
                    //
                    // Free our native memory
                    //
                    if ( pBytes != IntPtr.Zero )
                        Marshal.FreeHGlobal(pBytes);
                }
            }
            if (keyFileName == null)
                throw new InvalidOperationException("Unable to obtain private key file name");
            return keyFileName;
        }
        static string GetKeyFileDirectory(string keyFileName)
        {
            // Look up All User profile from environment variable
            string allUserProfile = System.Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData);
            // set up searching directory
            string machineKeyDir = allUserProfile + "\\Microsoft\\Crypto\\RSA\\MachineKeys";
            // Seach the key file
            string[] fs = System.IO.Directory.GetFiles(machineKeyDir, keyFileName);
            // If found
            if (fs.Length > 0)
                return machineKeyDir;
            // Next try current user profile
            string currentUserProfile = System.Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData);
            // seach all sub directory
            string userKeyDir = currentUserProfile + "\\Microsoft\\Crypto\\RSA\\";
            fs = System.IO.Directory.GetDirectories(userKeyDir);
            if (fs.Length > 0)
            {
                // for each sub directory
                foreach (string keyDir in fs)
                {
                    fs = System.IO.Directory.GetFiles(keyDir, keyFileName);
                    if (fs.Length == 0)
                        continue;
                    else
                        // found
                        return keyDir;
                }
            }
            throw new InvalidOperationException("Unable to locate private key file directory");
        }
        [DllImport("crypt32", CharSet = CharSet.Unicode, SetLastError = true)]
        internal extern static bool CryptAcquireCertificatePrivateKey(IntPtr pCert, uint dwFlags, IntPtr pvReserved, ref IntPtr phCryptProv, ref int pdwKeySpec, ref bool pfCallerFreeProv);
        [DllImport("advapi32", CharSet = CharSet.Unicode, SetLastError = true)]
        internal extern static bool CryptGetProvParam(IntPtr hCryptProv, CryptGetProvParamType dwParam, IntPtr pvData, ref int pcbData, uint dwFlags);
        [DllImport("advapi32", SetLastError = true)]
        internal extern static bool CryptReleaseContext(IntPtr hProv, uint dwFlags);
    }
    enum CryptGetProvParamType
    {
        PP_ENUMALGS = 1,
        PP_ENUMCONTAINERS = 2,
        PP_IMPTYPE = 3,
        PP_NAME = 4,
        PP_VERSION = 5,
        PP_CONTAINER = 6,
        PP_CHANGE_PASSWORD = 7,
        PP_KEYSET_SEC_DESCR = 8,       // get/set security descriptor of keyset
        PP_CERTCHAIN = 9,      // for retrieving certificates from tokens
        PP_KEY_TYPE_SUBTYPE = 10,
        PP_PROVTYPE = 16,
        PP_KEYSTORAGE = 17,
        PP_APPLI_CERT = 18,
        PP_SYM_KEYSIZE = 19,
        PP_SESSION_KEYSIZE = 20,
        PP_UI_PROMPT = 21,
        PP_ENUMALGS_EX = 22,
        PP_ENUMMANDROOTS = 25,
        PP_ENUMELECTROOTS = 26,
        PP_KEYSET_TYPE = 27,
        PP_ADMIN_PIN = 31,
        PP_KEYEXCHANGE_PIN = 32,
        PP_SIGNATURE_PIN = 33,
        PP_SIG_KEYSIZE_INC = 34,
        PP_KEYX_KEYSIZE_INC = 35,
        PP_UNIQUE_CONTAINER = 36,
        PP_SGC_INFO = 37,
        PP_USE_HARDWARE_RNG = 38,
        PP_KEYSPEC = 39,
        PP_ENUMEX_SIGNING_PROT = 40,
        PP_CRYPT_COUNT_KEY_USE = 41,
    }
}

--------------------------
新闻：上海电信计划2012年80%用户实现100M带宽
网站导航: 博客园首页新闻 .NET频道社区博问闪存找找看

CryptoHelper X509/RSA/TripleDes/Hash/MD5/SHA1 (Release 2)

Microshaoft — Tue, 19 May 2009 14:59:00 GMT

摘要: /*makecert.exe -n "CN=Microshaoft X509 Test - A" -sky exchange -pe -sv a.pvk a.cerpvk2pfx.exe -pvk a.pvk -spc a.cer -pfx a.pfx -f -po 123makecert.exe -n "CN=Microshaoft X509 Test - B&qu 阅读全文

--------------------------
新闻：上海电信计划2012年80%用户实现100M带宽
网站导航: 博客园首页新闻 .NET频道社区博问闪存找找看

Smtp Client LinkedResource AlternateView

Microshaoft — Mon, 11 May 2009 15:24:00 GMT


namespace ConsoleApplication
{
    using System;
    using System.Net;
    using System.Net.Mail;
    using System.Net.Mime;
    public class Class1
    {
        static void Main(string[] args)
        {
            string html = "";
            html += "中国字";
            html += "
";
            AlternateView view = AlternateView.CreateAlternateViewFromString(html, null, MediaTypeNames.Text.Html);
            LinkedResource picture = new LinkedResource(@"pic.JPG", MediaTypeNames.Image.Jpeg);
            picture.ContentId = "attachment1";
            view.LinkedResources.Add(picture);
            LinkedResource script = new LinkedResource(@"a.js", MediaTypeNames.Text.Plain);
            script.ContentId = "attachment2";
            view.LinkedResources.Add(script);
            MailMessage mail = new MailMessage();
            mail .AlternateViews.Add(view);
            mail.From = new MailAddress("xxxx@gmail.com", "Microshaoft-gmail");
            mail.To.Add(new MailAddress("yyyy@live.com", "Microshaoft-live"));
            mail.Subject = "Linked Resource Attachment Alternate Views Smtp Client Test " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            SmtpClient client = new SmtpClient("smtp.gmail.com");
            client.Credentials = new NetworkCredential("user","password");
            client.EnableSsl = true;
            client.Send(mail);
            Console.WriteLine("Hello World");
            Console.WriteLine(Environment.Version.ToString());
        }
    }
}

--------------------------
新闻：数万名网友签名抗议星际争霸2取消局域网功能
网站导航: 博客园首页新闻 .NET频道社区博问闪存找找看

Trace Soap Messages Logger SoapExtension

Microshaoft — Mon, 11 May 2009 03:55:00 GMT


namespace Microshaoft
{
    using System;
    using System.IO;
    using System.Web.Services.Protocols;
    using System.Configuration;
    public class TraceSoapMessagesLoggerSoapExtension : SoapExtension
    {
        private Stream _originalStream;
        private Stream _workStream;
        private string _filePath;
        public override Stream ChainStream(Stream stream)
        {
            _originalStream = stream;
            _workStream = new MemoryStream();
            return _workStream;
        }
        public override object GetInitializer(LogicalMethodInfo methodInfo, SoapExtensionAttribute attribute)
        {
            //return ((TraceExtensionAttribute)attribute).Filename;
            return null;
        }
        private static string _SoapMessagesLogPath = ConfigurationManager.AppSettings["SoapMessagesLogPath"];
        public override object GetInitializer(Type WebServiceType)
        {
            // Return a file name to log the trace information to, based on the
            // type.
            if (!_SoapMessagesLogPath.EndsWith(@"\"))
            {
                _SoapMessagesLogPath += @"\";
            }
            return _SoapMessagesLogPath + WebServiceType.FullName + ".{0}.{1}.log";
        }
        // Receive the file name stored by GetInitializer and store it in a
        // member variable for this specific instance.
        public override void Initialize(object initializer)
        {
            _filePath = (string) initializer;
        }
        public override void ProcessMessage(SoapMessage message)
        {
            switch (message.Stage)
            {
                case SoapMessageStage.BeforeSerialize:
                    break;
                case SoapMessageStage.AfterSerialize:
                    WriteStream();
                    break;
                case SoapMessageStage.BeforeDeserialize:
                    ReadStream();
                    break;
                case SoapMessageStage.AfterDeserialize:
                    break;
                default:
                    throw new Exception("invalid stage");
            }
        }
        public void WriteStream()
        {
            _workStream.Position = 0;
            byte[] buffer = ReadStreamToBytes(_workStream);
            TextReader reader = new StreamReader(_workStream);
            string s = reader.ReadToEnd();
            WriteLog(s, "response", _filePath);
            _originalStream.Write(buffer, 0, buffer.Length);
        }
        public void ReadStream()
        {
            //解压 请求
            byte[] bytes = ReadStreamToBytes(_originalStream);
            TextReader reader = new StreamReader(_originalStream);
            string s = reader.ReadToEnd();
            WriteLog(s, "request", _filePath);
            _workStream.Write(bytes, 0, bytes.Length);
            _workStream.Position = 0;
        }
        private static void WriteLog(string data, string title, string filePath)
        {
            string path = Path.GetDirectoryName(filePath);
            if (!Directory.Exists(path))
            {
                Directory.CreateDirectory(path);
            }
            string fileName = string.Format(filePath, title, DateTime.Now.ToString("yyyy-MM-dd.HH"));
            using (FileStream fs = new FileStream
                                        (
                                            fileName
                                            , FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite
                                         )
                    )
            {
                StreamWriter w = new StreamWriter(fs);
                w.BaseStream.Seek(0, SeekOrigin.End);
                w.WriteLine(title + "Begin===========" + DateTime.Now);
                w.Flush();
                w.WriteLine(data);
                w.WriteLine(title + "End=============");
                w.Flush();
                w.Close();
            }
        }
        public static byte[] ReadStreamToBytes(Stream stream)
        {
            byte[] buffer = new byte[64 * 1024];
            int r = 0;
            int l = 0;
            long position = -1;
            if (stream.CanSeek)
            {
                position = stream.Position;
                stream.Position = 0;
            }
            MemoryStream ms = new MemoryStream();
            while (true)
            {
                r = stream.Read(buffer, 0, buffer.Length);
                if (r > 0)
                {
                    l += r;
                    ms.Write(buffer, 0, r);
                }
                else
                {
                    break;
                }
            }
            byte[] bytes = new byte[l];
            ms.Position = 0;
            ms.Read(bytes, 0, (int) l);
            ms.Close();
            ms = null;
            if (position >= 0)
            {
                stream.Position = position;
            }
            return bytes;
        }
    }
    [AttributeUsage(AttributeTargets.Method)]
    public class TraceSoapMessagesLoggerSoapExtensionAttribute : SoapExtensionAttribute
    {
        private int _priority;
        public override int Priority
        {
            get
            {
                return _priority;
            }
            set
            {
                _priority = value;
            }
        }
        public override Type ExtensionType
        {
            get
            {
                return typeof(TraceSoapMessagesLoggerSoapExtension);
            }
        }
    }
}

--------------------------
新闻：数万名网友签名抗议星际争霸2取消局域网功能
网站导航: 博客园首页新闻 .NET频道社区博问闪存找找看

一道 SQL 面试题

Microshaoft — Sun, 03 May 2009 04:19:00 GMT

这是我在2002年左右,给公司出的一道SQL面试大题,前10(1~10)问,允许应考者充分准备不必现场作答,
后3(11~13)问要求应考者现场作答。当年被面试的人,对题目褒贬不一。

作为命题者(准确的说其中一些题目应该是我从一些经典的SQL考试题派生出来的),我的初衷还是主要考察
关系运算、集合运算相关的SQL查询语法知识的,能轻松应答的人,我个人认为,应该算是一个颇有"SQL查询"编写经验,
或者说熟练掌握了"SQL DML语法"的开发人员了。
,然而在实际工作中,虽然"一句蔚为壮观的SQL" 实现了 "功能",但是这 "一句SQL" 究竟执行的 "性能" 如何呢?
我想提醒读者,这些题目的答案不一定适用在实际的工作中。

一些参考答案及分析过几天贴出来。

有兴趣的网友可以在线回复作答一下，讨论一下

二维关系表 T(F1,F2,F3,F4,F5,F6,F7) 表示如下关系:
┌─────┬─────┬─────┬─────┬─────┬─────┬─────┐
│ 学生ID │ 学生姓名 │ 课程ID │ 课程名称 │   成绩   │ 教师ID │ 教师姓名 │
├─────┼─────┼─────┼─────┼─────┼─────┼─────┤
│    S3    │   王五   │    K4    │   政治   │    53    │    T4    │ 赵老师 │
├─────┼─────┼─────┼─────┼─────┼─────┼─────┤
│    S1    │   张三   │    K1    │   数学   │    61    │    T1    │ 张老师 │
├─────┼─────┼─────┼─────┼─────┼─────┼─────┤
│    S2    │   李四   │    K3    │   英语   │    88    │    T3    │ 李老师 │
├─────┼─────┼─────┼─────┼─────┼─────┼─────┤
│    S1    │   张三   │    K4    │   政治   │    77    │    T4    │ 赵老师 │
├─────┼─────┼─────┼─────┼─────┼─────┼─────┤
│    S2    │   李四   │    K4    │   政治   │    67    │    T5    │ 周老师 │
├─────┼─────┼─────┼─────┼─────┼─────┼─────┤
│    S3    │   王五   │    K2    │   语文   │    90    │    T2    │ 王老师 │
├─────┼─────┼─────┼─────┼─────┼─────┼─────┤
│    S3    │   王五   │    K1    │   数学   │    55    │    T1    │ 张老师 │
├─────┼─────┼─────┼─────┼─────┼─────┼─────┤
│    S1    │   张三   │    K2    │   语文   │    81    │    T2    │ 王老师 │
├─────┼─────┼─────┼─────┼─────┼─────┼─────┤
│    S4    │   赵六   │    K2    │   语文   │    59    │    T1    │ 王老师 │
├─────┼─────┼─────┼─────┼─────┼─────┼─────┤
│    S1    │   张三   │    K3    │   英语   │    37    │    T3    │ 李老师 │
├─────┼─────┼─────┼─────┼─────┼─────┼─────┤
│    S2    │   李四   │    K1    │   数学   │    81    │    T1    │ 张老师 │
├─────┼─────┼─────┼─────┼─────┼─────┼─────┤
│   ....   │          │          │          │          │          │          │
├─────┼─────┼─────┼─────┼─────┼─────┼─────┤
│   ....   │          │          │          │          │          │          │
└─────┴─────┴─────┴─────┴─────┴─────┴─────┘

请以一句 T-SQL (Ms SQL Server 2000) 或 Jet SQL (Ms Access) 作答!
1.如果 T 表还有一字段 F0 数据类型为自动增量整型(唯一,不会重复),
而且 T 表中含有除 F0 字段外,请删除其它字段完全相同的重复多余的脏记录数据(要保留其中的一条):

2.查询列印各科成绩最高和最低的记录: (就是各门课程的最高、最低分的学生和老师)
课程ID,课程名称,最高分,学生ID,学生姓名,教师ID,教师姓名,最低分,学生ID,学生姓名,教师ID,教师姓名

3.按成绩从高到低顺序,查询列印所有学生四门(数学,语文,英语,政治)课程成绩: (就是每个学生的四门课程的成绩单)
学生ID,学生姓名,数学,语文,英语,政治,有效课程数,有效平均分
(注: 有效课程即在 T 表中有该学生的成绩记录,如不明白可不列印"有效课程数"和"有效平均分")

4.查询列印数学成绩第 10 名到第 15 名的学生成绩单
或列印平均成绩第 10 名到第 15 名的学生成绩单
[学生ID],[学生姓名],数学,语文,英语,政治,平均成绩

5.按各科不及格率的百分数从低到高和平均成绩从高到低顺序,查询统计列印各科平均成绩和不及格率的百分数(用"N行"表示): (就是分析哪门课程难)
课程ID,课程名称,平均成绩,及格百分数

6.查询列印四门课程平均成绩和及格率的百分数(用"1行4列"表示): (就是分析哪门课程难)
数学平均分,数学及格百分数,语文平均分,语文及格百分数,英语平均分,英语及格百分数,政治平均分,政治及格百分数

7.按不同老师所教不同课程平均分从高到低,查询列印: (就是分析哪个老师的哪个课程水平高)
教师ID,教师姓名,课程ID,课程名称,平均分 (平均分按去掉一个最高分和一个最低分后取)

8.查询统计列印各科成绩,各分数段人数:
课程ID,课程名称,[100-85],[85-70],[70-60],[<60]

9.查询列印学生平均成绩及其名次

10.查询列印各科成绩前三名的记录:(不考虑成绩并列情况)
学生ID,学生姓名,课程ID,课程名称,成绩,教师ID,教师姓名

11.查询列印参加了所有考试科目的学生

12.查询列印"至少"与学生"S3 (王五)"参加了相同考试科目的学生

13.规范化

--------------------------
新闻：Silverlight打造杰克逊纪念专题
网站导航: 博客园首页新闻 .NET频道社区博问闪存找找看

Xml/Binary SerializerHelper and XmlReader read xml node/attribute on foward-only sequential

Microshaoft — Thu, 30 Apr 2009 16:24:00 GMT

摘要: namespace Test{ using System; using System.IO; using System.Text; using System.Xml; using System.Xml.Serialization; using Test.Share; using Microshaoft; public class Class1 { static void Main(string[] 阅读全文

--------------------------
新闻：传诺基亚正在开发Android手机
网站导航: 博客园首页新闻 .NET频道社区博问闪存找找看

Console Win32 API Native Methods Helper

Microshaoft — Fri, 27 Mar 2009 17:33:00 GMT

摘要: namespace ConsoleApplication{ using System; using Microshaoft; ///

/// Class1 的摘要说明。 ///

public class Class1 { ///

/// 应用程序的主入口点。 ///

阅读全文

--------------------------
新闻：7月编程语言排行榜
网站导航: 博客园首页新闻 .NET频道社区博问闪存找找看