<%@ 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程序范例:
如您对本文有疑问或者有任何想说的,请点击进行留言回复,万千网友为您解惑!
网友评论