MySQL是一种广泛使用的关系型数据库管理系统(RDBMS),而Java是一种流行的编程语言,两者结合使用在许多应用中都非常常见。MySQL的Java源码通常指的是用于连接、操作和管理MySQL数据库的Java库或驱动程序。
示例代码(连接MySQL数据库):
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class MySQLConnectionExample {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/mydatabase";
String user = "username";
String password = "password";
try (Connection conn = DriverManager.getConnection(url, user, password)) {
System.out.println("Connected to MySQL database!");
} catch (SQLException e) {
System.err.println("Failed to connect to MySQL database: " + e.getMessage());
}
}
}
示例代码(使用PreparedStatement防止SQL注入):
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class PreparedStatementExample {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/mydatabase";
String user = "username";
String password = "password";
try (Connection conn = DriverManager.getConnection(url, user, password)) {
String sql = "SELECT * FROM users WHERE username = ? AND password = ?";
try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
pstmt.setString(1, "admin");
pstmt.setString(2, "password");
pstmt.executeQuery();
}
} catch (SQLException e) {
System.err.println("Failed to execute SQL query: " + e.getMessage());
}
}
}
请注意,以上代码示例和参考链接仅供参考,实际使用时可能需要根据具体情况进行调整。