欢迎来到尧图网

客户服务 关于我们

您的位置:首页 > 教育 > 幼教 > fastify 连接 mysql

fastify 连接 mysql

2025/9/23 15:53:05 来源:https://blog.csdn.net/weixin_64684095/article/details/143931700  浏览:    关键词:fastify 连接 mysql

一、安装依赖

安装 @fastify/mysql

pnpm add @fastify/mysql

二、示例

1. 创建 index.js

连接数据库,确保已经启动数据库,输入数据库的账号,密码,域名,端口,库名。

import Fastify from "fastify";import routes from "./routes.js";import fastifyMysql from "@fastify/mysql";const fastify = Fastify({logger: true,});/** 连接数据库 */fastify.register(fastifyMysql, {host: "127.0.0.1",port: 3307,user: "root",password: "111111",database: "twogod",charset: "utf8mb4",promise: true,});/** 接受所有媒体类型 */fastify.addContentTypeParser("*", function (request, payload, done) {var data = "";payload.on("data", (chunk) => {data += chunk;});payload.on("end", () => {done(null, data);});});/** 注册接口 */fastify.register(routes);/** 启动服务 */const start = async () => {try {await fastify.listen({ port: 3000 });console.log("webserver is runing");} catch (err) {console.log(err);}};start();

2. 创建 routes.js

async function routes(fastify, options) {/** 登录 */fastify.post("/login", async (req, res, done) => {const { username, password } = req.body;try {const result = await fastify.mysql.query("SELECT * FROM sys_admins WHERE username=? AND PASSWORD=?",[username, password]);if (result[0].length > 0) {return {code: 200,msg: "success",data: result[0][0],};} else {return {code: 500,msg: "账号或密码错误!",data: null,};}} catch (err) {return {code: 500,msg: "error",data: err,};}});}export default routes;

版权声明:

本网仅为发布的内容提供存储空间,不对发表、转载的内容提供任何形式的保证。凡本网注明“来源:XXX网络”的作品,均转载自其它媒体,著作权归作者所有,商业转载请联系作者获得授权,非商业转载请注明出处。

我们尊重并感谢每一位作者,均已注明文章来源和作者。如因作品内容、版权或其它问题,请及时与我们联系,联系邮箱:809451989@qq.com,投稿邮箱:809451989@qq.com

热搜词