用jsp调用javaBean连接数据库

来源:互联网 发布:如何成为淘宝卖家 编辑:程序博客网 时间:2024/05/16 18:47

我是这样连接的。  
  opendb.java/class可以连接上数据库  
  代码:  
  package   com.sun;  
  import   java.sql.*;    
  public   class   opendb  
    {    
  Connection   con=null;    
  Statement   stmt=null;  
  ResultSet   rs=null;    
  String   user="syw";  
  String   password="198001";  
  String   query   =   "select   *   from   test";    
  String   url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jsp";  
  public   opendb()  
  {  
  try  
    {    
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");  
    }   catch(java.lang.ClassNotFoundException   e)    
        {    
          System.err.print("ClassNotFoundException:   ");    
          System.err.println(e.getMessage());    
        }  
  }  
  public   ResultSet   executeQuery(String   sql)  
  {  
  rs=null;    
  try   {    
      con   =   DriverManager.getConnection(url,user,password);    
      stmt=con.createStatement();  
      ResultSet   rs   =   stmt.executeQuery(sql);  
      }   catch(SQLException   ex)      
          {  
              System.err.println("SQLException:   "   +   ex.getMessage());    
          }    
  return   rs;  
  }  
  }    
  但是用jsp调用时出现这样的错误,不能正常现实!不知道是什么原因?  
  错误:  
  A   Servlet   Exception   Has   Occurred  
  org.apache.jasper.JasperException:   Unable   to   compile   class   for   JSPNote:   sun.tools.javac.Main   has   been   deprecated.  
  import   javax.servlet.*;  
  ^  
  public   class   reg2$jsp   extends   HttpJspBase   {  
                                                              ^  
  2   errors,   1   warning  
   
  at   org.apache.jasper.compiler.Compiler.compile(Compiler.java:284)  
  at   org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:543)  
  at   org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:176)  
  at   org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:188)  
  at   org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)  
  at   org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)  
  at   javax.servlet.http.HttpServlet.service(HttpServlet.java:1264)  
  at   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)  
  at   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)  
  at   org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)  
  at   org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)  
  at   org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)  
  at   org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)  
  at   org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:215)  
  at   org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)  
  at   org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)  
  at   org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)  
  at   org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)  
  at   org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)  
  at   org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2366)  
  at   org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)  
  at   org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)  
  at   org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)  
  at   org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)  
  at   org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)  
  at   org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)  
  at   org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)  
  at   org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)  
  at   org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)  
  at   org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)  
  at   org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1005)  
  at   org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1098)  
  at   java.lang.Thread.run(Thread.java:536)