protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {


    DbMangement dbmangement = new DbMangement();

    try {
        String[] person = dbmangement.SelectData();
        Username = person[0];
        email = person[1];
        birthday = person[2];
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

    PrintWriter out = response.getWriter();


    out.println(HTML_START + "<h2>Hi There!</h2><br/>"
                + "<h3>Name "+ Username +"</h3> <br/>"
                + "<h3>email "+ email +"</h3> <br/>"
                + "<h3>Ubd "+ birthday +"</h3> <br/>"
                +HTML_END);
      try {
        Class.forName("com.mysql.jdbc.Driver");
    } catch (ClassNotFoundException e1) {
        // TODO Auto-generated catch block
        e1.printStackTrace();
    }



}

private static final String Username = "root";
private static final String Passsword = "";
private static final String Con_String ="jdbc:mysql://localhost/testdb";



public  String[] SelectData() throws SQLException
{

    Connection conn = null;
    Statement statement = null;
    String[] Person = null;

    //String SqlQuiry = "INSERT INTO table1 VALUES (1 , 'ahmed' , 'mohamed' , '12/2/2014') ";

    String SelectQuiry = "SELECT `name`, `email`, `birtdate` FROM `table1` WHERE id = 1";
    try{
    conn = DriverManager.getConnection(Con_String, Username, Passsword);
    //System.out.println("connected");


    statement = conn.createStatement();    // create statement

    //statement.executeQuery(SelectQuiry);   // execute statement




    ResultSet RS = statement.executeQuery(SelectQuiry);   // execute statement
    //System.out.println("Executed !!");


    while(RS.next())
    {
        Person[0] = RS.getString("name");
        Person[1] = RS.getString("email");
        Person[2] = RS.getString("birtdate");

        //System.out.print("Name is "+UUsername +" Email Is : " +Uemail+ "bd is :" + Ubirthday);



    }
    RS.close();


    }catch(Exception e)
    {
        System.err.println(e);
        return null;

    }
    finally
    {
        if(statement != null)
        {conn.close();

        return Person;
        }

    }
    return Person;
    }