| |
<%@ 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", "aimsc1_aims002", "ZoIduG8rvNzm");
// 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();
%>
| ID |
FirstName LastName |
Affiliation |
Country |
Title of Talk |
<%
while(rs.next()){
%>
<%}%>
|
|
|
|
| <%
}
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();
}
}
%> |
|
|
