谁能帮帮我,这究竟是哪里错了.........

Question

<%@ page language="java" import="java.sql.*" %> <jsp:useBean id="RegisterBean" scope="page" class="opendb.opendb" />
<%
  String name1=request.getParameter("username");
 
  String pwd1=request.getParameter("password");
  
   String sql="select from user where username='"+name1+"'and password='"+pwd1+"'";
        ResultSet rs=RegisterBean.executeQuery(sql);
       if(rs.next())
        {
           rs.close();
   session.putValue("username",name1);
           
  %>
     
 <script language=javascript>
    window.loction="info.jsp?str=登陆成功"
   </script>
<%
     }
  else
{
   rs.close();
   session.putValue("login_message","Error on Login!");
   %>
    <script language=javascript>
    window.loction="info.jsp?str=登陆失败"
   </script>
   <%
      }
   %>

Answer 1

tomcat处显示说关键字user附近有错误,到底是哪里错了,谢谢大家了!!!1

Answer 2

String sql="select from user where username= 中的select from user 
应该是Select * from user吧！
Sql语句写错了。