国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 編程 > JSP > 正文

Jdbc連Sybase數據庫的幾種方法

2020-06-01 23:30:16
字體：大 中 小
來源：轉載
供稿：網友
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程序范例: 
    •             



      

      

      




      


      

      


      

      

      
發表評論
共有條評論

      

      

      

      

      

      
用戶名:

密碼:


      

      
驗證碼:

 

匿名發表

      

      





      		

      

      
      		

      

      


      










      

      




      


      




      




      




      


      

      

      


      








主站蜘蛛池模板：
霍林郭勒市|
涿鹿县|
密山市|
徐闻县|
米脂县|
囊谦县|
宁强县|
伽师县|
元谋县|
惠东县|
通化县|
喜德县|
丰台区|
石阡县|
恩施市|
景德镇市|
运城市|
乌拉特中旗|
冷水江市|
万宁市|
榆林市|
潢川县|
紫金县|
临颍县|
崇礼县|
驻马店市|
新巴尔虎右旗|
肥乡县|
上思县|
义马市|
高要市|
平阴县|
乐平市|
承德市|
丰顺县|
临海市|
襄樊市|
丹阳市|
顺昌县|
崇阳县|
威远县|


      <td id="cm3su"></td>
      <td id="cm3su"></td>
      <sub id="cm3su"><optgroup id="cm3su"></optgroup></sub>
      <td id="cm3su"></td>
    3. <small id="cm3su"><tbody id="cm3su"></tbody></small>