返回顶部
分享到

基于PyQt5实现的Windows定时关机工具

Mysql 来源:互联网 作者:佚名 发布时间:2025-05-24 23:05:14 人浏览
摘要

在日常使用电脑的过程中,我们经常会遇到需要定时关机的场景,比如: 夜间下载文件,想让电脑在任务完成后自动关机。 长时间运行的程序,需要在某个时间点关闭系统。 限制电脑使用时

在日常使用电脑的过程中,我们经常会遇到需要定时关机的场景,比如:

  • 夜间下载文件,想让电脑在任务完成后自动关机。
  • 长时间运行的程序,需要在某个时间点关闭系统。
  • 限制电脑使用时间,避免长时间占用资源。

虽然 Windows 自带 shutdown 命令可以定时关机,但操作方式较为繁琐,缺乏可视化界面。因此,本篇文章将带大家实现一个基于 PyQt5 的 Windows 定时关机工具,支持定时或延时关机、重启、注销,并提供系统托盘功能,方便随时管理关机任务。

 

功能介绍

本工具主要具备以下功能:

定时关机 —— 设定具体时间,到点自动关机。

延时关机 —— 设置倒计时,倒计时结束后自动关机。

重启 & 注销 —— 除关机外,还可执行系统重启和注销操作。

取消操作 —— 关机前可随时取消,避免误操作。

系统托盘支持 —— 运行后最小化到系统托盘,不影响日常操作。

人性化提示 —— 关机前弹出提醒,避免突发关机。

 

代码实现

 

1. 安装依赖

在运行代码之前,我们需要先安装 PyQt5 库:

1

pip install PyQt5 pyqt5-tools

 

2. 代码编写

以下是完整的代码实现:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

import sys

import os

import time

from PyQt5.QtWidgets import QApplication, QWidget, QLabel, QPushButton, QVBoxLayout, QTimeEdit, QSystemTrayIcon, QMenu, QAction

from PyQt5.QtGui import QIcon

from PyQt5.QtCore import QTimer, QTime

 

class ShutdownApp(QWidget):

    def __init__(self):

        super().__init__()

        self.initUI()

 

    def initUI(self):

        self.setWindowTitle('Windows 定时关机工具')

        self.setGeometry(600, 300, 300, 200)

         

        self.label = QLabel('请选择关机时间:', self)

        self.timeEdit = QTimeEdit(self)

        self.timeEdit.setDisplayFormat("HH:mm")

         

        self.startButton = QPushButton('设置关机', self)

        self.startButton.clicked.connect(self.scheduleShutdown)

         

        self.cancelButton = QPushButton('取消关机', self)

        self.cancelButton.clicked.connect(self.cancelShutdown)

         

        layout = QVBoxLayout()

        layout.addWidget(self.label)

        layout.addWidget(self.timeEdit)

        layout.addWidget(self.startButton)

        layout.addWidget(self.cancelButton)

         

        self.setLayout(layout)

         

        # 托盘功能

        self.trayIcon = QSystemTrayIcon(QIcon("icon.png"), self)

        trayMenu = QMenu()

        exitAction = QAction("退出", self)

        exitAction.triggered.connect(self.close)

        trayMenu.addAction(exitAction)

        self.trayIcon.setContextMenu(trayMenu)

        self.trayIcon.show()

 

    def scheduleShutdown(self):

        shutdown_time = self.timeEdit.time()

        current_time = QTime.currentTime()

        seconds = current_time.secsTo(shutdown_time)

         

        if seconds <= 0:

            self.label.setText("请选择一个未来的时间!")

            return

         

        self.label.setText(f"关机已设置,将在 {shutdown_time.toString()} 执行")

        os.system(f'shutdown -s -t {seconds}')

 

    def cancelShutdown(self):

        os.system('shutdown -a')

        self.label.setText("关机已取消!")

 

if __name__ == '__main__':

    app = QApplication(sys.argv)

    ex = ShutdownApp()

    ex.show()

    sys.exit(app.exec_())

 

功能使用

 

1. 运行软件

1

python shutdown_tool.py

 

2. 设置定时关机

  • 选择时间
  • 点击 “设置关机”
  • 程序将计算剩余时间,并执行关机命令

 

3. 取消关机

  • 如果想取消定时关机,点击 “取消关机” 按钮
  • 也可以手动在命令行执行:

1

shutdown -a

 

4. 系统托盘

  • 运行后可最小化到托盘
  • 右键点击托盘图标可 退出应用

 

技术要点解析

 

关机命令

Windows 提供 shutdown 命令来执行关机任务:

  • 定时关机:

1

shutdown -s -t 秒数

  • 取消关机:

1

shutdown -a

 

计算关机时间

我们使用 QTime 计算当前时间到设定时间的 秒数,避免时间计算错误:

1

seconds = current_time.secsTo(shutdown_time)

 

托盘图标支持

使用 QSystemTrayIcon 实现最小化到托盘:

1

self.trayIcon = QSystemTrayIcon(QIcon("icon.png"), self)

这样即使窗口关闭,应用仍能在后台运行。

 

运行效果

 

相关源码

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

418

419

420

421

422

423

424

425

426

427

428

429

430

431

432

433

434

435

436

437

438

439

440

441

442

443

444

445

446

447

448

449

450

451

452

453

454

455

456

457

458

459

460

461

462

463

464

465

466

467

468

469

470

471

import os

import sys

import time

import configparser

import win32api

import win32con

from datetime import datetime, timedelta

from PyQt5.QtWidgets import (QApplication, QMainWindow, QWidget, QVBoxLayout, QHBoxLayout,

                            QGroupBox, QRadioButton, QDateTimeEdit, QLabel, QPushButton,

                            QCheckBox, QSystemTrayIcon, QMenu, QMessageBox, QSpacerItem,

                            QSizePolicy, QFrame)

from PyQt5.QtCore import Qt, QTimer, QDateTime, QTime, QSize, QSharedMemory

from PyQt5.QtGui import QIcon, QFont, QPalette, QColor

 

def resource_path(relative_path):

    """ 获取资源的绝对路径,适用于开发环境和PyInstaller单文件模式 """

    if hasattr(sys, '_MEIPASS'):

        # PyInstaller创建的临时文件夹

        return os.path.join(sys._MEIPASS, relative_path)

    return os.path.join(os.path.abspath('.'), relative_path)

 

class ShutdownApp(QMainWindow):

    def __init__(self):

        super().__init__()

        self.task_running = False

        self.config_file = os.path.join(os.getenv('APPDATA'), 'shutdown_config.ini')

        self.first_show = True  # 用于跟踪是否是第一次显示

         

        self.setup_ui_style()

        self.init_ui()

        self.load_config()

         

        # 系统托盘

        self.tray_icon = QSystemTrayIcon(self)

        self.tray_icon.setIcon(QIcon(resource_path("icon.ico")))

        self.tray_icon.setToolTip("定时关机")

        self.tray_icon.activated.connect(self.tray_icon_activated)

         

        # 托盘菜单

        self.tray_menu = QMenu()

        self.show_action = self.tray_menu.addAction("显示")

        self.exit_action = self.tray_menu.addAction("退出")

        self.show_action.triggered.connect(self.show_normal)

        self.exit_action.triggered.connect(self.confirm_exit)

        self.tray_icon.setContextMenu(self.tray_menu)

        self.tray_icon.show()  # 确保托盘图标显示

         

        # 显示当前时间

        self.timer = QTimer(self)

        self.timer.timeout.connect(self.update_current_time)

        self.timer.start(1000)

         

        # 剩余时间计时器

        self.countdown_timer = QTimer(self)

        self.countdown_timer.timeout.connect(self.update_remaining_time)

     

    def setup_ui_style(self):

        """设置全局UI样式"""

        self.setStyleSheet("""

            QMainWindow {

                background-color: #f5f5f5;

            }

            QGroupBox {

                border: 1px solid #ccc;

                border-radius: 4px;

                margin-top: 10px;

                padding-top: 15px;

                font-weight: bold;

                color: #333;

            }

            QGroupBox::title {

                subcontrol-origin: margin;

                left: 10px;

                padding: 0 3px;

            }

            QRadioButton, QCheckBox {

                color: #444;

            }

            QPushButton {

                background-color: #4CAF50;

                color: white;

                border: none;

                padding: 8px 16px;

                border-radius: 4px;

                min-width: 80px;

            }

            QPushButton:hover {

                background-color: #45a049;

            }

            QPushButton:disabled {

                background-color: #cccccc;

            }

            QPushButton#cancel_btn {

                background-color: #f44336;

            }

            QPushButton#cancel_btn:hover {

                background-color: #d32f2f;

            }

            QDateTimeEdit {

                padding: 5px;

                border: 1px solid #ddd;

                border-radius: 4px;

            }

            QLabel#current_time_label {

                font-size: 16px;

                color: #333;

                padding: 5px;

                background-color: #e9f5e9;

                border-radius: 4px;

            }

            QLabel#remaining_time_label {

                font-size: 16px;

                color: #d32f2f;

                font-weight: bold;

                padding: 5px;

                background-color: #f9e9e9;

                border-radius: 4px;

            }

        """)

     

    def init_ui(self):

        self.setWindowTitle("定时关机")

        self.setWindowIcon(QIcon(resource_path("icon.ico")))

        self.resize(300, 440)

         

        # 主窗口布局

        main_widget = QWidget()

        self.setCentralWidget(main_widget)

        layout = QVBoxLayout(main_widget)

        layout.setContentsMargins(12, 12, 12, 12)

        layout.setSpacing(10)

         

        # 当前时间显示

        self.current_time_label = QLabel()

        self.current_time_label.setAlignment(Qt.AlignCenter)

        self.current_time_label.setObjectName("current_time_label")

        layout.addWidget(self.current_time_label)

         

        # 添加分隔线

        line = QFrame()

        line.setFrameShape(QFrame.HLine)

        line.setFrameShadow(QFrame.Sunken)

        layout.addWidget(line)

         

        # 定时/延时选择

        time_type_group = QGroupBox("时间类型")

        time_type_layout = QHBoxLayout()

        time_type_layout.setContentsMargins(10, 15, 10, 10)

         

        self.fixed_time_radio = QRadioButton("定时关机")

        self.delay_time_radio = QRadioButton("延时关机")

        self.fixed_time_radio.setChecked(True)

         

        time_type_layout.addWidget(self.fixed_time_radio)

        time_type_layout.addWidget(self.delay_time_radio)

        time_type_group.setLayout(time_type_layout)

        layout.addWidget(time_type_group)

         

        # 定时时间选择

        self.fixed_datetime = QDateTimeEdit()

        self.fixed_datetime.setDisplayFormat("yyyy-MM-dd HH:mm:ss")

        self.fixed_datetime.setDateTime(QDateTime.currentDateTime())

        self.fixed_datetime.setCalendarPopup(True)

        layout.addWidget(self.fixed_datetime)

         

        # 延时时间选择

        self.delay_datetime = QDateTimeEdit()

        self.delay_datetime.setDisplayFormat("HH:mm:ss")

        self.delay_datetime.setTime(QTime(0, 0, 0))

        self.delay_datetime.setVisible(False)

        layout.addWidget(self.delay_datetime)

         

        # 连接信号

        self.fixed_time_radio.toggled.connect(self.on_time_type_changed)

         

        # 操作类型

        action_group = QGroupBox("操作类型")

        action_layout = QHBoxLayout()

        action_layout.setContentsMargins(10, 15, 10, 10)

         

        self.shutdown_radio = QRadioButton("关机")

        self.restart_radio = QRadioButton("重启")

        self.logoff_radio = QRadioButton("注销")

        self.shutdown_radio.setChecked(True)

         

        action_layout.addWidget(self.shutdown_radio)

        action_layout.addWidget(self.restart_radio)

        action_layout.addWidget(self.logoff_radio)

        action_group.setLayout(action_layout)

        layout.addWidget(action_group)

         

        # 选项

        options_group = QGroupBox("选项")

        options_layout = QVBoxLayout()

        options_layout.setContentsMargins(10, 15, 10, 10)

         

        self.auto_start_check = QCheckBox("随系统启动")

        self.loop_exec_check = QCheckBox("循环执行")

         

        options_layout.addWidget(self.auto_start_check)

        options_layout.addWidget(self.loop_exec_check)

        options_group.setLayout(options_layout)

        layout.addWidget(options_group)

         

        # 剩余时间显示

        self.remaining_time_label = QLabel()

        self.remaining_time_label.setAlignment(Qt.AlignCenter)

        self.remaining_time_label.setObjectName("remaining_time_label")

        layout.addWidget(self.remaining_time_label)

         

        # 按钮布局

        button_layout = QHBoxLayout()

        button_layout.setContentsMargins(0, 10, 0, 0)

        button_layout.setSpacing(15)

         

        self.save_btn = QPushButton("保存设置")

        self.cancel_btn = QPushButton("取消")

        self.cancel_btn.setObjectName("cancel_btn")

        self.cancel_btn.setEnabled(False)

         

        self.save_btn.clicked.connect(self.save_config)

        self.cancel_btn.clicked.connect(self.cancel_task)

         

        button_layout.addWidget(self.save_btn)

        button_layout.addWidget(self.cancel_btn)

        layout.addLayout(button_layout)

         

        # 添加弹簧使布局更紧凑

        layout.addSpacerItem(QSpacerItem(20, 10, QSizePolicy.Minimum, QSizePolicy.Expanding))

     

    def on_time_type_changed(self, checked):

        self.fixed_datetime.setVisible(checked)

        self.delay_datetime.setVisible(not checked)

         

    def update_current_time(self):

        current_time = datetime.now().strftime("%Y年%m月%d日 %H:%M:%S")

        self.current_time_label.setText(f"当前时间: {current_time}")

         

    def save_config(self):

        config = configparser.ConfigParser()

        config['task'] = {

            'time_type': 'fixed' if self.fixed_time_radio.isChecked() else 'delay',

            'time': self.fixed_datetime.dateTime().toString("HHmmss") if self.fixed_time_radio.isChecked() else self.delay_datetime.time().toString("HHmmss"),

            'execute_type': 'shutdown' if self.shutdown_radio.isChecked() else 'restart' if self.restart_radio.isChecked() else 'logoff',

            'auto_start': '1' if self.auto_start_check.isChecked() else '0',

            'task_circ': '1' if self.loop_exec_check.isChecked() else '0'

        }

         

        with open(self.config_file, 'w') as f:

            config.write(f)

             

        self.set_auto_start(self.auto_start_check.isChecked())

        self.cancel_btn.setEnabled(True)  # 保存后启用取消按钮

        self.start_task()

         

    def load_config(self):

        if not os.path.exists(self.config_file):

            return

             

        config = configparser.ConfigParser()

        config.read(self.config_file)

         

        if 'task' in config:

            task_config = config['task']

             

            # 时间类型

            if task_config.get('time_type', 'fixed') == 'fixed':

                self.fixed_time_radio.setChecked(True)

                time_str = task_config.get('time', '000000')

                qtime = QTime.fromString(time_str, "HHmmss")

                current_date = QDateTime.currentDateTime()

                self.fixed_datetime.setDateTime(QDateTime(current_date.date(), qtime))

            else:

                self.delay_time_radio.setChecked(True)

                time_str = task_config.get('time', '000000')

                qtime = QTime.fromString(time_str, "HHmmss")

                self.delay_datetime.setTime(qtime)

                 

            # 操作类型

            execute_type = task_config.get('execute_type', 'shutdown')

            if execute_type == 'shutdown':

                self.shutdown_radio.setChecked(True)

            elif execute_type == 'restart':

                self.restart_radio.setChecked(True)

            else:

                self.logoff_radio.setChecked(True)

                 

            # 选项

            self.auto_start_check.setChecked(task_config.get('auto_start', '0') == '1')

            self.loop_exec_check.setChecked(task_config.get('task_circ', '0') == '1')

             

            if self.loop_exec_check.isChecked():

                self.cancel_btn.setEnabled(True)

                self.start_task()

                 

    def set_auto_start(self, enable):

        key = win32con.HKEY_CURRENT_USER

        sub_key = r"SoftwareMicrosoftWindowsCurrentVersionRun"

         

        try:

            reg_key = win32api.RegOpenKey(key, sub_key, 0, win32con.KEY_ALL_ACCESS)

            if enable:

                win32api.RegSetValueEx(reg_key, "定时关机", 0, win32con.REG_SZ, sys.executable)

            else:

                try:

                    win32api.RegDeleteValue(reg_key, "定时关机")

                except:

                    pass

            win32api.RegCloseKey(reg_key)

        except Exception as e:

            QMessageBox.warning(self, "警告", f"设置自启动失败: {str(e)}")

             

    def start_task(self):

        if self.task_running:

            return

             

        self.task_running = True

        self.toggle_components(True)

         

        if self.fixed_time_radio.isChecked():

            target_time = self.fixed_datetime.dateTime().toPyDateTime()

            now = datetime.now()

             

            if target_time < now:

                target_time += timedelta(days=1)

                 

            self.target_time = target_time

        else:

            delay = self.delay_datetime.time()

            self.target_time = datetime.now() + timedelta(

                hours=delay.hour(),

                minutes=delay.minute(),

                seconds=delay.second()

            )

             

        self.countdown_timer.start(1000)

        self.update_remaining_time()

         

    def update_remaining_time(self):

        now = datetime.now()

        remaining = self.target_time - now

         

        if remaining.total_seconds() <= 0:

            self.execute_action()

            if self.loop_exec_check.isChecked():

                self.start_task()

            else:

                self.cancel_task()

            return

             

        hours, remainder = divmod(int(remaining.total_seconds()), 3600)

        minutes, seconds = divmod(remainder, 60)

        remaining_str = f"{hours}小时{minutes}分{seconds}秒"

        self.remaining_time_label.setText(f"剩余时间: {remaining_str}")

         

        # 更新托盘提示

        self.tray_icon.setToolTip(f"定时关机 剩余时间: {remaining_str}")

         

    def execute_action(self):

        if self.shutdown_radio.isChecked():

            os.system("shutdown -s -t 0")

        elif self.restart_radio.isChecked():

            os.system("shutdown -r -t 0")

        else:

            os.system("shutdown -l")

             

    def cancel_task(self):

        """取消定时任务"""

        if not self.task_running:

            QMessageBox.warning(self, "警告", "没有正在运行的任务")

            return

             

        reply = QMessageBox.question(

            self,

            "确认",

            "确定要取消定时任务吗?",

            QMessageBox.Yes | QMessageBox.No

        )

         

        if reply == QMessageBox.Yes:

            self.task_running = False

            self.countdown_timer.stop()

            self.remaining_time_label.setText("")

            self.tray_icon.setToolTip("定时关机")

            self.toggle_components(False)

            self.cancel_btn.setEnabled(False)

             

            # 显示取消成功的提示

            QMessageBox.information(self, "提示", "定时任务已取消", QMessageBox.Ok)

         

    def toggle_components(self, disabled):

        self.fixed_time_radio.setDisabled(disabled)

        self.delay_time_radio.setDisabled(disabled)

        self.fixed_datetime.setDisabled(disabled)

        self.delay_datetime.setDisabled(disabled)

        self.shutdown_radio.setDisabled(disabled)

        self.restart_radio.setDisabled(disabled)

        self.logoff_radio.setDisabled(disabled)

        self.auto_start_check.setDisabled(disabled)

        self.loop_exec_check.setDisabled(disabled)

        self.save_btn.setDisabled(disabled)

         

    def tray_icon_activated(self, reason):

        if reason == QSystemTrayIcon.DoubleClick:

            self.show_normal()

             

    def show_normal(self):

        self.show()

        self.setWindowState(self.windowState() & ~Qt.WindowMinimized)

        self.activateWindow()

        self.raise_()

         

    def closeEvent(self, event):

        """重写关闭事件,改为最小化到托盘"""

        if self.isVisible():

            self.hide()

            self.tray_icon.show()  # 确保托盘图标显示

            if not self.first_show:  # 第一次启动时不显示消息

                self.tray_icon.showMessage(

                    "定时关机",

                    "程序已最小化到托盘",

                    QSystemTrayIcon.Information,

                    2000

                )

            self.first_show = False

            event.ignore()

        else:

            # 真正退出程序

            self.tray_icon.hide()

            event.accept()

             

    def confirm_exit(self):

        reply = QMessageBox.question(self, '确认', '是否退出?',

                                    QMessageBox.Yes | QMessageBox.No, QMessageBox.No)

        if reply == QMessageBox.Yes:

            self.tray_icon.hide()

            QApplication.quit()

 

def main():

    # 防止重复运行

    shared = QSharedMemory("定时关机")

    if not shared.create(512, QSharedMemory.ReadWrite):

        QMessageBox.warning(None, "警告", "程序已经在运行!")

        sys.exit(0)

         

    # 设置高DPI支持

    QApplication.setAttribute(Qt.AA_EnableHighDpiScaling)

     

    app = QApplication(sys.argv)

    window = ShutdownApp()

     

    # 如果配置了随系统启动且循环执行,则不显示窗口

    config_file = os.path.join(os.getenv('APPDATA'), 'shutdown_config.ini')

    if os.path.exists(config_file):

        config = configparser.ConfigParser()

        config.read(config_file)

         

        if 'task' in config and config['task'].get('auto_start', '0') == '1':

            if config['task'].get('task_circ', '0') == '1':

                window.showMinimized()

            else:

                window.show()

        else:

            window.show()

    else:

        window.show()

         

    sys.exit(app.exec_())

 

if __name__ == '__main__':

    main()

 

总结与优化方向

 

优点

界面简洁,操作方便

系统托盘支持,后台静默运行

支持定时 & 倒计时模式,满足不同需求

 

可优化方向

支持多任务管理(同时设置多个定时任务)

增加日志记录(记录每次关机任务)

增加任务进度条(倒计时可视化显示)

如果你对这个工具感兴趣,可以尝试优化它,让它变得更加智能!

在日常使用电脑的过程中,我们经常会遇到需要定时关机的场景,比如:

  • 夜间下载文件,想让电脑在任务完成后自动关机。
  • 长时间运行的程序,需要在某个时间点关闭系统。
  • 限制电脑使用时间,避免长时间占用资源。

虽然 Windows 自带 shutdown 命令可以定时关机,但操作方式较为繁琐,缺乏可视化界面。因此,本篇文章将带大家实现一个基于 PyQt5 的 Windows 定时关机工具,支持定时或延时关机、重启、注销,并提供系统托盘功能,方便随时管理关机任务。

 

功能介绍

本工具主要具备以下功能:

定时关机 —— 设定具体时间,到点自动关机。

延时关机 —— 设置倒计时,倒计时结束后自动关机。

重启 & 注销 —— 除关机外,还可执行系统重启和注销操作。

取消操作 —— 关机前可随时取消,避免误操作。

系统托盘支持 —— 运行后最小化到系统托盘,不影响日常操作。

人性化提示 —— 关机前弹出提醒,避免突发关机。

 

代码实现

 

1. 安装依赖

在运行代码之前,我们需要先安装 PyQt5 库:

1

pip install PyQt5 pyqt5-tools

 

2. 代码编写

以下是完整的代码实现:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

import sys

import os

import time

from PyQt5.QtWidgets import QApplication, QWidget, QLabel, QPushButton, QVBoxLayout, QTimeEdit, QSystemTrayIcon, QMenu, QAction

from PyQt5.QtGui import QIcon

from PyQt5.QtCore import QTimer, QTime

 

class ShutdownApp(QWidget):

    def __init__(self):

        super().__init__()

        self.initUI()

 

    def initUI(self):

        self.setWindowTitle('Windows 定时关机工具')

        self.setGeometry(600, 300, 300, 200)

         

        self.label = QLabel('请选择关机时间:', self)

        self.timeEdit = QTimeEdit(self)

        self.timeEdit.setDisplayFormat("HH:mm")

         

        self.startButton = QPushButton('设置关机', self)

        self.startButton.clicked.connect(self.scheduleShutdown)

         

        self.cancelButton = QPushButton('取消关机', self)

        self.cancelButton.clicked.connect(self.cancelShutdown)

         

        layout = QVBoxLayout()

        layout.addWidget(self.label)

        layout.addWidget(self.timeEdit)

        layout.addWidget(self.startButton)

        layout.addWidget(self.cancelButton)

         

        self.setLayout(layout)

         

        # 托盘功能

        self.trayIcon = QSystemTrayIcon(QIcon("icon.png"), self)

        trayMenu = QMenu()

        exitAction = QAction("退出", self)

        exitAction.triggered.connect(self.close)

        trayMenu.addAction(exitAction)

        self.trayIcon.setContextMenu(trayMenu)

        self.trayIcon.show()

 

    def scheduleShutdown(self):

        shutdown_time = self.timeEdit.time()

        current_time = QTime.currentTime()

        seconds = current_time.secsTo(shutdown_time)

         

        if seconds <= 0:

            self.label.setText("请选择一个未来的时间!")

            return

         

        self.label.setText(f"关机已设置,将在 {shutdown_time.toString()} 执行")

        os.system(f'shutdown -s -t {seconds}')

 

    def cancelShutdown(self):

        os.system('shutdown -a')

        self.label.setText("关机已取消!")

 

if __name__ == '__main__':

    app = QApplication(sys.argv)

    ex = ShutdownApp()

    ex.show()

    sys.exit(app.exec_())

 

功能使用

 

1. 运行软件

1

python shutdown_tool.py

 

2. 设置定时关机

  • 选择时间
  • 点击 “设置关机”
  • 程序将计算剩余时间,并执行关机命令

 

3. 取消关机

  • 如果想取消定时关机,点击 “取消关机” 按钮
  • 也可以手动在命令行执行:

1

shutdown -a

 

4. 系统托盘

  • 运行后可最小化到托盘
  • 右键点击托盘图标可 退出应用

 

技术要点解析

 

关机命令

Windows 提供 shutdown 命令来执行关机任务:

  • 定时关机:

1

shutdown -s -t 秒数

  • 取消关机:

1

shutdown -a

 

计算关机时间

我们使用 QTime 计算当前时间到设定时间的 秒数,避免时间计算错误:

1

seconds = current_time.secsTo(shutdown_time)

 

托盘图标支持

使用 QSystemTrayIcon 实现最小化到托盘:

1

self.trayIcon = QSystemTrayIcon(QIcon("icon.png"), self)

这样即使窗口关闭,应用仍能在后台运行。

 

运行效果

 

相关源码

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

418

419

420

421

422

423

424

425

426

427

428

429

430

431

432

433

434

435

436

437

438

439

440

441

442

443

444

445

446

447

448

449

450

451

452

453

454

455

456

457

458

459

460

461

462

463

464

465

466

467

468

469

470

471

import os

import sys

import time

import configparser

import win32api

import win32con

from datetime import datetime, timedelta

from PyQt5.QtWidgets import (QApplication, QMainWindow, QWidget, QVBoxLayout, QHBoxLayout,

                            QGroupBox, QRadioButton, QDateTimeEdit, QLabel, QPushButton,

                            QCheckBox, QSystemTrayIcon, QMenu, QMessageBox, QSpacerItem,

                            QSizePolicy, QFrame)

from PyQt5.QtCore import Qt, QTimer, QDateTime, QTime, QSize, QSharedMemory

from PyQt5.QtGui import QIcon, QFont, QPalette, QColor

 

def resource_path(relative_path):

    """ 获取资源的绝对路径,适用于开发环境和PyInstaller单文件模式 """

    if hasattr(sys, '_MEIPASS'):

        # PyInstaller创建的临时文件夹

        return os.path.join(sys._MEIPASS, relative_path)

    return os.path.join(os.path.abspath('.'), relative_path)

 

class ShutdownApp(QMainWindow):

    def __init__(self):

        super().__init__()

        self.task_running = False

        self.config_file = os.path.join(os.getenv('APPDATA'), 'shutdown_config.ini')

        self.first_show = True  # 用于跟踪是否是第一次显示

         

        self.setup_ui_style()

        self.init_ui()

        self.load_config()

         

        # 系统托盘

        self.tray_icon = QSystemTrayIcon(self)

        self.tray_icon.setIcon(QIcon(resource_path("icon.ico")))

        self.tray_icon.setToolTip("定时关机")

        self.tray_icon.activated.connect(self.tray_icon_activated)

         

        # 托盘菜单

        self.tray_menu = QMenu()

        self.show_action = self.tray_menu.addAction("显示")

        self.exit_action = self.tray_menu.addAction("退出")

        self.show_action.triggered.connect(self.show_normal)

        self.exit_action.triggered.connect(self.confirm_exit)

        self.tray_icon.setContextMenu(self.tray_menu)

        self.tray_icon.show()  # 确保托盘图标显示

         

        # 显示当前时间

        self.timer = QTimer(self)

        self.timer.timeout.connect(self.update_current_time)

        self.timer.start(1000)

         

        # 剩余时间计时器

        self.countdown_timer = QTimer(self)

        self.countdown_timer.timeout.connect(self.update_remaining_time)

     

    def setup_ui_style(self):

        """设置全局UI样式"""

        self.setStyleSheet("""

            QMainWindow {

                background-color: #f5f5f5;

            }

            QGroupBox {

                border: 1px solid #ccc;

                border-radius: 4px;

                margin-top: 10px;

                padding-top: 15px;

                font-weight: bold;

                color: #333;

            }

            QGroupBox::title {

                subcontrol-origin: margin;

                left: 10px;

                padding: 0 3px;

            }

            QRadioButton, QCheckBox {

                color: #444;

            }

            QPushButton {

                background-color: #4CAF50;

                color: white;

                border: none;

                padding: 8px 16px;

                border-radius: 4px;

                min-width: 80px;

            }

            QPushButton:hover {

                background-color: #45a049;

            }

            QPushButton:disabled {

                background-color: #cccccc;

            }

            QPushButton#cancel_btn {

                background-color: #f44336;

            }

            QPushButton#cancel_btn:hover {

                background-color: #d32f2f;

            }

            QDateTimeEdit {

                padding: 5px;

                border: 1px solid #ddd;

                border-radius: 4px;

            }

            QLabel#current_time_label {

                font-size: 16px;

                color: #333;

                padding: 5px;

                background-color: #e9f5e9;

                border-radius: 4px;

            }

            QLabel#remaining_time_label {

                font-size: 16px;

                color: #d32f2f;

                font-weight: bold;

                padding: 5px;

                background-color: #f9e9e9;

                border-radius: 4px;

            }

        """)

     

    def init_ui(self):

        self.setWindowTitle("定时关机")

        self.setWindowIcon(QIcon(resource_path("icon.ico")))

        self.resize(300, 440)

         

        # 主窗口布局

        main_widget = QWidget()

        self.setCentralWidget(main_widget)

        layout = QVBoxLayout(main_widget)

        layout.setContentsMargins(12, 12, 12, 12)

        layout.setSpacing(10)

         

        # 当前时间显示

        self.current_time_label = QLabel()

        self.current_time_label.setAlignment(Qt.AlignCenter)

        self.current_time_label.setObjectName("current_time_label")

        layout.addWidget(self.current_time_label)

         

        # 添加分隔线

        line = QFrame()

        line.setFrameShape(QFrame.HLine)

        line.setFrameShadow(QFrame.Sunken)

        layout.addWidget(line)

         

        # 定时/延时选择

        time_type_group = QGroupBox("时间类型")

        time_type_layout = QHBoxLayout()

        time_type_layout.setContentsMargins(10, 15, 10, 10)

         

        self.fixed_time_radio = QRadioButton("定时关机")

        self.delay_time_radio = QRadioButton("延时关机")

        self.fixed_time_radio.setChecked(True)

         

        time_type_layout.addWidget(self.fixed_time_radio)

        time_type_layout.addWidget(self.delay_time_radio)

        time_type_group.setLayout(time_type_layout)

        layout.addWidget(time_type_group)

         

        # 定时时间选择

        self.fixed_datetime = QDateTimeEdit()

        self.fixed_datetime.setDisplayFormat("yyyy-MM-dd HH:mm:ss")

        self.fixed_datetime.setDateTime(QDateTime.currentDateTime())

        self.fixed_datetime.setCalendarPopup(True)

        layout.addWidget(self.fixed_datetime)

         

        # 延时时间选择

        self.delay_datetime = QDateTimeEdit()

        self.delay_datetime.setDisplayFormat("HH:mm:ss")

        self.delay_datetime.setTime(QTime(0, 0, 0))

        self.delay_datetime.setVisible(False)

        layout.addWidget(self.delay_datetime)

         

        # 连接信号

        self.fixed_time_radio.toggled.connect(self.on_time_type_changed)

         

        # 操作类型

        action_group = QGroupBox("操作类型")

        action_layout = QHBoxLayout()

        action_layout.setContentsMargins(10, 15, 10, 10)

         

        self.shutdown_radio = QRadioButton("关机")

        self.restart_radio = QRadioButton("重启")

        self.logoff_radio = QRadioButton("注销")

        self.shutdown_radio.setChecked(True)

         

        action_layout.addWidget(self.shutdown_radio)

        action_layout.addWidget(self.restart_radio)

        action_layout.addWidget(self.logoff_radio)

        action_group.setLayout(action_layout)

        layout.addWidget(action_group)

         

        # 选项

        options_group = QGroupBox("选项")

        options_layout = QVBoxLayout()

        options_layout.setContentsMargins(10, 15, 10, 10)

         

        self.auto_start_check = QCheckBox("随系统启动")

        self.loop_exec_check = QCheckBox("循环执行")

         

        options_layout.addWidget(self.auto_start_check)

        options_layout.addWidget(self.loop_exec_check)

        options_group.setLayout(options_layout)

        layout.addWidget(options_group)

         

        # 剩余时间显示

        self.remaining_time_label = QLabel()

        self.remaining_time_label.setAlignment(Qt.AlignCenter)

        self.remaining_time_label.setObjectName("remaining_time_label")

        layout.addWidget(self.remaining_time_label)

         

        # 按钮布局

        button_layout = QHBoxLayout()

        button_layout.setContentsMargins(0, 10, 0, 0)

        button_layout.setSpacing(15)

         

        self.save_btn = QPushButton("保存设置")

        self.cancel_btn = QPushButton("取消")

        self.cancel_btn.setObjectName("cancel_btn")

        self.cancel_btn.setEnabled(False)

         

        self.save_btn.clicked.connect(self.save_config)

        self.cancel_btn.clicked.connect(self.cancel_task)

         

        button_layout.addWidget(self.save_btn)

        button_layout.addWidget(self.cancel_btn)

        layout.addLayout(button_layout)

         

        # 添加弹簧使布局更紧凑

        layout.addSpacerItem(QSpacerItem(20, 10, QSizePolicy.Minimum, QSizePolicy.Expanding))

     

    def on_time_type_changed(self, checked):

        self.fixed_datetime.setVisible(checked)

        self.delay_datetime.setVisible(not checked)

         

    def update_current_time(self):

        current_time = datetime.now().strftime("%Y年%m月%d日 %H:%M:%S")

        self.current_time_label.setText(f"当前时间: {current_time}")

         

    def save_config(self):

        config = configparser.ConfigParser()

        config['task'] = {

            'time_type': 'fixed' if self.fixed_time_radio.isChecked() else 'delay',

            'time': self.fixed_datetime.dateTime().toString("HHmmss") if self.fixed_time_radio.isChecked() else self.delay_datetime.time().toString("HHmmss"),

            'execute_type': 'shutdown' if self.shutdown_radio.isChecked() else 'restart' if self.restart_radio.isChecked() else 'logoff',

            'auto_start': '1' if self.auto_start_check.isChecked() else '0',

            'task_circ': '1' if self.loop_exec_check.isChecked() else '0'

        }

         

        with open(self.config_file, 'w') as f:

            config.write(f)

             

        self.set_auto_start(self.auto_start_check.isChecked())

        self.cancel_btn.setEnabled(True)  # 保存后启用取消按钮

        self.start_task()

         

    def load_config(self):

        if not os.path.exists(self.config_file):

            return

             

        config = configparser.ConfigParser()

        config.read(self.config_file)

         

        if 'task' in config:

            task_config = config['task']

             

            # 时间类型

            if task_config.get('time_type', 'fixed') == 'fixed':

                self.fixed_time_radio.setChecked(True)

                time_str = task_config.get('time', '000000')

                qtime = QTime.fromString(time_str, "HHmmss")

                current_date = QDateTime.currentDateTime()

                self.fixed_datetime.setDateTime(QDateTime(current_date.date(), qtime))

            else:

                self.delay_time_radio.setChecked(True)

                time_str = task_config.get('time', '000000')

                qtime = QTime.fromString(time_str, "HHmmss")

                self.delay_datetime.setTime(qtime)

                 

            # 操作类型

            execute_type = task_config.get('execute_type', 'shutdown')

            if execute_type == 'shutdown':

                self.shutdown_radio.setChecked(True)

            elif execute_type == 'restart':

                self.restart_radio.setChecked(True)

            else:

                self.logoff_radio.setChecked(True)

                 

            # 选项

            self.auto_start_check.setChecked(task_config.get('auto_start', '0') == '1')

            self.loop_exec_check.setChecked(task_config.get('task_circ', '0') == '1')

             

            if self.loop_exec_check.isChecked():

                self.cancel_btn.setEnabled(True)

                self.start_task()

                 

    def set_auto_start(self, enable):

        key = win32con.HKEY_CURRENT_USER

        sub_key = r"SoftwareMicrosoftWindowsCurrentVersionRun"

         

        try:

            reg_key = win32api.RegOpenKey(key, sub_key, 0, win32con.KEY_ALL_ACCESS)

            if enable:

                win32api.RegSetValueEx(reg_key, "定时关机", 0, win32con.REG_SZ, sys.executable)

            else:

                try:

                    win32api.RegDeleteValue(reg_key, "定时关机")

                except:

                    pass

            win32api.RegCloseKey(reg_key)

        except Exception as e:

            QMessageBox.warning(self, "警告", f"设置自启动失败: {str(e)}")

             

    def start_task(self):

        if self.task_running:

            return

             

        self.task_running = True

        self.toggle_components(True)

         

        if self.fixed_time_radio.isChecked():

            target_time = self.fixed_datetime.dateTime().toPyDateTime()

            now = datetime.now()

             

            if target_time < now:

                target_time += timedelta(days=1)

                 

            self.target_time = target_time

        else:

            delay = self.delay_datetime.time()

            self.target_time = datetime.now() + timedelta(

                hours=delay.hour(),

                minutes=delay.minute(),

                seconds=delay.second()

            )

             

        self.countdown_timer.start(1000)

        self.update_remaining_time()

         

    def update_remaining_time(self):

        now = datetime.now()

        remaining = self.target_time - now

         

        if remaining.total_seconds() <= 0:

            self.execute_action()

            if self.loop_exec_check.isChecked():

                self.start_task()

            else:

                self.cancel_task()

            return

             

        hours, remainder = divmod(int(remaining.total_seconds()), 3600)

        minutes, seconds = divmod(remainder, 60)

        remaining_str = f"{hours}小时{minutes}分{seconds}秒"

        self.remaining_time_label.setText(f"剩余时间: {remaining_str}")

         

        # 更新托盘提示

        self.tray_icon.setToolTip(f"定时关机 剩余时间: {remaining_str}")

         

    def execute_action(self):

        if self.shutdown_radio.isChecked():

            os.system("shutdown -s -t 0")

        elif self.restart_radio.isChecked():

            os.system("shutdown -r -t 0")

        else:

            os.system("shutdown -l")

             

    def cancel_task(self):

        """取消定时任务"""

        if not self.task_running:

            QMessageBox.warning(self, "警告", "没有正在运行的任务")

            return

             

        reply = QMessageBox.question(

            self,

            "确认",

            "确定要取消定时任务吗?",

            QMessageBox.Yes | QMessageBox.No

        )

         

        if reply == QMessageBox.Yes:

            self.task_running = False

            self.countdown_timer.stop()

            self.remaining_time_label.setText("")

            self.tray_icon.setToolTip("定时关机")

            self.toggle_components(False)

            self.cancel_btn.setEnabled(False)

             

            # 显示取消成功的提示

            QMessageBox.information(self, "提示", "定时任务已取消", QMessageBox.Ok)

         

    def toggle_components(self, disabled):

        self.fixed_time_radio.setDisabled(disabled)

        self.delay_time_radio.setDisabled(disabled)

        self.fixed_datetime.setDisabled(disabled)

        self.delay_datetime.setDisabled(disabled)

        self.shutdown_radio.setDisabled(disabled)

        self.restart_radio.setDisabled(disabled)

        self.logoff_radio.setDisabled(disabled)

        self.auto_start_check.setDisabled(disabled)

        self.loop_exec_check.setDisabled(disabled)

        self.save_btn.setDisabled(disabled)

         

    def tray_icon_activated(self, reason):

        if reason == QSystemTrayIcon.DoubleClick:

            self.show_normal()

             

    def show_normal(self):

        self.show()

        self.setWindowState(self.windowState() & ~Qt.WindowMinimized)

        self.activateWindow()

        self.raise_()

         

    def closeEvent(self, event):

        """重写关闭事件,改为最小化到托盘"""

        if self.isVisible():

            self.hide()

            self.tray_icon.show()  # 确保托盘图标显示

            if not self.first_show:  # 第一次启动时不显示消息

                self.tray_icon.showMessage(

                    "定时关机",

                    "程序已最小化到托盘",

                    QSystemTrayIcon.Information,

                    2000

                )

            self.first_show = False

            event.ignore()

        else:

            # 真正退出程序

            self.tray_icon.hide()

            event.accept()

             

    def confirm_exit(self):

        reply = QMessageBox.question(self, '确认', '是否退出?',

                                    QMessageBox.Yes | QMessageBox.No, QMessageBox.No)

        if reply == QMessageBox.Yes:

            self.tray_icon.hide()

            QApplication.quit()

 

def main():

    # 防止重复运行

    shared = QSharedMemory("定时关机")

    if not shared.create(512, QSharedMemory.ReadWrite):

        QMessageBox.warning(None, "警告", "程序已经在运行!")

        sys.exit(0)

         

    # 设置高DPI支持

    QApplication.setAttribute(Qt.AA_EnableHighDpiScaling)

     

    app = QApplication(sys.argv)

    window = ShutdownApp()

     

    # 如果配置了随系统启动且循环执行,则不显示窗口

    config_file = os.path.join(os.getenv('APPDATA'), 'shutdown_config.ini')

    if os.path.exists(config_file):

        config = configparser.ConfigParser()

        config.read(config_file)

         

        if 'task' in config and config['task'].get('auto_start', '0') == '1':

            if config['task'].get('task_circ', '0') == '1':

                window.showMinimized()

            else:

                window.show()

        else:

            window.show()

    else:

        window.show()

         

    sys.exit(app.exec_())

 

if __name__ == '__main__':

    main()

 

总结与优化方向

 

优点

界面简洁,操作方便

系统托盘支持,后台静默运行

支持定时 & 倒计时模式,满足不同需求

 

可优化方向

支持多任务管理(同时设置多个定时任务)

增加日志记录(记录每次关机任务)

增加任务进度条(倒计时可视化显示)

如果你对这个工具感兴趣,可以尝试优化它,让它变得更加智能!


版权声明 : 本文内容来源于互联网或用户自行发布贡献,该文观点仅代表原作者本人。本站仅提供信息存储空间服务和不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权, 违法违规的内容, 请发送邮件至2530232025#qq.cn(#换@)举报,一经查实,本站将立刻删除。

您可能感兴趣的文章 :

原文链接 :
相关文章
  • Python虚拟环境终极(含PyCharm的使用教程)

    Python虚拟环境终极(含PyCharm的使用教程)
    一、为什么需要虚拟环境? 场景 问题表现 虚拟环境解决方案 多项目依赖冲突 项目A需要Django 3.2,项目B需要Django 4.1 隔离不同项目的依赖版
  • Python中的魔术方法__new__介绍

    Python中的魔术方法__new__介绍
    一、核心意义与机制 1.1 构造过程原理 1.2 与 __init__ 对比 特性 __new__ __init__ 方法类型 静态方法 实例方法 返回值 必须返回实例对象 无返回值
  • 基于PyQt5实现的Windows定时关机工具

    基于PyQt5实现的Windows定时关机工具
    在日常使用电脑的过程中,我们经常会遇到需要定时关机的场景,比如: 夜间下载文件,想让电脑在任务完成后自动关机。 长时间运行的程
  • 宝塔安装的MySQL无法连接的情况及解决方案

    宝塔安装的MySQL无法连接的情况及解决方案
    一、错误 1130:Host xxx.xxx.xxx.xxx is not allowed to connect to this MySQL server 错误原因 此错误表示您的 IP 地址没有被授权访问宝塔服务器上的 MySQL。
  • MySQL中drop、truncate和delete的区别
    对于drop、truncate和delete,虽然简单,但是真要使用或者面试时候问到还是需要有一定的总结,今天来简单讲讲他们直接的区别。在此之前先
  • Linux搭建单机MySQL8.0.26版本的操作方法

    Linux搭建单机MySQL8.0.26版本的操作方法
    环境信息 IP 系统 规格 10.0.0.10 Ubuntu22.04 2c4g 数据库服务安装步骤 下载前置依赖 1 2 # 下载libtinfo5、libnuma1依赖 [root@lb ~]# apt update -y apt install
  • mysql中的group by高级用法
    MySQL中的GROUP BY是数据聚合分析的核心功能,主要用于将结果集按指定列分组,并结合聚合函数进行统计计算。以下从基本语法到高级用法进
  • MySQL双主搭建+keepalived高可用的实现

    MySQL双主搭建+keepalived高可用的实现
    一、测试环境准备 节点1 节点2 IP地址 192.168.101.77 192.168.101.79 MySQL版本 8.0.32 8.0.32 二、主从搭建 1.创建复制用户 节点1执行: 1 2 3 4 mysql CREA
  • MYSQL数据表基本操作之创建+查看+修改+删除操作方

    MYSQL数据表基本操作之创建+查看+修改+删除操作方
    在数据库管理中,数据表的创建、查看、修改和删除是最基本的操作。这些操作是日常数据库管理和维护中不可或缺的一部分,正确理解和
  • MySQL使用SHOW PROCESSLIST的实现
    1、SHOW PROCESSLIST 显示进程列表 SHOW [FULL] PROCESSLIST 用于查看当前MySQL服务器上的所有运行中的进程列表信息。这个命令可以帮助我们了解哪些
  • 本站所有内容来源于互联网或用户自行发布,本站仅提供信息存储空间服务,不拥有版权,不承担法律责任。如有侵犯您的权益,请您联系站长处理!
  • Copyright © 2017-2022 F11.CN All Rights Reserved. F11站长开发者网 版权所有 | 苏ICP备2022031554号-1 | 51LA统计