|
|
| Radio Buttons in DB Very Urgent |
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 JSP Page containing database is opened which comprises of Employee ID and Employee Name present in the database.Here I need Radio Buttons added dynamically for each Row. When I click the corresponding Radio Button and Submit,The Emp ID and Emp Name must automatically comes and sits in the corresponding Text Box in FindEmployee.jsp Page..
Her's the coding:
FINDEMPLOYEE.JSP:
<%@ 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>
-----------------------------------------------------------------------
DATABASE.JSP:
<%@ page language="java" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY BGCOLOR="LIGHTYELLOW">
<FORM NAME="f1" ACTION="FindEmployee.jsp">
<%
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Employee","","");
Statement stmt=null;
String query=null;
query="SELECT Emp_code,Emp_name FROM Employee ORDER BY Emp_code";
stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(query);
out.println("<B> <CENTER> EMPLOYEE NAME </CENTER> </B>");
ResultSetMetaData rsmd=rs.getMetaData();
int colcount=rsmd.getColumnCount();
out.println("<TABLE ALIGN=CENTER BORDER=1 CELLPADDING=2>");
out.println("<TR>");
for(int i=1;i<=colcount;i++) {
out.println("<TH>" +rsmd.getColumnLabel(i)+ "</TH>");
}
while(rs.next()) {
out.println("<TR>");
out.println("<TD>" +rs.getInt("Emp_code")+ "</TD>");
out.println("<TD>" +rs.getString("Emp_name")+ "</TD>");
out.println("</TR>");
}
out.println("</TABLE>");
out.println("</BODY>");
con.commit();
stmt.close();
rs.close();
con.close();
}
catch(Exception e) {
out.println("End Of Database");
}
%>
<P ALIGN="CENTER"> <INPUT TYPE="SUBMIT" VALUE="SUBMIT"> </P>
</FORM>
</BODY>
</HTML>
------------------------------------------------------------------------------
Its Very Urgent..
Please send me the coding asap..
Thanks/Regards,
R.Ragavendran.. |
| Answers |
hi friend,
<%@ 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('winopenradio.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 validate()
{
var emp_value ="";
for (var i=0; i < document.employee.empid.length; i++)
{
if (document.employee.empid[i].checked)
{
var emp_value = document.employee.empid[i].value;
}
}
if(emp_value=="" || emp_value==null)
{
alert("Please select Employee Id");
return false;
}
return true
}
function showEmp()
{
if(validate()){
for (var i=0; i < document.employee.empid.length; i++)
{
if (document.employee.empid[i].checked)
{
var emp_value = document.employee.empid[i].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" colspan=2><b>Select Employee Id</b></td></tr>
|
<%
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())
{
%>
<tr><td align="center" width="50%"><input type="radio" name="empid" value=<%=rs.getString(1)%>><%=rs.getString(1)%></td><td width="50%"><%=rs.getString(2)%></td></tr>
<%
}
%>
<%
}
catch (Exception e) {
e.printStackTrace();
}
%>
<tr><td align="center" width="50%"><input type="button" value="Select" onclick="javascript:showEmp();"</td></tr>
</table>
</form>
</body>
</html>
---------------------------------------------
Read for more information.
http://www.roseindia.net/jsp/
Thanks
|
| More Questions |
|
|
Post Answers
Ask Question
Facing Programming Problem?
|
|
|
|
|
