Java program that stores user inputs

[staticy2003]

Hello
I am almost new in Java, and i have to do a program in java that acquires the user inputs from a file or from the interaction with the GUI, and stores these data in a database.
I installed MYSQL, since it is opensource...
Anyone has any suggestion?
Thanks in advance

[CaptainMorgan]

Welcome to the Java Forums!

Have you attempted writing the code yet? If so, please post it if you get stuck - and please use code tags. You can start by reviewing both the Database forums for some posts related to yours, and/or have a view at this site's Tutorials where there are a few threads regarding databases.

MySQL is a good choice.. however, you say you're "almost new", and I'm not sure what you mean by that. For beginner Java programmers, this assignment you have to do requires the use of some more advanced concepts. But post your code and ask your specific questions, we're here to help.

See you around!

[sandeeprao.techno]

Before writing the program you have to create a DSN and then create tables in that particular DSN and then carry on with the code, also set the classpath for the database.

[Eranga]

First create required tables and stuff in the database first.

Then think that how to connect database to a Java application. At that point you can learn a lot about database connections. There few number of connections are available for Java.

Then try to find out that how to write data to a database table. Just use some values which is on your application itself included. Don't think about GUI and user command line inputs, etc.

At last try to work with user inputs.

Likewise try to step out your question first. Then try to do something. Then put your code here and all the members help you to solve your question. Don't worry about that you are a newbie for Java. This project is a very good one to start work with Java. Try and see.

Good luck pal...

[staticy2003]

Thank you very much for your answers. It helped me a lot. Now I am going to try the different ways for doing this program and in anycase, if something doesn't work I'll put the code here.
Thanks a lot

[Eranga]

Yep pal, that's better first start some work. We all are ready to help you at any time.

[JAdmin]

Here is a sample code to connect to a MySQL database

Code:

    Database name     : yourdatabase
    Databse user      : aUser
    Database password : aPwd

    import java.sql.*;
 
    Connection conn = null;
    Statement stmt = null;
    ResultSet  rs = null;
  
    try{
      Class.forName(com.mysql.jdbc.Driver);       
      conn = 
      DriverManager.getConnection("jdbc:mysql://localhost:3306/yourdatabase",aUser,aPwd);

       //Create a Statement object.  
       stmt = conn.createStatement();  
       //Get a ResultSet  
        rs = stmt.executeQuery("select * from users");
        //Loop through the results 
        while(rs.next()){          
          String userName = rs.getString("user");
          System.out.println(userName );
        }
      }catch( Throwable t){  
       //handle error here  
        t.printStackTrace();
      }
      finally{       
        //note the sequence of closing the objects. rs first 
        // followed by stmt and connection
        try{
	   if(rs != null) rs.close();
  	}catch(Throwable t){t.printStackTrace();}
 
 	try{
 	   if(stmt != null) stmt.close();
	}catch(Throwable t){t.printStackTrace();}
	
	try{
 	   if(con != null) con.close();
	}catch(Throwable t){t.printStackTrace();}
    }

Always remember to close your objects in a finally block. That is the time tested best practice.

Hope this helps!

Sincerely, your friends at JavaAdvice.com