基础知识指导:JDBC连接SYBASE的3种方法
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>