Speaker Index
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %> <% Connection con = null; PreparedStatement ps = null; ResultSet rs = null; String id; try{ Class.forName("com.mysql.jdbc.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/aims002_aimsciencesorgorganization", "aims002_user", "12348765"); // ps = con.prepareStatement("SELECT ID, lastName1, firstName1, affiliation1, country, abstractTitle FROM abstract WHERE id < ? ORDER BY lastName1"); ps = con.prepareStatement("SELECT ID, lastName1, firstName1, affiliation1, country, abstractTitle FROM abstract WHERE id < ? and lastName1 LIKE '[A]%' ORDER BY lastName1"); ps.setString(1, "3000"); rs = ps.executeQuery(); %>
Full list
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
<% while(rs.next()){ %> <%}%>
ID FirstName LastName Affiliation Country Title of Talk
<% } catch(SQLException e){ out.print(e.toString()); out.println("
test failed. Click here to return to the conference page."); } finally{ //Make Sure Everything Get Closed if(ps != null){ ps.close(); } if(con != null){ con.close(); } if(rs != null){ rs.close(); } } %>
== Copyright © American Institute of Mathematical Sciences 2003. ==