public   class  ConnectionBean
{
 public   static  Connection getConnection(String url, String login,String password)    throws  Exception
    {
         new   com.mysql.jdbc.Driver();
        Connection con  = DriverManager.getConnection(url, login, password);
         return  con;
    }

 public   static   void  main(String[] args)
    {
         try 
        {
            Connection con = ConnectionBean.getConnection("jdbc:mysql://localhost:3306/dbname","root","sa");
            System.out.println("con == " + con);
            Statement st = con.createStatement();
             String query = "SELECT " +
                    " project_name" +
                    " FROM project ";
            ResultSet rs = st.executeQuery(query);
             while  (rs.next())
            {
                String  projectName = rs.getString( 1 );
                System.out.println("projectName == " + projectName);
            }
        }
         catch (Exception e)
        {
            e.printStackTrace();
        }

    }
}

con == com.mysql.jdbc.Connection@5e0602
projectName == projectA
projectName == projectB
projectName == projectC
projectName == projectA