QuestionAsk Questions?
manjith
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
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
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
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
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
