20 lines
545 B
Plaintext
20 lines
545 B
Plaintext
use IO;
|
|
use ODBC;
|
|
|
|
bundle Default {
|
|
class Sql {
|
|
function : Main(args : String[]) ~ Nil {
|
|
conn := Connection->New("ds", "user", "password");
|
|
if(conn <> Nil) {
|
|
sql := "UPDATE players SET name = ?, score = ?, active = ? WHERE jerseyNum = ?";
|
|
pstmt := conn->CreateParameterStatement(sql);
|
|
pstmt->SetVarchar(1, "Smith, Steve");
|
|
pstmt->SetInt(2, 42);
|
|
pstmt->SetBit(3, true);
|
|
pstmt->SetInt(4, 99);
|
|
pstmt->Update()->PrintLine();
|
|
conn->Close();
|
|
};
|
|
}
|
|
}
|