Struct SelectBuilder 

pub struct SelectBuilder<'a> { /* private fields */ }

SELECT 查询构建器

Implementations

impl<'a> SelectBuilder<'a>

pub fn new(conn: &'a Connection, table: impl Into<String>) -> Self

创建新的 SELECT 构建器

pub fn columns(self, cols: &[&str]) -> Self

指定要查询的列

pub fn filter( self, condition: &str, params: impl IntoIterator<Item = Param>, ) -> Self

添加 WHERE 条件

pub fn filter_eq(self, column: &str, value: impl Into<Param>) -> Self

添加 WHERE 条件（单参数便捷方法）

pub fn order_by(self, column: &str, desc: bool) -> Self

添加 ORDER BY

pub fn limit(self, limit: usize) -> Self

设置 LIMIT

pub fn offset(self, offset: usize) -> Self

设置 OFFSET

pub fn build(&self) -> (String, Vec<Param>)

构建 SQL 语句

pub fn fetch_all(self) -> Result<Rows, SqliteError>

执行查询，返回所有行

pub fn fetch_one(self) -> Result<Option<Row>, SqliteError>

执行查询，返回第一行

pub fn count(self) -> Result<i64, SqliteError>

执行查询，返回行数