### Java 和 OpenCV 实现图像中编号识别并存储至数据库 #### 图像预处理 为了提高字符识别的准确性，通常需要对输入图像进行一系列预处理操作。这包括灰度化、二值化以及噪声去除等步骤[^3]。 ```java import org.opencv.core.Core; import org.opencv.core.Mat; import org.opencv.imgproc.Imgproc; public class Preprocessor { public static Mat preprocessImage(Mat input) { // Convert to grayscale Mat gray = new Mat(); Imgproc.cvtColor(input, gray, Imgproc.COLOR_BGR2GRAY); // Apply binary thresholding Mat binary = new Mat(); Imgproc.threshold(gray, binary, 0, 255, Imgproc.THRESH_BINARY | Imgproc.THRESH_OTSU); return binary; } } ``` #### 字符分割与定位 通过形态学变换和轮廓检测来分离单个字符区域，并将其转换成适合OCR引擎处理的形式。对于编号这类结构化的文本，可以通过查找连通域的方式获取候选区[^4]。 ```java List<Mat> extractNumbers(Mat processedImage) { List<MatOfPoint> contours = new ArrayList<>(); Mat hierarchy = new Mat(); // Find contours of the characters Imgproc.findContours(processedImage, contours, hierarchy, Imgproc.RETR_EXTERNAL, Imgproc.CHAIN_APPROX_SIMPLE); List<Mat> numbers = new ArrayList<>(); for (var contour : contours) { Rect boundingBox = Imgproc.boundingRect(contour); if (isValidNumberRegion(boundingBox)) { // Define criteria based on size and aspect ratio Mat numberROI = processedImage.submat(boundingBox); numbers.add(numberROI); } } return numbers; } ``` #### OCR文字识别 利用Tesseract或其他第三方库完成最终的文字解析工作。考虑到性能因素，建议预先训练针对特定字体风格的小规模数据集以提升精度[^1]。 ```xml <!-- Add Tesseract dependency --> <dependency> <groupId>net.sourceforge.tess4j</groupId> <artifactId>tess4j</artifactId> <version>5.4.0</version> </dependency> ``` ```java String recognizeText(List<Mat> images) throws Exception { ITesseract ocrEngine = new Tesseract(); StringBuilder resultBuilder = new StringBuilder(); for (var img : images) { BufferedImage bufferedImage = matToBufferedImage(img); // Conversion helper method required here String recognizedText = ocrEngine.doOCR(bufferedImage).trim(); if (!recognizedText.isEmpty()) { resultBuilder.append(recognizedText).append(","); } } return resultBuilder.toString().replaceAll(",$", ""); } ``` #### 数据持久化 一旦成功提取到了所需的信息，则可通过JDBC API将它们写入关系型数据库表内。这里假设已经建立了相应的连接池配置[^2]。 ```sql INSERT INTO NumberRecords (image_id, detected_number) VALUES (?, ?); ``` ```java void saveResults(String imageID, String detectedNumbers) { try (Connection conn = dataSource.getConnection(); PreparedStatement pstmt = conn.prepareStatement( "INSERT INTO NumberRecords (image_id, detected_number)" + " VALUES (?, ?)" )) { pstmt.setString(1, imageID); pstmt.setString(2, detectedNumbers); pstmt.executeUpdate(); } catch (SQLException e) { logger.error("Failed saving results.", e); } } ```