package cn.test.web.manager; import java.io.IOException; import java.io.InputStream; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class InitServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String path = InitServlet.class.getClassLoader().getResource("init.sql").getPath(); path = path.substring(1); System.out.println(path); String command = "cmd /c mysql -uroot -proot <" + path; //得到执行以上命令的进程 Process p = Runtime.getRuntime().exec(command); //得到执行进程的错误消息 InputStream in = p.getErrorStream(); StringBuffer sb = new StringBuffer(); byte buffer[] = new byte[1024]; int len = 0; while ((len = in.read(buffer)) > 0) { sb.append(new String(buffer,0,len)); } if(sb.length()>0){ request.setAttribute("message", "系统初始化失败!原因:" + sb.toString()); }else{ request.setAttribute("message", "系统初始化成功!!"); } request.getRequestDispatcher("/message.jsp").forward(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }
servlet执行sql脚本
最新推荐文章于 2018-09-08 22:13:30 发布