HI
I am doing a projects which has to delete a row in a data base
, and the it is a
servlet coding.
when executing the code in a browser, i am getting a message viz.
"oops, error[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause"
kindly go through my coding and let me know the bug plzz
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class Delete extends HttpServlet {
public void service(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
String username = req.getParameter("name");
String address = req.getParameter("address");
PrintWriter pw=res.getWriter();
pw.println("Name "+username);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con= DriverManager.getConnection("jdbc:odbc:ramesh","","");
if(con ==null){
pw.println("tere is error in connection");}
else{pw.println("wawww there is connection");}
Statement statement=con.createStatement();
ResultSet resultSet=statement.executeQuery("select * from members");
boolean temp=false;
String userID="";
while (resultSet.next())
{
userID=resultSet.getString(1);
temp=userID.equals(username);
if (temp)
{
pw.println("hi user");temp=true;break;}
}
if(temp){pw.println("u r a registered user");
while (resultSet.next())
{
userID=resultSet.getString(1);
temp=userID.equals(username);
if(temp){pw.println("hi user");temp=true;break;}
}
if(temp){pw.println("u r a registered user");
String stri = "delete from members (name, address)" + "values(?,?)";
PreparedStatement stmt = con.prepareStatement(stri);
stmt.setString(1,username);
stmt.setString(2,address);
int row = stmt.executeUpdate();
pw.println("your record has been deleted in the database");
statement.close();}
}
}
catch(ClassNotFoundException e) {pw.println("there is error");}
catch(SQLException e){pw.println("oops, error" +e.getMessage());}
}
}
------------------