Monday, 27 July 2015

Postgresql

INSERT QUERY;


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

%>
<html>
<head>
<%@ include file="/general/styles.css"%>
<%@page import="com.eventbee.general.DBManager"%>
<%@page import="com.eventbee.general.StatusObj"%>
<%@page import="com.eventbee.general.DbUtil"%>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Update</title>
</head>
<body>
SDFGHJKSDFGHJK
<%
DBManager dbmanager=new DBManager();
String Query="insert into eventinfo(eventid,eventname,city) values(?,?,?)";

StatusObj statobj=DbUtil.executeUpdateQuery(Query,new String[]{"1234567","Mamatha Varma","Tirupathi"});
out.println("updated successfully");

%>
</body>
</html>