Okay så skal der laves lidt :9
Download f.eks. MySQL og den JDBC driver du også kan finde på
www.mysql.com siden.
Du skal så bruge en klasse der kan snakke med en Database du kan bruge denne her:
/*
* DataBase.java
*
* Created on 3. december 2000, 21:06
*/
import java.sql.*;
import disky.database.*;
/**
*
* @author Søren Reinke
* @version
*/
public class DbHandler extends Object
{
private Connection con=null;
/** Creates new DataBase */
public DbHandler()
{
}
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;
}
}
Du åbner en forbindelse med:
DBHandler db=new DBHandler();
db.open("org.gjt.mm.mysql.Driver","jdbc:
mysql://SERVERNAME/DATABASENAVN","USERNAME","PASSWORD");
Så kan du sende en query med:
ResultSet res=db.executeQuery("select * from venner");
Det resultset kan du så behandle.
