windows服務的構成 在你類后面所包含的代碼里，你會注意到你所創建的windows服務擴充了system.serviceprocess.service類。所有以.net方式建立的windows服務必須擴充這個類。它會要求你的服務重載下面的方法，visual studio默認時包括了這些方法。 • dispose – 清除任何受控和不受控資源(managed and unmanaged resources) • onstart – 控制服務啟動 • onstop – 控制服務停止 數據庫表腳本樣例 在這個例子中使用的數據庫表是使用下面的t-sql腳本創建的。我選擇sql server數據庫。你可以很容易修改這個例子讓它在access或任何你所選擇的別的數據庫下運行。 create table [dbo].[myservicelog] ( [in_logid] [int] identity (1, 1) not null, [vc_status] [nvarchar] (40) collate sql_latin1_general_cp1_ci_as not null, [dt_created] [datetime] not null ) on [primary]
windows服務樣例 下面就是我命名為myservice的windows服務的所有源代碼。大多數源代碼是由visual studio自動生成的。 using system; using system.collections; using system.componentmodel; using system.data; using system.data.sqlclient; using system.diagnostics; using system.serviceprocess; namespace codeguru.mywindowsservice { public class myservice : system.serviceprocess.servicebase { private system.timers.timer timer1; /// <remarks> /// required designer variable. /// </remarks> private system.componentmodel.container components = null; public myservice() { // this call is required by the windows.forms // component designer. initializecomponent(); } // the main entry point for the process static void main() { system.serviceprocess.servicebase[] servicestorun;
servicestorun = new system.serviceprocess.servicebase[] { new myservice() }; system.serviceprocess.servicebase.run(servicestorun); } /// <summary> /// required method for designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void initializecomponent() { this.timer1 = new system.timers.timer(); ((system.componentmodel.isupportinitialize) (this.timer1)).begininit(); // // timer1 // this.timer1.interval = 30000; this.timer1.elapsed += new system.timers.elapsedeventhandler(this.timer1_elapsed); // // myservice // this.servicename = "my sample service"; ((system.componentmodel.isupportinitialize) (this.timer1)).endinit(); } /// <summary> /// clean up any resources being used. /// </summary> protected override void dispose( bool disposing ) { if( disposing ) { if (components != null) { components.dispose(); } } base.dispose( disposing ); } /// <summary> /// set things in motion so your service can do its work. /// </summary> protected override void onstart(string[] args) { this.timer1.enabled = true; this.logmessage("service started"); }
/// <summary> /// stop this service. /// </summary> protected override void onstop() { this.timer1.enabled = false; this.logmessage("service stopped"); } /* * respond to the elapsed event of the timer control */ private void timer1_elapsed(object sender, system.timers.elapsedeventargs e) { this.logmessage("service running"); } /* * log specified message to database */ private void logmessage(string message) { sqlconnection connection = null; sqlcommand command = null; try { connection = new sqlconnection( "server=localhost;database=sampledatabase;integrated security=false;user id=sa;password=;"); command = new sqlcommand( "insert into myservicelog (vc_status, dt_created) values (’" + message + "’,getdate())", connection); connection.open(); int numrows = command.executenonquery(); } catch( exception ex ) { system.diagnostics.debug.writeline(ex.message); } finally { command.dispose(); connection.dispose(); } } } }
