The operation is under the environment of ubuntu system, and the process will be simply recorded.
First use apt-get to install the database, type the command sudo apt-get install mysql-server, press Enter all the way, and then set the database root password on an interface
We need to create something in the database. Type mysql -uroot -p××××× to enter the sql console.
1. First create a data set create database databasename;
2.use database databasename ；
3. Create a table (create a very simple one here, only auto-increment id, username and password)
create table user_info ( id int(11) not null auto_increment, username varchar(30) not null, password varchar(30) not null, primary key ( id ) )ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
4. Insert a piece of data insert into user_info values(1,'mtjss2','123456') ;
The following is the part of node
Create a folder, such as myapp, and after npm init, the dependency folder of node_modules will be included
Use npm install --save to install the following dependencies
1.express
2.mysql
3.body-parser (used to parse post parameters)
Since Express does not seem to have its own database package, you usually create a new models folder and then write the logic of the database. If you just want a simple test, you can write it directly in app.js
For example, here is a logical encapsulation class of user.js under models. Currently, there is only one method to obtain user information through username. Others can be added later
var mysql = require('mysql') ;
//connection config
var connection = mysql.createConnection({
host : 'localhost' ,
user : 'root' ,
password : '123456' ,
database : 'my_box'
});
function User(user){
this.username = user.username ;
this.password = user.password ;
}
User.getUserbyUsername = function(username,callback){
var selectSql = 'select * from user_info where username = ?' ;
connection.query(selectSql,[username],function(err,res){
¦ if(err){
¦ ¦ console.log('getUserbyUsername err:' + err) ;
¦ ¦ return ;
¦ }
¦ console.log('Get name success') ;
¦ callback(err,res) ;
}) ;
} ;
module.exports = User ;
Post again app.js does not write routing for the time being, it is the processing of / and /reg methods
var mysql = require('mysql') ;
//connection config
var connection = mysql.createConnection({
host : 'localhost' ,
user : 'root' ,
password : '123456' ,
database : 'my_box'
});
function User(user){
this.username = user.username ;
this.password = user.password ;
}
User.getUserbyUsername = function(username,callback){
var selectSql = 'select * from user_info where username = ?' ;
connection.query(selectSql,[username],function(err,res){
¦ if(err){
¦ ¦ console.log('getUserbyUsername err:' + err) ;
¦ ¦ return ;
¦ }
¦ console.log('Get name success') ;
¦ callback(err,res) ;
}) ;
} ;
module.exports = User ;
The main page index.html is under the views folder. There is no code, but I will post it here
<!DOCTYPE html>
<html>
<head>
<title>my box</title>
</head>
<body>
<form action="/reg" method="post">
<input type="text" name="username"/>
<input type="submit" value="submit"/>
</form>
</body>
</html>
After starting with node app.js, just access localhost:3000 in the browser. Enter the user name in the database in the input to get the data.
ps: What are the advantages and disadvantages of using Node.js?
Node.js advantages: 1. It uses event-driven, asynchronous programming and is designed for network services. In fact, Javascript's anonymous functions and closure features are very suitable for event-driven and asynchronous programming. Moreover, JavaScript is easy to learn, and many front-end designers can quickly start doing back-end design. 2. Node.js' non-blocking mode IO processing brings Node.js high performance and outstanding load capacity with relatively low system resource consumption, making it very suitable for use as a middle-tier service that relies on other IO resources. 3. Node.js is lightweight and efficient, and can be considered a perfect solution for real-time application systems in data-intensive distributed deployment environments. Node is great for situations where you anticipate there may be high traffic before responding to the client, but the required server-side logic and processing isn't necessarily a lot.
Node.js Disadvantages: 1. Low reliability 2. Single process, single thread, only supports single-core CPU, and cannot fully utilize multi-core CPU servers. Once this process crashes, the entire web service crashes.
Replace String Characters in JavaScriptMar 11, 2025 am 12:07 AMDetailed explanation of JavaScript string replacement method and FAQ This article will explore two ways to replace string characters in JavaScript: internal JavaScript code and internal HTML for web pages. Replace string inside JavaScript code The most direct way is to use the replace() method: str = str.replace("find","replace"); This method replaces only the first match. To replace all matches, use a regular expression and add the global flag g: str = str.replace(/fi
8 Stunning jQuery Page Layout PluginsMar 06, 2025 am 12:48 AMLeverage jQuery for Effortless Web Page Layouts: 8 Essential Plugins jQuery simplifies web page layout significantly. This article highlights eight powerful jQuery plugins that streamline the process, particularly useful for manual website creation
Build Your Own AJAX Web ApplicationsMar 09, 2025 am 12:11 AMSo here you are, ready to learn all about this thing called AJAX. But, what exactly is it? The term AJAX refers to a loose grouping of technologies that are used to create dynamic, interactive web content. The term AJAX, originally coined by Jesse J
10 Mobile Cheat Sheets for Mobile DevelopmentMar 05, 2025 am 12:43 AMThis post compiles helpful cheat sheets, reference guides, quick recipes, and code snippets for Android, Blackberry, and iPhone app development. No developer should be without them! Touch Gesture Reference Guide (PDF) A valuable resource for desig
Improve Your jQuery Knowledge with the Source ViewerMar 05, 2025 am 12:54 AMjQuery is a great JavaScript framework. However, as with any library, sometimes it’s necessary to get under the hood to discover what’s going on. Perhaps it’s because you’re tracing a bug or are just curious about how jQuery achieves a particular UI
10 jQuery Fun and Games PluginsMar 08, 2025 am 12:42 AM10 fun jQuery game plugins to make your website more attractive and enhance user stickiness! While Flash is still the best software for developing casual web games, jQuery can also create surprising effects, and while not comparable to pure action Flash games, in some cases you can also have unexpected fun in your browser. jQuery tic toe game The "Hello world" of game programming now has a jQuery version. Source code jQuery Crazy Word Composition Game This is a fill-in-the-blank game, and it can produce some weird results due to not knowing the context of the word. Source code jQuery mine sweeping game
How do I create and publish my own JavaScript libraries?Mar 18, 2025 pm 03:12 PMArticle discusses creating, publishing, and maintaining JavaScript libraries, focusing on planning, development, testing, documentation, and promotion strategies.
jQuery Parallax Tutorial - Animated Header BackgroundMar 08, 2025 am 12:39 AMThis tutorial demonstrates how to create a captivating parallax background effect using jQuery. We'll build a header banner with layered images that create a stunning visual depth. The updated plugin works with jQuery 1.6.4 and later. Download the
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
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software
SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.
WebStorm Mac version
Useful JavaScript development tools
SublimeText3 Linux new version
SublimeText3 Linux latest version
