jsp连接数据库

你的数据源名在哪呢?
也不建议用jdbc-odbc桥.直接用数据库for jdbc的库吧

解决方案 »

  1.   

    我是用的2000server+jdk1.42+jswdk1.01
    在access中建表userlist，字段为username，password。（帐号为xyz。密码是123）
    登陆页login.htm
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <title>无标题文档</title>
    </head><body>
    <form name="form1" method="post" action="check.jsp">
      <table width="24%" height="62" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td width="42%">用户名</td>
          <td width="58%"><input name="username" type="text" size="14"></td>
        </tr>
        <tr> 
          <td>密码</td>
          <td><input name="password" type="password" size="14"></td>
        </tr>
        <tr>
          <td><input type="submit" name="Submit" value="确定"></td>
          <td><input type="reset" name="Submit2" value="取消"></td>
        </tr>
      </table>
    </form>
    </body>
    </html>验证页：check.jsp<%@ page import="java.sql.*" %>
    <%
    String url="jdbc:odbc:userlist";
    String driver="sun.jdbc.odbc.JdbcodbcDriver";
    Class.forName(driver);
    Connection conn=DriverManager.getConnection(url,"xyz","123");
    Statement sqlStatement=conn.createStatement();
    String sql="select * from userlist";
    ResultSet rs=sqlStatement.executeQuery(sql);
    String username=request.getParameter("username");
    String password=request.getParameter("password");
    String role="SB";
    while(rs.next())
    {
      if (username.equals(rs.getString("username"))&&password.equals(rs.getString("password")))
    {
       role=rs.getString("role");
       }
    }
    %>
    you are <%=role%>!
    错误提示是：
    IMPORTANT: Do not modify the generated servlets
    Unhandled error! You might want to consider having an error page to report such
    errors more gracefully
    com.sun.jsp.JspException: Compilation failed:Note: sun.tools.javac.Main has bee
     deprecated.
    work\%3A8080%2F\check_jsp_1.java:76: Ambiguous class: java.beans.Statement and
    ava.sql.Statement
                    Statement sqlStatement=conn.createStatement();
                    ^
    1 error, 1 warning        at com.sun.jsp.compiler.Main.compile(Main.java:347)
            at com.sun.jsp.runtime.JspLoader.loadJSP(JspLoader.java:135)
            at com.sun.jsp.runtime.JspServlet$JspServletWrapper.loadIfNecessary(Jsp
    ervlet.java:77)
            at com.sun.jsp.runtime.JspServlet$JspServletWrapper.service(JspServlet.
    ava:87)
            at com.sun.jsp.runtime.JspServlet.serviceJspFile(JspServlet.java:218)
            at com.sun.jsp.runtime.JspServlet.service(JspServlet.java:294)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
            at com.sun.web.core.ServletWrapper.handleRequest(ServletWrapper.java:15
    )
            at com.sun.web.core.Context.handleRequest(Context.java:414)
            at com.sun.web.server.ConnectionHandler.run(ConnectionHandler.java:139)
    HANDLER THREAD PROBLEM: java.net.SocketException: Socket is closed
    java.net.SocketException: Socket is closed
            at java.net.Socket.getInputStream(Unknown Source)
            at com.sun.web.server.ConnectionHandler.run(ConnectionHandler.java:161)请大家帮助