hsqldb随tomcat启动

wsxxz

Servlet:

package demo.web;
import java.io.IOException;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.hsqldb.Server;
public class PathServlet extends HttpServlet {
private Server server = new Server();
public void destroy() {
server.shutdown();
super.destroy();
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
}
public void init(ServletConfig config) throws ServletException {
String args[] = new String[0];
String path=config.getServletContext().getRealPath("/WEB-INF/lib/db/");
server.setDatabaseName(0, "hsqlDemo");
server.setDatabasePath(0, path);
server.setPort(9001);
server.setSilent(true);
Thread thread=new Thread(new Runnable(){
public void run() {
server.start();
}
});
thread.start();
}
}


web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee   http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<servlet>
<servlet-name>PathServlet</servlet-name>
<servlet-class>demo.web.PathServlet</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>PathServlet</servlet-name>
<url-pattern>/PathServlet</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>