新手提问关于 JAVABEAN 和 JDBC

1、下载Microsoft SQL Server 2000 Service Pack 3a并安装，SQL请选用混和安装模式！！！
http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=zh-cn2、下载SQL Server 2000 Driver for JDBC Service Pack 3
http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en3、运行时关闭防火墙

解决方案 »

  1.   

    第一个问题已经解决了
    谢谢
    YuLimin(阿敏总司令：兵熊熊壹个！将熊熊壹窝！立正稍息)现在还有一个问题
    各位帮帮忙
      

  2.   

    adduser.jsp<%@ page language="java" pageEncoding="GB2312" import="java.sql.*"%>
    <jsp:useBean id="user" class="test.User" scope="page">
    <jsp:setProperty name="user" property="*"/>
    </jsp:useBean>
    <jsp:useBean id="adduser" class="test.Adduser" scope="page"/>
    <html>
    <head>
    <title>Lomboz JSP</title>
    </head>
    <body bgcolor="#FFFFFF"><%
    adduser.setUser(user);
    adduser.UserRegist();
    out.println(user);
    out.println(user.getUsername());
    adduser.regist();
    %></body>
    </html>第二个问题新的出错信息
    javax.servlet.ServletException: [Microsoft][ODBC SQL Server Driver][SQL Server]???? 'user' ????????
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:795)
    org.apache.jsp.adduser_jsp._jspService(adduser_jsp.java:97)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    root cause java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]???? 'user' ????????
    sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
    sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
    sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source)
    sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source)
    sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(Unknown Source)
    test.Adduser.regist(Adduser.java:44)
    org.apache.jsp.adduser_jsp._jspService(adduser_jsp.java:86)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      

  3.   

    ODBC SQL Server Driver 
    Unknown Source，
    你用的是jdbcodbc桥？数据源没配好？
      

  4.   

    我用 com.microsoft.jdbc.sqlserver.SQLServerDriver
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=test","sa","sa");
    会出这用的错javax.servlet.ServletException: ??????????
    ?????? com.microsoft org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:795)
    org.apache.jsp.adduser_jsp._jspService(adduser_jsp.java:97)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    root cause java.lang.Error: ??????????
    ?????? com.microsoft test.Adduser.(Adduser.java:2)
    sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    java.lang.reflect.Constructor.newInstance(Unknown Source)
    java.lang.Class.newInstance0(Unknown Source)
    java.lang.Class.newInstance(Unknown Source)
    java.beans.Beans.instantiate(Unknown Source)
    java.beans.Beans.instantiate(Unknown Source)
    org.apache.jsp.adduser_jsp._jspService(adduser_jsp.java:65)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)用sun.jdbc.odbc.JdbcOdbcDriver
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    con=DriverManager.getConnection("jdbc:odbc:MSSQL","sa","sa")
    出如下的错
    javax.servlet.ServletException: [Microsoft][ODBC SQL Server Driver][SQL Server]???? 'user' ????????
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:795)
    org.apache.jsp.adduser_jsp._jspService(adduser_jsp.java:97)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    root cause java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]???? 'user' ????????
    sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
    sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
    sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source)
    sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source)
    sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(Unknown Source)
    test.Adduser.regist(Adduser.java:44)
    org.apache.jsp.adduser_jsp._jspService(adduser_jsp.java:86)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    为什么
    为什么
      

  5.   

    打开数据库然后找到安全然后找登陆
    把登陆时的密码改成sa
    出现这个原因是因为你的数据库密码不是sa