Passing database values from jsp to javascript

Question

How do I pass all the values from a database table to javascript. I tried using this but only one value is passed in the javascript.

This is the code in my jsp

while(rs.next){
String timestamp= new SimpleDateFormat("MM/dd/yyyy hh:mm a").format(rs.getTimestamp("enddate"));
}

and this is how it receives in my javascript

<script language="JavaScript">

TargetDate = "<%=timestamp%>";

Everytime i run the script only the first value from the table is passed in the javascript. How can I fix this?

iterate over the resultset, store in a string array

spiderman
– spiderman

2014-04-02 08:09:00 +00:00
Commented Apr 2, 2014 at 8:09 — spiderman
– spiderman, Commented Apr 2, 2014 at 8:09

spiderman · Accepted Answer · 2014-04-02 22:08:11Z

2

Basically you need to iterate over your result set and get the list of timetstamp. Currently you are fetching only one timetstamp and displaying it.

Then you need to convert this Java list to Javacript array Convert the Java ArrayList to JSON String, and use JSON.parse() to get Javascript object

Once you have the Javascript object, you are there..

json in java : http://json.org/java/

Alternate approach:

Note: Usage of scriptlets in JSP is NOT at all recommeded. Try using JSTL tag library.

Since you are looking for this, here it is

    <%
        int length = 3; // in your case, resultset count
        String results[] = new String[length];
        results[0] = "result1";
        results[1] = "result2";
        results[2] = "result3";

        // convert java string array to a javascript array

        StringBuffer sb = new StringBuffer();
        sb.append("[");
        for (int i = 0; i < results.length; i++) {
            sb.append("\"").append(results[i]).append("\"");
            if (i + 1 < results.length) {
                sb.append(",");
            }
        }
        sb.append("]");
        String jsarrayAsJavaString = sb.toString();
    %>
    <script language="JavaScript">
     var target = <%= jsarrayAsJavaString %>
     alert(target[0]); // target is a javascript array object. That's why you can do this
     alert(target); // print the entire javascript array

     //looping JS array
     for(var i=0;i<target.length;i++) {
         alert(target[i]); 
     }
    </script>

</body>

edited Apr 2, 2014 at 22:08

answered Apr 2, 2014 at 8:15

spiderman

11.1k13 gold badges57 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

newbie Over a year ago

thank you for your answer but can please you give me an example on how to convert the above?

spiderman Over a year ago

You are welcome. Try cleaning the jsp page by moving Java code.

FIFA oneterahertz Over a year ago

@spiderman I am facing an issue with json.Can you help me please?? stackoverflow.com/questions/37945432/…

cenk ebret · Accepted Answer · 2014-04-02 08:08:30Z

0

The problem i see in your code is, if i dont misunderstand; you try to take all timestamps from rs. But you declare one timestamp.

So i think, you should loop in rs, and declare timestamp in it and for all your rows, you should push it into an array on java side.

Then, you should return it as a timestamp json array as you try to do it in your javasript side. So for javascript, you will have a string array. There, you should loop again i think.

answered Apr 2, 2014 at 8:08

cenk ebret

6974 silver badges16 bronze badges

Collectives™ on Stack Overflow

Passing database values from jsp to javascript

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related