aplet i sterowniki jdbc

0

witam mam taki problem, chce w aplecie połączyć sie z baza danych mysqpl

uzywam do tego metody:

private Connection connect() {

    Connection connection = null;
    try {
        Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException ex) {ex.printStackTrace(); }
    
    try {
        connection = DriverManager.getConnection(URL,user,password);
    } catch (SQLException ex) { ex.printStackTrace(); }
        
      return connection;
} 

natomiast jak skompiluje aplet i wrzucę archiwum jar na serwer i odpalę go na stronie to wywala mi błąd:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at sun.applet.AppletClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.applet.AppletClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClassInternal(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at zamowienia.DBConnect.connect(DBConnect.java:30)
	at zamowienia.DBConnect.getZamowienia(DBConnect.java:142)
	at zamowienia.ApletZamowien.getInitData(ApletZamowien.java:341)
	at zamowienia.ApletZamowien.<init>(ApletZamowien.java:329)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at java.lang.Class.newInstance0(Unknown Source)
	at java.lang.Class.newInstance(Unknown Source)
	at sun.applet.AppletPanel.createApplet(Unknown Source)
	at sun.plugin.AppletViewer.createApplet(Unknown Source)
	at sun.applet.AppletPanel.runLoader(Unknown Source)
	at sun.applet.AppletPanel.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
java.sql.SQLException: No suitable driver found for jdbc:mysql://db4free.net:3306/zamowienia
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at zamowienia.DBConnect.connect(DBConnect.java:34)
	at zamowienia.DBConnect.getZamowienia(DBConnect.java:142)
	at zamowienia.ApletZamowien.getInitData(ApletZamowien.java:341)
	at zamowienia.ApletZamowien.<init>(ApletZamowien.java:329)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at java.lang.Class.newInstance0(Unknown Source)
	at java.lang.Class.newInstance(Unknown Source)
	at sun.applet.AppletPanel.createApplet(Unknown Source)
	at sun.plugin.AppletViewer.createApplet(Unknown Source)
	at sun.applet.AppletPanel.runLoader(Unknown Source)
	at sun.applet.AppletPanel.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

powiedzcie jak mam załadować te sterowniki do tego apletu, da sie to upakować w tym archiwum jar. proszę o pomoc pracuję w netbeans, podejrzewam że to wystarczy gdzies w wjenym miejscu dodac ale nie mam pojecia gdzie
0

hello

the problem with your program is that your compiler doesn't find the Package you need to connect with the right Driver

see "Class.forName("com.mysql.jdbc.Driver");

Solution to this is the download and inclusion of "Connector/J" with you can download from <url>www.mysql.com</url>

and search there for the "Connector/J" jar file to built it in into your project.

This would resolve all your problems.

greetz</url>

1 użytkowników online, w tym zalogowanych: 0, gości: 1