javaee:连接数据库失败java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

怼烎@ 2022-11-18 01:55 74阅读 0赞

# java.lang.ClassNotFoundException: com.mysql.jdbc.Driver #

### 1.加载数据库驱动失败： ###

检查你web服务器（tomcat）的lib目录下，有没有mysql-connector-java-5.1.44-bin.jar  
之前谷咕咕就是里面没有jar包，所以加载失败  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ExNDI0MjYxMzAz_size_16_color_FFFFFF_t_70]

### 2.项目是否导入mysql-connector-java-5.1.44-bin.jar包 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ExNDI0MjYxMzAz_size_16_color_FFFFFF_t_70 1]  
通过add，可以添加本地的jar包  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ExNDI0MjYxMzAz_size_16_color_FFFFFF_t_70 2]

### 3.加载驱动代码 ###

Connection ct;
    	PreparedStatement pstmt;
    	//建立数据库连接
    	public DB() { 
    		try { 
    			Class.forName("com.mysql.jdbc.Driver");
    			ct = DriverManager.getConnection("jdbc:mysql://localhost:3306/skd","root","root");
    		} catch (Exception e) { 
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		
    	}

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ExNDI0MjYxMzAz_size_16_color_FFFFFF_t_70 3]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ExNDI0MjYxMzAz_size_16_color_FFFFFF_t_70]: /images/20221022/e0299bbf2ee449a281eee726b177f930.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ExNDI0MjYxMzAz_size_16_color_FFFFFF_t_70 1]: /images/20221022/4dcdae3b74eb4be98b3608dfbfaf09c9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ExNDI0MjYxMzAz_size_16_color_FFFFFF_t_70 2]: /images/20221022/2880a69c227e464e944bbeccd6f0f733.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ExNDI0MjYxMzAz_size_16_color_FFFFFF_t_70 3]: /images/20221022/44cf944fbd9042499b19b64304e62e29.png