如何在查询中插入p参数的id号？

String query = "SELECT * FROM my_table WHERE id = ?";
try (PreparedStatement pstmt = connection.prepareStatement(query)) {
    pstmt.setInt(1, 123); // 假设要插入的id值为123
    ResultSet rs = pstmt.executeQuery();
    // 处理结果集
} catch (SQLException e) {
    e.printStackTrace();
}

import sqlite3

conn = sqlite3.connect('my_database.db')
cursor = conn.cursor()
query = "SELECT * FROM my_table WHERE id = ?"
cursor.execute(query, (123,))  # 假设要插入的id值为123
results = cursor.fetchall()
# 处理结果

<select id="selectById" resultType="MyType">
    SELECT * FROM my_table WHERE id = #{id}
</select>

int id = 123;
List<MyType> results = sqlSession.selectList("selectById", id);
// 处理结果

int id = 123;
var results = from item in myTable
              where item.Id == id
              select item;
// 处理结果