<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%
String ID = request.getParameter("id");
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 lastName1, firstName1, lastName2, FirstName2, lastName3, firstName3, abstractBody, abstractTitle FROM abstract WHERE id = ?");
ps.setString(1, ID);
%>
|
<% rs = ps.executeQuery();
while(rs.next()){
%>
<%=rs.getString("abstractTitle")%> |
| Author/Speaker
: <%=rs.getString("firstName1")%> <%=rs.getString("lastName1")%>
|
| Coauthors:
<%=rs.getString("FirstName2")%>
<%=rs.getString("lastName2")%>
<%=rs.getString("firstName3")%> <%=rs.getString("lastName3")%>
|
|
<%
out.println(""+rs.getString("abstractBody")+" ");
} %>
|
|
<%
}
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();
}
}
%>