Go Back   CodingForums.com > :: Server side development > Java and JSP

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 01-15-2013, 01:52 PM   PM User | #1
chettyharish
New Coder

 
Join Date: Oct 2011
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
chettyharish is an unknown quantity at this point
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
chettyharish is offline   Reply With Quote
Old 01-15-2013, 03:07 PM   PM User | #2
Fou-Lu
God Emperor


 
Fou-Lu's Avatar
 
Join Date: Sep 2002
Location: Saskatoon, Saskatchewan
Posts: 15,650
Thanks: 4
Thanked 2,451 Times in 2,420 Posts
Fou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to all
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.
Fou-Lu is offline   Reply With Quote
Old 01-15-2013, 06:52 PM   PM User | #3
chettyharish
New Coder

 
Join Date: Oct 2011
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
chettyharish is an unknown quantity at this point
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.
chettyharish is offline   Reply With Quote
Old 01-15-2013, 08:13 PM   PM User | #4
Old Pedant
Supreme Master coder!

 
Old Pedant's Avatar
 
Join Date: Feb 2009
Posts: 23,210
Thanks: 59
Thanked 3,996 Times in 3,965 Posts
Old Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to all
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.
Old Pedant is offline   Reply With Quote
Old 01-16-2013, 01:27 PM   PM User | #5
chettyharish
New Coder

 
Join Date: Oct 2011
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
chettyharish is an unknown quantity at this point
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
chettyharish is offline   Reply With Quote
Old 01-19-2013, 01:04 PM   PM User | #6
chettyharish
New Coder

 
Join Date: Oct 2011
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
chettyharish is an unknown quantity at this point
bumping
chettyharish is offline   Reply With Quote
Old 01-19-2013, 01:20 PM   PM User | #7
chettyharish
New Coder

 
Join Date: Oct 2011
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
chettyharish is an unknown quantity at this point
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
chettyharish is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 07:59 PM.


Advertisement
Log in to turn off these ads.