package dbWordsPackage;
import java.io.*;
import java.sql.*;
import javax.swing.JOptionPane;
 
/**
 *
 * @author EL-Prince
 */
public class dbWordsCon {
 
    public String URL = "jdbc:odbc:dbWords";
    public String Driver = "sun.jdbc.odbc.JdbcOdbcDriver";
 
    public Connection Con = null;
    public Statement Stmnt = null;
    public ResultSet rs = null;
 
    public dbWordsCon(){
 
        try{
            Class.forName(this.Driver);
            this.Con = DriverManager.getConnection(URL);
            this.Stmnt = this.Con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
            ResultSet.CONCUR_UPDATABLE);
 
            String sqlQuery = "SELECT * FROM words" ;
            rs = Stmnt.executeQuery(sqlQuery);
 
            String result = null;
 
            while(rs.next()){              
 
                BufferedReader r = new BufferedReader(rs.getCharacterStream(3));  
                JOptionPane.showMessageDialog(null, r.readLine());
            }
        }catch(SQLException ex) {
            ex.printStackTrace();
        } catch (ClassNotFoundException e ) {
            e.printStackTrace();
        }catch(Exception exp){
            exp.printStackTrace();
        }// End of catch
    }// End of constructor
 
}