• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database driven website

 
Mowyn Moosharafy
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hallo, i ask for notes on which java platform to choose to create a database driven website and also an online database driven mobile application. im into ms access programming since 2009.
i thank you much!
moon
 
Tim Moores
Bartender
Posts: 3129
50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do you mean by "Java platform"?

Note that Access is not well suited for concurrent access like you would have with a web app or mobile app. You should consider a more scalable DB instead, like Postgres or MySQL.
 
Mowyn Moosharafy
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hallo, thanks for the reply!
i read about Netbeans and JDBC.
i understand its probably best to use
Mysql and Java.
i ask if Netbeans is the one to use
and which installation of Netbeans in this link here
https://netbeans.org/downloads
in other words, which java/netbeans option to choose from if my aim is to create an dynamic database driven online application.
much thanks again,
moon
 
Henry Wong
author
Marshal
Pie
Posts: 22102
88
C++ Chrome Eclipse IDE Firefox Browser Java jQuery Linux VI Editor Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
moon moosha wrote:
in other words, which java/netbeans option to choose from if my aim is to create an dynamic database driven online application.


I don't think it matters. Netbeans is merely the development tool. So, it should work regardless.

And as you mentioned, JDBC is an option to get to a database. And if you want to use Access, I believe that there is a JDBC driver for it.

Henry
 
Mowyn Moosharafy
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Much thanks for explaining that.
Much appreciation!
Moon.
 
Knute Snortum
Bartender
Pie
Posts: 2897
62
Chrome Eclipse IDE Java Postgres Database VI Editor
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is this a beginning project? Because there is so much you need to know, maybe smaller projects would be good to try first. Here are my suggestions:

* Pick an IDE. NetBeans and Eclipse are free and professional quantity. Either is fine.
* Pick a database. MySql and PostGres are free and professional quality. Either is fine.
* Learn a little about the database you picked. Create some tables. Learn SQL and create a few "reports".
* Write an application that uses JDBC to print a report to the console.
* You may want to consider Hibernate, which is another way other than JDBC to communicate with a database. You interact with objects more than SQL. Not necessary, but useful.
* Write an application that will get user input from the console and create, remove, update, or delete a row in a table or tables.
* Pick a Servlet Container technology. Tomcat, Jetty, JBoss are examples. If you use Netbeans you may want to use GlassFish.
* Learn about HTTP, HTML, CSS
* Pick JSP or ThymeLeaf. JSP is more widely used but I think ThymeLeaf is more powerful and easier.
* If you want, update your JDBC/Hibernate report to HTML/JSP. Make this a small project because next...
* You should pick a dynamic web framework. The two biggies are Spring and Struts. I've used Spring, so I'd recommend it.
* Write "Hello, World!" in Spring/Struts
* Write a simple Login page that checks the database for the password.
* Okay, now write your application!

Oh, and I just notice you want to write a mobile app. Well, there may be a whole other way to go about that! I'll add this to the Mobile forum.
 
Mowyn Moosharafy
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello & thank you Knute!
i am going to take my first steps trying Mysql, Eclipse, and Java!
I will start by creating a simple database and a login/logout form.
i now have a clearer picture of how things interact and will surely get to understand more as i move forward.
thank you immensely!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic