Need help to develop a web based application using awt,swing,sql etc

[adiotrox]

Hi people,
I want to make a simple web based application using core and advance java(not a browser application)
including awt,swing,sql etc
i am completely naive in this please tell me how this kind of applications 'work' and how to 'develop' them.
i have to submit a project and want to do it on my own.
please do help.

Regards,
Adiotrox

[DarrylBurke]

Don't double post. The other thread you started in the AWT/Swing section has been removed.

db

[adiotrox]

he db can you also help me to solve my problem

[Fubarable]

...
i am completely naive in this please tell me how this kind of applications 'work' and how to 'develop' them....

1. Your question is a bit broad. Can you narrow down the specifics as to what particulars have you confused? If everything, then you may wish to do some Googling and studying to get an initial grasp on things.
2. Also consider searching out and using a local mentor. If this is for an academic project, and you're really a newbie at all of this, you're taking quite a big bite, hopefully not too big, and a local mentor could help immensely.

[adiotrox]

can i use jdbc-odbc bridge driver for a database server so that it will be able to access data through internet for my java application?

[DarrylBurke]

You've already been asked not to double post. I've removed one more thread about this that you started in the AWT/Swing forum.

Any further double posting will lead to a ban. No further warning will be given.

db

[Tolls]

can i use jdbc-odbc bridge driver for a database server so that it will be able to access data through internet for my java application?

Either do a simple web app first, no database, or do a desktop app with a database.
Don't try and learn all these technologies at once.

As for your question, go for a simple free database (something like JavaDB, but there are others) and use the JDBC driver that comes with that.
ALso, you don't open up your database to the internet. You would have a web server inbetween that talks to the database and the client.

[diamonddragon]

can i use jdbc-odbc bridge driver for a database server so that it will be able to access data through internet for my java application?

Why would You use JDBC-ODBC bridge and not JDBC driver?

[Kuttappu]

i am completely naive in this please tell me how this kind of applications 'work' and how to 'develop' them.
Adiotrox

Am also a beginner.. Having seen that none helped you so far, let me tell you what i know..

1.Database part

Hope u know to crete database and basic querries to create tables and other components in sql management studio..
U need to add your sql server: control panel -> AdminTools -> DataSources (ODBC) -> Add -> SQL server -> Name:Test -> Server:. -> with windowsNT authentication -> change the default database -> finish ->Testdata source ->ok

Note: we entered the server as "." (u need this later when u log in to management studio)

You can querry in management studio or through your program


2.Connection to database from program

u add to imports java.sql.*;
You need to choose driver and also connect. the following are the codes.

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Test"," username","password");
//Test is the server that we created. username n password if any.

Using PreparedStatement u can issue querries. Hope you know that.

3.Web based

You need to be more specific. I feel what u mean is a servlet.. If u are using NetBeans, selecting New WebBased Project itself will give you a layout..
Hope you know awt and swing components. Make your design and navigate to another page using response.sendRedirect("example") or request.getRequestDispatcher("example") depending on whether the target is html or java page..


If you post a better idea of what your project is, or be more specific, i think many will be able to help you..
This is the best forum for java i have seen so far..

Thank You.

[Tolls]

We have helped.
You don't learn 3 or 4 frameworks in one go and expect to actually be able to produce something useable.

As for your help, point 1 is only of any use if you are using SQL Server and, in any case, you should be using a SQL Server specific driver, not the bridge. That applies to any DB (except Acces which I don't htink has a proper driver, but then it should be the last choice of database).

And the other 2 points highlight how vague the OPs post was...they will be almost meaningless since there is no context to them. The OP needs to narrow their sights a bit.

[Kuttappu]

We have helped.
You don't learn 3 or 4 frameworks in one go and expect to actually be able to produce something useable.

Am sorry.. i dint see couple of posts when i scrolled down..

[Kuttappu]

As for your help, point 1 is only of any use if you are using SQL Server and, in any case, you should be using a SQL Server specific driver, not the bridge. That applies to any DB (except Acces which I don't htink has a proper driver, but then it should be the last choice of database).

And the other 2 points highlight how vague the OPs post was...they will be almost meaningless since there is no context to them. The OP needs to narrow their sights a bit.

Thats a great knowledge to me.. Am pretty new to java. I thought i was helping with what i know, sad
And what is "OP" ?

[Tolls]

"OP" = "Original Post(er)".

[adiotrox]

This is what i want to make-
An "e-diary" which stores all of your phone no.,address books,personal details,it should be a web based application so that all of your data is stored safely in a remote server.

what i want to know:-
1. can i develop an application using awt,swing for the client side(no need of browser),which will be install at client's side?
2. then to store and access data from database server..what exactly has to be done ?

And i appreciate all of your suggestions above.
Regards,
Adiotrox

[Tolls]

OK.
Yes you can.
For security purposes you do not want to expose your database to the internet directly, so you'll want a webapp between, probably a simple web service. Up to you whether it's RESTful or SOAP.
Your client will talk to this service to access/update the data in the database.

So, that's Swing, JWS (or some other WS framework), JDBC, web server, database to learn. I've probably missed a technology or two there as well.

[adiotrox]

@Tolls Thanks.

I Thinks i can drop the RESTful or SOAP part as i am a newbie and is JWS necessary??(might increase the complexity for me :) ).

1.Is it possible to make the application for client side using swing and then directly connect the application with the web server and web server to the database using jdbc??

*How to connect the swing application with the web server?

2.If i just go for a desktop application then only swing,jdbc and database is sufficient?

note:can you become my mentor?

[Tolls]

So how are you going to talk to the web server then?
That's my point.
You talk to web servers via Http. So you can go straight Http (which would be a case of roll-your-own REST), or use pre-existing frameworks (eg one of the JWS bits, which are a web service framework).

I was going to suggest 2 anyway, as a start point if nothing else.
Write a desktop app that does what you want, talking to a database on the same machine.
Write it such that you can "unplug" the database access parts (as a separate package).
Then you can unplug that bit and plug in something that talks to a web server instead for the database access.

If this sounds like a lot of gobbledigook then that's because (as I said earlier) you were asking to do rather a lot for someone new to Java.

[JosAH]

For security purposes you do not want to expose your database to the internet directly

Why not? Even governments do it every day ... ;-)

kindest regards,

Jos (runs -----------------------------------------------------------------------------------------------------------------------------------------> that a'way)

[Tolls]

Ours just leave unencrypted laptops and pen drives filled with state secrets lying around on trains and park benches.
Who needs exposed databases?

[JosAH]

Ours just leave unencrypted laptops and pen drives filled with state secrets lying around on trains and park benches.
Who needs exposed databases?

Those are just off-line agents; they're a governmental service; but what if there's no bench nor a train in the vicinity? You'll need a completely open on-line database. Jeez, people don't understand anything nowadays ...

kind regards,

Jos ;-)