Java连接MySQL数据库 报错
生活随笔
收集整理的這篇文章主要介紹了
Java连接MySQL数据库 报错
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
工具：eclipse、mysql、mysql-connector-java-5.1.43-bin
報錯原因：javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver Class.forName("com.mysql.jdbc.Driver"); <%@ page language="java" import="java.util.*, java.sql.*"contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> </head> <body><%String driverName = "com.mysql.jdbc.Driver"; //驅動程序名String userName = "root"; //數據庫用戶名String userPwd = "lwx"; //密碼String dbName = "rzw"; //數據庫名String url1 = "jdbc:mysql://localhost:3306/" + dbName;String url2 = "?user=" + userName + "&password=" + userPwd;String url3 = "&useUnicode=true&characterEncoding=UTF-8";String url = url1 + url2 + url3; //形成帶數據庫讀寫編碼的數據庫連接字Class.forName(driverName);Connection conn = DriverManager.getConnection(url);String sql = "Insert into stu_info(id,name,sex,age,weight,height) values(?,?,?,?,?,?)";PreparedStatement pstmt = conn.prepareStatement(sql);pstmt.setInt(1, 17);pstmt.setString(2, "張三");pstmt.setString(3, "男");pstmt.setInt(4, 20);pstmt.setFloat(5, 70);pstmt.setFloat(6, 175);int n = pstmt.executeUpdate();if (n == 1) {%>數據庫插入成功！<br><%} else {%>數據庫插入失敗！<br><%}if (pstmt != null) {pstmt.close();}if (conn != null) {conn.close();}%> </body> </html>
原文鏈接：https://blog.csdn.net/qq_40574571/article/details/81129483
總結
以上是生活随笔為你收集整理的Java连接MySQL数据库 报错的全部內容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： Java简易井字棋
- 下一篇： Java MySql 连接数据库