站内搜索: 请输入搜索关键词

当前页面: 开发资料首页JSP 专题Jdbc连Sybase数据库的几种方法

Jdbc连Sybase数据库的几种方法

摘要: Jdbc连Sybase数据库的几种方法


1.单用一个JSP文件测试SYBASE jconnect-5_2 JDBC数据库接口

<table style=BORDER-COLLAPSE: collapse cellSpacing=0 cellPadding=5 width=100% bgColor=#ffff00 border=1><tr><td>
<%@ page contentType=text/html;charset=GB2312 %><%@ page import=java.sql.* %><head> JSP测试SYBASE jconnect-5_2 JDBC数据库接口 </head><body>
JSP测试SYBASE jconnect-5_2 JDBC数据库接口


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

<%out.print(数据库操作成功,恭喜你);%> <%rs.close(); stmt.close(); conn.close(); %> </body>
</td></tr></table>

2.再用JSP和Java Bean的方法:
<table cellSpacing=0 cellPadding=5 width=100% bgColor=#ffff00 border=3><tr><td>
JSP Code:<%@ page contentType=text/html;charset=GB2312 %><%@ page import=java.sql.* %><head>  </head><body><%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)+|
);}rs.close(); %>
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;}}
</td></tr></table>

3.利用JDBC(SYBAE jconnect-5_2)查询Sybase ASA7.0中数据的图形化Java程序范例:
<table cellSpacing=0 cellPadding=5 width=100% bgColor=#ffff00 border=3><tr><td>
////   一个简单的利用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();}}  
</td></tr></table>



↑返回目录
前一篇: 用定制标签库和配置文件实现对JSP页面元素的访问控制
后一篇: jsp中用bean和servlet联合实现用户注册、登录