Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Uncaught SyntaxError: Unexpected token R in JSON at position 12
- at JSON.parse (<anonymous>)
- at XMLHttpRequest.xmlhttp.onreadystatechange ((index):112)
- HTML code --------------------------------------------
- <input type="text" id="ab" name="search" placeholder="Search.." onkeyup="myFunction()">
- JSP code --------------------------------------------
- <%@page import="java.sql.DriverManager"%>
- <%@page import="java.sql.ResultSet"%>
- <%@page import="java.sql.PreparedStatement"%>
- <%@page import="java.sql.Connection"%>
- <%@page contentType="text/html" pageEncoding="UTF-8"%>
- <%
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "");
- PreparedStatement ps = con.prepareStatement("SELECT * FROM student WHERE name = ?");
- String name=request.getParameter("name");
- ps.setString(1, name);
- ResultSet res = ps.executeQuery();
- ResultSetMetaData rsmd = res.getMetaData();
- int columnsNumber = rsmd.getColumnCount();
- if(res.first())
- {
- String str= res.getString(1)+" "+res.getString(2)+" "+res.getString(3)+" "+res.getString(4)+" "+res.getString(5);
- out.print(str) ;
- }else
- {
- out.print("Name not valid");
- }
- con.close();
- } catch (Exception e){
- System.out.println(e);
- }
- finally
- {
- }
- %>
- JS/AJAX/JSON code----------------------------------------------
- <script>
- function myFunction() {
- var name=document.getElementById("ab").value;
- var urls="time.jsp?name="+name;
- var xmlhttp;
- if (window.XMLHttpRequest)
- {
- xmlhttp=new XMLHttpRequest();
- }
- // code for IE6, IE5
- else
- {
- xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
- }
- xmlhttp.onreadystatechange=function()
- {
- if (xmlhttp.readyState==4 && xmlhttp.status==200)
- {
- var a = JSON.parse(xmlhttp.responseText);
- document.getElementById("deta").innerHTML=a;
- // want data be printed in "deta" html element
- }
- }
- xmlhttp.open("GET",urls,true);
- xmlhttp.send();
- }
- </script>
Add Comment
Please, Sign In to add comment