Untitled

  String htmlText1 = "", htmlTableHeader1 ="", htmlText2 = "";
        String customerData = "";
        /*SQL initialization and data retrieval*/
	try{
        Class.forName("com.mysql.jdbc.Driver"); //SQL driver for java
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/mchanner?user=mchanner&password=mchanner"); //connection string for SQL server
        Statement stmt = conn.createStatement();

        ResultSet customerInfo = stmt.executeQuery("select customer_id, customer_name, customer_year, customer_maidenName, customer_address, customer_city, customer_state, account_balance "+"from customerdata"); //!!! where customer_id="+accountNumber);

/* html generation*/


String customer_id="",customer_name="",customer_year="",customer_maidenName="",customer_address="",
        customer_city="",customer_state="",account_balance="";


	    /*Create table header*/
                 htmlText1 = "<html> <body>\r\n";
	             htmlTableHeader1=
                       "<table style=\"width:100%\" border=\"1\">"
                     + "<tr>"
                     +    "<td style=\"font-weight:bold\">ID</td>"
                     +    "<td style=\"font-weight:bold\">Name</td>"
                     +    "<td style=\"font-weight:bold\">Year</td>"
		             +    "<td style=\"font-weight:bold\">Maiden Name</td>"
                     +    "<td style=\"font-weight:bold\">Address</td>"
                     +    "<td style=\"font-weight:bold\">City</td>"
                     +    "<td style=\"font-weight:bold\">State</td>"
                     +    "<td style=\"font-weight:bold\">Account Balance</td>"
                     + "</tr>\r\n";

            while(customerInfo.next()){

            //For table cells
            customer_id = customerInfo.getString("customer_id");
	        customer_name = customerInfo.getString("customer_name");
	        customer_year = customerInfo.getString("customer_year");
	        customer_maidenName = customerInfo.getString("customer_maidenName");
	        customer_address = customerInfo.getString("customer_address");
	        customer_city = customerInfo.getString("customer_city");
            customer_state = customerInfo.getString("customer_state");
            account_balance = customerInfo.getString("account_balance");

            customerData +=
                       "<tr>"
                     +    "<td>"+customer_id+"</td>"
                     +    "<td>"+customer_name+"</td>"
                     +    "<td>"+customer_year+"</td>"
          		     +    "<td>"+customer_maidenName+"</td>"
                     +    "<td>"+customer_address+"</td>"
                     +    "<td>"+customer_city+"</td>"
                     +    "<td>"+customer_state+"</td>"
                     +    "<td>"+account_balance+"</td>"
                     + "</tr>";
            }

    htmlText2= "</table> </body> </html>\r\n";
        }


        catch (SQLException e1) {
                System.out.println(e1.getMessage());
        }
        catch (ClassNotFoundException e2){
                System.out.println(e2.getMessage());
        }
	    catch (NoSuchElementException e3){
                System.out.println(e3.getMessage());
	    }


    return (htmlText1 + htmlTableHeader1 + customerData + htmlText2);