基础知识指导:JDBC连接SYBASE的3种方法

文章作者 100test 发表时间 2007:03:14 16:47:24
来源 100Test.Com百考试题网

1.单用一个JSP文件测试SYBASE jconnect-5_2 JDBC数据库接口：
<%@ page contentType="text/html.charset=GB2312" %>
<%@ page import="java.sql.*" %>







JSP测试SYBASE jconnect-5_2 JDBC数据库接口



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="0select emp_lname,dept_id,street,city,state from employee order by emp_lname".
ResultSet rs=stmt.executeQuery(sql).
while(rs.next()) {
out.print("" rs.getString("emp_lname") "").
out.print("" rs.getString("dept_id") "").
out.print("" rs.getString("street") "").
out.print("" rs.getString("city") "").
out.print("" rs.getString("state") "").
}
%>

---

<%out.print("数据库操作成功，恭喜你").%>
<%
rs.close().
stmt.close().
conn.close().
%>

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

<%@ page contentType="text/html.charset=GB2312" %>
<%@ page import="java.sql.*" %>








<%
ResultSet rs=sybase.Query("0select * 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().
%>

---