songaihua
发贴: 2
积分: 0
|
于 2005-01-18 19:08
写法错误 <%@ page contentType="text/html; charset=gb2312" %> <%@ page import="java.sql.*"%> <%@ page import="java.util.*"%> <%@ page import="sun.jdbc.odbc.*"%>
<%
Connection con=null; String DriverName="sun.jdbc.odbc.JdbcOdbcDriver"; ////////采用指定路径的方法.不用建立数据源. // String URL="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=c:/data/test.mdb"; ////////采用建立数据源的方法.在系统数据源中建立test的数据源.用户是test,密码是test. String URL="jdbc:odbc:test"; String user="test"; String password="test"; try{ Class.forName(DriverName); con = DriverManager.getConnection(URL,user,password); }catch(Exception ne) { out.println(ne); }
Statement stmt=con.createStatement(); ResultSet rst=stmt.executeQuery("select * from teacher "); out.println("--------------------"); out.println("<br>"); while(rst.next()) { out.println("ID号:"+rst.getString("teacherid")+"---"+"姓名:"+rst.getString("teachername")); out.println("<br>"); } rst.close(); stmt.close(); con.close(); %>
|