


Detailed explanation of nodejs connection to mysql database and basic knowledge points
This article mainly introduces nodejs to connect to mysql database. It summarizes and analyzes nodejs connection and operation of mysql database in the form of examples, configuration and mysql database query, adding data and other operational skills. Friends in need can refer to the following
The examples in this article describe nodejs connecting to mysql database and basic knowledge points. Share it with everyone for your reference, the details are as follows:
1. Several commonly used global variables
1, __filename
Get the path of the current file
2, __dirname
Get the directory of the current file
3, process.cwd()
Get the directory of the current project
2. Import and export of files
1. Use require
to import files
2. Use module .exports
Export the variables, methods, and objects specified in the file
3.node
The directory structure of the project
demo
package.json The package or module that the current project depends on
router The file that stores the route
views Modules that store views
public Static files
module Writing modules such as databases
app.js Main Entry file
4. Write the routing view separately in the router
filedemo
1. View view file
const express = require("express"); const router = express.Router(); router.get("/", (req, res) => { res.send("hello word"); }); router.get("/article", (req, res) => { res.send("我是文章列表"); }) module.exports = router;
2. Call
'use strict'; const express = require("express"); const app = express(); app.use("/",require("./router/03_router")) app.use("/app",require("./router/03_router1")) app.listen(3000);
in the main file 5. Useejs
template
1. It needs to be installed but does not need to be introduced
npm install ejs --save
2. Configure
//配置模板的文件路径 app.set("views",__dirname+"/views"); //配置模板引擎 app.set("view engine","ejs");
in the main file. 3. Use
①. Template File
<!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <title>Document</title> </head> <body> <h1 id="我是模板渲染的">我是模板渲染的</h1> </body> </html>
②, rendering template in route
'use strict'; const express = require("express"); const router = express.Router(); router.get("/", (req, res) => { //可以直接使用res.render("03_index"); res.render("03_index.ejs"); }); router.get("/article", (req, res) => { res.send("我是文章列表"); }) module.exports = router;
③, main file
'use strict'; const express = require("express"); const app = express(); //配置模板的文件路径 app.set("views",__dirname+"/views"); //配置模板引擎 app.set("view engine","ejs"); app.use("/",require("./router/03_router")) app.use("/app",require("./router/03_router1")) app.listen(3000);
6. About the use of ejs
template files
1. Return data
... let dataset = { name:"张三", age:20, books:['三国演义','西游记','红楼梦','水浒传'] } res.render("03_index.ejs",dataset); ...
2. Ordinary fields
<h2><%= name %></h2> <h2><%= age %></h2>
3. Iterate array
<ul> <% for(let i in books){%> <li><%= books[i] %></li> <%}%> </ul>
## 7. Load static files
1. Configure//设置静态文件的加载(js,css,img) app.use(express.static(__dirname+"/public"));in the main file 2. Use
<link rel="stylesheet" href="./css/bootstrap.css" rel="external nofollow" > <script type="text/javascript" src="./js/jquery-3.1.1.min.js"></script> <img src="/static/imghwm/default1.png" data-src="./img/002.jpg" class="lazy" alt="Detailed explanation of nodejs connection to mysql database and basic knowledge points" > ...in the template
8. Use mysqldatabase
module #db.js
file
'use strict'; const mysql = require("mysql"); /** * 将整个方法全部暴漏出去 * @param sql sql语句 * @param arg 传递到sql语句中的参数,可以不写 * @param callback 回调函数,可以不写 */ module.exports = function (sql,arg,callback) { //1.创建连接(根据自己的数据库配置) let config = mysql.createConnection({ host:"localhost", //数据库的地址 user:"root", //数据库用户名 password:"root", //数据库密码 port:"3306", //mysql数据库的端口号 database:"mybatistest" //使用那个数据库 }); //2.开始连接数据库 config.connect(); //3.对数据库的增删改查操作 config.query(sql,arg,(err,data)=>{ callback && callback(err,data); }) //4.关闭数据库 config.end(); }
2. Use query data in
router view① , import the file
//引入数据库文件 const db = require("./../module/db");
②, use
router.get("/", (req, res) => { db("select * from m_dept",(err,data)=>{ console.log(data); res.render("03_index.ejs",{data:data}); }) });
3 in the view, add Data
①. For the front-end page, see code example
②. Obtain user data parameters through
req.queryrouter.get("/regist",(req, res)=>{ //获取到输入参数,前提是input上要写name console.log(req.query); db("insert into student(name,age) values(?,?)",[req.query.username,req.query.age],(err,data)=>{ console.log(data); if(data){ res.send("成功"); } }) })
9. About the way node returns
jsonIn the front-end and back-end separation development model, the data returned by the backend is generally json, and there is no need to use the ejs template engine
... res.json({ info:"成功", code:1 }); ...
The above is what I compiled for everyone. I hope it will be helpful to everyone in the future.
Related articles:
Ajax technology composition and core principle analysisAjax asynchronous loading analysisAbout the output stream at the end of the servlet in Ajax technologyThe above is the detailed content of Detailed explanation of nodejs connection to mysql database and basic knowledge points. For more information, please follow other related articles on the PHP Chinese website!

JavaScript runs in browsers and Node.js environments and relies on the JavaScript engine to parse and execute code. 1) Generate abstract syntax tree (AST) in the parsing stage; 2) convert AST into bytecode or machine code in the compilation stage; 3) execute the compiled code in the execution stage.

The future trends of Python and JavaScript include: 1. Python will consolidate its position in the fields of scientific computing and AI, 2. JavaScript will promote the development of web technology, 3. Cross-platform development will become a hot topic, and 4. Performance optimization will be the focus. Both will continue to expand application scenarios in their respective fields and make more breakthroughs in performance.

Both Python and JavaScript's choices in development environments are important. 1) Python's development environment includes PyCharm, JupyterNotebook and Anaconda, which are suitable for data science and rapid prototyping. 2) The development environment of JavaScript includes Node.js, VSCode and Webpack, which are suitable for front-end and back-end development. Choosing the right tools according to project needs can improve development efficiency and project success rate.

Yes, the engine core of JavaScript is written in C. 1) The C language provides efficient performance and underlying control, which is suitable for the development of JavaScript engine. 2) Taking the V8 engine as an example, its core is written in C, combining the efficiency and object-oriented characteristics of C. 3) The working principle of the JavaScript engine includes parsing, compiling and execution, and the C language plays a key role in these processes.

JavaScript is at the heart of modern websites because it enhances the interactivity and dynamicity of web pages. 1) It allows to change content without refreshing the page, 2) manipulate web pages through DOMAPI, 3) support complex interactive effects such as animation and drag-and-drop, 4) optimize performance and best practices to improve user experience.

C and JavaScript achieve interoperability through WebAssembly. 1) C code is compiled into WebAssembly module and introduced into JavaScript environment to enhance computing power. 2) In game development, C handles physics engines and graphics rendering, and JavaScript is responsible for game logic and user interface.

JavaScript is widely used in websites, mobile applications, desktop applications and server-side programming. 1) In website development, JavaScript operates DOM together with HTML and CSS to achieve dynamic effects and supports frameworks such as jQuery and React. 2) Through ReactNative and Ionic, JavaScript is used to develop cross-platform mobile applications. 3) The Electron framework enables JavaScript to build desktop applications. 4) Node.js allows JavaScript to run on the server side and supports high concurrent requests.

Python is more suitable for data science and automation, while JavaScript is more suitable for front-end and full-stack development. 1. Python performs well in data science and machine learning, using libraries such as NumPy and Pandas for data processing and modeling. 2. Python is concise and efficient in automation and scripting. 3. JavaScript is indispensable in front-end development and is used to build dynamic web pages and single-page applications. 4. JavaScript plays a role in back-end development through Node.js and supports full-stack development.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

SublimeText3 English version
Recommended: Win version, supports code prompts!

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

SublimeText3 Chinese version
Chinese version, very easy to use

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function
