import javax.servlet.ServletException;
import javax.servlet.http.*;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;


class DBHandler {
    private String database = "";
    private Connection conn;

    public DBHandler(String database){
        this.database=database;
    }

    public void setConn(Connection conn) {
        this.conn = conn;
    }

    public Connection getConn() {
        return conn;
    }

    public Connection getConnection(){
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(database);

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

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

        setConn(conn);
    }

    public void retriveData() throws SQLException {
        String sql="SELECT id,i,j FROM HData";
        Statement statement = getConnection().createStatement();
        ResultSet resultSet = statement.executeQuery(sql);
        while (resultSet.next()){
            int id  = resultSet.getInt("id");
            int i = resultSet.getInt("i");
            int j = resultSet.getInt("j");
        }

    }
}

public class Highway extends HttpServlet {
    Connection conn;
    DBHandler dbHandler;

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        PrintWriter out = response.getWriter();
        String database = "jdbc:mysql://localhost:3306/dbo?user=root&password=root";
        dbHandler = new DBHandler(database);
        dbHandler.getConnection();

    }





}