Hi,
How can I refresh my JSP Page?
I am addind and deleting some mrecords with pressing button on my JSP page, but everytime I have to use browser's back button and hit refresh to see the updates.
How can I just refresh it every time I update the page..
Your help will be appreciated.
Thanks
> document.forms[0].submit(); make it as a js function
> and call when you add/delete an record.
Hey skp71,
I am already calling JS function add and delete on onclick event of ADD and DELETE button.
I tried writting document.forms[0].submit(); in my function.
But id didn't work.
Could anyone help please?
Thanks
int i = delete_Customer(delName);
System.out.println("i:"+i);
if (i==1)
{
System.out.println("Sending response");
response.sendRedirect("/abc/CustomerList.jsp");
}
//
//
int delete_Customer(String delName) {
// TODO Auto-generated method stub
int i=0;
Statement stmt = null;
Connection con = null;
try
{
System.out.println("In Try block for Deleting values");
Class driverClass = Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
Driver driver = (Driver) driverClass.newInstance();
DriverManager.registerDriver(driver);
con = DriverManager.getConnection("jdbc:db2:" + DB2Server, DB2UserID, DB2pass);
stmt = con.createStatement();
System.out.println(delName);
String query =
"DELETE FROM CUSTOMERNAME WHERE Customer_Name = '" +delName.trim()+ "'";
System.out.println("Values Deleted");
i = stmt.executeUpdate(query);
System.out.println("Nrows="+i);
stmt.close();
con.close();
}
catch(Exception e)
{
System.out.println("EXCEPTION : "+e.toString());
try
{
System.out.println("Severe error in DELETE, unable to continue");
if(stmt != null)
stmt.close();
if(con != null)
con.close();
}
catch(SQLException se)
{
System.out.println(se.toString());
}
}
System.out.println("i:"+i);
return i;
}//delete method ends
This is my servlet code.
It's not throwing any error,
it's also going to my system log (sending response) but then it doesn't redirect it to the jsp page.
Thanks
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException
{
doGet(request, response);
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException
{
String Cust_Name,DELETE;
DB2Server = props.getProperty("SERVER");
DB2UserID = props.getProperty("USER");
DB2pass =props.getProperty("PASS");
Cust_Name = null;
DELETE = null;
if((tStr = request.getParameter("CUSTOMER_NAME")) != null) {
Cust_Name = tStr;
}
if((tStr = request.getParameter("DELETE")) != null) {
DELETE = tStr;
}
if(DELETE !=null) {
if(DELETE.equals("DELETE")){
System.out.println("HW: DELETE Customer: " );
if((tStr = request.getParameter("Selected_names"))!= null){
System.out.println(tStr);
String delName="";
int pos = 0;
pos=tStr.trim().indexOf(",");
while ( pos != -1) //till there is atleast 1 ,
{
System.out.println("while loop");
delName = tStr.substring(0, tStr.indexOf(","));
tStr = tStr.substring(tStr.indexOf(",") + 1 );
System.out.println("DElName:"+delName);
System.out.println("tStr::"+tStr);
System.out.println("Customer names to be deleted are:"+delName.trim());
int i = delete_Customer(delName);
System.out.println("i:"+i);
if (i==1)
{
System.out.println("Sending response");
response.sendRedirect("/aaa/CustomerList.jsp");
}
delName = tStr.trim();
pos=tStr.indexOf(",");
}//while ends
}
}//2nd if ends
}//if ends
It's in doGet.
thanks
All,
all of a sudden, it started working if I just delete one record.
For more then one record I put if i>=1, but it didn't work
any idea? why?
Let me know
int i = delete_Customer(Cust_Name);
System.out.println("i:"+i);
System.out.println("check value of i");
if (i==1 || i>=1)
{
System.out.println("Sending response");
response.sendRedirect("/aaa/CustomerList.jsp");
}
I also trie if (i!= 0)
Thanks
hi avni,
here u can't acces that type condition.
int i = delete_name(name);
becoz, here the Value of i is only 1 or 0 based on the query exceution.
if the record is delete it returns 1 otherwiae it ll return 0
i think u ll catch my point.
Bala
hi avni,
if u want to delete the multiple data in database in one click, i am right.
yes it can be possible.
we have an option in Java.SQL
that is executeBatch();
can u know about this
i think the below link is very useful for u.
http://jug.org.ua/wiki/display/JavaAlmanac/Executing+a+Batch+of+SQL+Statements+in+a+Database
Bala
