JDBC连接Sybase数据库的三种方法_java频道_java教程

JDBC连接Sybase1.单用一个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>

JDBC连接Sybase2.再用jsp和java bean的方法:

<%@ 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 = 
本新闻共3页,当前在第1页  1  2  3