Hi Friend,

We are providing you a code that will connect the servlet to database and insert the data.

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

public class ConnectAndInsert extends HttpServlet{

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException,IOException{
int id=5;
String connectionURL = "jdbc:mysql://localhost:3306/register";;
Connection con=null;
try{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(connectionURL, "root", "root");
System.out.println("Connect to database");
PreparedStatement ps = con.prepareStatement("INSERT INTO data VALUES(?,?)");
ps.setString(1,"Roseindia");
ps.setString(2,"Delhi");
int i = ps.executeUpdate();
ps.close();
con.close();
System.out.println("Disconnect to database");
}
catch(Exception ex){
System.out.println(ex);
}

}
}

Thanks