获取剪切板中的内容 往数据库中导入数据命令 MD5 执行批处理



 1. 获取剪切板中的内容

           String clipBoardText = null;
            if (Clipboard.ContainsText(TextDataFormat.UnicodeText))
            {
                clipBoardText = Clipboard.GetText(TextDataFormat.UnicodeText);
            }
            else if (Clipboard.ContainsText(TextDataFormat.Rtf))
            {
                clipBoardText = Clipboard.GetText(TextDataFormat.Rtf);

            }
            else if (Clipboard.ContainsText(TextDataFormat.Text))
            {
                clipBoardText = Clipboard.GetText(TextDataFormat.Text);
            }

            char[] sp = new char[5];
            sp[0] = ' ';
            sp[1] = ',';
            sp[2] = '\t';
            sp[3] = '\n';
            sp[4] = '\r';
            if (clipBoardText != null)
            {
                string[] columns = clipBoardText.Split(sp);
                
            }
            else
            {
                MessageBox.Show("不存在粘贴文本!!!");
            }

2. 往数据库中导入数据命令

imp userName/userPwd@ServiceName  file=fileName full=y ignore=y

full:代表是否全部导入  y是  n否； ignore表示是否忽略错误  y是 n否

3. 密码转换成MD5

        private string EncodePassword(string originalPassword)
        {
            Byte[] originalBytes;
            Byte[] encodedBytes;
            MD5 md5;

            md5 = new MD5CryptoServiceProvider();
            originalBytes = ASCIIEncoding.Default.GetBytes(originalPassword);
            encodedBytes = md5.ComputeHash(originalBytes);

            return BitConverter.ToString(encodedBytes);
        }

4. 代码执行批处理程序

        private bool callExcutableBatchFile(string currentFPath)
        {
            try
            {
                System.Diagnostics.Process process = new System.Diagnostics.Process();

                string currentBatFPath = currentFPath + "tmpRestoreData.bat";     //批处理程序文件路径
                if (!File.Exists(currentBatFPath))
                {
                    MessageBox.Show("不存在可执行的批处理文件!!!\n路径为:" + currentBatFPath);
                    return false;
                }

                FileInfo file = new FileInfo(currentBatFPath);
                process.StartInfo.WorkingDirectory = file.Directory.FullName;
                process.StartInfo.FileName = currentBatFPath;
                process.StartInfo.CreateNoWindow = false;
                if (process.Start())
                {
                    process.WaitForExit();
                    if (process.HasExited)
                    {
                        process.Close();
                        process.Dispose();
 
                    }
                }
            }
            catch (Exception ex)
            {
            }
            finally
            { }
        }