error in code!

sabra · June 7th, 2010, 02:53 PM

import java.sql.*;
import java.io.*;

import java.util.*;

publicclass TestDB {

/**

* @param

*/

publicstaticvoid main(String[] args) {

// TODO Auto-generated method stub

{

try

{

runTest();

}

catch (SQLException ex)

{

while (ex !=null)

{

ex.printStackTrace();

ex = ex.getNextException();

}

catch (IOException ex)

{

ex.printStackTrace();

}

/**

*

*/

publicstaticvoid runTest()

throws SQLException, IOException

{

Connection conn = getConnection();

try

{

Statement stat = conn.createStatement();

stat.execute("CREATE TABLE Greetings(Message CHAR(20))");

stat.execute("INSERT INTO Greeting VALUES('Hello World!')");

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

result.next();

System.out.println(result.getString(1));

stat.execute("DROP TABLE Greetings");

}

finally

{

conn.close();

}

/**

*

*/

publicstatic Connection getConnection()

throws SQLException, IOException

{

Properties props = new Properties();

FileInputStream in = new FileInputStream("database.properties");

props.load(in);

in.close();

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

if (drivers !=null)

System.setProperty("jdbc", drivers);

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

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

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

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

}