Examples of using java Application and JSP to call javaBean

// 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.exe cuteQuery (SQL );
} Catch (SQLException ex ){
System. err. println ("aq.exe cuteQuery:" + 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;