用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)
- 用jsp调用javaBean连接数据库
- Servlet+jsp+javabean+连接数据库
- jsp+javabean 连接 mysql 数据库
- Servlet+jsp+javabean+连接数据库
- JSP通过JavaBean连接SQL Server数据库
- JSP通过JavaBean连接Sql Server数据库
- 用JavaBean连接Access数据库
- jsp连接调用数据库小结
- Jsp连接JavaBean
- jsp调用javabean实例
- JSP 调用 javaBean
- JSP调用JavaBean
- jsp调用javabean
- MVC jsp+servlet+javabean 连接Mysql数据库测试demo
- JSP+JavaBean连接数据库时无法读取表中内容
- JavaBean类连接数据库
- 使用JavaBean连接数据库
- javaBean连接数据库
- VS2005设置WDK编译环境
- 同步更新子窗体的数据
- 拷贝构造函数和赋值操作符的区别
- 可以让你少奋斗十年的工作经验
- 预编译指令的作用
- 用jsp调用javaBean连接数据库
- Tomcat 6 数据源配置详解
- GridView翻页时样式
- MyEclipse 卡死问题。
- MySql分页
- 『网页制作』页面滚动HTML代码
- asp.net 读取SAP数据(rfc形式全过程)
- 修改数据库字段
- 创建UML状态图中的分区视频教程