Popup very urgent plz

Expert:Ragavendran.R
Respected Sir/Madam,
I am R.Ragavendran.. I got your reply.. Thank you very much for the response. Now I am sending the code.. Here When I click "View Database" Button,a small pop up window must be opened which comprises of Employee ID and Employee Name present in the database.
When I click Employee ID present in the pop up box, The "Enter Employee ID" and "Enter Employee Name"text box must be filled automatically with the selected Employee ID and Name. I went through your coding but I dont know to apply it in my coding..
Her's the coding:
<%@ page language="java" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.sql.*" %>

<HTML>
<BODY BGCOLOR="LIGHTYELLOW">
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Employee","","");
Statement stmt=null;
%>
<FORM NAME="form" METHOD="GET" ACTION="process.jsp">

<H3> <P ALIGN="CENTER"> <FONT SIZE=6> EMPLOYEE DETAILS </FONT> </P> </H3> </BR> </BR>
<BR>
<BR>
<TABLE CELLSPACING=5 CELLPADDING=5 BGCOLOR="LIGHTBLUE" COLSPAN=2 ROWSPAN=2 ALIGN="CENTER">
<TR>
<TD> <FONT SIZE=5> Enter Employee ID </TD> <TD> <INPUT TYPE="TEXT" NAME="id"> </TD> <TD> <INPUT TYPE="BUTTON" VALUE="View Database">
</FONT> </TD>
</TR>
<TR>
<TD> <FONT SIZE=5> Enter Employee Name </TD>
<TD><INPUT TYPE="TEXT" NAME="name">
</FONT> </TD>
</TR>
<TR>
<TD> <FONT SIZE=5> Enter New Name (For UPDATE only) </TD>
<TD><INPUT TYPE="TEXT" NAME="nname"> </FONT> </TD>
</FONT> </TR>
<TR> <FONT SIZE=6>
<TD> <INPUT TYPE="SUBMIT" NAME="s1" VALUE="Insert">
<INPUT TYPE="SUBMIT" NAME="s1" VALUE="Delete">
<INPUT TYPE="SUBMIT" NAME="s1" VALUE="Update">
<INPUT TYPE="SUBMIT" NAME="s1" VALUE="Query"> </TD>
</TR> </FONT>
//The following portion also gets included in this code. I have written it for Query operation.//
<%
if(session.getAttribute("empcode") !=null && session.getAttribute("empname") !=null) { %>
<script language="javascript">
document.getElementById('id').value=<%=session.getAttribute("empcode").toString()%>
document.getElementById('name').value='<%=session.getAttribute("empname").toString()%>'
</script>
<%
session.removeAttribute("empcode");
session.removeAttribute("empname");
}

%>
</FORM>
</BODY>
</HTML>

Its Very Urgent..
Please send me the coding asap..

Thanks/Regards,
R.Ragavendran..

Answers

Hi firend,

<%@ page language="java" %>

<%@ page import="java.lang.*" %>

<%@ page import="java.sql.*" %>

<HTML>

<head>

</head>

<BODY BGCOLOR="LIGHTYELLOW">

<%

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

//Connection con=DriverManager.getConnection("jdbc:odbc:Employee","","");

Statement stmt=null;

%>

<FORM NAME="form" METHOD="GET" ACTION="process.jsp">

<H3> <P ALIGN="CENTER"> <FONT SIZE=6> EMPLOYEE DETAILS </FONT> </P> </H3> </BR> </BR>

<BR>

<BR>

<TABLE CELLSPACING=5 CELLPADDING=5 BGCOLOR="LIGHTBLUE" COLSPAN=2 ROWSPAN=2 ALIGN="CENTER">

<TR>

<TD> <FONT SIZE=5> Enter Employee ID </TD> <TD> <INPUT TYPE="TEXT" NAME="id" id="emp_id"> </TD> <TD> <INPUT TYPE="button" NAME="s1" VALUE="View Database" onClick="window.open('winopen.jsp','mywindow','width=500,height=350,toolbar=no,resizable=yes,menubar=yes')">

</FONT> </TD>

</TR>

<TR>

<TD> <FONT SIZE=5> Enter Employee Name </TD>

<TD><INPUT TYPE="TEXT" NAME="name" id="emp_name">

</FONT> </TD>

</TR>

<TR>

<TD> <FONT SIZE=5> Enter New Name (For UPDATE only) </TD>

<TD><INPUT TYPE="TEXT" NAME="nname"> </FONT> </TD>

</FONT> </TR>

<TR> <FONT SIZE=6>

<TD> <INPUT TYPE="SUBMIT" NAME="s1" VALUE="Insert">

<INPUT TYPE="SUBMIT" NAME="s1" VALUE="Delete">

<INPUT TYPE="SUBMIT" NAME="s1" VALUE="Update">

<INPUT TYPE="SUBMIT" NAME="s1" VALUE="Query"> </TD>

</TR> </FONT>

<%

if(session.getAttribute("empcode") !=null && session.getAttribute("empname") !=null) { %>

<script language="javascript">

document.getElementById('id').value=<%=session.getAttribute("empcode").toString()%>

document.getElementById('name').value='<%=session.getAttribute("empname").toString()%>'

</script>

<%

session.removeAttribute("empcode");

session.removeAttribute("empname");

}

%>

</FORM>

</BODY>

</HTML>

<%@ page import="java.sql.*" %>

<html>

<head>

<script type="text/javascript">

function trim(stringToTrim) {

return stringToTrim.replace(/^\s+|\s+$/g,"");

}

function showEmp(emp_value)

{

xmlHttp=GetXmlHttpObject();

if (xmlHttp==null)

{

alert ("Browser does not support HTTP Request")

return

}

var url="getuser.jsp"

url=url+"?emp_id="+emp_value;

xmlHttp.onreadystatechange=stateChanged

xmlHttp.open("GET",url,true)

xmlHttp.send(null)

}

function stateChanged()

{

if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")

{

var showdata = xmlHttp.responseText;

var strar = trim(showdata).split(":");

if(strar.length>0)

{

window.opener.location.reload();

window.location.reload();

window.close();

opener.document.getElementById("emp_id").value=strar[1];

opener.document.getElementById("emp_name").value=strar[0];

window.close();

}

}

}

function GetXmlHttpObject()

{

var xmlHttp=null;

try

{

// Firefox, Opera 8.0+, Safari

xmlHttp=new XMLHttpRequest();

}

catch (e)

{

//Internet Explorer

try

{

xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");

}

catch (e)

{

xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");

}

}

return xmlHttp;

}

</script>

</head>

<body>

<form name="employee">

<br><br>

<table border="0" width="400px" align="center" bgcolor="#CDFFFF">

<tr><td align="center"><b>Select Employee Id</b></td></tr>

<tr><td align="center">

<select name="emp_id" onchange="showEmp(this.value);">

<option value="-1">Select</option>

<%

Connection conn = null;

String url = "jdbc:mysql://localhost:3306/";;

String dbName = "user_register";

String driver = "com.mysql.jdbc.Driver";

String userName = "root";

String password = "root";

int sumcount=0;

Statement st;

try {

Class.forName(driver).newInstance();

conn = DriverManager.getConnection(url+dbName,userName,password);

String query = "select * from employee_details";

st = conn.createStatement();

ResultSet rs = st.executeQuery(query);

%>

<%

while(rs.next())

{

%>

<option value="<%=rs.getString(1)%>"><%=rs.getString(1)%></option>

<%

}

%>

<%

}

catch (Exception e) {

e.printStackTrace();

}

%>

</select>

</td></tr>

</table>

</body>

</html>

--------------------------------------------------------

Thanks

Amardeep

Read for more information

http://www.roseindia.net/jsp

More Questions

Post Answers

Ask Question Facing Programming Problem?