AJAX DATA FETCH IN JSP :

 AJAX DATA FETCH IN JSP :

JAVA SCRIPT FUNCTION TO CALL AJAX:

<script type="text/javascript">

                function loadXMLDoc()

                {

                            

                    var xmlhttp;

                    var keys = document.assignNewTask.team.value

                    var urls = "Emp_Fetch.jsp?ok=" + keys

                    if (window.XMLHttpRequest)

                    {

                        xmlhttp = new XMLHttpRequest();

                    }

                    else

                    {

                        xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");

                    }

                    xmlhttp.onreadystatechange = function ()

                    {

                        removeall();

                        if (xmlhttp.readyState == 4)

                        {

                           

                            z = 0;

                            var roott = xmlhttp.responseXML.documentElement;

                           

                            var ress = roott.getElementsByTagName("membername")[z].childNodes[0].nodeValue;

                            

                           

                            while (ress != null)

                            {

                                addoptions(ress)

                                z++

                                var ress = roott.getElementsByTagName("membername")[z].childNodes[0].nodeValue;

                            }

                        }

                        function removeall()

                        {

                            var ct = document.assignNewTask.name.length;

                            for (i = ct; i >= 0; i--)

                            {

                                document.assignNewTask.name.options[i] = null;

                            }

                        }

                        function addoptions(reslt)

                        {

                          // alert(reslt);

                            var ct1 = document.createElement("OPTION");

                            ct1.text = reslt;

                            ct1.value = reslt;

                            document.assignNewTask.name.options.add(ct1);

                        }

                    }

                    xmlhttp.open("GET", urls, true);

                    xmlhttp.send();

                }

               

            </script>

CALLING AJAX FUNCTION IN SELECT TAG:

SELECT TEAM      :

                        <select id="team" name="team" onchange="loadXMLDoc()">

                            <option value="">---Select Team---</option>

                            <%

                                String name = "";

                                String gid="0";

                                int size=0;

                                 Connection con1 = Database_Connection1.Database_Connection2();

                                 Statement stmg=con1.createStatement();

                                 ResultSet rslen=stmg.executeQuery("select length(groupid) as size from teamleads where Tid='"+Tid+"'");

                                 while(rslen.next())

                                 {

                                     size=rslen.getInt("size");

                                 }

                                con1.close();

                                 for(int i=0;i<size;i++)

                                 {

                                ResultSet rs = stm.executeQuery(" select gnanme,gid from groups where gid=(select SPLIT_STR(groupid,',',"+i+") from teamleads where Tid='"+Tid+"')");

                               

                                

                                while (rs.next())

                                {

                                    name = rs.getString("gnanme");

                                    gid=rs.getString("gid");

                                   

                                    

                            %>

                            <option value="<%=gid%>"><%=name%></option>

                            <%}

                                 }%>

                        </select>

Employee name      :

                        <select name="name">  //AJAX DROPDOWN

                           

                            <option value="">--Choose Employee Name--</option>

                        </select>

JSPSERVLET:-

<%@page import="java.util.ArrayList"%>

<%@page import="java.util.List"%>

<%@page import="com.pack.Database_Connection1"%>

<%@page import="java.sql.ResultSet"%>

<%@page import="java.sql.Statement"%>

<%@page import="java.sql.Connection"%>

<%@page import="javax.naming.InitialContext"%>

<%@page import="javax.sql.DataSource"%>

<%@page import="javax.naming.Context"%>

<%@ page contentType="text/html" pageEncoding="UTF-8"%>

<%

    response.setContentType("text/xml");

    try

    {

  String gid = request.getParameter("ok"); 

  List<String> memnames=new ArrayList<String>();

 

            String name = "";

            int size = 0;

           Connection con1 = Database_Connection1.Database_Connection2();

            Statement stmg = con1.createStatement();

            ResultSet rslen = stmg.executeQuery("select length(membersid) as size from groups where gid='" + gid + "'");

            while (rslen.next()) {

                size = rslen.getInt("size");

                System.out.println("GIVEN SIZE.."+size);

            }

           

         

         for (int i = 0; i <=size; i++)

            {

                ResultSet rs = stmg.executeQuery(" select membername from members where memid=(select SPLIT_STR(membersid,','," +i+ ") from groups where gid='" + gid + "')");

              

                while (rs.next()) {

                  

                    memnames.add(rs.getString(1));

                }

              

           }

         System.out.println("SIZE .."+memnames.size());

         if(memnames.size()>1)

         {

             System.out.println("GREATER VALE..");

          out.println("<members>");

         for(int i=0;i<memnames.size();i++)

         {

            out.println("<membername>" + memnames.get(i) + "</membername>");

         }

             out.println("</members>");

           

         }

         else

         {

            System.out.println("GREATER VALE other..");

             out.println("<members>");

             out.println("<membername>" + memnames.get(0) + "</membername>");

              out.println("</members>");

            

            

         }

                        

    stmg.close();

    con1.close();

           

            }

        catch(Exception ex)

        {

            System.out.println("ERROR.."+ex.getMessage());

        }

        

           

%>

DISABLING TEXTBOX ,USING ONCHANGE EVENTS IN JAVASCRIPT

 DISABLING TEXTBOX ON CHANGE EVENTS IN JAVASCRIPT


<!DOCTYPE html>
<html>
<body>

<p>Select a new car from the list.</p>

<input type="text" id="myText">

<select id="mySelect" onchange="myFunction()">
  <option value="Audi">Audi
  <option value="BMW">BMW
  <option value="Mercedes">Mercedes
  <option value="Volvo">Volvo
</select>

<p>When you select a new car, a function is triggered which outputs the value of the selected car.</p>

<p id="demo"></p>

<script>
function myFunction() {

    var x = document.getElementById("mySelect").value;
    document.getElementById("demo").innerHTML = "You selected: " + x;
if(x=="Volvo")
{
document.getElementById("myText").disabled = true;
}
}
</script>

</body>
</html>

DYNAMIC HTML TABLE BINDING IN JSP

DYNAMIC HTML TABLE BINDING WITH SQL DATABASE VALUES:

<%--
    Document   : index
    Created on : 30 Nov, 2015, 9:34:15 AM
    Author     : User
--%>

<%@page import="java.util.List"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
        <h1>Hello World!</h1>
        <%
            int count =0;
            List<String> no=new ArrayList<String>();
            List<String> data=new ArrayList<String>();
            Class.forName("com.mysql.jdbc.Driver");
         Connection con= DriverManager.getConnection("Jdbc:mysql://localhost/kk","root","root");
        Statement stm=con.createStatement();
       ResultSet rs= stm.executeQuery("select * from pkm");
       while(rs.next())
       {
         
           no.add(rs.getString("no"));
           data.add(rs.getString("name"));
         
       }
       out.println("<table border='1'> <tr><td> S:NO</td><td> NAME</td></tr>");
       for(int i=0;i<no.size();i++)
       {
           out.println("<tr><td> "+no.get(i)+"</td><td>"+data.get(i)+"</td></tr>");
       }
       out.println("</table>");

            %>
           
    </body>
</html>

HELPER CLASS IN ANDROID

DATABASE HELPER CLASS IN ANDROID:

DataBaseHandler.java

import android.content.ContentValues;

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

public class DataBaseHandler extends SQLiteOpenHelper

{

          private static final int DATABASE_VERSION = 1; 

          private static final String DATABASE_NAME = "contactsManager"; 

          private static final String tablename = "contacts"; 

          private static final String id = "id"; 

          private static final String fname = "fname"; 

          private static final String lname = "lnamer";

         

           public DataBaseHandler(Context context)

        { 

               super(context, DATABASE_NAME, null, DATABASE_VERSION); 

               //3rd argument to be passed is CursorFactory instance 

           }

              @Override

              public void onCreate(SQLiteDatabase db)

              {

                     // TODO Auto-generated method stub

                     String CREATE_CONTACTS_TABLE = "CREATE TABLE " + tablename + "(" 

                       + id + " INTEGER PRIMARY KEY," + fname + " TEXT," 

                       + lname + " TEXT" + ")"; 

               db.execSQL(CREATE_CONTACTS_TABLE); 

                    

                    

              }

              @Override

              public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)

              {

                  // Drop older table if existed 

               db.execSQL("DROP TABLE IF EXISTS " + tablename); 

         

               // Create tables again 

               onCreate(db);

                    

              }

               void addContact(DataDb data) { 

                      SQLiteDatabase db = this.getWritableDatabase(); 

                

                      ContentValues values = new ContentValues();

                      values.put(id,data.getID());

                      //values.put(id,data.getID());

                      values.put(fname, data.getfname()); // Contact Name 

                      values.put(lname, data.getlname()); // Contact Phone 

                

                      // Inserting Row

                      db.insert(tablename, null, values); 

                      //2nd argument is String containing nullColumnHack 

                      db.close(); // Closing database connection 

                  } 

                

             

         

          

}

DataDb.java

MAPPING VARIABLES IN SQLITE DATABASE:

package android.mydata;

public class DataDb

{

       Integer id;

       String fname;

       String lname;

       public DataDb()

       {

             

       }

       public DataDb(int id,String fname,String lname)

       {

              this.id=id;

              this.fname=fname;

              this.lname=lname;

             

       }

       public Integer getID()

       {

              return this.id;

       }

       public void setID(Integer id)

       {

              this.id=id;

       }

       public String getfname()

       {

              return this.fname;

       }

       public void setfname(String fname)

       {

              this.fname=fname;

       }

       public String getlname()

       {

              return this.lname;

       }

       public void setlname(String lname)

       {

              this.lname=lname;

       }

      

}

MainActivity.java

METHOD TO INSERT:

    public void insert(View v)

    {

       EditText e1=(EditText)findViewById(R.id.editText1);

       EditText e2=(EditText)findViewById(R.id.editText2);

       String name1=e1.getText().toString();

       String name2=e2.getText().toString();

        DataBaseHandler db = new DataBaseHandler(this);

       Log.d("Insert: ", "Inserting .."); 

        db.addContact(new DataDb(1,name1, name2)); 

        Toast.makeText(this, "DATA INSERTED..", Toast.LENGTH_LONG).show();

      

      

    }

MAKING PHONE CALL IN ANDROID

MAKING CALL IN ANDROID

    public void makecall(View v)

    {   EditText e1=(EditText)findViewById(R.id.editText1);

        String number=e1.getText().toString();

       Intent callIntent = new Intent(Intent.ACTION_CALL); 

       callIntent.setData(Uri.parse("tel:"+number));//change the number 

       startActivity(callIntent); 

    }

PROGRESS BAR IN ANDROID

PROGRESS BAR FOR WAITING IN ANDROID

  

 public void progress(View v)

    {

   

       progressBar = new ProgressDialog(this); 

       progressBar.setCancelable(true);//you can cancel it by pressing back button 

       progressBar.setMessage("File downloading ..."); 

       progressBar.setProgressStyle(ProgressDialog.STYLE_HORIZONTAL);

       progressBar.setProgress(0);//initially progress is 0 

       progressBar.setMax(100);//sets the maximum value 100 

       progressBar.show();//displays the progress bar

      Thread t1=new Thread()

      {

         public void run()

         {

                while (i <= 100)

                { 

                 

                  try {Thread.sleep(100);} catch (InterruptedException e) {e.printStackTrace();}

                  progressBar.setProgress(i);

                  i++;

                 

                  if(i==100)

                  {

                    

                    

                      progressBar.dismiss(); 

                      i=0;

                        

                  }

              

                          

                } 

                   

         }

        

         

      };

     

      t1.start();

       }