小鸟问题：如何用jsp（jdbc）连接本地sqlserver数据库？

jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName= 加端口号  如果还没好把错误帖出来

解决方案 »

  1.   

    小弟也试了同上的方法 我在lib库里面配置了jdbc的驱动了的
    结果还是显示
    javax.servlet.ServletException: [Microsoft][SQLServer JDBC Driver][SQLServer]?? 'sa' ?????
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:682)
    org.apache.jsp.db2000test_jsp._jspService(db2000test_jsp.java:90)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:320)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:293)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)