Monday, 27 July 2015

Postgresql

DELETE QUERY:



<%@page import="java.util.ArrayList"%>
<%@page import="java.util.HashMap"%>

<%
if(session.getAttribute("authData")==null){
response.sendRedirect("/adminconsole/login.jsp");
return;
}

%>
<html>
<head>
<%@ include file="../general/styles.css"%>
<%@ include file="../general/header.jsp"%>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<style type="text/css">
.odd {
background-color: #E4FAE6;
}

.even {
background-color: #F1FCF2;
}

.head {
background-color: silver;
}
</style>
</head>

<body>

<%
DBManager dbmanager=new DBManager();
String query="delete from eventinfo where eventid='847191235'";


    System.out.println("query is:"+query);
  StatusObj statobj = DbUtil.executeUpdateQuery(query,null);
 
  out.println("deleted successfully");
 
%>

</body>
</html>