Powershell 操作SQL Server

最新推荐文章于 2024-07-28 18:38:22 发布

我想趣玩

最新推荐文章于 2024-07-28 18:38:22 发布

阅读量1.6k

点赞数

分类专栏： powershell

本文链接：https://blog.csdn.net/iuxin/article/details/46821565

版权

powershell 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

function OPDB{
param(
[alias('f')]$funName,
[alias('q')]$sql
)
$DBHost="服务器地址"
$DBName="数据库名"
$DBUser="账号"
$DBPwd="密码"

$conn = New-Object System.Data.SqlClient.SqlConnection

$sqlconn = "server=$DBHost;uid=$DBUser;pwd=$DBPwd;database=$DBName;charset=gbk"
$conn.ConnectionString=$sqlconn
$conn.open()
$cmd=new-object System.Data.SqlClient.SqlCommand
$cmd.Connection=$conn

#region Set-Data use update and insert
function Set-Data{
  $cmd.CommandText=$sql
  [void]$cmd.ExecuteNonQuery()
}
#endregion
#region Get-Data
function Get-Data{
  $cmd.commandtext=$sql
     $SqlAdapter = New-Object mysql.Data.mySqlClient.mySqlDataAdapter
     $SqlAdapter.SelectCommand = $cmd
     $DataSet = New-Object System.Data.DataSet
     [void]$SqlAdapter.Fill($DataSet,"data")
     return $dataset.tables['data']
}
#endregion
#判断传入值，并执行相应函数
if($funName -eq 'set'){
  Set-Data
}
if($funName -eq 'get'){
  Get-Data
}
$conn.Close()
}