Java Mysql Problem.
Hey alle sammen, jeg sidder med et lille problem i min java.den vil ikke hente informationerne ud fra min MySQL database.
Tror desværre bare det er mig der angriber dette forkert.
jeg kan godt bare hente dele ud af databasen, men kan ikke få den til det når jeg trykker på en knap.
***************************************
BankAccountStatus.java
***************************************
import javax.swing.*;
public class BankAccountStatus {
/**
* @param args
*/
public static void main(String[] args)
{
// Set the look and feel to Java Swing Look
try {
UIManager.setLookAndFeel( UIManager.getCrossPlatformLookAndFeelClassName() );
} catch(Exception e) {}
new MainFrame();
}
}
***************************************
MysqlFetch.java
***************************************
import java.sql.*;
public class MysqlFetch {
String str = "Ingen Ting";
public String main ()
{
try
{
String host = "frostdrake.tk";
String port = "3306";
String user = "testdb";
String pass = "test";
String base = "TestDB";
String url = "jdbc:mysql://" + host + ":" + port + "/" + base;
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection( url , user , pass );
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(" SELECT * FROM `table` ");
while(rs.next())
{
int f1 = rs.getInt(1);
String f2 = rs.getString(2);
String f3 = rs.getString(3);
str = (f1 + " - " + f2 + " - " + f3);
System.out.println(str);
}
}
catch (Exception e)
{
e.printStackTrace();
//new ErrorFrame("UPSI... Some Kind of Error");
}
return str;
}
}
***************************************
MainFrame.java
***************************************
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
public class MainFrame {
JFrame jtfMainFrame;
JButton jbnButton1, jbnButton2;
JTextField jtfInput;
JPanel jplPanel;
public MainFrame()
{
// Creating Objects
jtfMainFrame = new JFrame("Get Account Status");
jbnButton1 = new JButton("Query");
jplPanel = new JPanel();
jtfInput = new JTextField(20);
jbnButton1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
MysqlFetch Mysql = new MysqlFetch();
String result = Mysql.main();
jtfInput.setText(result);
}
});
// Adding items to Panel
jplPanel.add(jbnButton1);
jplPanel.add(jtfInput);
// Adding Items to Frame.
jtfMainFrame.getContentPane().add(jplPanel, BorderLayout.CENTER);
jtfMainFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jtfMainFrame.pack();
jtfMainFrame.setVisible(true);
}
}
Fejlmeddelelsen er:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at MysqlFetch.main(MysqlFetch.java:20)
at MainFrame$1.actionPerformed(MainFrame.java:25)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Er der nogen der kan give et eksempel på hvordan dette kan gøres?
