Parent - child jsp communication

View Answers

July 14, 2009 at 1:34 PM

Hi Friend,

Please visit the following links:

http://www.roseindia.net/jsp/popup-window-using-ajax-in-jsp.shtml
http://www.roseindia.net/jsp/pop-window.shtml

Hope that it will be helpful for you.
Thanks

July 14, 2009 at 4:36 PM

Hi..,

you can use query string to pass values..

like showpopup.jsp?kms=4500

hope will help you

Thanks
Sakthivel

July 16, 2009 at 3:38 PM

Hi Friend,

Try the following code:

1)user.jsp:
<%@ page import="java.sql.*" %>
<html>
<head>
<script language="javascript">
function editRecord(id){
window.open('http://localhost:8080/examples/jsp/edituser.jsp?id='+id,'mywindow','width=500, height=350,toolbar=no,resizable=yes,menubar=yes');

}
</script>
</head>
<body>

<br><br>
<table border="1">
<tr><th>Serial No</th><th>From City</th><th>To City</th><th>Distance</th><th></th></tr>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "test";
String driver = "com.mysql.jdbc.Driver";
String userName ="root";
String password="root";

int sumcount=0;
Statement st;
try{
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+db,userName,password);
String query = "select * from Person";
st = con.createStatement();
ResultSet rs = st.executeQuery(query);
%>

<%
while(rs.next()){
%>
<tr><td><%=rs.getString(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><input type="button" name="edit" value="Edit" style="background-color:#49743D;font-weight:bold;color:#ffffff;" onclick="editRecord(<%=rs.getString(1)%>);" ></td>
</tr>
<%
}
%>
<%
}
catch (Exception e) {
e.printStackTrace();
}
%>
</table>
</form>
</body>
</html>

2)edituser.jsp
<%@page language="java"%>
<%@page import="java.sql.*"%>
<form method="post" action="update.jsp">
<table border="1">
<tr><th>Serial No</th><th>From City</th><th>To City</th><th>Distance</th></tr>
<%
String id=request.getParameter("id");
int no=Integer.parseInt(id);

Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";;
String dbName = "test";
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 Person where serialNo='"+no+"'";
st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
while(rs.next()){
%>

<tr>
<td><input type="text" name="sNo" value="<%=rs.getString(1)%>"></td>
<td><input type="text" name="from" value="<%=rs.getString(2)%>"></td>
<td><input type="text" name="to" value="<%=rs.getString(3)%>"></td>
<td><input type="text" name="dis" value="<%=rs.getString(4)%>"></td>
</tr>
<tr>
<td><input type="submit" name="Submit" value="Update" style="background-color:#49743D;font-weight:bold;color:#ffffff;"></td>
</tr>
<%
}
}
catch(Exception e){}
%>
</table>
</form>
</form>

3)update.jsp
<%@page import="java.sql.*"%>
<% String no=request.getParameter("sNo");
String from=request.getParameter("from");
String to=request.getParameter("to");
String distance=request.getParameter("dis");
try{
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root";, "root");

Statement st=null;
st=conn.createStatement();
st.executeUpdate("update Person set serialNo='"+no+"', fromCity='"+from+"',toCity='"+to+"',distance='"+distance+"' where serialNo='"+no+"'");
out.println("Data is updated successfully");
}
catch(Exception e){}
%>

Thanks