test是ODBC数据原设置的路径,foot表名,name字段名
<%
String url="jdbc:odbc:test";
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver);
Connection conn=DriverManager.getConnection(url,"","");
Statement sqlStatement=conn.createStatement();
String sql="select * from foot";
//String sql="update foot set username='baobo1' where id=1";
ResultSet rs=sqlStatement.executeQuery(sql);
while(rs.next())
{
%>
<ul>
<li><%=rs.getString("name")%></li>
</ul>
<%
}
%>
<%
String url="jdbc:odbc:test";
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver);
Connection conn=DriverManager.getConnection(url,"","");
Statement sqlStatement=conn.createStatement();
String sql="select * from foot";
//String sql="update foot set username='baobo1' where id=1";
ResultSet rs=sqlStatement.executeQuery(sql);
while(rs.next())
{
%>
<ul>
<li><%=rs.getString("name")%></li>
</ul>
<%
}
%>