Web Front-end
Front-end Q&A
How to combine Node.js and SQL with page layering to achieve dynamic website development
How to combine Node.js and SQL with page layering to achieve dynamic website development
Node.js is JavaScript that runs on the server side.
SQL is a structured query language used to manage relational databases. These two technologies are combined to enable the development of dynamic websites.
When developing a dynamic website, we need to establish a connection with the database and execute SQL statements to read and write data. In Node.js, many modules can be used to help us connect to the database, the most popular is the mysql module.
Page layering refers to dividing the front-end HTML, CSS and JavaScript code into multiple levels, with each level having different code responsibilities. The advantage of this is that the code can be better organized and the code maintainability can be improved.
Let’s introduce how to combine Node.js and SQL with page layering to develop dynamic websites.
1. Project structure
In order to better organize the code, we need to divide the code into multiple levels. The following is the directory structure of the project:
myapp/ ├── app.js ├── package.json ├── node_modules/ ├── public/ │ ├── css/ │ │ └── style.css │ ├── js/ │ │ ├── main.js │ │ └── jquery.min.js │ └── img/ │ └── logo.png └── views/ ├── index.html ├── header.html ├── footer.html └── error.html
-
app.js: The entry file of the project. -
package.json: Project configuration file. -
node_modules/: Stores the modules required for the project. -
public/: Store static files, such as CSS, JavaScript, and images. -
views/: Stores HTML template files.
2. Database connection
In app.js, we need to connect to the database. The code to use the mysql module to connect to the MySQL database is as follows:
const mysql = require('mysql');
// 创建连接
const connection = mysql.createConnection({
host: 'localhost', // 数据库主机地址
user: 'root', // 数据库用户名
password: '123456', // 数据库密码
database: 'myapp' // 数据库名称
});
// 连接数据库
connection.connect((err) => {
if (err) {
console.error('连接数据库失败：', err);
return;
}
console.log('连接数据库成功');
});
// 关闭连接
connection.end((err) => {
if (err) {
console.error('关闭连接失败：', err);
return;
}
console.log('关闭连接成功');
});3. Database operation
After connecting to the database, we can execute SQL statements to read and write data. The following is a simple example to insert a piece of data into the database:
const sql = 'INSERT INTO users SET ?';
const data = { username: 'test', password: '123456' };
connection.query(sql, data, (err, results, fields) => {
if (err) {
console.error('插入数据失败：', err);
return;
}
console.log('插入数据成功');
});The query method is used here to execute SQL statements. The first parameter is the SQL statement, and the second parameter is the data to be inserted, expressed in the form of an object.
4. Page layering
In the views directory, we store the HTML template files of the website. These template files are rendered into final HTML pages by the template engine.
We use the ejs template engine to render HTML templates. Here is a simple example:
<!-- index.html --> <!DOCTYPE html> <html> <head> <title>Node.js 实现 SQL 和页面分层</title> <link rel="stylesheet" href="/css/style.css"> </head> <body> <% include header.html %> <div class="container"> <h1>欢迎来到我的网站！</h1> <p><%= message %></p> </div> <% include footer.html %> <script src="/js/jquery.min.js"></script> <script src="/js/main.js"></script> </body> </html>
As you can see, use <% %> and <%= %> in HTML to insert JavaScript code. The include directive is used to introduce other HTML template files.
In Node.js, use the ejs module to render HTML templates. The following is an example:
const ejs = require('ejs');
const fs = require('fs');
const template = fs.readFileSync('views/index.html', 'utf8');
const data = { message: '欢迎访问我的网站！' };
const html = ejs.render(template, data);
console.log(html);This code reads the views/index.html template file and uses the object { message: 'Welcome to my website! ' } to render the template and finally generate the final HTML page.
5. Summary
Through the above introduction, we have learned how to use Node.js and SQL combined with page layering to develop dynamic websites. In actual projects, there are more technologies and tools that can be used, such as ORM framework, Webpack, Gulp, etc., which can greatly improve development efficiency and code quality.
The above is the detailed content of How to combine Node.js and SQL with page layering to achieve dynamic website development. For more information, please follow other related articles on the PHP Chinese website!
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
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1663
14
1420
52
1313
25
1266
29
1238
24
React's Role in HTML: Enhancing User Experience
Apr 09, 2025 am 12:11 AM
React combines JSX and HTML to improve user experience. 1) JSX embeds HTML to make development more intuitive. 2) The virtual DOM mechanism optimizes performance and reduces DOM operations. 3) Component-based management UI to improve maintainability. 4) State management and event processing enhance interactivity.
Frontend Development with React: Advantages and Techniques
Apr 17, 2025 am 12:25 AM
The advantages of React are its flexibility and efficiency, which are reflected in: 1) Component-based design improves code reusability; 2) Virtual DOM technology optimizes performance, especially when handling large amounts of data updates; 3) The rich ecosystem provides a large number of third-party libraries and tools. By understanding how React works and uses examples, you can master its core concepts and best practices to build an efficient, maintainable user interface.
React and the Frontend: Building Interactive Experiences
Apr 11, 2025 am 12:02 AM
React is the preferred tool for building interactive front-end experiences. 1) React simplifies UI development through componentization and virtual DOM. 2) Components are divided into function components and class components. Function components are simpler and class components provide more life cycle methods. 3) The working principle of React relies on virtual DOM and reconciliation algorithm to improve performance. 4) State management uses useState or this.state, and life cycle methods such as componentDidMount are used for specific logic. 5) Basic usage includes creating components and managing state, and advanced usage involves custom hooks and performance optimization. 6) Common errors include improper status updates and performance issues, debugging skills include using ReactDevTools and Excellent
React Components: Creating Reusable Elements in HTML
Apr 08, 2025 pm 05:53 PM
React components can be defined by functions or classes, encapsulating UI logic and accepting input data through props. 1) Define components: Use functions or classes to return React elements. 2) Rendering component: React calls render method or executes function component. 3) Multiplexing components: pass data through props to build a complex UI. The lifecycle approach of components allows logic to be executed at different stages, improving development efficiency and code maintainability.
React's Ecosystem: Libraries, Tools, and Best Practices
Apr 18, 2025 am 12:23 AM
The React ecosystem includes state management libraries (such as Redux), routing libraries (such as ReactRouter), UI component libraries (such as Material-UI), testing tools (such as Jest), and building tools (such as Webpack). These tools work together to help developers develop and maintain applications efficiently, improve code quality and development efficiency.
React vs. Backend Frameworks: A Comparison
Apr 13, 2025 am 12:06 AM
React is a front-end framework for building user interfaces; a back-end framework is used to build server-side applications. React provides componentized and efficient UI updates, and the backend framework provides a complete backend service solution. When choosing a technology stack, project requirements, team skills, and scalability should be considered.
The Future of React: Trends and Innovations in Web Development
Apr 19, 2025 am 12:22 AM
React's future will focus on the ultimate in component development, performance optimization and deep integration with other technology stacks. 1) React will further simplify the creation and management of components and promote the ultimate in component development. 2) Performance optimization will become the focus, especially in large applications. 3) React will be deeply integrated with technologies such as GraphQL and TypeScript to improve the development experience.
React: The Power of a JavaScript Library for Web Development
Apr 18, 2025 am 12:25 AM
React is a JavaScript library developed by Meta for building user interfaces, with its core being component development and virtual DOM technology. 1. Component and state management: React manages state through components (functions or classes) and Hooks (such as useState), improving code reusability and maintenance. 2. Virtual DOM and performance optimization: Through virtual DOM, React efficiently updates the real DOM to improve performance. 3. Life cycle and Hooks: Hooks (such as useEffect) allow function components to manage life cycles and perform side-effect operations. 4. Usage example: From basic HelloWorld components to advanced global state management (useContext and
