1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 | #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 tabla autores ################################### $Query = 'INSERT INTO autor (nombre, apellidos, nacionalidad, fechanacimiento) values ("Luis", "Cereijo", "Español", "1982-01-10")' $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] $Query2 = 'INSERT INTO autor (nombre, apellidos, nacionalidad, fechanacimiento) values ("Pablo", "Ferrer", "Español", "1986-02-20")' $Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query2, $Connection) $DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command) $DataSet = New-Object System.Data.DataSet $RecordCount = $dataAdapter.Fill($dataSet, "data") $DataSet.Tables[0] $Query3 = 'INSERT INTO autor (nombre, apellidos, nacionalidad, fechanacimiento) values ("Carlos", "Molina", "Español", "1979-09-25")' $Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query3, $Connection) $DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command) $DataSet = New-Object System.Data.DataSet $RecordCount = $dataAdapter.Fill($dataSet, "data") $DataSet.Tables[0] $Query4 = 'INSERT INTO autor (nombre, apellidos, nacionalidad, fechanacimiento) values ("Julio", "Rey", "Español", "1979-03-03")' $Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query4, $Connection) $DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command) $DataSet = New-Object System.Data.DataSet $RecordCount = $dataAdapter.Fill($dataSet, "data") $DataSet.Tables[0] $Query5 = 'INSERT INTO autor (nombre, apellidos, nacionalidad, fechanacimiento) values ("Anna", "Tod", "Estadounidense", "1968-04-17")' $Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query5, $Connection) $DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command) $DataSet = New-Object System.Data.DataSet $RecordCount = $dataAdapter.Fill($dataSet, "data") $DataSet.Tables[0] $Query6 = 'INSERT INTO autor (nombre, apellidos, nacionalidad, fechanacimiento) values ("Massimo", "Alfaro", "Italiano", "1980-12-15")' $Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query6, $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() |
