Class.forName("oracle.jdbc.driver.OracleDriver");
            String url = "jdbc:oracle:thin:@127.0.0.1:1521:yuanchao";
            con = DriverManager.getConnection(url,"scott","tiger");
            st = con.createStatement();
            String sql = "select * from emp where empno="+p+" and ename='"+name+"'";
            System.out.println(sql);
            b = st.execute(sql);
            System.out.println(p+name);
            System.out.println(b);
我就是想做一个用户名和密码验证的例子，但好像返回的都是true。。
谢谢大家帮忙看看 ！

版主，那么要验证用户名和密码该如何验证呢？

jsp+servlet+javabean

javabean:


public class CheckUser {
    Connection con = null;
    PreparedStatement st = null;
    ResultSet rs = null;
    boolean b = true;
    public boolean checkUser(String name,int p)
    {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            String url = "jdbc:oracle:thin:@127.0.0.1:1521:yuanchao";
            con = DriverManager.getConnection(url,"scott","tiger");
            String sql = "select * from emp where empno=? and ename= ?";
            st = con.prepareStatement(sql);
        
            st.setInt(1, p);
            st.setString(2, name);
            System.out.println(sql);
            System.out.println(st.execute());
            boolean b  = st.execute();
            
            
            
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        finally
        {
            if(rs!=null)
            {
                try {
                    rs.close();
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
            }
            if(st!=null)
            {
                try {
                    st.close();
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
            }
            if(con!=null)
            {
                try {
                    con.close();
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
            }
        
            if(b==true)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
    }

}
问题好像出在红色的地方！只要赋值，返回的结果就是赋的直的结果

[[it] 本帖最后由 yc12 于 2008-9-4 16:36 编辑 [/it]]

servlet:应该没什么问题？
response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        String strname = request.getParameter("name");
        String pwd = request.getParameter("pwd");
        int p = Integer.parseInt(pwd);
        CheckUser c = new CheckUser();
        boolean b = c.checkUser(strname, p);
        if(b==true)
        {
            out.println("ok");
        }
        else
        {
            out.println("out");
        }

多谢版主了，我用resultset对象做出来了，但是如果不用resultset能不能做呢？我以前是做asp的，直接就可以execute就能判断了！不用resultset。要是不用resultset对象,可以不可以判断呢？

[[it] 本帖最后由 yc12 于 2008-9-5 09:45 编辑 [/it]]