package area;
import java.sql.*;
import java.util.*;
public class area
{
int id;
public void setId(int id)
{
this.id=id;
}
public String deleterecord()
{
String message="";
try{
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
Connection con=DriverManag er.getConnectio n("Jdbc:Odbc:my DSN","sa","");
PreparedStateme nt st=con.prepareS tatement("delet e from tbl_area where id=?");
st.setInt(1,id) ;
st.executeUpdat e();
message="record deleted";
}
catch(Exception e)
{
message=e.getMe ssage();
}
return message;
}
this is my bean area class..
----------------------------------------------------
<%@page contentType="te xt/html"%>
<%@page pageEncoding="U TF-8"%>
<%@page import="java.sq l.*"%>
<%@page import="java.io .*"%>
<%@page import="java.ut il.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<jsp:useBean id="are" class="area.are a" scope="page">
<%
String s=request.getPa rameter("ares") ;
if(s!=null)
{
%>
<jsp:setPropert y name="are" property="id" param="ares"/>
<%
}
%>
</jsp:useBean>
<%
try{
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
Connection con=DriverManag er.getConnectio n("Jdbc:Odbc:my DSN","sa","");
Statement st=con.createSt atement();
ResultSet rs=st.executeQu ery("select id,aname from tbl_area where status='Y'");
%>
<form action="area.js p" method="get">
Select area:
<select name="areas" >
<option value="">select area</option>
<%
while(rs.next() )
{
%>
<option value="<%=rs.ge tString(1)%>">< %=rs.getString( 2)%></option>
<%
}
%>
</select>
<br><br><br>
<input type="submit" name="Submit" value="edit">
<input type="submit" name="Submit" value="delete">
</form>
<%
}
catch(Exception e)
{out.println(e) ;}
%>
<%
try{
if(request.getP arameter("submi t").equals("del ete"))
{
String delmessage=are. deleterecord();
out.println(del message);
}
}
catch(Exception E)
{
}
%>
can anybody help me why the data is not being deleted?plzz it's kind of urgent
import java.sql.*;
import java.util.*;
public class area
{
int id;
public void setId(int id)
{
this.id=id;
}
public String deleterecord()
{
String message="";
try{
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
Connection con=DriverManag er.getConnectio n("Jdbc:Odbc:my DSN","sa","");
PreparedStateme nt st=con.prepareS tatement("delet e from tbl_area where id=?");
st.setInt(1,id) ;
st.executeUpdat e();
message="record deleted";
}
catch(Exception e)
{
message=e.getMe ssage();
}
return message;
}
this is my bean area class..
----------------------------------------------------
<%@page contentType="te xt/html"%>
<%@page pageEncoding="U TF-8"%>
<%@page import="java.sq l.*"%>
<%@page import="java.io .*"%>
<%@page import="java.ut il.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<jsp:useBean id="are" class="area.are a" scope="page">
<%
String s=request.getPa rameter("ares") ;
if(s!=null)
{
%>
<jsp:setPropert y name="are" property="id" param="ares"/>
<%
}
%>
</jsp:useBean>
<%
try{
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
Connection con=DriverManag er.getConnectio n("Jdbc:Odbc:my DSN","sa","");
Statement st=con.createSt atement();
ResultSet rs=st.executeQu ery("select id,aname from tbl_area where status='Y'");
%>
<form action="area.js p" method="get">
Select area:
<select name="areas" >
<option value="">select area</option>
<%
while(rs.next() )
{
%>
<option value="<%=rs.ge tString(1)%>">< %=rs.getString( 2)%></option>
<%
}
%>
</select>
<br><br><br>
<input type="submit" name="Submit" value="edit">
<input type="submit" name="Submit" value="delete">
</form>
<%
}
catch(Exception e)
{out.println(e) ;}
%>
<%
try{
if(request.getP arameter("submi t").equals("del ete"))
{
String delmessage=are. deleterecord();
out.println(del message);
}
}
catch(Exception E)
{
}
%>
can anybody help me why the data is not being deleted?plzz it's kind of urgent
Comment