Java program that transfers stock prices to MySQL database

[naipulb]

Hi

Jag want to bring stock prices from csv files (excel) on the internet and copy them to a MySQL database through a Java program. I have downloaded the following:

-Eclipse
-MySQL server 5.0
-MySQL Connector/J

With this installed I should be able to edit mySQL databases through JDBC, but I don't know so much more. Can somebody help me to get started?

[sukatoa]

Quote:

Can somebody help me to get started?

have some tutorials about it first....

sukatoa

[DonCash]

You will need to create a new Java project in Eclipse. Once complete, right click the project in the Package window and click 'Properties' Then navigate to 'Java Build Path' Click 'Add JARs' and locate the MySQL JDBC driver. Add it and click OK..

Then you can use this code to connect to the database:

Code:

   import java.sql.*;

   public class Connect
   {
       public static void main (String[] args)
       {
           Connection conn = null;

           try
           {
               String userName = "testuser";
               String password = "testpass";
               String url = "jdbc:mysql://localhost/test";
               Class.forName ("com.mysql.jdbc.Driver").newInstance ();
               conn = DriverManager.getConnection (url, userName, password);
               System.out.println ("Database connection established");
           }
           catch (Exception e)
           {
               System.err.println ("Cannot connect to database server");
           }
           finally
           {
               if (conn != null)
               {
                   try
                   {
                       conn.close ();
                       System.out.println ("Database connection terminated");
                   }
                   catch (Exception e) { /* ignore close errors */ }
               }
           }
       }
   }