Guest User

Untitled

a guest
Apr 19th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.87 KB | None | 0 0
  1. Uncaught SyntaxError: Unexpected token R in JSON at position 12
  2. at JSON.parse (<anonymous>)
  3. at XMLHttpRequest.xmlhttp.onreadystatechange ((index):112)
  4.  
  5.  
  6.  
  7.  
  8.  
  9. HTML code --------------------------------------------
  10.  
  11. <input type="text" id="ab" name="search" placeholder="Search.." onkeyup="myFunction()">
  12.  
  13. JSP code --------------------------------------------
  14.  
  15. <%@page import="java.sql.DriverManager"%>
  16. <%@page import="java.sql.ResultSet"%>
  17. <%@page import="java.sql.PreparedStatement"%>
  18. <%@page import="java.sql.Connection"%>
  19. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  20. <%
  21. try
  22. {
  23. Class.forName("com.mysql.jdbc.Driver");
  24. Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "");
  25. PreparedStatement ps = con.prepareStatement("SELECT * FROM student WHERE name = ?");
  26. String name=request.getParameter("name");
  27. ps.setString(1, name);
  28. ResultSet res = ps.executeQuery();
  29.  
  30. ResultSetMetaData rsmd = res.getMetaData();
  31. int columnsNumber = rsmd.getColumnCount();
  32.  
  33. if(res.first())
  34. {
  35.  
  36. String str= res.getString(1)+" "+res.getString(2)+" "+res.getString(3)+" "+res.getString(4)+" "+res.getString(5);
  37. out.print(str) ;
  38.  
  39. }else
  40. {
  41.  
  42. out.print("Name not valid");
  43. }
  44. con.close();
  45.  
  46. } catch (Exception e){
  47. System.out.println(e);
  48. }
  49. finally
  50. {
  51.  
  52. }
  53. %>
  54.  
  55.  
  56. JS/AJAX/JSON code----------------------------------------------
  57.  
  58. <script>
  59. function myFunction() {
  60.  
  61.  
  62. var name=document.getElementById("ab").value;
  63.  
  64. var urls="time.jsp?name="+name;
  65.  
  66. var xmlhttp;
  67. if (window.XMLHttpRequest)
  68. {
  69. xmlhttp=new XMLHttpRequest();
  70. }
  71. // code for IE6, IE5
  72. else
  73. {
  74. xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  75. }
  76.  
  77. xmlhttp.onreadystatechange=function()
  78. {
  79. if (xmlhttp.readyState==4 && xmlhttp.status==200)
  80. {
  81.  
  82. var a = JSON.parse(xmlhttp.responseText);
  83. document.getElementById("deta").innerHTML=a;
  84. // want data be printed in "deta" html element
  85.  
  86. }
  87. }
  88.  
  89. xmlhttp.open("GET",urls,true);
  90. xmlhttp.send();
  91. }
  92. </script>
Add Comment
Please, Sign In to add comment