//2012-04-26 johnpfeiffer
/*
New Dynamic Web Project -> Save ... New Servlet
Download the appropriate driver, i.e. http://dev.mysql.com/downloads/connector/j/
right click on the project -> Build Path -> Add Libraries -> Connectivity Driver Definition -> New Driver Definition ->
Available Templates (scroll and select MySQL JDBC Driver 5.1) -> Jar List (tab) -> Add Jar/Zip (browse)
Project Explorer will now display a MySQL JDBC Driver in the Project
For a Servlet mysql-connector-java-5.1.19-bin.jar must be in the WEB-INF/lib directory,
F5 refresh the project, then right click on the driver file above and "Add to Build Path"
*/
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class MySQLServlet extends HttpServlet
{
private static final long serialVersionUID = 1L;
public void service(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
{
response.setContentType( "text/html" );
PrintWriter out = response.getWriter();
out.println("<html><head><title>Servlet JDBC</title></head>");
out.println("<body><h1>Servlet JDBC</h1>");
// connecting to database
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con =DriverManager.getConnection
("jdbc:mysql://10.10.10.186:3306/mysql","root","tnlzV_dURd9h1woEl3zQ");
stmt = con.createStatement();
rs = stmt.executeQuery( "SELECT * FROM mysql.user" );
// displaying records
while( rs.next() )
{ out.print( rs.getObject(1).toString() + "," );
out.print( rs.getObject(2).toString() + "<br />" );
}
}catch (SQLException e)
{ throw new ServletException("Servlet Could not display records.", e);
}catch (ClassNotFoundException e)
{ throw new ServletException("JDBC Driver not found.", e);
}finally
{ try {
if(rs != null)
{ rs.close();
rs = null;
}
if(stmt != null)
{ stmt.close();
stmt = null;
}
if(con != null)
{ con.close();
con = null;
}
}catch( SQLException e )
{ e.printStackTrace();
}
}
out.println("</body></html>");
out.close();
}
} //end class