# Minimal Crud in NodeJS
**Repository Path**: sscarlet/minimal-crud-in-node-js
## Basic Information
- **Project Name**: Minimal Crud in NodeJS
- **Description**: 200行代码,零依赖,实现一个最简单的前后端分离的系统
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No
## Statistics
- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-08-15
- **Last Updated**: 2024-08-15
## Categories & Tags
**Categories**: Uncategorized
**Tags**: None
## README
# Minimal Crud in NodeJS
简体中文 | [English](./README.en.md)
## 概述
仅使用200行代码,不使用任何依赖,实现一个最简单的前后端分离的系统
包含对一个表的查询全部,根据ID查询,分页查询,添加,修改,删除功能
## 运行
项目使用了Node22.5.0新增的node:sqlite库,因此需要保证NodeJS版本>=22.5.0,且需要使用`--experimental-sqlite`CLI 标志启用此
API。
```bash
node --experimental-sqlite .\src\main.mjs
```
运行后会自动在项目根目录下创建`sqlite.db`数据库文件,并创建`user`表。
`user`表包含如下三列
| 列名 | 类型 | 备注 |
| -------- | ------ | -------------- |
| id | Integer| 主键、自增 |
| username | Text | 非空 |
| password | Text | 非空 |
## 使用
+ 单击`Query`按钮,若id输入框内容为空,会查询user表全部数据,以json的形式在下方展示,否则会根据用户的id查询数据
+ 单击`Save`按钮,若id输入框内容为空,会根据用户名输入框和密码输入框的值在表中新增数据,否则会根据id修改数据
+ 单击`Delete`按钮,会根据id删除数据
+ 单击`Pagination Query`按钮,会对user表进行分页查询
![][img]
[img]:data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA6MAAAF2BAMAAABpJFOaAAAAEXRFWHRTb2Z0d2FyZQBTbmlwYXN0ZV0Xzt0AAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAAnUExURf///+/w8HZ2dgMABD6Z6Ml2GnUbAfr6yZzl+PrBbgAXbwFcsTMnJ0eBrgsAABDNSURBVHja7J2/j9vIFcd5NghBnXQAoajz2U1Kw8OCELegCmfhelwEShdtEWi7FFOloALkFluzu06FL3RHFfb9Adcckn8q770ZUb+1uz5bHDHfL7yyRI24M/PhvPdmxJ0X9Pq9AGqVQBRIId8FokAKQRAEQRAEQRAEQd9Wz16eSS++tIbnquDLtnTgi7NdO2f+3NP14oyf+rodUVT8GMZA+rvg+NSBQNo6pL7WCEiBFEiBtM2+tDNVb+NAZ+euEXcD/dZCJUFgVEov3qnr2b2iw12lFvS+UVmXXwaaXpr43Eg707vpKOf+KQOpJj3LCq5Y0Jn1qFJUo+KXadZUBx5HWih11RxSojfq0QNB058JKdWGMdPBMJ2qWF4aepk3gfSVIpDy26Wa9CwxdIAqnHIdqc7FZ6LcUAceRdqZVoFuwm5YpETq7z16oH86pV5MAl0GP/U60yxUWchdVXJv6er8hrczjRnfP3KqjFSTKvFnqnXxnzyMO1PiSc9HvcY68CjS7qjXjCtwSBOuRRbQda8X1Is0JvkIvRPa3jIJvRWYRRNIM/rJpZekUjwQeXy+ysKSu41+ijJorAOPIuXaNIi0y65UK7Zr1GOdWS5IQ7K3zteahF4odmfnR5pLDcjoVl3r8aWGE1MZ6TZ6To6rsQ70FSn1U7KNNEzET3mDlDyoqqSaVE9yAXc3YVlkQHocKY3IXEKLoEbKfak3kMbNTGK4Ghz1ZrLGRtUMxHu+S7qJzr1Gyp6qIaTsrZibDX5qpOw8N5Cys2oGKRnd0R3PV6q1JzUfym466618KSFtqgOPh0eq4tDu/DXqqpyCWiPxJMW6f9tAKu/USDm4NFlDEW8qsXcl1XzP+MKrqjO7CVYRbxU01oHH56W6oWkVzdBH4qnsvDTZNLz8To3UutaG5qUL7p9XlVRTcy1D9qe8yKBkBl0FjXXgcaRdNfpXIzUyqpSlhoyfjvI1UvvOGikhThpZPbrnRa1QJWzLZMlDrG0e0NTFVkqQNtaBX39h8xw1+kqf+/KI98mfAlIgBVIgBVIgBVIgbS3Ss30KSIH0CR2BW7Nbd2s2BEEQ9K313QMmu3e6yA90iu9fPnwO6Hx6Nu+f0h9enC7yTzrFH/v9B88BnRHpAzxenC7yPZ3ih/7D54CAFAJSCEjbjlSr+AGkg6lKTiDlGyPHtuCt/DdcAGmTSE3J/04iLcZ9PT6BdNEfpptIIyBtEulgZn9OIZ1sUTqElKkDqSdIh7EMw2JOXCOV9s3n0X/7g5ttpHNroBMqPIzJDI/3kNKPVktCSufgAsZZcyA9P9KIja5ZClI9N0sTE8Fhsm14Y1twckfISrOQy2AbaVRGyeCWkPI5ogWdzI5bIG0K6YKRyhgkPsXYWs4aaaTUom/G9MaEgOm5HbbbSBNCWFzfyjmiRZTYEwNps0iJw+DGLGnMmvHOJEazraUHstDX5HiLA0iJtLm+lXNEC46YEiBt3PDSYFQxIY1KQbY1LzVJpGggmuXkbkrF9pGW/AdohJTPQUj5DnogbTw8cnTp0GQr4uUiw5gN6zgqb1xUuxcesTEe3Mo5COkSEW+Dk5i5SWbztS9d0qGbLaQ8xxkmMjkd/PU3dqT7vpQuii1fWsKXNrrUoGManNGIo1UZX0W5s9TAIVOxHJJD1RQnHYh4hyl508HMRrwEFBFvwwuCShEusrYyL12K8d1fEByq0Y9LBrU/L7ULgvW8lIpiXtooUvaW2yuCdoBh2f6Ske5ogm9iWoZUl0DatlGK70uBFEiBFAJS6HFIcR9v24S77SEIgtrst9v257T4++CzVewZGoQeQINYvMGqVcEb1day6aE87wG7/++e7Bbsgd3jc61jm+VcGNIi3WzigQ6pkXbVCaSTfH3Ajx4wXN09pLY1dXsLdRhpKFuOJheKVPbfPIi0G2+N0jDe/mC1Si3AfTHKXXFfesBuE7sPutpCqreuS9nEO6+Rco6Yi0T6c3kMqSVWI90pxIlnVkj1aJbLfqz+9EAR82bO+4Yn30aa7SB1AzWUAkV2mUg/pceQ2hY9BunkjnF61QOHXX3nNngc0nJ9TXuLtKg4q4JNNtWZqnepS5bFiae4iVoyuJhSj3LjskBM8lXJkHMuKcWZjUY9Lsp5cXiD6djt9S4jlHqgiVRRITcpdBs4JzY3SOauL52xCU3tIedLumr0Y2ITcWmlFpKWi50KJ0fKNSehoBOVrjTvsewt0k/ctFC5tFhvpJmceKqiWq+RflCqnPLO1vaKJmpXnHqJjjJSl1/rCNIwaQJpOuUmEYpYWvSre14ka6SxPeRGH29nntieYKSSlusI0tRvpJxOLAuJZ8kb8Os0sMmyJDPFGimN0avS5ovoxoErSQ22hbqS5G6FdG14LdJuI+kt+BpLgvdBOOoZvmazLrc05+POsGp3yJpS6gXODkZ1LyQjmKTlqpE6w2skX80qPvIVaeniO87dkTMimyyLG5KtkfKlntuCRGhVsuLWWQcU+oZ0lTWLc7ksZFwmLhHjos4P4g5JwMuFTeL21re+1ObQ2UHKlnqS++1LA0bAe++LQ0ldZiUmU274UsksJrEFtXizZG6zkSnfkNoqSh4EBmSTMtmwIRNk1KbVIb6MjUT4bKNtUyQt1y5SjjfKy0DKHiQJd5CG6TGk4Q7S7qofvEOq1R5Snsdomx/vFFJJy7WPVBJhXADSiiCYGqkzOtToPz2ANHORv0n8M7ySNYu8A1XBIS3XK0W2qkF9aI3UJo7SWUfSch1AGvqPVDxLnQeL+sCunAjqnxN+FW4jFV8qJS06Ts1TOaTGH6SSNYudBI1SvjyzVQ4trr22OXvqQ+RL+XmROHRaloi0JC/TO6M08R4pzyxzTdOwZBXxSrIsaTFN0QrJFLuDdFVy1OvcCNKE8xu5x8pG+I1HvFWgS77uRnmRBpKCOgt+6hENCc5lONpDNuLlmJinpGRwKjtKQ05xyY+CNFv50oX3Ee9nma0p9VnyYH1M3SqozVIkWZPfbCPleWkh81LrQo0U+hC7R17j9WVeyume0xlNXDjfl/hVzrGlSudZravt2XkpT7KvEutCA1v6VcUH+ZGCfZmXckLr3Pt56S9Tmp10VSpRzujeBYmWnpbcWPc7SGdcXtmSKrcJtDhDlX2UjF8+rB4Zm5T9mqpAExeXWZYfJO9XsVo9qlYOMpQ+sOto7Gs5LRcbKvGl9KSyk5jK/9Wj7TXPna9VguNrvE/4FU2s8e42RJ+stFvjfaRWUdVlIDWPQFp/d/ZIuWCiUaTdre9096Vz36/RL0P6F3H+D6obP+k3NPN96SZSk9lv9E9dptXjT+/796WbSDl0eMzVqrMv+g3NIa1TiR+/7tIn2F3P72rYRBq6YOEbqTnDq1V88Q3yUq3rASAF0tYhxd32Z2nQd1/t1/YCyI+RM+9/HeGvSL1B2v9aAlIghYAUAtL/Y6RD/t5zDSfa2E3wfb31rttpkPdDB1L/kRLPYnmI03A3I5A+mC4GSH1EGpWPQRol9gdILwFpMpiqZT9Sb+KoNG9VyTkn5oX6t91e13ySfep5l97B7eCGuRZkgifTN8gz4e8oNWP6X88LRhoPZv3JPCqHsdsEm4/M3S69kztGGnEZvRzGbjdmIPXOl455v3p6FjHSpXAbxoy0Th2zQqoFqeHts/Uc2537HPEO1WiYcKYBGrCcjSBSFqlLHbODlJ6aJZUq5pM5kPo4Snl7+uUkqpHquVb3gnSVDYhxbhhevsWOkZrrW4RHniIVw7tGeh+vDO8GUgmPZhIeSWogHssfkZTAU6TkFCVNTLRGGm34Uos0ogDqbSxIqYxh/zu8WgCpp6NUzyVNTJE4pGm/IHiriHfp/Oh4SFOdCZfi9ImEdDAdA6mnSCkaIqrqzW/OlxaqJJwlz0tloiJIOZIazY366Oalc74UgNQ7pNsLRuVDC/RmfCT9COQh0nrh4PGy2YiB1NtRWqj4iUSdKwVSfw0vvi8FUiAFUujbIsVNn20Tbs2GIAiCIAiCIAiCIAiCIAiCIAiCIAiCIAiCIOjLpBT6oGV6jS4AUghIISCFgBQCUiCFgBQCUghIISAFUuhihWV7CIIgCIKgw3qO2BezGQhIISCFgBQCUiCFLmkOgy7AKIWAFAJSCEghIG15yAumEARBEARBhwLf54efQxcb925MZp5jYtMWpKvpzBZSDNhLtrsWqdqyu89xU34bxuupl9DlIlVA2gKp12xoFZC2yaHyPxheIIWAFAJS6Pch3Q+PMDW93IiXQt7n6vnrTaQcAWOgtnWmCrXKHkMQBP2vvTvMbRuGAShswBciwPvfbZFkJ2nsNDW2LLL6PaBo4HD94TdRlETYAF5OmPOxmGfxOiL6qWrjUMyzeB0RwyhdVrOUjpB384tSeXeI8Y1zk5SeaLiVLfu6p5sxZ9nszbLnWy7VaxulpdXs8mX9voRGmkd7m09b62f9mS+TYtbPUebHiJ3RWL8rMS1sssHfqdL2e15+l7H7TGn97k5pUNqj0pJgczlQa6O1Kc2dp2zX7yjtXem6spyvo3YdpdPLxEtph0rzNpeuSh8Tb96vTaP9mweluiD6KXlLkVur3GiF76WOvVypl3cr3ihBpeYteTlqvGWNzQecI4EDAPAbJ8B/1NVw9G/ifVVqHIo5Gg9K8f68mwfzbsq7o20g8HkWpUnpiZxFXjsVprZzO8fcOhy2z3D4aTw+SS7HZctpTDmOibXDYe/g7Gg8/n+JtHYxTG2fNuavB21/G4+PKC2dCpfkWX8uifSl0iPx+IjSuPY0lCwaL5Ueicdn5tI57job7hVtyqOfxeOjozRbGZsZ7bkN07XDYfMMhx/H47OJ973x+O/r0nxvPAAAQ86fSpzxnLoFlIJSUApKQenYWMUYpaAUlOKvlTokG06pkTqU0aDUOgYAAOxUSFAcgVJQCkpBKaU4yxrGLTBKQSkoBaWgdPCSl1MAAIC9wvfg2yXQfd178FUEOIXSdTnzRW/Se+K825Q+vGnCUc0I4/WLakqHUZqUDkCZNrdvmqD01BPq3qhUHo2m1CAdTqlBOppSg3QApbmpeD3L4bwVb8bmTRNZ3qfm1gy6UsVQ+RgAALycMOdjMXvxuiH6qmrjUMxevG4ISiHvAvgBNnzPNJ2WLfvS1TCXNwWXzd4se77lUt46BfNpvDvY4Xy6vNO7vs87yglMe7t3lDe3P329+y0enSqd7l7R3jpBv1d6i0eXSkuCXQ/U2uhrSjPzZTy6VLquLufrKFxH6et4dKg0b3PjqvQx8ebzeAVxfyVvKXJrlRutkJ0uH6LVvjsV72N8u+Y2Dvffwi0YL3kDAPBbJ8F/cLp25G/h/ZVqHIr5Lt5R+HmVzu1ZDm3N2jYGy7qV0pPk3dzk3XKetu4eTXMsG4Mh7554E2HeKjU+z6c0t0rbB0o7dBbZkmnb4K07uzEvHQvbZzislm9nNiUkktSOyHaUtibTcrwSa8dCPEm8dVwuJVHUsxkTaU8l0sOcGPPXg7ZdpYvWW3FEaWdKSxfDujC5JN7XSqN9uCxggtIulca1R6Fk3Xip9PZd3KpfdDWXznHXqXCvNJ9WvDelGst6G6XZyt6SQ8tPlbV0LDw+w6EazZyuPb5ZAqf2iDP0k3gx2LpUKxgAAMfnTyXReE7dAkpBKSgFpaB0bKxijFJQCkpBKSgd2qiCFwAAoJLaAa1eQCkoBaWglFJQCkpBKSilFJSiF2zbAwAAAAAAAAAAAAAAAMAv5w+R+qvzgNLM7QAAAABJRU5ErkJggg==