%@ page import="java.sql.*" %> <%@ include file="/dbconn/dbconn.inc" %> <% String query = "Select * from content WHERE guid=?"; java.sql.PreparedStatement RCstmt = conn.prepareStatement(query); RCstmt.setString(1, request.getParameter("rockclimbing")); java.sql.ResultSet RCrs = RCstmt.executeQuery(); String img = ""; while(RCrs.next()) { String id = RCrs.getString("guid"); String imgSml = RCrs.getString("path"); String imgTmp = RCrs.getString("path_large"); if (imgTmp != null){ img = imgTmp; } else { img = imgSml; } String content_title = RCrs.getString("content_title").trim(); String content_abstract = RCrs.getString("content_abstract").trim(); String content_body = RCrs.getString("content_body"); String pub_date = RCrs.getString("pub_date"); %>
|