How to connect to access database using javascript_javascript skills
I just saw a program written by a friend that uses javascript to connect to an excel database. I wanted to change it to an access database, so I found these two articles
———————————————————————— ----------------------------
I have spent a lot of effort in the past few days to find ways to connect javascript to the access database on the Internet,
After sorting and summarizing, I finally wrote a piece of code that can be effectively executed.
But this code can run normally locally, but once it is placed on a free personal space, it cannot be executed. The main reason is that the operation permissions are insufficient, because most free spaces that only support static pages
has made very strict restrictions, so whether it is using mdb or reading and writing plain text files,
cannot pass, and a js error will be reported by the page. Some free spaces abroad directly prohibit the uploading of files with extensions like mdb
.
Although there is no hope of making your own counter or message board on the free space of purely static pages,
this program may still be useful to some friends, so I wrote it for you to study.
File composition:
The Access database is named MyData.Mdb, and a table named count is built in it. The table consists of two
fields: ID and COUNT, and there is a piece of data in the table: ('count','100').
The text file is called count.txt, and any number is written in it.
The static page is named Cnt.htm.
The above 3 files are placed in the same directory.
Since the Access database is used, and it uses non-standard SQL syntax, please pay attention to the need to add square brackets to the table name
and field name: []
The following is from the page Code:
The getCountFromDB method operates on the Access database, and the getCountFromTxt
method operates on txt plain text. Both methods are executed locally.
Postscript: Although only The free space for static pages is not available, but I think some free space that supports
Asp should be available. Of course, I have not tried it specifically, I am just imagining it.
And using this method to read and write databases is only suitable for work such as counters and message boards that do not require
confidentiality. After all, the code is all written in javascript and anyone can see it.
Then you can get the path to download the db file for analysis, so you can’t use it to
save things you don’t want others to know.
As one of my colleagues said, using javascript to connect to the database for operations is simply a step forward. Haha, it is true. Since you cannot use free space to make your own counter, Then this code can only be used for fun and to find a good feeling for yourself.
-------------------------------------------------
Many friends online feel that when they are solving certain problems, I am very confused, and many people find it difficult to understand how to use JavaScript to connect to the database. They even conclude that JavaScript can only be executed by the client and cannot connect to the database. And I searched it and found that the introduction on CSDN is too general for beginners. I can't understand it at all. I didn't search other forums. In this situation, I decided to take a good look at MSDN. After looking at VC's examples of connecting to the database, I summarized the method of connecting to the database using JAVASCRIPT. I now publish it to everyone

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

Frequently Asked Questions and Solutions for Front-end Thermal Paper Ticket Printing In Front-end Development, Ticket Printing is a common requirement. However, many developers are implementing...

JavaScript is the cornerstone of modern web development, and its main functions include event-driven programming, dynamic content generation and asynchronous programming. 1) Event-driven programming allows web pages to change dynamically according to user operations. 2) Dynamic content generation allows page content to be adjusted according to conditions. 3) Asynchronous programming ensures that the user interface is not blocked. JavaScript is widely used in web interaction, single-page application and server-side development, greatly improving the flexibility of user experience and cross-platform development.

There is no absolute salary for Python and JavaScript developers, depending on skills and industry needs. 1. Python may be paid more in data science and machine learning. 2. JavaScript has great demand in front-end and full-stack development, and its salary is also considerable. 3. Influencing factors include experience, geographical location, company size and specific skills.

Learning JavaScript is not difficult, but it is challenging. 1) Understand basic concepts such as variables, data types, functions, etc. 2) Master asynchronous programming and implement it through event loops. 3) Use DOM operations and Promise to handle asynchronous requests. 4) Avoid common mistakes and use debugging techniques. 5) Optimize performance and follow best practices.

Discussion on the realization of parallax scrolling and element animation effects in this article will explore how to achieve similar to Shiseido official website (https://www.shiseido.co.jp/sb/wonderland/)...

How to merge array elements with the same ID into one object in JavaScript? When processing data, we often encounter the need to have the same ID...

The latest trends in JavaScript include the rise of TypeScript, the popularity of modern frameworks and libraries, and the application of WebAssembly. Future prospects cover more powerful type systems, the development of server-side JavaScript, the expansion of artificial intelligence and machine learning, and the potential of IoT and edge computing.

In-depth discussion of the root causes of the difference in console.log output. This article will analyze the differences in the output results of console.log function in a piece of code and explain the reasons behind it. �...
