Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 7 of 7
  1. #1
    New Coder
    Join Date
    Oct 2011
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Final Year Project Help Please

    Ok guys I know I am late. I have 3 months to complete my project and well I have not started anything. as expected.

    The Project:
    The project is a DTH Management System. We need to have the following things
    A front end at the business website, an interface consisting of all the stuff such as add customers, payments etc.
    A front end business side tool where operators can insert stuff. (Thinking of Java frames and panels)
    A front end tool (website or java interface) which is able to output graphs using the data from the database.
    And a SQL backend for all the 3 above.

    The database is the biggest problem, should we opt for MySQL, MS SQL.
    Is it easier to create and display graphs in Java or PHP Website? (In terms of ease of creation).

    Please help ASAP as we will have to learn and implement them.



    Thank you very much

  • #2
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,987
    Thanks
    4
    Thanked 2,660 Times in 2,629 Posts
    Choosing the db as well as writing the ERD should be your priority here. Fortunately, using basic SQL syntax is standardized, so you can get away with changing your mind so long as you don't do anything proprietary. Why not an Oracle database for example? Oracle and Java play along quite well, as does Java an MySQL. I've used Java for SQLServerExpress, but not an enterprise SQLServer. I don't recall it being difficult to set up, but would definitely need a package for it (MySQL used to as well, but now that oracle acquired sun, I'm not sure if its built in nowadays).

    Personally, I avoid JSP and Servlets like the plague. I've never had anything but troubles with implementing them, and have always found them to be overall issues in stability. I do like that it is quite fast though.

    Its easy to create graphs in both Java and PHP. Personally I'd use PHP if its for a website, and Java if its for a desktop app or applet. If I need to use Desktop and Web app, I'd consider using soap between them.

  • #3
    New Coder
    Join Date
    Oct 2011
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the help. The problem is very limited knowledge currently lol. I am looking at youtube videos and learning java and php. Say where can I Learn SOAP as a a beginner and when should I look into it, I mean after the MySQL+Java+PHP or between there somewhere. I am avoiding Oracle DB as I am doing the project for college and most free on-line hosts only support MySQL and I have also heard that Oracle can sometimes create lots of errors during setting up.

  • #4
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,210
    Thanks
    75
    Thanked 4,343 Times in 4,309 Posts
    Why would you WANT to try to use both PHP and Java for the same project?

    Yes, you can do it. But all it will do is almost double your learning time.

    Choose one and stick with it.

    I agree that PHP is the easier to use for Web-based work, but if your class/department requires you to use Java, then go ahead and use JSP.

    You *can* use JSP and *NOT* use any of the Java Frameworks, and if you are in a hurry to produce something I'd be sorely tempted to go in that direction. Fundamentally, you just create HTML pages and then, at the last step, slip in the JSP code.

    For example, you might create some HTML like this:
    Code:
    <table>
        <tr><th>Name</th><th>Address</th></tr>
        <tr><td>$NAME</td><td>$ADDRESS</td></tr>
    </table>
    Here, $NAME and $ADDRESS just serve as place holders so you can see what the HTML will produce.

    And when the page looks "pretty", you now go and slip in your Java code. Roughly, something like this:
    Code:
    <table>
        <tr><th>Name</th><th>Address</th></tr>
    <%
    ... make db connection ...
    ... make statement object ...
    ResultSet rs = stmt.executeQuery("SELECT name, address FROM table ORDER BY name" );
    
    while ( rs.next() )
    {
    %>
        <tr><td><%=rs.getString(1)%></td>
            <td><%=rs.getString(2)%></td></tr>
    <%
    }
    %>
    </table>
    Not the best JSP code, but it works and actually works quite well. It's a good first step with JSP.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #5
    New Coder
    Join Date
    Oct 2011
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The department is actually quite flexible, and allows us to use anything except Visual Basic.
    The reason I am inclined towards Java and PHP is due to the fact that youtube has a very detailed series on both the topics and I believe that it will be faster if I learn visually instead of a book. Though I also see that they also have a JQuery one which also looks good. There are few with JSP series but they kinda have fewer videos.


    Java:
    https://www.youtube.com/course?list=ECFE2CE09D83EE3E28
    https://www.youtube.com/course?list=EC27BCE863B6A864E3

    PHP
    https://www.youtube.com/course?list=EC442FA2C127377F07

    JQuery
    https://www.youtube.com/course?list=EC6B08BAA57B5C7810

    JSP
    https://www.youtube.com/playlist?lis...F6C1917A427E96

    So can you suggest me better? JQuery library also looks good, but the JSP one has 25videos. Can I get a more comprehensive study path for JSP?? I also see that there is a vast array of information for PHP but very little for JSP.
    Last edited by chettyharish; 01-16-2013 at 01:44 PM. Reason: More Information

  • #6
    New Coder
    Join Date
    Oct 2011
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts
    bumping

  • #7
    New Coder
    Join Date
    Oct 2011
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Also can you please tell me what Tools for eclipse will be useful like windowbuilder pro. For the entire project.

    Thank you for all your help


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •