//java bean //file name: faq.java import java.sql.*; public class faq { String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; String sConnStr = "jdbc:odbc:faq"; Connection conn = null; ResultSet rs = null; public faq() { try { Class.forName(sDBDriver); }catch(java.lang.ClassNotFoundException e) { System.err.println("faq(): " + e.getMessage()); } } public ResultSet executeQuery(String sql) { rs = null; try { conn = DriverManager.getConnection(sConnStr); Statement stmt = conn.createStatement(); rs = stmt.executeQuery(sql); }catch(SQLException ex) { System.err.println("aq.executeQuery: " + ex.getMessage()); } return rs; } } //java Application //file name: testfaq.java import java.sql.*; class getRs { public static String Answer; public static String Subject; public static String[][] rsArray = new String[9][2];; public static int n = 0;
|