当前位置：首页 -> 技术开发 -> JSP专区 -> Jdbc连Sybase数据库的几种方法

Jdbc连Sybase数据库的几种方法

时间： 2021-07-31 作者：daque

1.单用一个jsp文献尝试sybase jconnect-5_2 jdbc数据库接口：

<%@ 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>

2.再用jsp和java bean的本领: 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;}}

3.运用jdbc(sybae jconnect-5_2)查问sybase asa7.0中数据的图形化java步调典型: //// 一个大略的运用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();}}

Jdbc连Sybase数据库的几种方法

相关推荐

推荐下载

热门阅览

最新排行