找不到适用于jdbc:mysql:// localhost:3306 / DATASET的驱动程序
首先
将JDBC连接器放在类路径中,您可以从此处下载它
如果您正在使用maven,请使用以下命令:
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --><dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.13</version></dependency>
其次, 确保您的连接信息正确:
public class CreateConnection { String driver = "com.mysql.jdbc.Driver"; String DB_username = "root"; String DB_password = "pass"; String DB_URL = "jdbc:mysql://localhost:3306/DATAbase"; public Connection getConnection() { try { Class.forName(driver); java.sql.Connection con = DriverManager.getConnection(DB_URL, DB_username, DB_password); return con; } catch (ClassNotFoundException | SQLException e) { System.out.println("Exception " + e); return null; } }}我建议您改用Prepared Statement,这是一种安全的做法,您可以在此处了解此Prepared
Statement



