Du skal benytte en driver: mm.mysql-2.0.1-bin.jar kan hentes fra:
http://mmmysql.sourceforge.net/ Læg den i biblioteket ...\\bin\\jdk1.3\\jre\\lib\\ext
Du skal ikke tilføje i Classpath med denne driver.
Dernæst benytter du dbHandler:
import java.io.*;
import java.sql.*;
public class DatabaseHandler extends Object {
private Connection con=null;
/** Creates new DataBase */
public DatabaseHandler() {
}
public boolean open(String dbDriverName, String dbClassName, String user, String pass){
try{
if(con==null){
Class.forName(dbDriverName).newInstance();
con = DriverManager.getConnection(dbClassName, user, pass);
}
}
catch (SQLException e) {
e.printStackTrace(System.out);
return false;
}
catch (ClassNotFoundException e) {
e.printStackTrace(System.out);
return false;
}
catch (InstantiationException e) {
e.printStackTrace(System.out);
return false;
}
catch (IllegalAccessException e) {
e.printStackTrace(System.out);
return false;
}
return true;
}
public void close() {
if(con!=null) {
try {
con.close();
con=null;
}
catch (SQLException e) {
e.printStackTrace(System.out);
}
}
}
public int doUpdate(String sql) {
if(con!=null) {
try {
long time=System.currentTimeMillis();
Statement stat=con.createStatement();
System.out.println(\"SQL Update = \"+(System.currentTimeMillis()-time)+\" ms \"+sql);
return stat.executeUpdate(sql);
}
catch (SQLException e) {
e.printStackTrace(System.out);
}
}
return 0;
}
public ResultSet doQuery(String sql) {
if(con!=null) {
try {
long time=System.currentTimeMillis();
Statement stat=con.createStatement();
System.out.println(\"SQL Update = \"+(System.currentTimeMillis()-time)+\" ms \"+sql);
return stat.executeQuery(sql);
}
catch (SQLException e) {
e.printStackTrace(System.out);
}
}
return null;
}
}
Kalder den med:
DatabaseHandler db = new DatabaseHandler();
db.open(\"org.gjt.mm.mysql.Driver\",\"jdbc:
mysql://HOSTNAME/DIN_DATABASE\",\"BRUGERNAVN\",\"PASSWORD\");
Det skulle være det. Held og lykke
