PS的世界——连接mysql数据库执行查询操作

带p图功能的脚本我写不来。
它只是单纯的PowerShell
需要先下载安装 mysql connector/net

1. 准备环境

[void][system.Reflection.Assembly]::LoadFrom("C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.12\Assemblies\v4.5.2\MySql.Data.dll") 
$Server="localhost"
$Database="zixun"
$user="root" 
$Password= "hir3H4o0ot" 
$charset="utf8"
$None = "None"
$connectionString = "server=$Server;uid=$user;pwd=$Password;database=$Database;charset=$charset;SslMode=$None"
$connection = New-Object MySql.Data.MySqlClient.MySqlConnection($connectionString)

3. 执行查询

$connection.Open()

$insert  = "select * from zixun.ctpstock where ID='I50153';"
$insertcommand = New-Object MySql.Data.MySqlClient.MySqlCommand
$mysqlDataSet = New-Object System.Data.DataSet
$adapter = new-object  MySql.Data.MySqlClient.MySqlDataAdapter
$insertcommand.Connection=$connection
$insertcommand.CommandText=$insert
$adapter.SelectCommand=$insertcommand

$nSet = $adapter.Fill($mysqldataset,"data")
foreach($x in $mysqlDataSet.Tables[0]){
    write-host $x.ID  $x.cqyzDate $x.GP  
}

$connection.Close()