Jdbc連Sybase數據庫的詳細教程

2024-09-05 00:17:57

字體：大中小

來源：轉載

供稿：網友

　　今天小編給大家分享一篇Jdbc連Sybase數據庫的詳細教程，感興趣的朋友跟小編一起來了解一下吧!

　　1.單用一個JSP文件測試SYBASE jconnect-5_2 JDBC數據庫接口：

 JSP測試SYBASE jconnect-5_2 JDBC數據庫接口 JSP測試SYBASE jconnect-5_2 JDBC數據庫接口

");out.print("");out.print("");out.print("");out.print("");}%> "+rs.getString("emp_lname")+" "+rs.getString("dept_id")+" "+rs.getString("street")+" "+rs.getString("city")+" "+rs.getString("state")+"

數據庫操作成功，恭喜你");%>

　　2.再用JSP和Java Bean的方法:

JSP Code:");}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;}}

　　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;i1)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();}}