powershell连接数据库_使用powershell连接oracle数据库(取值、更新)

在工作中我们常常需要使用powershell连接Oracle数据库。

但是在百度找到的代码都是很老的&＃xff0c;而且还需要oracle数据库连接客户端。查找一番后发现Oracle官方早已经发布了对.net官方连接库&＃xff0c;高效简单。

连接库地址&＃xff1a;

https://www.oracle.com/technetwork/developer-tools/visual-studio/overview/index.html

$AssemblyFile &＃61; "Oracle.ManagedDataAccess.dll"

[Reflection.Assembly]::LoadFile($AssemblyFile)

$username &＃61; "xx"

$password &＃61; "xx"

$datasource &＃61; "192.168.xx.xx/dbname"

$sql &＃61; "SELECT * from xxdb"

$connectionnectionString &＃61; &＃39;User Id&＃61;&＃39; &＃43; $username &＃43; &＃39;;Password&＃61;&＃39; &＃43; $password &＃43; &＃39;;Data Source&＃61;&＃39; &＃43; $datasource

$connectionnection &＃61; New-Object Oracle.ManagedDataAccess.Client.OracleConnection($connectionnectionString)

$connectionnection.open()

$command&＃61;$connection.CreateCommand()

$command.CommandText&＃61;$sql

$da &＃61; New-Object Oracle.ManagedDataAccess.Client.OracleDataAdapter($command)

$builder&＃61;New-Object Oracle.ManagedDataAccess.Client.OracleCommandBuilder($da) #用来更新数据库

$ds &＃61; New-Object system.Data.DataSet [void]$da.fill($ds,"xxdb")

foreach($row in $ds.Tables["xxdb"] )

{

$row["xxFLAG"]&＃61;"1"

$da.Update($ds,"xxdb") #更新数据库

}

$connection.close()