📄 急！！！jsp连接access_百度知道.htm
字号:
<DIV class=cpro></DIV>
<DIV class=cprodiv id=cproshow></DIV>
<DIV class="b4y gray mb12">您想在自己的网站上展示百度“知道”上的问答吗？来<A
href="http://zhidao.baidu.com/iknowcode.html" target=_blank>获取免费代码</A>吧！
<HR SIZE=1>
如要投诉或提出意见建议，请到<BR><A
href="http://post.baidu.com/f?kw=%B0%D9%B6%C8%D6%AA%B5%C0%CD%B6%CB%DF"
target=_blank>百度知道投诉吧</A>反馈。 </DIV></DIV>
<DIV id=center>
<DIV class=bai>
<DIV class="t3_favor bcg bgg"><SPAN style="PADDING-RIGHT: 10px; FLOAT: right"><A
onclick="window.open('http://cang.baidu.com/do/add?it='+encodeURIComponent(document.title)+'&iu='+encodeURIComponent(location.href)+'&tn=%E7%9F%A5%E9%81%93%E9%97%AE%E9%A2%98%2C&fr=ik#nw=1','_s','scrollbars=no,width=600,height=450,right=75,top=20,status=no,resizable=yes'); return false;"
href="http://cang.baidu.com/do/add" target=_blank>添加到搜藏</A></SPAN><SPAN
style="PADDING-LEFT: 10px"><CS4 />已解决</SPAN></DIV>
<DIV class="b3 bcg mb12">
<DIV class=p90>
<DIV class="f14 B wr"><CQ>急！！！jsp连接access</CQ></DIV>
<DIV class=wr><SPAN class=red><IMG height=16
src="急！！！jsp连接access_百度知道.files/icn_point.gif" width=16 align=absMiddle>
悬赏分：20</SPAN> - <SPAN class=gray>提问时间2007-1-18 23:38</SPAN></DIV>
<DIV
class="f14 wr"><CD>我已经建立了用access建立了图书管理系统的数据库,并建立了图书明细表.也弄了数据源.执行别的jsp的文件都成功，但唯独连接数据库的都没用。请各位帮帮我
<BR><%@ page contentType="text/html; charset=gb2312" language="java"
import="java.sql.*" errorPage="" %> <BR><html> <BR><head>
<BR><title>JSP连接Access数据库（一）显示记录</title> <BR></head>
<BR><body> <BR><div align="center" >JSP连接Access数据库</div>
<BR><div align="center" > <BR><br/><hr> <BR><p>
<BR><% <BR>//载入驱动程序类别 <BR>Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
<BR>//建立数据库连接，jspdata为ODBC数据源名称 <BR>Connection con =
DriverManager.getConnection("jdbc:odbc:jspdata"); <BR>//建立Statement对象
<BR>Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
<BR>ResultSet.CONCUR_READ_ONLY); <BR>//建立ResultSet(结果集)对象，并执行SQL语句 <BR>ResultSet
rs = stmt.executeQuery("select * from 图书明细表"); <BR>%> <BR></p>
<BR><p align="center">图书管理系统图书明细表中记录如下</p> <BR><table width="640"
border="1" align="center" bordercolor="#7188e0"> <BR><tr
bgcolor="d1d1ff"> <BR><Td width="80">图书编号</th> <BR><th
width="300">图书名称</th> <BR><th width="200">出版社</th>
<BR><th width="200">定价</th> <BR><th width="200">日期</th>
<BR></tr><% <BR>while(rs.next()) <BR>{%> <BR><tr
bgcolor="#f8f8f8"> <BR><td><%= rs.getString(1) %></td>
<BR><td><%= rs.getString(2) %></td> <BR><td><%=
rs.getString(3) %></td> <BR><td bgcolor="#f6f6f8"><%=
rs.getString(4) %></td> <BR><td><%= rs.getString(5)
%></td> <BR></tr> <BR><% <BR>} <BR>rs.close();
<BR>stmt.close(); <BR>con.close(); <BR>%> <BR></table> <BR><p
align="center"><br/> <BR>如果能看到表格中的数据，说明连接数据库成功！</p>
<BR></body> <BR></html> <BR><BR><BR>执行后显示
<BR><BR>org.apache.jasper.JasperException: Exception in JSP: /jspdata.jsp:15
<BR><BR>12: //载入驱动程序类别 <BR>13: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
<BR>14: //建立数据库连接，jspdata为ODBC数据源名称 <BR>15: Connection con =
DriverManager.getConnection("jdbc:odbc:jspdata"); <BR>16: //建立Statement对象
<BR>17: Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
<BR>18: ResultSet.CONCUR_READ_ONLY); <BR><BR><BR>root cause
<BR><BR>javax.servlet.ServletException: [Microsoft][ODBC 驱动程序管理器]
未发现数据源名称并且未指定默认驱动程序
<BR>org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:843)
<BR>org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:776)
<BR>org.apache.jsp.jspdata_jsp._jspService(jspdata_jsp.java:115)
<BR>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
<BR>javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
<BR>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
<BR>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
<BR>org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
<BR>javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
<BR><BR><BR>root cause <BR><BR>java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器]
未发现数据源名称并且未指定默认驱动程序</CD></DIV>
<DIV class="f14 wr"></DIV>
<DIV class=gray align=right>提问者：<A
href="http://passport.baidu.com/?detail&aid=7&default_tab=2&un=jangji"
target=_blank>jangji</A> - <A
href="http://www.baidu.com/search/zhidao_help.html#n5" target=_blank>试用期 一级</A>
</DIV></DIV></DIV>
<DIV class="t3 bcg bgg" style="POSITION: relative">其他回答
<DIV
style="FONT-WEIGHT: normal; FONT-SIZE: 12px; RIGHT: 10px; POSITION: absolute; TOP: 4px">共
5 条</DIV></DIV>
<DIV class="b3 bcg mb12">
<DIV class="p90 wr"><A name=67376226>
<DIV class=f14>在windows的ODBC数据源里创建ODBC了吗？ </DIV>
<DIV class=gray align=right>回答者：<A
href="http://passport.baidu.com/?detail&aid=7&default_tab=2&un=gimgen1026"
target=_blank>gimgen1026</A> - <A
href="http://www.baidu.com/search/zhidao_help.html#n5" target=_blank>秀才 三级</A>
1-18 23:45</DIV>
<DIV id=Lg></DIV><A name=67378381>
<DIV class=f14>开始 > 设置 > 控制面版 > 管理工具 > 数据源(ODBC) > 系统DNS 添加
<BR><BR>根据我的经验,绝对是没有数据源或者数据源错误,
<BR>另外,我发现你没有捕获ClassNotFoundException异常,这在JAVA里也会出错了啊~~~~ </DIV>
<DIV class=gray align=right>回答者：<A
href="http://passport.baidu.com/?detail&aid=7&default_tab=2&un=254489387"
target=_blank>254489387</A> - <A
href="http://www.baidu.com/search/zhidao_help.html#n5" target=_blank>试用期 一级</A>
1-19 00:07</DIV>
<DIV id=Lg></DIV><A name=67499141>
<DIV class=f14><% <BR>String url=""; <BR>ResultSet rs=null; <BR>Connection
con=null; <BR>String driver=""; <BR>String sql=""; <BR><BR>sql="select * from hz
where 序号=110"; <BR>url="jdbc:odbc:driver={Microsoft Access Driver
(*.mdb)};DBQ=d:/jmedu/hzb.mdb"; <BR>driver="sun.jdbc.odbc.JdbcOdbcDriver";
<BR>try { <BR>Class providerClass = Class.forName(driver); <BR>con =
DriverManager.getConnection(url); <BR>Statement stmt=con.createStatement();
<BR><BR>rs=stmt.executeQuery(sql); <BR>if(rs.next()) <BR>{ <BR>String
aa=rs.getString("配合比"); <BR>out.print("success!!"); <BR>out.print(aa); <BR>}
<BR><BR><BR>} catch (ClassNotFoundException e) { <BR>e.printStackTrace(); <BR>}
<BR>%> <BR>把这段拷上，改下sql语句，和你的数据库的存放位置，不需要配置odbc </DIV>
<DIV class=gray align=right>回答者：<A
href="http://passport.baidu.com/?detail&aid=7&default_tab=2&un=web%5Fwin"
target=_blank>web_win</A> - <A
href="http://www.baidu.com/search/zhidao_help.html#n5" target=_blank>初学弟子 一级</A>
1-19 17:33</DIV>
<DIV id=Lg></DIV><A name=68292967>
<DIV class=f14>极有可能你少了一样东西 <BR><BR>classpath <BR>%java_home%\jre\lib\rt.jar
<BR><BR>rt.jar这个类包一定要加在类环境变量中,否则没有 <BR>sun.jdbc.odbc.JdbcodbcDriver
<BR>这样说你应该明白了吧 </DIV>
<DIV class=gray align=right>回答者：匿名 1-23 19:16</DIV>
<DIV id=Lg></DIV><A name=69547251>
<DIV class=f14>你的程序没有问题，挂在我的程序中能正常显示记录。 <BR>再查一下你的数据源设置，耐心一点！！
<BR>我的配置是：j2sdk1.4.2_08和Jakarta-tomcat-3.3.2 </DIV>
<DIV class=gray align=right>回答者：<A
href="http://passport.baidu.com/?detail&aid=7&default_tab=2&un=yll5247"
target=_blank>yll5247</A> - <A
href="http://www.baidu.com/search/zhidao_help.html#n5" target=_blank>试用期 一级</A>
1-30 10:43</DIV>
<DIV id=Lg></DIV></DIV></DIV></DIV></DIV></DIV>
<SCRIPT src="急！！！jsp连接access_百度知道.files/zhidao.js"></SCRIPT>
<SCRIPT src="急！！！jsp连接access_百度知道.files/cpronum_iknow.js"></SCRIPT>
<SCRIPT language=javascript>
var arrBaiduCproConfig=new Array();
arrBaiduCproConfig['n'] = 'baiduiknow_cpr';
arrBaiduCproConfig['tm'] = 24;
arrBaiduCproConfig['cm'] = 60;
arrBaiduCproConfig['um'] = 24;
arrBaiduCproConfig['rad'] = 1;
arrBaiduCproConfig['cad'] = 0;
arrBaiduCproConfig['wn'] = 1;
arrBaiduCproConfig['bg'] = '#ffffff';
arrBaiduCproConfig['tt'] = '#000000';
arrBaiduCproConfig['ct'] = '#000000';
arrBaiduCproConfig['url'] = '#000000';
arrBaiduCproConfig['ta'] = 'right';
arrBaiduCproConfig['tl'] = 'top';
arrBaiduCproConfig['tn'] = 'baiduCPROiknow';
cpro_top_space=700;
cpro_everyadvheight=100;
cpro_maxnum=cpronum_iknow;
cpro_num=(document.body.scrollHeight-cpro_top_space)/cpro_everyadvheight;
cpro_num=cpro_num>cpro_maxnum?cpro_maxnum:cpro_num;
cpro_num=parseInt(cpro_num, 10);
arrBaiduCproConfig['hn'] =cpro_num;
if(cpro_num>0){
document.write(baiduCproIFrame());
}
</SCRIPT>
<DIV id=ft>©2007 Baidu</DIV><IMG style="DISPLAY: none" src=""> </BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -