interclient driver kan ikke findes?
Jeg har disse 2 classer hvor jeg via en applet forsøget at proppe 2 variabler i min database, men mens jeg kan sagtens kan compile begge og køre dem sker der ikke noget inde på databasen ? Min catch println fortæller mig at den ikke kan finde interclient driveren? Min classpath seer sådan ud:C:\Program Files\Borland\InterClient\interclient.jar;.import java.awt.*;
import java.awt.event.*;
import java.applet.Applet;
import java.sql.*;
public class Guest extends Applet implements ActionListener
{
DBForbindelse db;
Button submit;
TextField txtAdresse, txtPostBy;
public void init()
{
try
{
db = new DBForbindelse();
}
catch( ClassNotFoundException c )
{}
catch( SQLException s )
{}
submit = new Button("Submit");
txtAdresse = new TextField(30);
txtPostBy = new TextField(30);
add (new Label ("indtast Navn :"));
add (txtAdresse);
add (new Label ("indtast Adresse :"));
add (txtPostBy);
add (submit);
submit.addActionListener(this);
}
public void actionPerformed(ActionEvent e)
{
String adresse = txtAdresse.getText();
String postBy = txtPostBy.getText();
// System.out.println(navn);
try
{
db.indsaetGaest(adresse, postBy);
}
catch( NullPointerException c )
{}
}
}
import java.sql.*;
public class DBForbindelse
{
Connection conn;
Statement statement;
public DBForbindelse() throws ClassNotFoundException , SQLException
{
try
{
Class.forName( "interbase.interclient.Driver" );
}
catch( ClassNotFoundException c ){ System.out.println(c); }
String url = "jdbc:interbase://localhost/c:/Programmer/Borland/InterBase/examples/Database//hoteladm.gdb";
conn = DriverManager.getConnection( url, "sysdba", "masterkey" );
}
public void indsaetGaest( String adresse, String postBy)
{
try{
Statement stmt = conn.createStatement();
String query = "Insert Into GUEST(NAME,ADDRESS) values ('"+adresse+"','"+postBy+"')";
statement.executeUpdate(query);
}catch (SQLException a){System.out.println(a);}
catch( NullPointerException n ){System.out.println(n);}
}
}
