Advertisement
Guest User

Untitled

a guest
Jun 3rd, 2016
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. var postData = $('#ajaxform').serializeArray();
  2. $
  3. .ajax({
  4. type: 'POST',
  5. url : "attendancePercentage",
  6. data : postData,
  7. dataType:'html',
  8. success : function(data, status) {
  9. alert(status);
  10. alert(data);
  11. }
  12. });
  13.  
  14. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  15.  
  16.  
  17. String stDate=request.getParameter("startDateValue");
  18. String enDate=request.getParameter("endDateValue");
  19. System.out.println(""+stDate+""+enDate+"");
  20. List stList = new ArrayList();
  21.  
  22. try {
  23. Class.forName("com.mysql.jdbc.Driver");
  24. Connection con = DriverManager.getConnection(
  25. "jdbc:mysql://localhost:3306/test_schema", "root", "root");
  26. String sql = "select * from attendance where attendance.date>=? and attendance.date<=?";
  27.  
  28. PreparedStatement pstmt = con.prepareStatement(sql);
  29. pstmt.setString(1, stDate);
  30. pstmt.setString(2, enDate);
  31.  
  32. rs = pstmt.executeQuery();
  33. while (rs.next()) {
  34. StudentMark ge = new StudentMark();
  35.  
  36. ge.setStudentName(rs.getString(3));
  37. ge.setDate(rs.getString(2));
  38. ge.setStatus(rs.getString(4));
  39.  
  40. stList.add(ge);
  41. }
  42. System.out.println("list>>"+stList);
  43.  
  44. } catch (Exception e) {
  45. System.err.println(e.getMessage());
  46. }
  47.  
  48.  
  49.  
  50. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement