Thanks for the response.
I still haven't found the complete solution.
Onchange of the combo box, How do i submit the combo box data from javascript back to the servlet.
Function of this servlet is to display the data of the user selected in the combo box. Hence i need to pass the name of the user back to the servlet to browse the database for this selected user's details like residence phone, office phone, lastname etc.
I am using bea-weblogic server.
I've pasted the following code below :-
1) Below is the servlet named EditPhonebookEntry.java
package Phonebook_Project;
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class EditPhonebookEntry extends HttpServlet
{
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String strSql = "";
String strUrl = "";
String strFirstName = "";
String strLastName = "";
String strHdnfirstname="";
int iCombocount = 0;
public void doGet (HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException
{
res.setContentType("text/html");
PrintWriter sysout = res.getWriter();
sysout.println("<html>");
sysout.println("<head>");
sysout.println("<Title> EDIT PHONE BOOK ENTRY PAGE </title>");
sysout.println("</head>");
sysout.println("<hr><h1 align=center> PHONEBOOK.COM </h1></hr>");
sysout.println("<body>");
sysout.println("<form name=EditPhonebookEntry method=post>");
sysout.println("<table border=0 cellspacing=1>");
sysout.println("<tr>");
sysout.println("<td> First Name:   </td> ");
sysout.println("<script language=\"javascript\" src=\"Phonebook_Project/fFirstname.js\">");
sysout.println("</script>");
sysout.println("<td> <select id=cmbFirstname name=cmbFirstname onChange=\"fFirstname()\">");
connectiondb();
try
{
rs = stmt.executeQuery(strSql);
iCombocount = 1;
while (rs.next())
{
strFirstName = rs.getString("FirstName");
sysout.println("<option value= " + strFirstName + " > " + strFirstName + " </option>");
iCombocount ++;
}
rs.close();
}
catch (Exception e)
{
System.out.println("The error is :" + e.getMessage());
}
sysout.println("</select>");
sysout.println("</td>");
sysout.println("<td><input type=hidden name=hdnFirstname></td>");
strHdnfirstname = req.getParameter("hdnFirstname");
System.out.println(strHdnfirstname);
sysout.println("<td> Last Name:   </td>");
sysout.println("<td> <input type=text name=txtLastName value=*****></td>");
sysout.println("</tr>");
sysout.println("<tr>");
sysout.println("<td> Residence Phone:   </td>");
sysout.println("<td> <input type=text name=txtResphone value=*****></td>");
sysout.println("</tr>");
sysout.println("<tr>");
sysout.println("<td> Office Phone:   </td>");
sysout.println("<td> <input type=text name=txtOffphone value=*****></td>");
sysout.println("</tr>");
sysout.println("<tr>");
sysout.println("<td> <br><input type=submit name=butBack value=BACK> </td>");
sysout.println("<td> <br><input type=submit name=butSave value=SAVE> </td>");
sysout.println("<td> <br><input type=submit name=butDelete value=DELETE> </td>");
sysout.println("</tr>");
sysout.println("</table>");
sysout.println("</form>");
sysout.println("</body>");
sysout.println("</html>");
};
public void connectiondb()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
strUrl = "jdbc

dbc

honebook";
con=DriverManager.getConnection(strUrl,"sa","");
stmt = con.createStatement();
strSql = "SELECT * FROM UserMaster";
}
catch (Exception e)
{
System.out.println("The error is :" + e.getMessage());
}
};
}
2) Below is the code for javascript named fFirstname.js
Note:- I've commented the lines which gives an error.
function fFirstname()
{
document.EditPhonebookEntry.hdnFirstname.value = document.EditPhonebookEntry.cmbFirstname.value;
//document.EditPhonebookEntry.action="http://localhost:8001/EditPhonebookEntry.java";
//Location="http://localhost:8001/EditPhonebookEntry.java"
//document.EditPhonebookEntry.method="post";
//document.EditPhonebookEntry.submit();
}
Note :-
These lines work perfectly in a jsp page but not in servlet.
If I convert this into a jsp page it works perfectly well as the form is submitted and accessed within the jsp page itself. But I want to do this pgm using servlets.
Thanks in advance.