如何把java和数据库连接_求救！ java和数据库如何连接

求救！ java和数据库如何连接

import java.sql.*;

import java.io.*;

import java.util.*;

class TestDB

{

public static void main (String args[]) {

try {

Connection conn = getConnection();

Statement stat = conn.createStatement();

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

stat.execute(

"INSERT INTO Greetings VALUES ('Hello, DataBase!')");

ResultSet result

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

while (result.next())

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

result.close();

stat.execute("DROP TABLE Greetings");

stat.close();

conn.close();

}

catch (SQLException ex) {

while (ex != null) {

ex.printStackTrace();

ex = ex.getNextException();

}

}

catch (IOException ex) {

ex.printStackTrace();

}

}

/* Gets a connection from the properties specified

in the file database.properties */

public static 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", drivers);

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

// return DriverManager.getConnection(url, props);

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

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

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

}

}

一道java和数据库的连接代码！

编译可以完成，但运行时抛出

SQLException异常，no suiable driver

为什么？？？？？？？？？？？？？？？？？？？？？

请高手指点，