Monday, May 20, 2024
 Popular · Latest · Hot · Upcoming
99
rated 0 times [  106] [ 7]  / answers: 1 / hits: 32305  / 12 Years ago, wed, march 14, 2012, 12:00:00

i have a java class ::



package MyPackage;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;

import com.google.gson.Gson;

public class PopulateTextbox {

Gson gson = new Gson();
JSONObject obj = new JSONObject();
JSONArray arr = new JSONArray();
String temp1;

String temp;
List <String>rowValues = new ArrayList<String>();
List <Integer>rowValues1 = new ArrayList<Integer>();
String[] contactListNames;
Connection con=null;
Statement st=null;
ResultSet rs=null;


public String method(){


try{


String driver = sun.jdbc.odbc.JdbcOdbcDriver;
Class.forName(driver);

String db = jdbc:odbc:Practice_Database;
con = DriverManager.getConnection(db,,);

st = con.createStatement();
String sql = SELECT Emp_Name,ID,Email_Add FROM EmployeeSearch;
rs = st.executeQuery(sql);

while(rs.next()){
obj.put(ID, rs.getInt(ID));
obj.put(Names,rs.getString(Emp_Name));
obj.put(Email, rs.getString(Email_Add));
arr.add(obj);

}
//obj.accumulate(ID,rowValues1);

//obj.accumulate(Names,rowValues);
temp1 = arr.toString();
System.out.println(temp1);

}catch(Exception e){System.out.println(e);}
/*finally{
try {
if(con!=null)con.close();
} catch (SQLException e) {

e.printStackTrace();
}
try {
if(rs!=null)rs.close();
} catch (SQLException e) {

e.printStackTrace();
}try {
if(st!=null)st.close();

} catch (SQLException e) {

e.printStackTrace();
}


}*/
return temp1;

}
public static void main(String args[])
{
PopulateTextbox obj = new PopulateTextbox();
String temp1= obj.method();


}
}


This is returning me a Json array. Now i want to call method() of this class in JavaScript again and again to get new values as i update my database. I have a data grid which is working fine as the page loads for the first time with a set of values in this json array. But how to refresh data using Ajax. Or how to call the method() using Ajax so that data gets refreshed when i click on a button on the page. The code where i am calling this method in java-script is ::



<%

String temp1;
PopulateTextbox obj = new PopulateTextbox();
temp1 = obj.method();
%>


i am getting problem in retrieving new set of values in temp1 through a Ajax call to the server . please help ? Thanks.


More From » java

 Answers
10

Create a blank JSP (for example, textBoxAjaxResp.jsp) and out put your JSON string from that JSP:



<%

String temp1;
PopulateTextbox obj = new PopulateTextbox();
temp1 = obj.method();
%>

<%=temp1 %>


and hit that JSP using jQuery AJAX call.



$.get(mypath/textBoxAjaxResp.jsp, function (response) {
//do operation using the response
}, json);

[#86855] Tuesday, March 13, 2012, 12 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
adam

Total Points: 363
Total Questions: 102
Total Answers: 104

Location: Burkina Faso
Member since Thu, Dec 15, 2022
1 Year ago
;