Eclipse

thanks for the reply. i did'nt knew eclipse had a builtin JDbc driver. anyways i was trying to run my program and it says something about classpath. i have not download any jdbc driver or anyhthing.

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.io.FileInputStream;

import java.io.IOException;

import java.util.Properties;

/**

A simple data source for getting database connections.

*/

public class SimpleDataSource

{

/**

Initializes the data source.

@param fileName the name of the property file that

contains the database driver, URL, username, and password

*/

public static void init(String fileName)

throws IOException, ClassNotFoundException

{

Properties props = new Properties();

FileInputStream in = new FileInputStream(fileName);

props.load(in);

String driver = props.getProperty("jdbc.driver");

url = props.getProperty("jdbc.url");

username = props.getProperty("jdbc.username");

password = props.getProperty("jdbc.password");

Class.forName(driver);

}

/**

Gets a connection to the database.

@return the database connection

*/

public static Connection getConnection() throws SQLException

{

return DriverManager.getConnection(url, username, password);

}

private static String url;

private static String username;

private static String password;

}

Main

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.Statement;

/**

Tests a database installation by creating and querying

a sample table. Call this program as

java -classpath driver_class_path;. TestDB database.properties

*/

public class TestDB

{

public static void main(String[] args) throws Exception

{

if (args.length == 0)

{

System.out.println(

"Usage: java -classpath driver_class_path;."

+ " TestDB database.properties");

return;

}

else

SimpleDataSource.init(args[0]);

Connection conn = SimpleDataSource.getConnection();

try

{

Statement stat = conn.createStatement();

stat.execute("CREATE TABLE Test (Name CHAR(20))");

stat.execute("INSERT INTO Test VALUES ('Romeo')");

ResultSet result = stat.executeQuery("SELECT * FROM Test");

result.next();

System.out.println(result.getString("Name"));

stat.execute("DROP TABLE Test");

}

finally

{

conn.close();

}

}

}

lrngjavaa at 2007-7-12 2:07:24 >