在Visual Studio2017中使用Windows Service访问MySQL数据库

using System.ServiceProcess;
using MySql.Data.MySqlClient;

namespace MyService
{
    public partial class Service1 : ServiceBase
    {
        private MySqlConnection connection;
        private MySqlCommand command;

        public Service1()
        {
            InitializeComponent();
        }

        protected override void OnStart(string[] args)
        {
            string connectionString = "server=服务器地址;user id=用户名;password=密码;database=数据库名";
            connection = new MySqlConnection(connectionString);
            command = connection.CreateCommand();

            // 打开数据库连接
            connection.Open();

            // 执行查询
            command.CommandText = "SELECT * FROM 表名";
            MySqlDataReader reader = command.ExecuteReader();

            // 处理查询结果
            while (reader.Read())
            {
                // 处理每一行数据
                string column1 = reader.GetString(0);
                string column2 = reader.GetString(1);
                // ...
            }

            // 关闭数据库连接
            reader.Close();
            connection.Close();
        }

        protected override void OnStop()
        {
            // 停止服务时关闭数据库连接
            if (connection != null && connection.State == System.Data.ConnectionState.Open)
            {
                connection.Close();
            }
        }
    }
}