<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%

    String connectionURL = "jdbc:mysql://localhost:3306/users";
    Connection connection = null;
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    connection = DriverManager.getConnection(connectionURL, "root", "pass");
    if (!connection.isClosed()) {
        out.println("Connection Established");

        PreparedStatement preparedStmt = connection.prepareStatement("INSERT INTO users.user_details (`Email`, `Name`, `Password`)  VALUES ('ram@gmail.com', 'Ram Das', '12345678')");
        preparedStmt.execute();
        String sql="select * from user_details";
        PreparedStatement statement=connection.prepareStatement(sql);
        ResultSet rs=statement.executeQuery();
        if(rs.next())
        {
            System.out.println(rs.getString(1));
        }
    }
    connection.close();
%>