import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
/**
* @author Sridhar Srinivasan
Jun 24, 2009 12:53:57 PM
*/
public class MySQLConnection {
private static Connection getConnection(){
String driverClassName=”com.mysql.jdbc.Driver”;
String connectionUrl=”jdbc:mysql://localhost:3306/test”;
String userName=”root”;
String password=”mysql”;
Driver driver = (Driver) getObject(driverClassName);
Connection connection=null;
try {
DriverManager.registerDriver(driver);
connection=DriverManager.getConnection(connectionUrl,userName,password);
} catch (SQLException e) {
e.printStackTrace();
}
return connection;
}
public static void main(String[] args) {
Connection connection = getConnection();
try {
Statement statement = connection.createStatement();
statement.executeUpdate(“DELETE FROM STUDENTS”);
} catch (SQLException e) {
e.printStackTrace();
}
}
public static Object getObject(String className){
Object object = null;
try {
object=Class.forName(className).newInstance();
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return object;
}
}
