Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var postData = $('#ajaxform').serializeArray();
- $
- .ajax({
- type: 'POST',
- url : "attendancePercentage",
- data : postData,
- dataType:'html',
- success : function(data, status) {
- alert(status);
- alert(data);
- }
- });
- protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- String stDate=request.getParameter("startDateValue");
- String enDate=request.getParameter("endDateValue");
- System.out.println(""+stDate+""+enDate+"");
- List stList = new ArrayList();
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = DriverManager.getConnection(
- "jdbc:mysql://localhost:3306/test_schema", "root", "root");
- String sql = "select * from attendance where attendance.date>=? and attendance.date<=?";
- PreparedStatement pstmt = con.prepareStatement(sql);
- pstmt.setString(1, stDate);
- pstmt.setString(2, enDate);
- rs = pstmt.executeQuery();
- while (rs.next()) {
- StudentMark ge = new StudentMark();
- ge.setStudentName(rs.getString(3));
- ge.setDate(rs.getString(2));
- ge.setStatus(rs.getString(4));
- stList.add(ge);
- }
- System.out.println("list>>"+stList);
- } catch (Exception e) {
- System.err.println(e.getMessage());
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement