I want to reload the same page after performing ajax call without jquery.Is it possible? In my code i am going to delete database names inside a table.after deleting the dbnames,the page doesn't show the dbnames.Is it possible?I tried it with window.location="Databases.jsp" But it didn't work.What can i do to perform this task?also i am displaying the table containing database name inside a framset.So when i chage/delete database name i want to refresh the left side frameset also.(that is i need to refresh the whole page)My code:
Database.jsp
<%--
Document : Databases
Created on : Nov 10, 2014, 3:08:01 PM
Author : user
--%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DatabaseMetaData"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="querywork.DBConnection"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<script language="javascript" type="text/javascript">
var request;
function drop()
{
var cboxes = document.getElementsByName('ch');
var len = cboxes.length;
var dbnam = document.getElementById("hid") .value
var dbs="";
var dbname=dbnam.split(",")
for (var i=0; i<len; i++) {
if(cboxes[i].checked)
{
dbs= dbname[i]
var url="Delete.jsp?val="+dbs;
if(window.XMLHttpRequest){
request=new XMLHttpRequest();
}
else if(window.ActiveXObject){
request=new ActiveXObject("Microsoft.XMLHTTP");
}
try
{
request.onreadystatechange=getInfo;
request.open("GET",url,true);
request.send();
}
catch(e)
{
alert("Unable to connect to server");
}
}
}
}
function getInfo(){
if(request.readyState==4){
var val=request.responseText;
document.getElementById('amit').innerHTML=val;
}
}
</script>
</head>
<body>
<form id="form1" name="form1" method="post" action="">
<h2>Databases</h2>
<label>
<input type="text" name="textfield" value="Database Name" id="dbname" />
</label>
<label>
<input type="submit" name="Submit" value="CREATE" onClick="create(textfield.value)"/>
</label>
<p> </p>
<%
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/", "root", "");
DatabaseMetaData dbmd = conn.getMetaData();
ResultSet ctlgs = dbmd.getCatalogs();
%>
<table border="1" cellpadding ="2"cellspacing="3">
<tr>
<td>
</td>
<td>
Database Name
</td>
</tr>
<%
String dbnme = "";
int i = 0;
while (ctlgs.next()) {
dbnme = dbnme + ctlgs.getString(1) + ",";
String name = "ch" + i;
%>
<tr>
<td>
<input name="ch" type="checkbox" value="" id="<%=name%>"/>
</td>
<td>
<%=ctlgs.getString(1)%>
</td>
</tr>
<%
i++;
}%>
</table>
<input type="hidden" name="hid" id="hid1" value="<%=i%>"/>
<input type="hidden" name="hid" id="hid" value="<%=dbnme%>"/>
<%
} catch (Exception e) {
out.println(e);
}%>
<font color="blue"><u><label id="lid" onclick="drop()"> Drop</label></u></font>
<br></br>
<div id="amit"></div>
</form>
</body>
Delete.jsp
<%--
Document : Delete
Created on : Nov 11, 2014, 9:43:22 PM
Author : user
--%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="querywork.DBConnection"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<%
String responseText = "";
String message = "";
String dbname = request.getParameter("val");
boolean flg = false;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/", "root", "");
PreparedStatement ps = conn.prepareStatement("DROP DATABASE " + dbname);
int k = ps.executeUpdate();
if (k > 0) {
flg = true;
} else {
flg = false;
}
if (flg) {
message = "success";
} else {
message = "failed";
}
// }
responseText = "Deleted";
out.println(responseText);
//response.sendRedirect("index.html");
%>
<input type="hidden" id="hid" value="<%=message%>"/>
<script>
var msg=document.getElementById("hid"). value
alert(msg)
window.location='Databases.jsp';
</script>
