Interstage Shunsaku Data Manager Application Development Guide - Microsoft(R) Windows(R) 2000/ Microsoft(R) Windows Server(TM) 2003 - - UNIX -
|
Contents
Index

|
G.2.2 Deleting Data
The following example shows how the C# .NET are used to delete data.
'I want to delete the data relating to Hotel 9 from the hotels in Adelaide that have a vacancy on 2006/07/18.'
Perform a search using the date (2006/07/18) and location (Adelaide) as conditions, then delete data whose name matches "Hotel 9".
An Example of Using the APIs
The following is a sample program using the C# .NET.
using System;
using Fujitsu.Shunsaku;
class SampleDelete {
static public void Main( string[] args ) {
ShunService service = null;
try {
// Create ShunService
service = new ShunService();
// Connect Shunsaku by specifying the host name and port number
service.Host = "DirSvr1";
service.Port = 33101;
service.Connect();
// Create ShunSearchRequirement
ShunSearchRequirement req = new ShunSearchRequirement();
// Set each type of search conditions
req.QueryExpression = "/document/base/city == 'Adelaide' AND /document/information/date == '2006/07/18'";
req.ReturnExpression = "/document/base/name/text()";
req.ReplyNumber = 1;
req.RequestCount = 30;
// Specify the search condition and execute the search
ShunResultSet rs = service.Search( req );
// Create ShunRecordCollection for deleting data
ShunRecordCollection deleteRecords = new ShunRecordCollection();
// Obtain the record of Hotel 9
foreach ( ShunRecord record in rs.Records ) {
if ( record.Data == "Hotel 9" ) {
deleteRecords.Add( record );
}
}
// Delete the data if acquisition of the corresponding record is successful
if ( deleteRecords.Count > 0 ) {
service.Delete( deleteRecords );
Console.WriteLine( "Deletion complete" );
}
// Close the connection to Shunsaku
service.Disconnect();
}
catch ( ShunContinuousException e ) {
// Processing to perform if ShunContinuousException occurs
try {
if( service != null && service.State == ShunConnectionState.Open ) {
service.Disconnect();
}
}
catch ( ShunException ex ) {
Console.WriteLine("Error message : {0}", ex.Message );
}
Console.WriteLine("Error message : {0}", e.Message );
}
catch ( ShunConnectionTerminatedException e ) {
// Processing to perform if ShunConnectionTerminatedException occurs
Console.WriteLine("Error message : {0}", e.Message );
}
}
} |
Execution Results
All Rights Reserved, Copyright(C) FUJITSU LIMITED 2006