jsp 连接 sql server 数据库
我用的是一个bean 连接的,bean 内容如下:
//连接数据库的JavaBean,运用连接池技术,数据源为,manage,配置见server.xml
package dbconn;
import java.sql.*;
import javax.naming.Context;
import javax.sql.DataSource;
import javax.naming.InitialContext;
public class DBConn
{
public static Connection getConnection() throws Exception
{
try
{
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource) envCtx.lookup("jdbc/bdmis");//查找数据源
return ds.getConnection();//返回连接
}
catch (Exception e)
{
throw e;
}
}
}
编译时出现如下语句:
Exception in thread "main" java.lang.NoClassDefFoundError: DBConn/java
请按任意键继续. . .
我在程序调用的时候采用:
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.io.*" %>
<%@page import="dbconn.*"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="DB" class="dbconn.DBConn" scope="page"/>
<%
Connection conn = DB.getConnection();//连接数据库
Statement stm = conn.createStatement();
........
stm.close();
conn.close();
%>
结果报错如下:
java.lang.NoClassDefFoundError: dbconn/DBConn
java.lang.Class.getDeclaredConstructors0(Native Method)
java.lang.Class.privateGetDeclaredConstructors(Unknown Source)
java.lang.Class.getConstructor0(Unknown Source)
java.lang.Class.newInstance0(Unknown Source)
java.lang.Class.newInstance(Unknown Source)
org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:178)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:296)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
cn.com.czr.util.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:105)
我知道是驱动的问题,但是无法编译Dbconn,请教大家,还忘不吝赐教。送分!!