web项目启动时自动启动mysql数据库

背景介绍：

    最近在学习spring，看到容器事件ApplicationEvent时，突然想到一个问题，因为在本地搭建了一套学习环境，每次启动web项目时都要首先手动启动mysql，有时忘了启动mysql时，控制台就会抛出数据库连接失败的异常信息，所以就在想，能否利用容器事件功能，在项目启动时自动启动mysql，项目停止时自动关闭mysql。

实现：

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;/*** web项目启动时启动mysql;* web项目停止时关闭mysql* * @author Administrator**/
public class MySqlListener implements ServletContextListener {public void contextDestroyed(ServletContextEvent arg0) {try {Runtime runtime = Runtime.getRuntime();Process process = runtime.exec("net stop mysql");InputStream is = process.getInputStream();BufferedReader reader = new BufferedReader(new InputStreamReader(is));String line = "";while ((line = reader.readLine()) != null) {line += line + "\n";}//process.waitFor();reader.close();is.close();process.destroy();System.out.println("正在关闭mysql数据库......");System.out.println(line);} catch (IOException e) {e.printStackTrace();} }public void contextInitialized(ServletContextEvent arg0) {try {Runtime runtime = Runtime.getRuntime();Process process = runtime.exec("net start mysql");InputStream is = process.getInputStream();BufferedReader reader = new BufferedReader(new InputStreamReader(is));String line = "";while ((line = reader.readLine()) != null) {System.out.println(line);line += line + "\n";}reader.close();is.close();process.destroy();System.out.println("正在启动mysql数据库......");System.out.println(line);} catch (IOException e) {e.printStackTrace();}}
}

将监听器配置到web.xml中

  <listener><listener-class>com....listener.MySqlListener</listener-class></listener>

这样就可以实现我想要的功能，大家有什么好的建议请留言！