坐等结果代码如下
<% 
    //jspexdb.setStr("hello world!");
   // out.println(jspexdb.getStr());
    //jspexdb  = new JspexBean();
        //JspexBean jBean = new JspexBean();
     //jspexbean;
         String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
        String dbURL = "jdbc:sqlserver://192.168.1.117:1443; DatabaseName=CRM";
        String userName = "sa";
        String userPwd = "mzyuan";
        Connection dbConn = null;
        //Connection conn = null;
        try
        {
            Class.forName(driverName).newInstance();
            out.println("驱动程序已加载");
        }
        catch(Exception e)
        {
            out.println("加载驱动程序错误...");
            e.printStackTrace();
        }
        try
        {
            dbConn = DriverManager.getConnection(dbURL,userName,userPwd);
            out.println("connection Successful!");
        }
        catch (SQLException e)
        {
            System.out.println("数据库连接错误...");
            e.printStackTrace();
        }
     /*
     if (null == jspexbean)
     {
         out.println("error");
     }
     else
     {
     out.println("success");
     }
     String sqlStr = "SELECT [userid],[username],[password],[email],[flag] FROM [CRM].[dbo].[user]";
     ResultSet rs = jspexbean.reslutSet(null,sqlStr);
     */
     String sqlStr = "SELECT userid,username,password,email,flag FROM dbo.user";
     PreparedStatement pst = dbConn.prepareStatement(sqlStr);
     pst.executeQuery();
     ResultSetMetaData rsmd = pst.getMetaData();
     out.println(rsmd.getColumnCount());
     out.println(rsmd.getTableName(1));
     %>
主要是在
PreparedStatement pst = dbConn.prepareStatement(sqlStr);这一句出现问题
具体问题描述如下:
message An exception occurred processing JSP page /index-ec.jsp at line 72
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /index-ec.jsp at line 7269:      ResultSet rs = jspexbean.reslutSet(null,sqlStr);
70:      */
71:      String sqlStr = "SELECT userid,username,password,email,flag FROM dbo.user";
72:      PreparedStatement pst = dbConn.prepareStatement(sqlStr);
73:      pst.executeQuery();
74:      ResultSetMetaData rsmd = pst.getMetaData();
75:      out.println(rsmd.getColumnCount());
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:521)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:430)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
 
root cause
java.lang.NullPointerException
org.apache.jsp.index_002dec_jsp._jspService(index_002dec_jsp.java:138)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:723)异常数据库