How to connect to mysql database?

[Kavitha Sen]

Dear Ranchers,

I have eclipse ide,tomcat server and mysql database, oracle ide.
I have included ojdbc14.jar in classpath.

Now i like to know how to connect database in eclipse. I mean what code should be included? and where to include? can any one help me.

sorry for asking the basic doubt.

[Kavitha Sen]

hello again,

I copied the following code for database connection.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
public class TestClassForNameApp {
 
  public static void main(String args[]) {
 
    try {
      Class.forName("oracle.jdbc.driver.OracleDriver");
    } catch (ClassNotFoundException e) {
      System.out.println("Oops! Can't find class oracle.jdbc.driver.OracleDriver");
      System.exit(1);
    }
 
    Connection conn = null;
    Statement stmt = null;
    ResultSet rset = null;
    try {
      conn = DriverManager.getConnection("jdbc:oracle:thin:@dssw2k01:1521:orcl", "scott", "tiger");
 
      stmt = conn.createStatement();
      rset = stmt
          .executeQuery("select 'Hello '||USER||'!' result from dual");
      while (rset.next())
        System.out.println(rset.getString(1));
      rset.close();
      rset = null;
      stmt.close();
      stmt = null;
      conn.close();
      conn = null;
    } catch (SQLException e) {
      System.out.println("Darn! A SQL error: " + e.getMessage());
    } finally {
      if (rset != null)
        try {
          rset.close();
        } catch (SQLException ignore) {
        }
      if (stmt != null)
        try {
          stmt.close();
        } catch (SQLException ignore) {
        }
      if (conn != null)
        try {
          conn.close();
        } catch (SQLException ignore) {
        }
    }
  }
}
 

    

But i get this error.

Darn! A SQL error: Io exception: The Network Adapter could not establish the connection

What should I do? please help me. Thanks.

[aswin kumar]

hi !
configure a jdbc Driver in eclipse, for this windows->showView->DBBrowser->rtClick->someConfiurations like drivername and Login Details and add jar files for Driver

and then make sure Database is in running mode,after that you can execute your program.

regards,