Contenidos
Servidor inserta datos en MySQL
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
##Server $port=2020 $endpoint = new-object System.Net.IPEndPoint ([IPAddress]::Any,$port) $udpclient=new-Object System.Net.Sockets.UdpClient $port $content=$udpclient.Receive([ref]$endpoint) $valoresalmacenar=[Text.Encoding]::ASCII.GetString($content) [void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data") $Connection = New-Object MySql.Data.MySqlClient.MySqlConnection $ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"estado" $Connection.ConnectionString = $ConnectionString $Connection.Open() $Query = 'INSERT INTO Persons (PersonID,LastName,FirstName,Address,City,Estado) VALUES ('+$valoresalmacenar+')' $Query $Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection) $DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command) $DataSet = New-Object System.Data.DataSet $RecordCount = $dataAdapter.Fill($dataSet, "data") $DataSet.Tables[0] $Connection.Close() $udpclient.Close() |
Cliente que manda datos que instará el servidor
|
1 2 3 4 5 6 7 |
##Client $port=2020 $endpoint = new-object System.Net.IPEndPoint ([IPAddress]::Loopback,$port) $udpclient=new-Object System.Net.Sockets.UdpClient $b=[Text.Encoding]::ASCII.GetBytes('"2","Grillo","Pepito","Castellana","Berlin","1"') $bytesSent=$udpclient.Send($b,$b.length,$endpoint) $udpclient.Close() |
Ver los valores insertados en la tabla de la base de datos
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data") $Connection = New-Object MySql.Data.MySqlClient.MySqlConnection $ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"estado" $Connection.ConnectionString = $ConnectionString $Connection.Open() $Query='select PersonID,FirstName,Estado from Persons' $Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection) $DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command) $DataSet = New-Object System.Data.DataSet $RecordCount = $dataAdapter.Fill($dataSet, "data") $DataSet.Tables[0] $Connection.Close() |
