Connect Java to SQL

[ŖàΫ ỏƒ Ңόρę]

Hi

I'm working these days on how to connect java applet with SQL database.

I have searched many times and finally found this code

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {
  public static void main(String[] args) throws Exception {
    if (conn != null) {
      System.out.println("Connection attempt was successful!");

      try {
        conn.close();
      } catch (SQLException ex) {
        ex.printStackTrace();
        System.out.println("Problem closing the connection");
      }
    }
  }

  static Connection conn;

  static Statement st;

  static {
    try {
      // Step 1: Load the JDBC driver.
      Class.forName("org.hsqldb.jdbcDriver");
      System.out.println("Driver Loaded.");
      // Step 2: Establish the connection to the database.
      String url = "jdbc:hsqldb:data/tutorial";

      conn = DriverManager.getConnection(url, "sa", "");
      System.out.println("Got Connection.");

      st = conn.createStatement();
    } catch (Exception e) {
      System.err.println("Got an exception! ");
      e.printStackTrace();
      System.exit(0);
    }
  }
}

After I read about the connection , I could not understand this line

// Step 1: Load the JDBC driver.
      Class.forName("org.hsqldb.jdbcDriver");

Also this line

 // Step 2: Establish the connection to the database.
      String url = "jdbc:hsqldb:data/tutorial";

Can someone explain that to me ?

I'll be thankful to you guys.

:)

[masijade]

They are explained in the Tutorial. Go through that from front to back.

[baloda]

Class.forName("org.hsqldb.jdbcDriver");

loads the database drivers that will provide the necessary things i.e. connectivity to a specific data base u r using for ur application.

String url = "jdbc:hsqldb:data/tutorial";

this is the url for the data base server.

if ur database is on the same machine then u can change it
(MS-Access database)

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:FMSDB",null ,null);
//FMSDB is database name and first null is username and second is password

for more details u can visit

http://java-sql.blogspot.com/2011/03...ns-injava.html

[masijade]

if ur database is on the same machine then u can change it
(MS-Access database)

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:FMSDB",null ,null);
//FMSDB is database name and first null is username and second is password

for more details u can visit

SQL where clause with Date in Java

The question there is, why would you want to?

[baloda]

The question there is, why would you want to?

i think that will be easy to understand for a starter.

http://java-sql.blogspot.com/2011/03...ns-injava.html

[masijade]

i think that will be easy to understand for a starter.

Not likely.

[baloda]

Not likely.

May be, u r right. but at that time i thought like that.


http://java-sql.blogspot.com/2011/03...ns-injava.html