return.jsp

<%@ page import="java.sql.*,java.util.*,java.text.*,java.text.SimpleDateFormat" %>
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%@ page import="java.util.*,javax.mail.*"%>
<%@ page import="javax.mail.internet.*" %>
<%@ page import="java.util.Date" %>
<%
String userid = request.getParameter("userid");
String id0 = request.getParameter("bookname1");
String id1 = request.getParameter("bookname2");
String id2 = request.getParameter("bookname3");
String id3 = request.getParameter("bookname4");
java.util.Date now = new java.util.Date();
String DATE_FORMAT = "dd-MM-yyyy";
SimpleDateFormat sdf = new SimpleDateFormat(DATE_FORMAT);
String strDateNew = sdf.format(now) ;

Date currentDate = new Date();
        System.out.println(sdf.format(currentDate));

        // convert date to calendar
        Calendar c = Calendar.getInstance();
        c.setTime(currentDate);

        // manipulate date
        c.add(Calendar.DATE, 15);
      

        // convert calendar to date
        Date currentDatePlusOne = c.getTime();

      //  out.println(sdf.format(currentDatePlusOne));
        String dates = sdf.format(currentDatePlusOne);
        
        
        String idj[] = new String[4];
        idj[1] = request.getParameter("bookname2");
        idj[2] = request.getParameter("bookname3");
        idj[3] = request.getParameter("bookname4");

        int i=1;
        for(int j=1;j<=3;j++)
        {
            if(idj[j]==null || idj[j]=="" )
            {
        
            }
            else if(idj[j] != null || idj[j]!="")
            {
            out.println("Book Is  :"+idj[j]+"....");
            i++;
            }
}



String flag = request.getParameter("flag");
String flag1 = "0";
PreparedStatement pstmt;
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1/login", "root", "");
//pstmt=con.prepareStatement("Insert into transaction(userid,id0,id1,id2,id3,issue_date,return_date,flag) values(?,?,?,?,?,?,?,?)");
pstmt=con.prepareStatement("Update transaction set flag='"+flag1+"' where userid='"+ userid +"'and id0='"+ id0 +"' and id1='"+ id1 +"' and id2='"+ id2 +"' and id3='"+ id3 +"'");

//pstmt.setString(1,userid);
//pstmt.setString(2,id0);
//pstmt.setString(3,id1);
//pstmt.setString(4,id2);
//pstmt.setString(5,id3);
//pstmt.setString(6,strDateNew);
//pstmt.setString(7,dates);
//pstmt.setString(8,flag1);
pstmt.executeUpdate();

String id[] = new String[4];
id[0] = id0;
id[1] = id1;
id[2] = id2;
id[3] = id3;
        String book[] =new String[4];
        String bookname[] = new String[4];
        String authorname[] = new String[4];
        int ii=0;
        for(ii=0;ii<i;ii++)
        {
        book[ii] = id[ii];
        Class.forName("com.mysql.jdbc.Driver");
//        Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1/login", "root", "");
        Statement st = con.createStatement();
        ResultSet rs = st.executeQuery("select * from books where id='" + book[ii] + "'");
        if (rs.next()) {
        bookname[ii] = rs.getString("bookname");
        authorname[ii] = rs.getString("authorname");
//        out.println(book[ii]);
//        out.println(bookname[ii]);
//        out.println(authorname[ii]);
        }
        }
    //Creating a result for getting status that messsage is delivered or not!
    String result;
    
    
    String total = new String();
        for(int j1=0;j1<i;j1++)
        {
            total = total + bookname[j1]+" by "+authorname[j1]+"\n"; 
        }
    out.println("Total "+total);
    
    // Get recipient's email-ID, message & subject-line from index.html page
    final String to = request.getParameter("email");
    final String subject = "Book Return To Charusat Library by You.";
    final String messg = total;
    request.setAttribute("errorMessage1", "Book Return Successfully"); 
    RequestDispatcher dispatcher = request.getRequestDispatcher("returnbook.jsp");
    dispatcher.forward( request, response);
    // Sender's email ID and password needs to be mentioned
    final String from = "hdesai777.hd@gmail.com";
    final String pass = "7383000598";
    
    // Defining the gmail host
    String host = "smtp.gmail.com";
 
    // Creating Properties object
    Properties props = new Properties();
 
    // Defining properties
    props.put("mail.smtp.host", host);
    props.put("mail.transport.protocol", "smtp");
    props.put("mail.smtp.auth", "true");
    props.put("mail.smtp.starttls.enable", "true");
    props.put("mail.user", from);
    props.put("mail.password", pass);
    props.put("mail.port", "465");
 
    // Authorized the Session object.
    Session mailSession = Session.getInstance(props, new javax.mail.Authenticator() {
        @Override
        protected PasswordAuthentication getPasswordAuthentication() {
            return new PasswordAuthentication(from, pass);
        }
    });
 
    try {
        // Create a default MimeMessage object.
        MimeMessage message = new MimeMessage(mailSession);
        // Set From: header field of the header.
        message.setFrom(new InternetAddress(from));
        // Set To: header field of the header.
        message.addRecipient(Message.RecipientType.TO,
                new InternetAddress(to));
        // Set Subject: header field
        message.setSubject(subject);
        // Now set the actual message
        
        message.setText(messg);

        // Send message
        Transport.send(message);
        
        //response.sendRedirect("returnbook.jsp");
        result = "Your mail sent successfully....";
        //response.sendRedirect("returnbook.jsp");
        }
//        catch (IllegalStateException e) 
//        {
//           //response.sendRedirect("index.jsp");
//        }
        catch (MessagingException mex) 
        {
        mex.printStackTrace();
        result = "Error: unable to send mail....";
        //response.sendRedirect("returnbook.jsp");
        }
//        catch(Exception e)
//        {
//            response.sendRedirect("returnbook.jsp");
//        }
%>