Ejercicios de MySQL: insertar datos en la tabla libro de la base de datos librería | Scripting and security

#Realizado por Santiago Candamil

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection
$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" +  ";database="+"libreria"
$Connection.ConnectionString = $ConnectionString
$Connection.Open()

###################################
#Insertar en la tabla libro
###################################

$Query = 'insert into libro (titulo, IDautor, añoedicion, CIFeditorial, precio, nejemplares, ISBN) values("SOM",6,2011,"C12345678",25,3,"9540615377117");'
$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]

$Query1 = 'insert into libro (titulo, IDautor, añoedicion, CIFeditorial, precio, nejemplares, ISBN) values("SOR",5,2012,"C12345678",30,4,"6896369875304");'
$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query1, $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()

#Realizado por Santiago Candamil

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")

$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection

$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"libreria"

$Connection.ConnectionString = $ConnectionString

$Connection.Open()

###################################

#Insertar en la tabla libro

###################################

$Query = 'insert into libro (titulo, IDautor, añoedicion, CIFeditorial, precio, nejemplares, ISBN) values("SOM",6,2011,"C12345678",25,3,"9540615377117");'

$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]

$Query1 = 'insert into libro (titulo, IDautor, añoedicion, CIFeditorial, precio, nejemplares, ISBN) values("SOR",5,2012,"C12345678",30,4,"6896369875304");'

$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query1, $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()

CATEGORÍAS

Bases de datos, PowerShell

ETIQUETAS

Connection, data, Insert, Libro, LoadWithPartialName, MySQL, New-Object, pwd, Reflection.Assembly, Santiago Candamil, Server, System.Reflection.Assembly

CATEGORÍAS

ETIQUETAS

MÁS