Java Servlet Documentation

hi

Now, run the give code.

ConnectionDatabase.java


import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class ConnectionDatabase extends HttpServlet{
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";;
String dbName = "register";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "root";
try{
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+dbName,userName,password);
out.println("Successfully connect to the database");
conn.close();

}
catch (Exception e) {
e.printStackTrace();
}

}
}

web.xml

<?xml version="1.0" encoding="ISO-8859-1"?>

<web-app xmlns="http://java.sun.com/xml/ns/j2ee";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd";
version="2.4">

<servlet>
<servlet-name>Connection</servlet-name>
<servlet-class>ConnectionDatabase</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Connection</servlet-name>
<url-pattern>/ConnectionDatabase</url-pattern>
</servlet-mapping>
</web-app>