public String insertCustomerDetails(String memNo) {
CustomerDBConnection c = new CustomerDBConnection();
String res = " ";
ResultSet rs = null;
String status = "pending";
int quantity = 1;
String type = "DVD";
String fine = "0";
try {
String issuedate = c.calculateIssueDate();
String duedate = c.calculateDueDate();
String query1 = "Select movieID from cart where memNo=?";
ps = con.prepareStatement(query1);
ps.setString(1, memNo);
rs = ps.executeQuery();
while (rs.next()) {
String movieid = rs.getString(1);
System.out.println("inside db");
String query =
"Insert into customerdetails(membershipno,movieid,quantity,type,issueddate,duedate,status,fine) values(?,?,?,?,?,?,?,?)";
ps = con.prepareStatement(query);
ps.setString(1, memNo);
ps.setString(2, movieid);
ps.setInt(3, quantity);
ps.setString(4, type);
ps.setString(5, issuedate);
ps.setString(6, duedate);
ps.setString(7, status);
ps.setString(8, fine);
ps.executeUpdate();
}
String query3 = "Delete from cart where memNo=?";
ps = con.prepareStatement(query3);
ps.setString(1, memNo);
ps.executeUpdate();
res = "true";
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return res;
}
