Sql og java
Vi har kopieret diskys dbhandler og forsøger at få kontakt med vores server. I stedet får vi en lang fejlmeddelselse. Er der nogen der kan se hvad der er galt? I må gerne skrive det på ikke fagsprog, da vi er ret uerfarne i programmering/**
* @author mholst
*
* To change this generated comment edit the template variable "typecomment":
* Window>Preferences>Java>Templates.
* To enable and disable the creation of type comments go to
* Window>Preferences>Java>Code Generation.
*/
import java.sql.*;
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)
{
System.out.println("************************************************************************");
try
{
if(con==null)
{
Class.forName(dbDriverName).newInstance();
con = DriverManager.getConnection("dres", "dres", "XXXX");
System.out.println("con = "+con);
}
}
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;
}
}
/**
* @author mholst
*
* To change this generated comment edit the template variable "typecomment":
* Window>Preferences>Java>Templates.
* To enable and disable the creation of type comments go to
* Window>Preferences>Java>Code Generation.
*/
import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
public class Controller extends dbHandler
{
/** Creates new Database */
public Controller()
{
}
public boolean open()
{
return super.open("org.gjt.mm.mysql.Driver","jdbc:mysql://ishtar.imv.au.dk/dres","dres","XXXX");
}
}
Her er fejlmeddelelsen.
************************************************************************
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:198)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)
at java.lang.ClassLoader.loadClass(ClassLoader.java:262)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:322)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:130)
at dbHandler.open(dbHandler.java:32)
at Controller.open(Controller.java:24)
at Director.<init>(Director.java:27)
at Director.main(Director.java:256)
hallo
