📄 jsp连接数据库大全.htm
字号:
<html><head><title>Jsp连接数据库大全 - 经典论坛</title>
<link rel=stylesheet type=text/css href=/css/style.css><link rel=stylesheet type=text/css href=/css/bbs.css><script language=JavaScript src=/js/adbanner.js></script><meta HTTP-EQUIV=Expires CONTENT=0><meta HTTP-EQUIV=Content-Type content="text/html; charset=gb2312">
</head><body background="/articleimg/bbsimg/ " bgcolor="#FFFFFF" text=#000000 link= vlink= alink=><table width=100% border=0 cellpadding=0 cellspacing=6 class=border><tr><td width=101 align=center class=logoBackground><a href=/><img src=/img/common/logo.gif width=90 height=27 border=0></a></td><td width=* valign=top><table width=100% height=31 border=0 cellpadding=0 cellspacing=0><tr valign=top><td align=center><table width=100% border=0 cellpadding=0 cellspacing=6 class=navDark><tr><td align=center><a href=/news/index.asp class=navLink>业界动态</a></td></tr></table></td><td width=6><img src=/img/spacer.gif width=6 height=6></td><td align=center><table width=100% border=0 cellpadding=0 cellspacing=6 class=navDark><tr><td align=center><a href=/tech/index.asp class=navLink>技术文档</a></td></tr></table></td><td width=6><img src=/img/spacer.gif width=6 height=6></td><td align=center><table width=100% border=0 cellpadding=0 cellspacing=6 class=navDark><tr><td align=center><a href=/design/index.asp class=navLink>艺术设计</a></td></tr></table></td><td width=6><img src=/img/spacer.gif width=6 height=6></td><td align=center><table width=100% border=0 cellpadding=0 cellspacing=6 class=navDark><tr><td align=center><a href=/photo/index.asp class=navLink>摄影摄像</a></td></tr></table></td><td width=6><img src=/img/spacer.gif width=6 height=6></td><td align=center><table width=100% border=0 cellpadding=0 cellspacing=6 class=navDark><tr><td align=center><a href=/computer/index.asp class=navLink>计算机技术</a></td></tr></table></td><td width=6><img src=/img/spacer.gif width=6 height=6></td><td align=center><table width=100% border=0 cellpadding=0 cellspacing=6 class=navDark><tr><td align=center><a href=/download/index.asp class=navLink>资源下载</a></td></tr></table></td><td width=6><img src=/img/spacer.gif width=6 height=6></td><td align=center><table width=100% border=0 cellpadding=0 cellspacing=6 class=navDark><tr><td align=center><a href=/column/index.asp class=navLink>个人专栏</a></td></tr></table></td><td width=6><img src=/img/spacer.gif width=6 height=6></td><td align=center><table width=100% border=0 cellpadding=0 cellspacing=6 class=navDark><tr><td align=center><a href=/cg class=navLink>CG绘画</a></td></tr></table></td><td width=6><img src=/img/spacer.gif width=6 height=6></td><td align=center><table width=100% border=0 cellpadding=0 cellspacing=6 class=navDark><tr><td align=center><a href=/special class=navLink>专题</a></td></tr></table></td><td width=6><img src=/img/spacer.gif width=6 height=6></td><td align=center class=navlight><table width=100% border=0 cellpadding=0 cellspacing=6><tr><td align=center><b><a href=/bbs class=navLink>经典论坛</a></b></td></tr></table></td></tr></table><table width=100% border=0 cellpadding=0 cellspacing=6 class=navlight><tr><td nowrap><a href=signup.asp class=navlink>注册</a> | <a href=login.asp class=navlink>登录</a> | <a href=login.asp?action=logoff class=navlink>退出</a> | <a href=profile.asp class=navlink>个人信息</a> | <a href=ubbmisc.asp?action=lostpw class=navlink>找口令</a> | <a href=changepassword.asp class=navlink>改口令</a> | <a href=updateemail.asp class=navlink>改邮件</a> | <a href=showFavor.asp class=navlink>收藏</a> | <a href=pm.asp class=navlink>悄悄话</a> | <a href=faq.html class=navlink>帮助</a> | <a href=/bbs/NewsDetail.asp?id=1217560 class=navlink>规则</a> | <a href=Category.asp?action=ListArchive class=navlink>精华</a> | <a href=search.asp class=navlink>搜索</a></td></tr></table></td></tr><tr class=pageLight><TD colspan=2 align=center><table border=0 cellspacing=0 cellpadding=0><tr><td align=center valign=top><script language=JavaScript>showbanner(2,2);</script><table width=100% border=0 cellpadding=1 cellspacing=0><tr><td align=center><script language=JavaScript>showbanner(7,7);</script></td></tr></table></td><td><img src=/img/spacer.gif width=6 height=4></td><td valign=top align=center><script language=JavaScript>showbanner(4,4);</script><table width=100% border=0 cellspacing=0 cellpadding=0><tr><td><img src=/img/spacer.gif width=6 height=4></td></tr></table><script language=JavaScript>showbanner(4,4);</script><table width=100% border=0 cellspacing=0 cellpadding=0><tr><td><img src=/img/spacer.gif width=6 height=4></td></tr></table><script language=JavaScript>showbanner(10,7);</script><table width=100% border=0 cellpadding=1 cellspacing=0><tr><td align=center><script language=JavaScript>showbanner(10,7);</script></td></tr></table></td></tr><tr><td colspan=3><script language=JavaScript>showbanner(9,6);</script></td></tr></table></td></tr><tr><TD colspan=2><table width=100% border=0 cellpadding=0 cellspacing=6 class=pageSeparator><tr><td>您的位置： <a href=/>首页</a> > <a href=.>经典论坛</a> > <a href=list.asp?groupname=Dreamweaver+MX+Developer+%D3%EB%CA%FD%BE%DD%BF%E2%B1%E0%B3%CC&Daysprune=0&page=908>Dreamweaver MX Developer 与数据库编程</a> > Jsp连接数据库大全</td></tr></table></td></tr></table><table width=99% border=0><tr><td valign=top><br></td><td valign=top align=center width=40%><a href="posting.asp?action=newtopic&page=908&forum=Dreamweaver+MX+Developer+%D3%EB%CA%FD%BE%DD%BF%E2%B1%E0%B3%CC"><img alt=新开主题 border=0 src="/articleimg/bbsimg/topic5.gif"></a> <a href="posting.asp?page=908&action=reply&topic=503009&forum=Dreamweaver+MX+Developer+%D3%EB%CA%FD%BE%DD%BF%E2%B1%E0%B3%CC&TopicSubject=Jsp%C1%AC%BD%D3%CA%FD%BE%DD%BF%E2%B4%F3%C8%AB"><img alt=回复该主题 border=0 src='/articleimg/bbsimg/reply5.gif'></a><br></td></tr></table>
<script type="text/javascript" src="inc/NewsDetail.js"></script>
<table width="99%" border=0>
<tr>
<td>
</td>
<td align=right><a href="newsDetail.asp?action=findthread&Forum=Dreamweaver+MX+Developer+%D3%EB%CA%FD%BE%DD%BF%E2%B1%E0%B3%CC&go=newer&id=503009&posts=">上一贴</a> | <a href="newsDetail.asp?action=findthread&Forum=Dreamweaver+MX+Developer+%D3%EB%CA%FD%BE%DD%BF%E2%B1%E0%B3%CC&go=older&id=503009&posts=">下一贴</a></td>
</tr>
</table>
<table cellspacing=0 cellpadding=0 width="99%" border=0>
<tr>
<td class="bordercolor">
<table cellspacing=1 cellpadding=4 width="100%" border=0>
<tr class=listtitle>
<td valign=center width="18%"><b>发表人</b></td>
<td valign=center><b>主题: Jsp连接数据库大全</b></td>
</tr>
<tr class="pageLight">
<td valign=top width="18%"><a name="503009"></a> cjj31<br>
<img src=/articleimg/usericon/cjj31.gif vspace=5><br><b>阳光锈了</b><br>
积分：3578<br>
发贴：2772<br>
来自：嘉兴<br>
注册：2000-07-05<br>
</td>
<td valign="top">
<script type="text/javascript">
writeTools('17',
'2002-06-03 <FONT COLOR=#800080>10:39:22</font>',
'cjj31',
'cjj31',
true,
'',
'',
'',
true,
'Jsp%C1%AC%BD%D3%CA%FD%BE%DD%BF%E2%B4%F3%C8%AB',
'503009',
'503009',
'',
'Dreamweaver+MX+Developer+%D3%EB%CA%FD%BE%DD%BF%E2%B1%E0%B3%CC',
'Jsp%C1%AC%BD%D3%CA%FD%BE%DD%BF%E2%B4%F3%C8%AB',
false,
false,
1,
0
);
</script>
现在有好多初学jsp的网友经常会问数据库怎么连接啊，怎么老出错啊？所以我集中的在这写篇文章供大家参考，其实这种把数据库逻辑全部放在jsp里未必是好的做法，但是有利于初学者学习，所以我就这样做了，当大家学到一定程度的时候，可以考虑用MVC的模式开发。在练习这些代码的时候，你一定将jdbc的驱动程序放到服务器的类路径里，然后要在数据库里建一个表test,有两个字段比如为test1，test2，可以用下面SQL建 create table test(test1 varchar(20),test2 varchar(20)，然后向这个表写入一条测试纪录，那么现在开始我们的jsp和数据库之旅吧。 <br>一、jsp连接Oracle8/8i/9i数据库（用thin模式） <br>testoracle.jsp如下： <br><%@ page contentType="text/html;charset=gb2312"%> <br><%@ page import="java.sql.*"%> <br><html> <br><body> <br><%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); <br>String url="jdbc:oracle:thin:@localhost:1521:orcl"; <br>//orcl为你的数据库的SID <br>String user="scott"; <br>String password="tiger"; <br>Connection conn= DriverManager.getConnection(url,user,password); <br>Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); <br>String sql="select * from test"; <br>ResultSet rs=stmt.executeQuery(sql); <br>while(rs.next()) {%> <br>您的第一个字段内容为：<%=rs.getString(1)%> <br>您的第二个字段内容为：<%=rs.getString(2)%> <br><%}%> <br><%out.print("数据库操作成功，恭喜你");%> <br><%rs.close(); <br>stmt.close(); <br>conn.close(); <br>%> <br></body> <br></html> <br>二、jsp连接Sql Server7.0/2000数据库 <br>testsqlserver.jsp如下： <br><%@ page contentType="text/html;charset=gb2312"%> <br><%@ page import="java.sql.*"%> <br><html> <br><body> <br><%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); <br>String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; <br>//pubs为你的数据库的 <br>String user="sa"; <br>String password=""; <br>Connection conn= DriverManager.getConnection(url,user,password); <br>Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); <br>String sql="select * from test"; <br>ResultSet rs=stmt.executeQuery(sql); <br>while(rs.next()) {%> <br>您的第一个字段内容为：<%=rs.getString(1)%> <br>您的第二个字段内容为：<%=rs.getString(2)%> <br><%}%> <br><%out.print("数据库操作成功，恭喜你");%> <br><%rs.close(); <br>stmt.close(); <br>conn.close(); <br>%> <br></body> <br></html> <br>三、jsp连接DB2数据库 <br>testdb2.jsp如下： <br><%@ page contentType="text/html;charset=gb2312"%> <br><%@ page import="java.sql.*"%> <br><html> <br><body> <br><%Class.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance(); <br>String url="jdbc:db2://localhost:5000/sample"; <br>//sample为你的数据库名 <br>String user="admin"; <br>String password=""; <br>Connection conn= DriverManager.getConnection(url,user,password); <br>Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); <br>String sql="select * from test"; <br>ResultSet rs=stmt.executeQuery(sql); <br>while(rs.next()) {%> <br>您的第一个字段内容为：<%=rs.getString(1)%> <br>您的第二个字段内容为：<%=rs.getString(2)%> <br><%}%> <br><%out.print("数据库操作成功，恭喜你");%> <br><%rs.close(); <br>stmt.close(); <br>conn.close(); <br>%> <br></body> <br></html> <br>四、jsp连接Informix数据库 <br>testinformix.jsp如下： <br><%@ page contentType="text/html;charset=gb2312"%> <br><%@ page import="java.sql.*"%> <br><html> <br><body> <br><%Class.forName("com.informix.jdbc.IfxDriver").newInstance(); <br>String url = <br>"jdbc:informix-sqli://123.45.67.89:1533/testDB:INFORMIXSERVER=myserver; <br>user=testuser;password=testpassword"; <br>//testDB为你的数据库名 <br>Connection conn= DriverManager.getConnection(url); <br>Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); <br>String sql="select * from test"; <br>ResultSet rs=stmt.executeQuery(sql); <br>while(rs.next()) {%> <br>您的第一个字段内容为：<%=rs.getString(1)%> <br>您的第二个字段内容为：<%=rs.getString(2)%> <br><%}%> <br><%out.print("数据库操作成功，恭喜你");%> <br><%rs.close(); <br>stmt.close(); <br>conn.close(); <br>%> <br></body> <br></html><br><br><font color="Red">不错，对含代码的文章贴时注意选中“禁止笑脸转换”选项</font><div align=right><p align=right>[这消息被hsx编辑过(编辑时间2002-06-03 <FONT COLOR=#800080>11:40:02</font>)]<br></p></div>
</td>
</tr>
<tr class="border">
<td valign=top width="18%"><a name="510549"></a> benjamin<br>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -