JSP Servlet update patient data

Hi Friend,

I'm attaching my inserting patient data servlet as requested. I tried your posted code, its not working in my case, perhaps of the following things which I can explain to you so it is clearer.

1. I am doing a search on a patient visit table which has a FK on patient id, but there can be many visits by the same customer, right? meaning this id is repeated in the search results, however usually a patient will have only one visit on a particular date, so I decided that I will edit based on date of visit.which works fine but when I go to popup.jsp, I need to have the id as well because editing can be only done when you have in the where clause 'where patient_id='"+id+"' and dov='"+date+"'; if i use any other statement obviously there will be mutliple forms popping up on the edit window and that is not the desired result if you know what i mean, I need the particular one.

So with your code, I am getting the edit page but blank maybe because...
1. you have converted the date into 'mm-dd-yyyy' or 'dd-mm-yyyy' format where as my stored date is 'yyyymmdd' so right now in the URL, I am getting undefined=undefined-undefined

2. My index page has a patient register form and also the search facility on the same page, but this one is already resolved because I am doing it only based on id from your previous code. However, the issue or response Send Redirect so that the data from the form doesn't disappear which I requested last time.

3. Also, if you see my servlet code, you can see I am populating 2 tables based on a single form which works fine. but I cannot seem to get the fields populate in the edit process using the one while (rs.next()){ loop. Can you show me how to populate the rest of the fields from a different table? And finally, if my search result from the database returns no records based on the search criteria, I want a message "no records found' i tried many ways like while (rs.next()){ int count=0; ... count++;...if(count>0){ message"no records found'} but its not working, can you please show me how this can be done? Thank you so much for all your help.
Regards,

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.swing.*;

public class registeration extends HttpServlet{
@Override
public void init(ServletConfig config) throws ServletException{
super.init(config);
}
/**Process the HTTP Get request*/
@Override
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException{
String connectionURL = "jdbc:mysql://localhost:3306/patient_db";
Connection connection=null;
ResultSet rs;
res.setContentType("text/html");
PrintWriter out = res.getWriter();
String message_update="Data has been successfully inserted!";
String title="Update Message";
String error_message="Error Message ";



//get the variables entered in the form (patient table)
String patient_id = req.getParameter("pid");//not null, unique
String fname = req.getParameter("f_name");
String minitial = req.getParameter("m_initial");
String lname = req.getParameter("l_name");//not null
String gender =req.getParameter ("gender");//select option
String dateofbirth = req.getParameter("dob");//not null
String status = req.getParameter ("status");//select option
String hphone = req.getParameter ("hphone");
String wphone = req.getParameter ("wphone");//not null
String mphone = req.getParameter ("mphone");
String email = req.getParameter ("email");
String occupation = req.getParameter ("occupation");
String checkValues1[]=req.getParameterValues("region");//select list
String address = req.getParameter ("address");
String checkValues2[]=req.getParameterValues("bloodgrp");//select list
//String notes = req.getParameter ("notes");
//String picture = req.getParameter ("picture");

//Get Form Variables - Insurance Table columns

String checkValues3[]=req.getParameterValues("insurancec");//not null(select list)
String policynum = req.getParameter ("policynum");
String smoker = req.getParameter ("smoker");
String referredto = req.getParameter ("referredto");



try {
// Load the database driver
Class.forName("com.mysql.jdbc.Driver");
// Get a Connection to the database
connection = DriverManager.getConnection(connectionURL, "root", "root");

String value1="";
for(int i=0;i<checkValues1.length;i++){
value1+=checkValues1[i]+" ";
}
String value2="";
for(int i=0;i<checkValues2.length;i++){
value2+=checkValues2[i]+" ";
}
String value3="";
for(int i=0;i<checkValues3.length;i++){
value3+=checkValues3[i]+" ";
}



//Add the data into the patient table
String sql = "insert into patient values (?,?,?,?,?,STR_TO_DATE(?,'%m/%d/%Y'),?,?,?,?,?,?,?,?,?)";
PreparedStatement pst = connection.prepareStatement(sql);
pst.setString(1, patient_id);
pst.setString(2, fname);
pst.setString(3, minitial);
pst.setString(4, lname);
pst.setString(5, gender);
pst.setString(6,dateofbirth);
pst.setString(7, status);
pst.setString(8, hphone);
pst.setString(9, wphone);
pst.setString(10, mphone);
pst.setString(11, email);
pst.setString(12, occupation);
pst.setString(13, value1);
pst.setString(14, address);
pst.setString(15, value2);


//Add the data into the insurance table
String sql1 = "insert into insurance values (?,?,?,?,?)";
PreparedStatement pst1 = connection.prepareStatement(sql1);
pst1.setString(1,patient_id);
pst1.setString(2, value3);
pst1.setString(3, policynum);
pst1.setString(4, smoker);
pst1.setString(5, referredto);



int numRowsChanged = pst.executeUpdate();
int numRowsChanged1 = pst1.executeUpdate();

// show that the new data has been entered
JOptionPane.showMessageDialog(null,message_update,title,
JOptionPane.INFORMATION_MESSAGE);
res.sendRedirect("index.jsp");

pst.close();
pst1.close();
}
catch(ClassNotFoundException e){
JOptionPane.showMessageDialog(null,error_message + e.getMessage());
}
catch(SQLException e){
//out.println("SQLException caught: " + e.getMessage());
JOptionPane.showMessageDialog(null,error_message + e.getMessage());
res.sendRedirect("index.jsp");
}

catch (Exception e){
out.println(e);
}
finally {
// Always close the database connection.
try {
if (connection != null) connection.close();
}
catch (SQLException ignored){
out.println(ignored);
}
}
}
}