<%@ page import="java.sql.*" %>
<html>
<%
String id=request.getParameter("number");
String pd=request.getParameter("passwd");
String url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=F:/test/10/YANG.mdb"; try{
Connection conn=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection(url,"","");
Statement ui=conn.createStatement();
String sql="select * from yuyang ";
ResultSet rs=ui.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(2));
}
out.println("dui");
}
catch(Exception e){
out.println("erro");
}
%>
</html>
<html>
<%
String id=request.getParameter("number");
String pd=request.getParameter("passwd");
String url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=F:/test/10/YANG.mdb"; try{
Connection conn=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection(url,"","");
Statement ui=conn.createStatement();
String sql="select * from yuyang ";
ResultSet rs=ui.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(2));
}
out.println("dui");
}
catch(Exception e){
out.println("erro");
}
%>
</html>
这里是输出到控制台罢了还有看你得控制台有什么错误没有。
String id=request.getParameter("number");
String pd=request.getParameter("passwd");
String url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=F:/test/10/YANG.mdb"; try{
Connection conn=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection(url,"","");
Statement ui=conn.createStatement();
String sql="select * from yuyang ";
ResultSet rs=ui.executeQuery(sql);
while(rs.next())
{
out.println(rs.getString(2));
}
out.println("dui");
}
catch(Exception e){
out.println("erro");
}