title: Getting Error Message (Line 1: Incorrect syntax near 'password'.) while running Servlet
body: <p>I'm making servlet to work with J2ME, but whenever running this one getting below error message.</p>
  
  <p>Error: </p>
  
  <blockquote>
    <p>java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL
    Server]Line 1: Incorrect syntax near 'password'.)</p>
  </blockquote>
  
  <pre><code>public class GetNpostServlet extends HttpServlet
  {
  @Override
  protected void doGet(HttpServletRequest req, HttpServletResponse res) 
                       throws ServletException, IOException
  {
  // Same code appears in doPost()
  // Shown both places to emphasize that data is received thru
  // different means (environment variable vs stream), 
  // yet processed the same inside the servlet
  String acct = req.getParameter("account"),
          pwd = req.getParameter("password");    
  
  String balance = accountLookup(acct, pwd);
  
  if (balance == null)
  {
    res.sendError(HttpServletResponse.SC_BAD_REQUEST, 
   "Unable to locate  account.");            
    return;
  }
  
  res.setContentType("text/plain");    
  PrintWriter out = res.getWriter();
  out.print(balance);
  out.close();
  }
  
  @Override
  protected void doPost(HttpServletRequest req, HttpServletResponse res) 
                      throws ServletException, IOException
  {
  // Same code appears in doGet()
  // Shown both places to emphasize that data is received thru
  // different means (stream vs environment variable), 
  // yet processed the same inside the servlet
  String acct = req.getParameter("account"),
          pwd = req.getParameter("password");    
  
  String balance = accountLookup(acct, pwd);
  
  if (balance == null)
  {
    res.sendError(HttpServletResponse.SC_BAD_REQUEST, 
  "Unable to locate account.");            
    return;
  }
  
  res.setContentType("text/plain");    
  PrintWriter out = res.getWriter();
  out.print(balance);
  out.close();
  }
  
  /*--------------------------------------------------
   * Lookup bank account balance in database
   *-------------------------------------------------*/
  private String accountLookup(String acct, String pwd)
  {
  Connection con = null;
  Statement st = null;
  StringBuilder msgb = new StringBuilder("");
  
  try
  {
    // These will vary depending on your server/database      
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
    con = DriverManager.getConnection("jdbc:odbc:acctInfo");
  
    Statement stmt = con.createStatement();
    ResultSet rs = stmt.executeQuery(
                       "Select balance from acctInfo where account = " +
                       acct + "and password = '" + pwd + "'");      
  
    if (rs.next())
      return rs.getString(1);
    else
      return null;
     }
     catch (Exception e)
     {                  
      return e.toString();
      }
      }
  
      }
  </code></pre>