using?System;
using?System.Collections;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Data.OracleClient;
using?System.Drawing;
using?System.IO;
using?System.Linq;
using?System.Runtime.CompilerServices;
using?System.Text;
using?System.Threading;
using?System.Threading.Tasks;
using?System.Windows.Forms;
using?Microsoft.Office.Interop.Word;

namespace?Expert_For_Oracle
{
????public?partial?class?Form1?:?Form
????{
????????public?string?ConnectionString
????????{
????????????get?{?return?this.textBox1.Text;?}
????????}

????????string?sql?=?“??select?*?from?（SELECT?t1.Table_Name???AS?\“Table_Name\““
????????????????+?“????t1.Column_Name??AS?\“Column_Name\““
????????????????+?“???t1.Data_Type????AS?\“Data_Type\““
????????????????+?“???t1.Data_Length??AS?\“Data_Length\““
????????????????+?“???t1.NullAble?????AS?\“NullAble\““
????????????????+?“???t2.Comments?????AS?\“Comments\““
????????????????+?“???t1.Data_Default?\“Data_Default\““
????????????????+?“???FROM?cols?t1“
????????????????+?“???left?join?user_col_comments?t2“
????????????????+?“???on?t1.Table_name?=?t2.Table_name“
????????????????+?“???and?t1.Column_Name?=?t2.Column_Name“
????????????????+?“???left?join?user_tab_comments?t3“
????????????????+?“???on?t1.Table_name?=?t3.Table_name“
????????????????+?“???WHERE?NOT?EXISTS?（SELECT?t4.object_Name“
????????????????+?“??????????FROM?User_objects?t4“
????????????????+?“??????????WHERE?t4.object_Type?=?‘TABLE‘“
????????????????+?“???????????AND?t4.Temporary?=?‘Y‘“
????????????????+?“???????????AND?t4.object_Name?=?t1.Table_Name）“
????????????????+?“??ORDER?BY?t1.Table_Name?t1.Column_ID）?k“
????????????????+?“??where?k.\“Table_Name\“?=?“;
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????????this.Load?+=?Form1_Load;
????????????this.button1.Click?+=?button1_Click;
????????????this.button2.Click?+=?button2_Click;
????????}

????????void?button2_Click（object?sender?EventArgs?e）
????????{
????????????OracleConnection?conn?=?new?OracleConnection（ConnectionString）;//創(chuàng)建一個(gè)新連接
????????????try
????????????{
????????????????conn.Open（）;
????????????}
????????????catch?（Exception?ee）
????????????{
????????????????MessageBox.Show（“連接失敗！“）;
????????????????return;
????????????}
????????????conn.Close（）;?//關(guān)閉連接
????????????MessageBox.Show（“連接成功！“）;

????????}

????????void?button1_Click（object?sender?EventArgs?e）
????????{
????????????Thread?thread?=?new?Thread（new?ThreadStart（delegate（）
????????????{
????????????????int?finsh?=?0;
????????????????var?dt?=?GetAllTableName（）.Tables[0];
????????????????for?（int?i?=?0;?i?????????????????{
????????????????????this.BeginInvoke（new?Action（（）?=>
????????????????????{
????????????????????????this.lbl.Text?=?“共：“?+?dt.Rows.Count?+?“?張表，已經(jīng)導(dǎo)出：“?+?i?+?“?張表“;
????????????????????}））;
????????????????????var?tableName?=?dt.Rows[i][“TABLE_NAME“

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????目錄???????????0??2017-08-30?10:25??Expert?For?Oracle\
?????目錄???????????0??2017-08-30?10:25??Expert?For?Oracle\Expert?For?Oracle\
?????文件?????????187??2015-04-20?09:43??Expert?For?Oracle\Expert?For?Oracle\App.config
?????文件????????4090??2015-04-20?10:53??Expert?For?Oracle\Expert?For?Oracle\Expert?For?Oracle.csproj
?????文件????????5768??2015-04-20?11:48??Expert?For?Oracle\Expert?For?Oracle\Form1.Designer.cs
?????文件????????8235??2015-04-20?11:48??Expert?For?Oracle\Expert?For?Oracle\Form1.cs
?????文件????????5817??2015-04-20?11:48??Expert?For?Oracle\Expert?For?Oracle\Form1.resx
?????文件?????????529??2015-04-20?09:43??Expert?For?Oracle\Expert?For?Oracle\Program.cs
?????目錄???????????0??2017-08-30?10:25??Expert?For?Oracle\Expert?For?Oracle\Properties\
?????文件????????1376??2015-04-20?09:43??Expert?For?Oracle\Expert?For?Oracle\Properties\AssemblyInfo.cs
?????文件????????2886??2015-04-20?09:43??Expert?For?Oracle\Expert?For?Oracle\Properties\Resources.Designer.cs
?????文件????????5612??2015-04-20?09:43??Expert?For?Oracle\Expert?For?Oracle\Properties\Resources.resx
?????文件????????1104??2015-04-20?09:43??Expert?For?Oracle\Expert?For?Oracle\Properties\Settings.Designer.cs
?????文件?????????249??2015-04-20?09:43??Expert?For?Oracle\Expert?For?Oracle\Properties\Settings.settings
?????目錄???????????0??2017-08-30?10:25??Expert?For?Oracle\Expert?For?Oracle\bin\
?????目錄???????????0??2017-08-30?10:25??Expert?For?Oracle\Expert?For?Oracle\bin\Debug\
?????文件???????24576??2015-04-20?11:48??Expert?For?Oracle\Expert?For?Oracle\bin\Debug\Expert?For?Oracle.exe
?????文件?????????187??2015-04-20?09:43??Expert?For?Oracle\Expert?For?Oracle\bin\Debug\Expert?For?Oracle.exe.config
?????文件???????30208??2015-04-20?11:48??Expert?For?Oracle\Expert?For?Oracle\bin\Debug\Expert?For?Oracle.pdb
?????文件???????24224??2015-04-20?15:59??Expert?For?Oracle\Expert?For?Oracle\bin\Debug\Expert?For?Oracle.vshost.exe
?????文件?????????187??2015-04-20?09:43??Expert?For?Oracle\Expert?For?Oracle\bin\Debug\Expert?For?Oracle.vshost.exe.config
?????目錄???????????0??2017-11-23?15:01??Expert?For?Oracle\Expert?For?Oracle\bin\Release\
?????目錄???????????0??2017-08-30?10:25??Expert?For?Oracle\Expert?For?Oracle\obj\
?????目錄???????????0??2017-08-30?10:25??Expert?For?Oracle\Expert?For?Oracle\obj\Debug\
?????文件?????????865??2015-04-20?09:43??Expert?For?Oracle\Expert?For?Oracle\obj\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件????????7212??2015-04-20?10:44??Expert?For?Oracle\Expert?For?Oracle\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件?????????753??2015-04-20?15:59??Expert?For?Oracle\Expert?For?Oracle\obj\Debug\Expert?For?Oracle.csproj.FileListAbsolute.txt
?????文件?????????977??2015-04-20?11:48??Expert?For?Oracle\Expert?For?Oracle\obj\Debug\Expert?For?Oracle.csproj.GenerateResource.Cache
?????文件????????5722??2015-04-20?10:53??Expert?For?Oracle\Expert?For?Oracle\obj\Debug\Expert?For?Oracle.csprojResolveAssemblyReference.cache
?????文件???????24576??2015-04-20?11:48??Expert?For?Oracle\Expert?For?Oracle\obj\Debug\Expert?For?Oracle.exe
?????文件???????30208??2015-04-20?11:48??Expert?For?Oracle\Expert?For?Oracle\obj\Debug\Expert?For?Oracle.pdb
............此處省略8個(gè)文件信息