Mysql Get the next Auto_increment values

We can use the sql like this

: show table status like 'table_name'

after that, we get only data in 'Auto_increment' field

Initialized servlet on deploy

We have to implements ServletContextListener and add the class into web.xml

example ... servlet class name MyServlet.java

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletContextListener;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class MyServlet extends HttpServlet implements ServletContextListener {

...

...

// implement methods

public void contextInitialized(ServletContextEvent sce) {

System.out.println("MyServlet initialized...");

}

public void contextDestroyed(ServletContextEvent sce) {

System.out.println("MyServlet destroyed...");

}

}

in web.xml




MyServlet
MyServlet
1


MyServlet
/MyServlet


MyServlet



30