站长资源网络编程
Jdbc连Sybase数据库的几种方法
简介1.单用一个JSP文件测试SYBASE jconnect-5_2 JDBC数据库接口： <%@ page contentType="text/html;charset=GB2312" %><%@ page import="java.sql.*" %> JSP测试</div>
<div class="news_infos"><div id="MyContent">1.单用一个JSP文件测试SYBASE jconnect-5_2 JDBC数据库接口： <P></P><PRE><CODE><%@ page contentType="text/html;charset=GB2312" %><%@ page import="java.sql.*" %><HTML><HEAD><TITLE> JSP测试SYBASE jconnect-5_2 JDBC数据库接口 </TITLE><META NAME="Generator" CONTENT="EditPlus2.11"><META NAME="Author" CONTENT="naxin"></HEAD><BODY><center>JSP测试SYBASE jconnect-5_2 JDBC数据库接口</center><BR><BR><table border=3 align=center ><%Class.forName("com.sybase.jdbc2.jdbc.SybDriver");String url ="jdbc:sybase:Tds:localhost:2638"; Connection conn= DriverManager.getConnection(url, "dba","sql"); Statement stmt=conn.createStatement(); String sql="select emp_lname,dept_id,street,city,state from employee order by emp_lname"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {out.print("<TR><TD>"+rs.getString("emp_lname")+"</TD>");out.print("<TD>"+rs.getString("dept_id")+"</TD>");out.print("<TD>"+rs.getString("street")+"</TD>");out.print("<TD>"+rs.getString("city")+"</TD>");out.print("<TD>"+rs.getString("state")+"</TD></TR>");}%> </table><BR><HR><%out.print("数据库操作成功，恭喜你");%> <%rs.close(); stmt.close(); conn.close(); %> </BODY></HTML></CODE></PRE><br><br>2.再用JSP和Java Bean的方法: <BR><PRE><CODE>JSP Code:<%@ page contentType="text/html;charset=GB2312" %><%@ page import="java.sql.*" %><HTML><HEAD><TITLE> </TITLE><META NAME="Generator" CONTENT="EditPlus2.11"><META NAME="Author" CONTENT="naxin"></HEAD><BODY><jsp:useBean id="sybase" scope="page" class="test.sybconn" /><%ResultSet rs=sybase.Query("select * from tjck_dh"); while(rs.next()) {out.print("|"+rs.getString("name")+"|");out.print(rs.getString("card_no")+"|");out.print(rs.getString("amount")+"|");out.print(rs.getString("home_call")+"|");out.print(rs.getString("office_call")+"|<br>");}rs.close(); %><HR>Bean的代码:package test;import java.sql.*;public class sybconn {// String sDBDriver = "com.sybase.jdbc2.jdbc.SybDriver"; String sConnStr = "jdbc:sybase:Tds:localhost:2638";// String user="dba";// String passwd="sql";Connection conn = null;ResultSet rs = null;public ResultSet Query(String sql) throws SQLException,Exception {Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();conn = DriverManager.getConnection(sConnStr,"dba","sql");Statement stmt = conn.createStatement();rs = stmt.executeQuery(sql);return rs;}}</CODE></PRE><br><br>3.利用JDBC(SYBAE jconnect-5_2)查询Sybase ASA7.0中数据的图形化Java程序范例: <BR><PRE><CODE>//// 一个简单的利用JDBC(SYBAE jconnect-5_2)查询Sybase ASA7.0中数据的图形化Java程序范例// 执行的SQL语句是" select * from employee " ,可以改成自己所需的.// 运行方式为: c:\> java JDBCTest //import java.awt.*; import java.sql.*; // 在使用JDBC之前，必须引入JAVA的SQL包class JDBCTest extends Frame {TextArea myTextArea;public JDBCTest () {//设定程序的显示界面super("一个简单的利用JDBC(jconnect-5_2)查询Sybase ASA7.0中数据的图形化Java程序范例");setLayout(new FlowLayout());myTextArea = new TextArea(30,80);add(myTextArea);resize(500,500);show();myTextArea.appendText("数据库查询中，请等待......\n");}void displayResults(ResultSet results) throws SQLException {//首先得到查询结果的信息ResultSetMetaData resultsMetaData = results.getMetaData();int cols = resultsMetaData.getColumnCount();//将等待信息清除myTextArea.setText("");//显示结果while(results.next()) {for(int i=1;i<=cols;i++) {if(i>1)myTextArea.appendText("\t");try{myTextArea.appendText(results.getString(i));}// 捕获空值时产生的异常catch(NullPointerException e){}}myTextArea.appendText("\n");}}public boolean handleEvent(Event evt) {if (evt.id == Event.WINDOW_DESTROY) {System.exit(0);return true;}return super.handleEvent(evt);}public static void main(String argv[]) throws SQLException,Exception {//设定查询字串String queryString = "select * from employee";JDBCTest myJDBCTest = new JDBCTest();//加载驱动程序Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();//建立连接,localhost为主机名,dba为用户名，sql为密码Connection myConn = DriverManager.getConnection("jdbc:sybase:Tds:localhost:2638","dba","sql");Statement myStmt = myConn.createStatement();//执行查询ResultSet myResults = myStmt.executeQuery(queryString);myJDBCTest.displayResults(myResults);//关闭所有打开的资源myResults.close();myStmt.close();myConn.close();}} </CODE></PRE><BR></div>
</div>
</div>
<div class="share"> </div>
<div class="nextinfo">
<p>上一篇：<a href="http://m.wwsws.com/show/1/163475.html" title="用定制标签库和配置文件实现对JSP页面元素的访问控制">用定制标签库和配置文件实现对JSP页面元素的访问控制</a></p>
<p>下一篇：<a href="http://m.wwsws.com/show/1/163477.html" title="轻松使用JSP生成饼图">轻松使用JSP生成饼图</a></p>
</div>
<div class="otherlink">
<h2>最新资源</h2>
<ul>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620773.html" one-link-mark="yes" title="群星《歌手2024 第3期》[FLAC/分轨][204.16MB]"><span>群星《歌手2024 第3期》[FLAC/分轨][204.16MB]</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620772.html" one-link-mark="yes" title="群星《乘风2024 第6期》[320K/MP3][57.95MB]"><span>群星《乘风2024 第6期》[320K/MP3][57.95MB]</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620771.html" one-link-mark="yes" title="群星《乘风2024 第6期》[FLAC/分轨][170.72MB]"><span>群星《乘风2024 第6期》[FLAC/分轨][170.72MB]</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620770.html" one-link-mark="yes" title="陈立强1995-我爱你胜过这世界[福茂][WAV+CUE]"><span>陈立强1995-我爱你胜过这世界[福茂][WAV+CUE]</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620769.html" one-link-mark="yes" title="群星-《2014年十大发烧唱片精选HQCD》[低速原抓WAV+CUE]"><span>群星-《2014年十大发烧唱片精选HQCD》[低速原抓</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620768.html" one-link-mark="yes" title="群星2013-青春缤纷辑压箱宝大公开3CD2[新加坡限量版][WAV整轨]"><span>群星2013-青春缤纷辑压箱宝大公开3CD2[新加坡限</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620767.html" one-link-mark="yes" title="林育群.2013-BalladShow（日本版）【环球】【WAV+CUE】"><span>林育群.2013-BalladShow（日本版）【环球】【WAV+</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620766.html" one-link-mark="yes" title="陈加洛.1992-痛到感觉不到【宝丽金】【WAV+CUE】"><span>陈加洛.1992-痛到感觉不到【宝丽金】【WAV+CUE】</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620765.html" one-link-mark="yes" title="群星.2023-宿命之敌电视剧原声带【韶愔音乐】【FLAC分轨】"><span>群星.2023-宿命之敌电视剧原声带【韶愔音乐】【</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620764.html" one-link-mark="yes" title="東京事変-大発見[FLAC+CUE]"><span>東京事変-大発見[FLAC+CUE]</span></a>
</li>
</ul>
</div>
</div>
<div class="sidebar">
<div class="cloud"><h2 class="hometitle">一句话新闻</h2><a href="/3G/1/604673.html"><ul>微软与英特尔等合作伙伴联合定义“AI PC”：键盘需配有Copilot物理按键<br><br>几个月来，英特尔、微软、AMD和其它厂商都在共同推动“AI PC”的想法，朝着更多的AI功能迈进。在近日，英特尔在台北举行的开发者活动中，也宣布了关于AI PC加速计划、新的PC开发者计划和独立硬件供应商计划。<br>在此次发布会上，英特尔还发布了全新的全新的酷睿Ultra Meteor Lake NUC开发套件，以及联合微软等合作伙伴联合定义“AI PC”的定义标准。</ul></a></div>
</div>
</article>
<footer>
<p>友情链接:<a href="http://www.imxmx.com/" title="杰晶网络" target="_blank">杰晶网络</a> <a href="http://www.ddrfans.com/" title="DDR爱好者之家" target="_blank">DDR爱好者之家</a> <a href="http://www.nqxw.com/" title="南强小屋" target="_blank">南强小屋</a> <a href="http://www.paidiu.com/" title="黑松山资源网" target="_blank">黑松山资源网</a> <a href="http://www.dyhadc.com/" title="白云城资源网" target="_blank">白云城资源网</a> <a href="/sitemap.xml">SiteMap</a></p>
<p>Design by <a href="http://m.wwsws.com">伏龙阁资源网</a> <a href="/">http://m.wwsws.com</a></p>
</footer>
<script src="/images/nav.js"></script>
<script type="text/javascript">
jQuery.noConflict();
jQuery(function() {
var elm = jQuery('#left_flow2');
var startPos = jQuery(elm).offset().top;
jQuery.event.add(window, "scroll", function() {
var p = jQuery(window).scrollTop();
jQuery(elm).css('position', ((p) > startPos) ? 'fixed' : '');
jQuery(elm).css('top', ((p) > startPos) ? '0' : '');
});
});
</script>
</body>
</html>