Untitled

<%@page import="java.sql.Driver"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>

    <%@ page import="javax.sql.*" %>
    <%@ page import="java.sql.*" %>
    <%@ page import="java.sql.DriverManager" %>
    <%@ taglib prefix="json" uri="http://www.atg.com/taglibs/json" %>
    <%@ page import="org.json.simple.JSONObject"%>
    <%@ page import="org.json.simple.JSONArray"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>my web</title>
</head>
<body>

<%

java.sql.Connection con = null;

String url = "jdbc:mysql://localhost:3306/learning";

String username = "root";

String password = "laira123";

try{

    Class.forName("com.mysql.jdbc.Driver").newInstance();

    con = DriverManager.getConnection(url,username,password);

    //out.println("connected");
    java.sql.Statement stmt = con.createStatement();

    String query = "SELECT * FROM emp";

    ResultSet rs = stmt.executeQuery(query);

    JSONArray json = new JSONArray();

    while(rs.next()){

        json.add(rs.getString("fname"));
        json.add(rs.getString("lname"));
        System.out.println("firstName:"+rs.getString("fname") +" "+"lastName:"+rs.getString("lname"));
    }

     out.println(json.toJSONString());


}

catch(Exception e){

    e.printStackTrace();

}

%>

</body>
</html>

package com.example.anuu.myjson;

import android.annotation.TargetApi;
import android.net.Uri;
import android.os.AsyncTask;
import android.os.Build;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.text.Html;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.TextView;


import org.json.JSONArray;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
import java.io.Reader;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.URL;

public class MainActivity extends AppCompatActivity {

    Button click;
    TextView textView;

    URL url;

    HttpURLConnection connection;

    BufferedReader reader;

    StringBuffer buffer;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        click = (Button) findViewById(R.id.clickButton);

         textView = (TextView) findViewById(R.id.text1);

        click.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {

                new JSONTask().execute("http://192.168.1.9:8080/WedDBJSp/JspDb.jsp");

            }
        });

    }

    public class JSONTask extends AsyncTask<String, String, String> {
        String line = " ";

        @Override
        protected String doInBackground(String... params) {

            try {
                url = new URL(params[0]);

                connection = (HttpURLConnection) url.openConnection();

                connection.connect();

                InputStream stream = connection.getInputStream();

                reader = new BufferedReader(new InputStreamReader(stream));

                buffer = new StringBuffer();

                while ((line = reader.readLine()) != null) {

                   buffer.append(line);
                }


            }

            catch (MalformedURLException e) {
                e.printStackTrace();
            } catch (IOException e) {
                e.printStackTrace();
            } finally {
                if (connection != null) {
                    connection.disconnect();
                }

                try {
                    if (reader != null) {
                        reader.close();
                    }
                } catch (IOException e) {
                    e.printStackTrace();
                }

            }

            return buffer.append(line).toString();
        }

        @TargetApi(Build.VERSION_CODES.JELLY_BEAN)
        @Override
        protected void onPostExecute(String result) {
            super.onPostExecute(result);

//            Log.i("id11",result.toString());

            textView.setText(Html.fromHtml(result).toString());

            Log.i("data1", "json data");
        }
    }`enter code here`

}