3
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.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:myDSN", "sa","");
PreparedStatement st=con.prepareStatement("delete from tbl_area where id=?");
st.setInt(1,id);
st.executeUpdate();
message="record deleted";
}
catch(Exception e)
{
message=e.getMessage();
}
return message;
}
this is my bean area class..
----------------------------------------------------
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<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.area" scope="page">
<%
String s=request.getParameter("ares");
if(s!=null)
{
%>
<jsp:setProperty name="are" property="id" param="ares"/>
<%
}
%>
</jsp:useBean>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:myDSN", "sa","");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select id,aname from tbl_area where status='Y'");
%>
<form action="area.jsp" method="get">
Select area:
<select name="areas" >
<option value="">select area</option>
<%
while(rs.next())
{
%>
<option value="<%=rs.getString(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.getParameter("submit").equals("delete") )
{
String delmessage=are.deleterecord();
out.println(delmessage);
}
}
catch(Exception E)
{
}
%>
can anybody help me why the data is not being deleted?plzz it's kind of urgent
