JdbcRowSet.rar_jdbcrowset资源-CSDN文库

共1个文件

htm：1个

版权申诉

167 浏览量 2022-09-24 15:21:55 上传评论收藏 4KB RAR 举报

资源推荐

资源详情

资源评论

收起资源包目录

JdbcRowSet.rar （1个子文件）

使用JdbcRowSet和CachedRowSet的例子.htm 14KB

<html> <head> <title>使用JdbcRowSet和CachedRowSet的例子</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <link href="../../css/index.css" rel="stylesheet" type="text/css"> </head> <script language="javaScript"> function valiform() { if(document.form2.keyword.value==""){ alert("请输入关键字！"); document.form2.keyword.focus(); return false; } } function valiform1(){ if(document.form5.pinjianame.value==""){ alert("请输入姓名！"); document.form5.pinjianame.focus(); return false; } if(document.form5.pinjiacontent.value==""){ alert("请输入评价内容！"); document.form5.pinjiacontent.focus(); return false; } } </script> <body bgcolor="#FFFFFF" background="../../images/background.gif" leftmargin="0" topmargin="0"> <table width="756" height="1146" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="LTR"> <tr> <td width="747" height="78"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="19%" height="65"><div align="center"><img src="../../images/logo.gif" width="120" height="50"></div></td> <td width="81%"><table width="94%" height="53" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="81%"><div align="right"> <script type="text/JavaScript"> alimama_pid="mm_10575332_787950_1609286"; alimama_titlecolor="0000FF"; alimama_descolor ="000000"; alimama_bgcolor="FFFFFF"; alimama_bordercolor="0339DA"; alimama_linkcolor="008000"; alimama_bottomcolor="FFFFFF"; alimama_anglesize="0"; alimama_bgpic="0"; alimama_icon="0"; alimama_sizecode="12"; alimama_width=468; alimama_height=60; alimama_type=2; </script> <script src="http://a.alimama.cn/inf.js" type=text/javascript> </script> </div></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td height="20" class="ArticleTeitle"><table width="100%" height="25" border="0" cellpadding="0" cellspacing="0" bgcolor="#3399FF" > <tr> <td width="29%"><font color="#FFFFFF"> <div align="left">  您的位置：文章阅读 ┆ <a href="../../index.jsp"><font color="#FFFFFF">回首页</font></a></div> </font></td> <td width="71%"><font color="#FFFFFF">  </font> <div align="right"><font color="#FFFFFF"><a href="../../learn.jsp"><font color="#FFFFFF">学习笔记</font></a><font color="#FFFFFF">┆</font>  <a href="../../article.jsp"><font color="#FFFFFF">java文摘</font></a><font color="#FFFFFF">┆</font> <a href="../../download.jsp"><font color="#FFFFFF">源码下载</font></a> <font color="#FFFFFF"><font color="#FFFFFF">┆</font><a href="../../javacode.jsp"><font color="#FFFFFF">Java实例</font></a> <font color="#FFFFFF">┆</font><font color="#FFFFFF"> <a href="../../tool.jsp"><font color="#FFFFFF">Java教学</font></a> ┆ <a href="../../version.jsp"><font color="#FFFFFF">译文习作</font></a><font color="#FFFFFF">┆</font>  <a href="../../reply.jsp"><font color="#FFFFFF">留言板</font></a> </font></div> </td> </tr> </table></td> </tr> <tr> <td height="1039" align="center" valign="top"><table width="100%" height="1035" border="0" cellpadding="0" cellspacing="0"> <tr> <td height="30"><form name="form2" method="post" action="../../search.jsp" onSubmit="return valiform()"> <table width="94%" height="20" border="0" align="right" cellpadding="0" cellspacing="0"> <tr> <td width="13%"><div align="center"><font color="#0066FF"><strong>站内资源搜索:</strong></font></div></td> <td width="60%"><div align="center"> <input name="keyword" type="text" class="Active" size="70"> </div></td> <td> <div align="center"> </div> <input name="Submit3" type="submit" class="ActiveButton" value=" GO! "> </td> </tr> </table> </form></td> </tr> <tr> <td height="25" bgcolor="#95CAFF" class="ArticleTeitle"> <table width="70%" height="26" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="13%"><img src="../../images/fave.gif" width="72" height="25"></td> <td width="29%"><div align="right"> ┆ 将本文寄给朋友   </div></td> <td width="45%"><input name="textfield32" type="text" class="Active" value="（暂没开通）" size="30"></td> <td width="13%"><img src="../../images/button_send.gif" width="50" height="25"></td> </tr> </table></td> </tr> <tr> <td height="977" align="center" valign="top"> <br> <table width="701" height="146" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td height="80" colspan="2"><table width="100%" height="47" border="0" align="center" cellpadding="0" cellspacing="0" class="ArticleTeitle"> <tr> <td width="72%" height="45" bgcolor="#B5DAFF"><div align="center"><font color="#333333" size="4" face="黑体">使用JdbcRowSet和CachedRowSet的例子</font></div></td> <td width="15%" bgcolor="#B5DAFF"><p align="right"> </p></td> <td width="1%" bgcolor="#B5DAFF"> </td> <td width="12%" bgcolor="#B5DAFF"><p align="center"> <a href="http://203.93.208.26/kj/cwb/dir5/dir5a/rowset.zip"> 下载源代码</a></p></td> </tr> </table> <div align="right"><font color="#333333"><br> <strong>〖作者：站长整理〗〖大小：1k 〗〖发布日期：2005-08-25 〗〖浏览：614 〗<br> </strong></font></div></td> </tr> <tr> <td width="528" height="35" valign="top" class="ArticleTeitle">  <FONT color=#333333> </FONT> <pre>//Access数据库 import java.sql.*; import javax.sql.rowset.*; import com.sun.rowset.*; public class JDBCRowSetExample{ public static void main(String[] argv){ String url = "jdbc:odbc:zz3zcwb"; String login = ""; String password = ""; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); JdbcRowSet rowSet = new JdbcRowSetImpl(); //set url,login and password; rowSet.setUrl( url ); rowSet.setUsername(login ); rowSet.setPassword(password ); rowSet.setCommand("select * from Article"); rowSet.execute(); while(rowSet.next()){ String id=rowSet.getString("Article_id"); String name=rowSet.getString("Article_name"); System.out.println("id="+id+" name="+name); } rowSet.close(); } catch(Exception e) { e.printStackTrace(); } } } </pre> <pre>//mysql数据库 import java.sql.*; import javax.sql.rowset.*; import com.sun.rowset.*; public class JDBCCachedRowSetExample{ public static void main(String[] argv){ String url= "jdbc:mysql://127.0.0.1:3306/soft?user=root&password="; String login = ""; String password = ""; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); CachedRowSet crs=new CachedRowSetImpl(); //set url,login and password; crs.setUrl( url ); crs.setUsername(login ); crs.setPassword(password ); crs.setCommand("select * from soft"); crs.setPageSize(5); crs.ex

评论收藏

内容反馈

版权申诉