我用bean访问 mssql 老是出错，用了好多人的不同代码都是这个错误

Question

sql server的jdbc-odbc的驱动加了吗?三个文件

Answer 1

驱动的三个jar文件都加了
我用jsp直接访问就没事
用bean就出问题

Answer 2

注意 jdk1.5 编译的 bean 不能在 jdk1.4 下使用

Answer 3

不会吧 
我用的是jdk1.4+tomcat
编译工具是netbean
可能真是这个问题

Answer 4

看你的错误提示好像是try与catch的匹配对不完整呀,你再检查一下代码

Answer 5

问题是：该捕获的异常没有捕获，你可以Catch(Exception e)试一试

Answer 6

缺少catch
把代码发上来吧

Answer 7

////////////////
//mysql.jsp文件
////////////////
//// 预览地址 http://210.72.194.7:8080/myapp/usebean/mssql.jsp
<%@ page contentType="text/html;charset=gb2312"%>   
<%@ page import="java.sql.*"%> 
<%@ page import="Microsoft.Connect" %>
<jsp:useBean id="Connect" scope="page" class="Microsoft.Connect" />
<%//Connect.Connect();%>
<%Connect.displayDbProperties();%>
<%
/*
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);   
String sql="select * from jobs"; 
ResultSet rs=stmt.executeQuery(sql); 
while(rs.next()) {  
out.println(rs.getString(1)+"   ");
out.println(rs.getString(2)+"   ");*/
} 
%>

Answer 8

////////////////
//Connet.java文件
////////////////
package Microsoft;
import java.*;
public class Connect{
     private java.sql.Connection  con = null;
     private final String url = "jdbc:microsoft:sqlserver://";
     private final String serverName= "localhost";
     private final String portNumber = "1433";
     private final String databaseName= "pubs";
     private final String userName = "sa";
     private final String password = ""; //密码保密
     // Informs the driver to use server a side-cursor,
     // which permits more than one active statement
     // on a connection.
     private final String selectMethod = "cursor";     // Constructor
     public Connect(){}     private String getConnectionUrl(){
          return url+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectMethod+";";
     }     private java.sql.Connection getConnection(){
          try{
               Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
               con = java.sql.DriverManager.getConnection(getConnectionUrl(),userName,password);
               if(con!=null) System.out.println("Connection Successful!");
          }catch(Exception e){
               e.printStackTrace();
               System.out.println("Error Trace in getConnection() : " + e.getMessage());
         }
          return con;
      }     /*
          Display the driver properties, database details
     */     public void displayDbProperties(){
          java.sql.DatabaseMetaData dm = null;
          java.sql.ResultSet rs = null;
          try{
               con= this.getConnection();
               if(con!=null){
                    dm = con.getMetaData();
                    System.out.println("Driver Information");
                    System.out.println("\tDriver Name: "+ dm.getDriverName());
                    System.out.println("\tDriver Version: "+ dm.getDriverVersion ());
                    System.out.println("\nDatabase Information ");
                    System.out.println("\tDatabase Name: "+ dm.getDatabaseProductName());
                    System.out.println("\tDatabase Version: "+ dm.getDatabaseProductVersion());
                    System.out.println("Avalilable Catalogs ");
                    rs = dm.getCatalogs();
                    while(rs.next()){
                         System.out.println("\tcatalog: "+ rs.getString(1));
                    }
                    rs.close();
                    rs = null;
                    closeConnection();
               }else System.out.println("Error: No active Connection");
          }catch(Exception e){
               e.printStackTrace();
          }
          dm=null;
     }     private void closeConnection(){
          try{
               if(con!=null)
                    con.close();
               con=null;
          }catch(Exception e){
               e.printStackTrace();
          }
     }
     public static void main(String[] args) throws Exception
       {
          Connect myDbTest = new Connect();
          myDbTest.displayDbProperties();
       }
}

Answer 9

//////////
//D:\Tomcat 4.1\work\Standalone\localhost\myapp\usebean\mssql_jsp.java
//这个 mssql_jsp.java 文件是干什么用的？
////////package org.apache.jsp;import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;
import java.sql.*;
import Microsoft.Connect;public class mssql_jsp extends HttpJspBase {
  private static java.util.Vector _jspx_includes;  public java.util.List getIncludes() {
    return _jspx_includes;
  }  public void _jspService(HttpServletRequest request, HttpServletResponse response)
        throws java.io.IOException, ServletException {    JspFactory _jspxFactory = null;
    javax.servlet.jsp.PageContext pageContext = null;
    HttpSession session = null;
    ServletContext application = null;
    ServletConfig config = null;
    JspWriter out = null;
    Object page = this;
    JspWriter _jspx_out = null;
    try {
      _jspxFactory = JspFactory.getDefaultFactory();
      response.setContentType("text/html;charset=gb2312");
      pageContext = _jspxFactory.getPageContext(this, request, response,
       null, true, 8192, true);
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;      out.write("   \r\n");
      out.write(" \r\n");
      out.write("\r\n");
      Microsoft.Connect Connect = null;
      synchronized (pageContext) {
        Connect = (Microsoft.Connect) pageContext.getAttribute("Connect", PageContext.PAGE_SCOPE);
        if (Connect == null){
          try {
            Connect = (Microsoft.Connect) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "Microsoft.Connect");
          } catch (ClassNotFoundException exc) {
            throw new InstantiationException(exc.getMessage());
          } catch (Exception exc) {
            throw new ServletException("Cannot create bean of class " + "Microsoft.Connect", exc);
          }
          pageContext.setAttribute("Connect", Connect, PageContext.PAGE_SCOPE);
        }
      }
      out.write("\r\n");
//Connect.Connect();
      out.write("\r\n");
Connect.displayDbProperties();
      out.write("\r\n");/*
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);   
String sql="select * from jobs"; 
ResultSet rs=stmt.executeQuery(sql); 
while(rs.next()) {  
out.println(rs.getString(1)+"   ");
out.println(rs.getString(2)+"   ");*/
}     } catch (Throwable t) {
      out = _jspx_out;
      if (out != null && out.getBufferSize() != 0)
        out.clearBuffer();
      if (pageContext != null) pageContext.handlePageException(t);
    } finally {
      if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
    }
  }
}

Answer 10

你把代码排整齐，然后检查一下有没有那个try---catch不匹配的。可能是你用了不同的编辑器打开了，然后就出问题了。再说那些提示都是一些简单的错误，可以解决的。

Answer 11

我用netbean编译的
应该没有问题呀

Answer 12

这个问题应该是jsp的前面少了个import什么东西/
而不是程序的错误