java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/

数据库   发布日期:2025年07月06日   浏览次数:169

出现这个异常原因可能很多:

1.编码问题

2.没有加载类驱动:换一种数据库的连接方式,就忘了这个:Class.forName(driverclass);

  1. import java.io.IOException;
  2. import java.io.InputStream;
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.sql.Statement;
  8. import java.util.Properties;
  9. public class JdbcUtil {
  10. private static String driverclass;
  11. private static String url;
  12. private static String user;
  13. private static String password;
  14. static{
  15. try{
  16. ClassLoader cl=JdbcUtil.class.getClassLoader();
  17. InputStream in=cl.getResourceAsStream("dbbcfg.properties");
  18. Properties props=new Properties();
  19. props.load(in);
  20. driverclass=props.getProperty("driverClass");
  21. url=props.getProperty("url");
  22. user=props.getProperty("user");
  23. password=props.getProperty("password");
  24. in.close();
  25. }catch (Exception e){
  26. e.printStackTrace();
  27. }
  28. try {
  29. Class.forName(driverclass);
  30. }catch (ClassNotFoundException e){
  31. e.printStackTrace();
  32. }
  33. }
  34. public static Connection getConnection(){
  35. try {
  36. Connection conn = DriverManager.getConnection(url,user,password);
  37. return conn;
  38. } catch (Exception e) {
  39. throw new RuntimeException("链接数据库的url或用户名密码错误,请检查您的配置文件");
  40. }
  41. }
  42. public static void release(ResultSet rs,Statement stmt,Connection conn){
  43. if(rs!=null){
  44. try {
  45. rs.close();
  46. } catch (SQLException e) {
  47. e.printStackTrace();
  48. }
  49. rs = null;
  50. }
  51. if(stmt!=null){
  52. try {
  53. stmt.close();
  54. } catch (SQLException e) {
  55. e.printStackTrace();
  56. }
  57. stmt = null;
  58. }
  59. if(conn!=null){
  60. try {
  61. conn.close();
  62. } catch (SQLException e) {
  63. e.printStackTrace();
  64. }
  65. conn = null;
  66. }
  67. }
  68. public static void main(String[] args){
  69. System.out.println("Test connection");
  70. try{
  71. Connection conn=JdbcUtil.getConnection();
  72. System.out.println(conn);
  73. }catch (Exception e){
  74. e.printStackTrace();
  75. }
  76. }
  77. }

 

以上就是java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/的详细内容,更多关于java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/的资料请关注九品源码其它相关文章!