从SqliteException获取违规SQL的行号

import java.util.regex.Matcher;
import java.util.regex.Pattern;
import java.sql.*;

public class SqliteExceptionExample {
    public static void main(String[] args) {
        try {
            // 连接SQLite数据库
            Connection connection = DriverManager.getConnection("jdbc:sqlite:/path/to/database.db");
            
            // 执行有错误的SQL语句
            Statement statement = connection.createStatement();
            statement.execute("INSERT INTO table_name (column1, column2) VALUES (value1, value2)");
            
            // 关闭连接
            connection.close();
        } catch (SQLException e) {
            // 捕获SqliteException异常
            if (e instanceof SQLiteException) {
                String errorMessage = e.getMessage();
                
                // 使用正则表达式提取行号
                Pattern pattern = Pattern.compile("near line (\\d+)");
                Matcher matcher = pattern.matcher(errorMessage);
                if (matcher.find()) {
                    String lineNumber = matcher.group(1);
                    System.out.println("违规SQL的行号：" + lineNumber);
                }
            }
        }
    }
}