cmakelist如何增加sqlite3，可不可以给个模板

现在总是报错

/usr/bin/ld: libMPI_DES_DLL.so: undefined reference to sqlite3_bind_int' /usr/bin/ld: libMPI_DES_DLL.so: undefined reference tosqlite3_column_double'
/usr/bin/ld: libMPI_DES_DLL.so: undefined reference to sqlite3_bind_double' /usr/bin/ld: libMPI_DES_DLL.so: undefined reference tosqlite3_step'
/usr/bin/ld: libMPI_DES_DLL.so: undefined reference to sqlite3_open' /usr/bin/ld: libMPI_DES_DLL.so: undefined reference tosqlite3_reset'
/usr/bin/ld: libMPI_DES_DLL.so: undefined reference to sqlite3_column_int' /usr/bin/ld: libMPI_DES_DLL.so: undefined reference tosqlite3_prepare_v2'
/usr/bin/ld: libMPI_DES_DLL.so: undefined reference to sqlite3_finalize' /usr/bin/ld: libMPI_DES_DLL.so: undefined reference tosqlite3_bind_text'
/usr/bin/ld: libMPI_DES_DLL.so: undefined reference to sqlite3_bind_int64' /usr/bin/ld: libMPI_DES_DLL.so: undefined reference tosqlite3_close_v2'
/usr/bin/ld: libMPI_DES_DLL.so: undefined reference to `sqlite3_errmsg'

自己解决了
find_package(MPI REQUIRED)
find_package(Threads REQUIRED)
find_package(SQLite3 REQUIRED)
set(THREADS_PREFER_PTHREAD_FLAG ON)

target_link_libraries(yourapp PUBLIC Threads::Threads)
target_link_libraries(yourapp PUBLIC ${MPI_C_LIBRARIES})
target_link_libraries(yourapp PUBLIC sqlite3)
target_link_libraries(yourapp PUBLIC dl)
target_link_libraries(yourapp PUBLIC pthread)