jdbc 连接sqlserver2008 登录失败 连不上数据库

Question

package common;import java.sql.*;public class DBUtil
{
  private static String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

  private static String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=BookShop";

  private static String userId = "sa";

  private static String password = "sa";     private static Connection con = null;

  private static Statement stmt = null;

  private static ResultSet rs = null;

       public static int ExecuteUpdate(String sql) throws Exception
    {
                 int rows = 0;        try
        {
                         Class.forName(driverName);                         con = DriverManager.getConnection(url, "sa", "sa");                         stmt = con.createStatement();                         rows = stmt.executeUpdate(sql);
        }
        catch(Exception ex)
        {
                         System.out.print(ex.getMessage());
        }                return rows;
    }        public static ResultSet ExecuteQuery(String sql) throws Exception
    {
               try 
        {
                        Class.forName(driverName).newInstance();                         con = DriverManager.getConnection(url, "sa", "sa");                         stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);                         rs = stmt.executeQuery(sql);
        }
        catch(Exception ex)
        {
                         System.out.print(ex.getMessage());
        }                 return rs;
    }
}上面是部分代码 
 我的其他工程连接数据库是能连接上的 同样是jdbc 连接的用户也是一样的这个工程我找不出错 但是连接不上数据库 

Answer 1

用户 'sa' 登录失败。用户 'sa' 登录失败。用户 'sa' 登录失败。用户 'sa' 登录失败。用户 'sa' 登录失败。用户 'sa' 登录失败。用户 'sa' 登录失败。2011-3-9 9:09:49 org.apache.catalina.core.ApplicationDispatcher invoke
严重: Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at org.apache.jsp.BookType_jsp._jspService(BookType_jsp.java:239)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)
at servlet.BookType.doGet(BookType.java:90)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
An exception occurred processing JSP page /BookType.jsp at line 4845:          // 鍥句功淇℃伅闆嗗悎
46:          ResultSet rsBook1 = (ResultSet)request.getAttribute("RSBOOK1");
47: 
48:          while(rsBook1.next())
49:          {
50:              // 鍥句功缂栧彿
51:              String bookId = rsBook1.getString("BookId");
Stacktrace: