<%@ page language="java" import="java.sql.*" buffer="none" info="only for testing" %>

<%
	String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	String sConnStr = "jdbc:odbc:test1";
	
	Connection conn = null;
	ResultSet RS = null;
		try {
			Class.forName(sDBDriver); 
		}catch(java.lang.ClassNotFoundException e) {
			System.err.println("test1(): " + e.getMessage());
		}
	
		try {
			conn = DriverManager.getConnection(sConnStr); 
			Statement stmt = conn.createStatement();
                        String strSQL="Select col3, col4, col5 From tbTopic Where col2<161";
                        RS = stmt.executeQuery(strSQL);
		} catch(SQLException ex) { 
			System.err.println("aq.executeQuery: " + ex.getMessage());
		}

        while (RS.next()) {
                out.print(RS.getString("idTopic"));
        }
        RS.close();
%>