problem in accessing bean

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sumantabardhan
    New Member
    • Mar 2008
    • 1
    #1

    problem in accessing bean

    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 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="saltlake ">saltlake</option>-->

    <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"))
    { out.println("su manta");
    String delmessage=are. deleterecord();
    out.println(del message);
    }
    }

    catch(Exception E)
    {
    }

    %>
    can any help me solving this bcuz I can't delete data....
    Tags: None
    • Stang02GT
      Recognized Expert Top Contributor
      • Jun 2007
      • 1206
      #2
      Originally posted by sumantabardhan
      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 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="saltlake ">saltlake</option>-->

      <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"))
      { out.println("su manta");
      String delmessage=are. deleterecord();
      out.println(del message);
      }
      }

      catch(Exception E)
      {
      }

      %>
      can any help me solving this bcuz I can't delete data....
      sumantabardhan,

      Welcome! It appears that your question will fall into one of or specific forums. Please check out the Java and JavaScript forms, and PM a moderator and ask them to move your post to the correct forum.


      thanks!

        Comment

        Previous template Next
        Working...