javascript variable to jsp expression

Question

I'm trying to show the data from postgresql to slickgrid. However, in javascript for loop, I can't retrieve right values from JSP expression. How can I do it?

conn = dataSource.getConnection();
        stmt = conn.createStatement();
        rs  = stmt.executeQuery("SELECT host_name,username,key_value,updated from pass_table");
        while(rs.next()) {
            hostname.add(rs.getString(1));  
        } 
    } catch (Exception e) {
        out.println("<br /><font color='red'><strong>SQL Exception: " + e + "</strong></font><br/>");
        }
        %>


      $(function () {
       var data = [];
        for (var i = 0; i < 2; i++) {
          data[i] = {
            //title: "Task " + i
            title: "<%= hostname.get(i)%>"  <===this part
            //title: "${row.host_name}" + i
         };
        }


        grid = new Slick.Grid("#myGrid", data, columns, options);
      })
    </script>

this question is possible duplicate check out this jsp-js i think you have the problem with i in this <%= hostname.get(i)%> code. — Hashy
– Hashy, Commented Nov 2, 2015 at 6:46

Hashy · Accepted Answer · 2015-11-02 12:11:41Z

1

try this ,

$(function () {
    var data =[]; 
     <%
        for(int i = 0; i < 2; i++) {
        %>
       data[<%=i%>] ={
              title:"<%= hostname.get(i)%>"
        <%
        };
        %>
     };

     grid = new Slick.Grid("#myGrid", data, columns, options);
          })

edited Nov 2, 2015 at 12:11

answered Nov 2, 2015 at 6:59

Hashy

2742 silver badges10 bronze badges

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

2 Comments

James Over a year ago

this error below occured when I executed it An error occurred at line: 107 in the jsp file: /SlickGrid-master/examples/example1-simple.jsp i cannot be resolved to a type 104: <% 105: for(int i = 0; i < 2; i++) { 106: %> 107: data[<%i%>] ={ 108: title:"<%= hostname.get(i)%>" 109: <% 110: }

Hashy Over a year ago

@Hyunseung sorry I forgot equal sign and semicolon.

James · Accepted Answer · 2015-11-02 07:33:16Z

0

I replaced code as below and it works. Thank you so much Hashy!!

$(function () {
    var data =[]; 
     <%
        for(int i = 0; i < 2; i++) {
        %>
       data[<%=i%>] ={title:"<%= hostname.get(i)%>"};
     <%
     };
%>
     grid = new Slick.Grid("#myGrid", data, columns, options);
          })

answered Nov 2, 2015 at 7:33

James

3158 silver badges19 bronze badges

Collectives™ on Stack Overflow

javascript variable to jsp expression

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related