Jdbc连Sybase数据库的几种方法-技术开发专区

Jdbc连Sybase数据库的几种方法

作者：佚名编辑：魏国亮 2006-07-22 12:50

【IT168 技术文档】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();
    %>

第1页：Jdbc连Sybase数据库的几种方法（上）第2页：Jdbc连Sybase数据库的几种方法（下）

关注我们