The update operation

The update operation is as follows. The UpdateCustomer method takes the Customer parameter and creates a prepared statement for the UPDATE statement. The statement is used to update a customer row in the table:

// Update Customer method with parameter customer
func UpdateCustomer(customer Customer){
 var database *sql.DB
 database= GetConnection()
 var error error
 var update *sql.Stmt
 update,error = database.Prepare("UPDATE CUSTOMER SET CustomerName=?, SSN=? WHERE CustomerId=?")
 if error != nil {
 panic(error.Error())
 } 
      update.Exec(customer.CustomerName,customer.SSN,customer.CustomerId)
defer database.Close()
}
// main method
func main() {
 var customers []Customer
 customers = GetCustomers()
 fmt.Println("Before Update",customers)
 var customer Customer
 customer.CustomerName = "George Thompson"
 customer.SSN = "23233432"
 customer.CustomerId = 5
 UpdateCustomer(customer)
 customers = GetCustomers()
 fmt.Println("After Update",customers)
}

Run the following commands:

go run database_operations.go

The following screenshot displays the output:

Let's take a look at the delete operation in the next section.