java.sql.SQLException:没有为jdbc找到合适的驱动程序:mysql:// localhost / dbname [英] java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/dbname
问题描述
我已经搜索了堆栈交换搜索的第一页上的所有链接,但没有一个真正起作用。连接器添加在类路径中,此代码可以在我的学校计算机上运行。这是jFrame中jButton的编码。
I have searched all the links which come on the first page of the stack exchange search for this title, but none really worked.The connector is added in class path and this code works on my school computer. This is the coding of a jButton in a jFrame.
DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
try {
Class.forName("java.sql.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/game", "root", "password");
Statement stmt = con.createStatement();
String sfld = (String) jComboBox1.getSelectedItem();
String op = (String) jComboBox2.getSelectedItem();
String crit = jTextField1.getText();
String query;
if (sfld.equals("contactNo")) {
query = "select * from user where " + sfld + " " + op + " " + crit + ";";
} else {
query = "select * from user where " + sfld + " " + op + " \"" + crit + "\";";
}
ResultSet rs = stmt.executeQuery(query);
int count = 0;
while (rs.next()) {
count++;
model.addRow(new Object[]{
rs.getString(1), rs.getString(2), rs.getString(3),
rs.getString(4), rs.getString(5)
});
}
rs.close();
stmt.close();
con.close();
jTable1.setModel(model);
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
System.out.println(e);
e.printStackTrace();
}
它有时会恢复正常,但每次尝试都会发出相同的信息。之后我重新安装了几次mysql,并将操作系统改为Linux Mint 18 KDE,但仍然出现了麻烦错误。
我使用的是英特尔i3 64位处理器(如果这有帮助的话)。
所有帮助赞赏!
It worked sometime back, but it is giving the same message after every try. After that I reinstalled mysql a few times, and changed the OS to Linux Mint 18 KDE but still the smae error haunts me. I am using a Intel i3 64 bit processor(if this helps). All help appreciated!
EDIT1:
完整的堆栈跟踪
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/game
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at SearchFrame.jButton1ActionPerformed(SearchFrame.java:127)
at SearchFrame.access$000(SearchFrame.java:15)
at SearchFrame$2.actionPerformed(SearchFrame.java:71)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6533)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6298)
at java.awt.Container.processEvent(Container.java:2236)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2294)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
at java.awt.Container.dispatchEventImpl(Container.java:2280)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
EDIT2:
这是将驱动程序更改为com.mysql.jdbc.Driver时的堆栈跟踪
This is the stack trace when I change the driver to com.mysql.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at SearchFrame.jButton1ActionPerformed(SearchFrame.java:126)
at SearchFrame.access$000(SearchFrame.java:15)
at SearchFrame$2.actionPerformed(SearchFrame.java:71)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6533)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6298)
at java.awt.Container.processEvent(Container.java:2236)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2294)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
at java.awt.Container.dispatchEventImpl(Container.java:2280)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
推荐答案
MySQL驱动程序是 com.mysql.jdbc.Driver
(来源)
The MySQL driver is com.mysql.jdbc.Driver
(source)
注意:您的代码容易受到SQL注入攻击。 使用参数和预准备语句而不是连接。
Note: your code is vulnerable to SQL injections. Use parameters and prepared statements instead of concatenating.
这篇关于java.sql.SQLException:没有为jdbc找到合适的驱动程序:mysql:// localhost / dbname的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!