class QueryTableModel extends AbstractTableModel 
   {
    	Vector cache;
    	int ColCount;
    	String[] headers;
    	Connection db=null;
    	Statement statement;
    	String driverName="com.mysql.jdbc.Driver";
    	//String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
    	//String driverName = "com.jnetdirect.jsql.JSQLDriver";
    	//String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
    	String SQLLoadDatabaseQuery = "SELECT * FROM HouseHoldApplianceDatabase";
    	String URL = "jdbc:mysql://localhost:3306/DatabaseName";
	   // String serverName = "127.0.0.1";
	   // String portNumber = "1433";		
    	//String mydatabase = serverName + ":" + portNumber;
    	//String currentURL = "jdbc:JSQLConnect://" + mydatabase;
    	//String username = "username";
       // String password = "password";
 
    	public QueryTableModel()
    	{
    		cache = new Vector();
    		closeDB();
    		initDB(URL);
    		loadDB();
    	}
 
    	public String getColumnName(int i)
    	{
    		return headers[i];
    	}
 
    	public int getColumnCount()
    	{
    		return ColCount;
    	}
 
    	public int getRowCount()
    	{
    		return cache.size();
 
    	}
 
    	public Object getValueAt(int row, int col)
    	{
    		return ((String[]) cache.elementAt(row))[col];
    	}
 
    	 public void loadDB()
     	{
     		cache = new Vector();
 		    try {
 
 
 		      ResultSet rs = statement.executeQuery(SQLLoadDatabaseQuery);
 		      ResultSetMetaData meta = rs.getMetaData();
 		      ColCount = meta.getColumnCount();
 
 		      headers = new String[ColCount];
 		      for (int h = 1; h <= ColCount; h++) {
 		        headers[h - 1] = meta.getColumnName(h);
 		      }
 
 		      while (rs.next()) {
 		        String[] record = new String[ColCount];
 		        for (int i = 0; i < ColCount; i++) {
 		          record[i] = rs.getString(i + 1);
 		        }
 		        cache.addElement(record);
 		      }
 		      fireTableChanged(null);
 		    } catch (Exception e) {
 		      e.printStackTrace();
 		      System.err.println("Database still can't be loaded");
 		    }
 
     	}
 
    	 public void closeDB() {
 		    try {
 		      if (statement != null) {
 		        statement.close();
 		      }
 		      if (db != null) {
 		        db.close();
 		      }
 		    } catch (Exception e) {
 		      System.out.println("Could not close the current connection.");
 		      e.printStackTrace();
 		    }
    	 }
 
    	 public void initDB(String url) {
    		    try {	   
    		      Class.forName(driverName).newInstance();
    		  //  Connection con = DriverManager.getConnection(url);
    		      db = DriverManager.getConnection(url,"******","******");
    		      statement = db.createStatement();
    		     System.err.println("The database in initialized");
    		    } catch (Exception e) {
    		        System.err.println("Unable to find and load driver");
    		        System.exit(1);
    		      }
    		    }
    	}

public void initDB(String url) {
    		    try {	   
    		      Class.forName(driverName).newInstance();
    		  //  Connection con = DriverManager.getConnection(url);
    		      db = DriverManager.getConnection(url,"******","******");
    		      statement = db.createStatement();
    		     System.err.println("The database in initialized");
    		    } catch (Exception e) {
    		        System.err.println("Unable to find and load driver");
 
                        e.printStackTrace();
 
                        System.exit(1);
    		      }
    		    }
    	}