|
<%@ 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, email, lastName1, firstName1, affiliation1, country, abstractTitle FROM abstract WHERE lastName1 like 'Y%' and id < ? order by lastName1");
// ps = con.prepareStatement("SELECT ID, lastName1, firstName1, affiliation1, country, abstractTitle FROM abstract WHERE id < ? ORDER BY lastName1");
ps.setString(1, "3000");
rs = ps.executeQuery();
%>
<%
}
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();
}
}
%>
|