[摘要]1.单用一个JSP文件测试SYBASE jconnect-5_2 JDBC数据库接口： <%@ page contentType="text/html;charset=GB2312&...
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("
|
关键词：Jdbc连Sybase数据库的几种办法