search
HomeWeb Front-endJS TutorialHow 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.


Copy code The code is as follows:



New Document < ;/TITLE> <br><meta name="Generator" content="EditPlus"> <br><meta name="Author" content=""> <br><meta name="Keywords" content=""> <br><meta name="Description" content=""> <br><script language="JavaScript"> <BR><!-- <BR>function getCountFromDB( ) { <BR> //Based on the current page file, find the absolute path where the file is located. <BR> var filePath = location.href.substring(0, location.href.indexOf("Cnt.htm")); <BR> var path = filePath "MyData.mdb"; <BR> //Remove the string The first 8 characters of "files://". <BR> path = path.substring(8); <BR> var updateCnt = 0; <br><br> //Generate sql statements for query and update. <BR> var sqlSelCnt = "Select COUNT FROM [COUNT] Where ID = 'count'"; <BR> var sqlUpdCnt = "Update [COUNT] SET [COUNT] = '"; <br><br> //Establish a connection , and generate the relevant string www.knowsky.com. <BR> var con = new ActiveXObject("ADODB.Connection"); <BR> con.Provider = "Microsoft.Jet.OLEDB.4.0"; <BR> con.ConnectionString = "Data Source=" path; <br> <br> con.open; <BR> var rs = new ActiveXObject("ADODB.Recordset"); <BR> rs.open(sqlSelCnt, con); <BR> while (!rs.eof) { <BR> var cnt = rs.Fields("COUNT"); <BR> document.write(cnt); <BR> //Add 1 to the result and update the database. <BR> updateCnt = cnt * 1 1; <BR> rs.moveNext; <BR> } <BR> rs.close(); <BR> rs = null; <br><br> sqlUpd Cnt = sqlUpdCnt updateCnt "'" ; <BR> con.execute(sqlUpdCnt); <br><br> con.close(); <BR> con = null; <BR>} <br><br>function getCountFromTxt() { <BR> var filePath = location.href.substring(0, location.href.indexOf("Cnt.htm")); <BR> var path = filePath "count.txt"; <BR> path = path.substring(8); <BR> var nextCnt = 0; <br><br> var fso, f1, ts, s; <BR> //Open the text file in read-only mode. <BR> var ForReading = 1; <BR> //Open the text file in reading and writing mode.<BR> var ForWriting = 2; <br><br> fso = new ActiveXObject("Scripting.FileSystemObject"); <BR> f1 = fso.GetFile(path); <BR> ts = f1.OpenAsTextStream(ForReading, true ); <BR> s = ts.ReadLine(); <BR> nextCnt = eval(s) 1; <BR> document.write("now count is:" s); <BR> ts.Close(); <br><br> ts = f1.OpenAsTextStream(ForWriting, true); <BR> ts.WriteLine(nextCnt); <BR> ts.close(); <BR>} <BR>//--> <BR></script> <br> <br><br>




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



// ^_^

//

//(c) in 2002-2003 by Alex(Chinese: Jiang Jianhua)

//http://www.finder.net.cn

//C Email : jiangjh@finder.net.cn

//F Email: jjh_115@eyou.com






Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
JavaScript Engines: Comparing ImplementationsJavaScript Engines: Comparing ImplementationsApr 13, 2025 am 12:05 AM

Different JavaScript engines have different effects when parsing and executing JavaScript code, because the implementation principles and optimization strategies of each engine differ. 1. Lexical analysis: convert source code into lexical unit. 2. Grammar analysis: Generate an abstract syntax tree. 3. Optimization and compilation: Generate machine code through the JIT compiler. 4. Execute: Run the machine code. V8 engine optimizes through instant compilation and hidden class, SpiderMonkey uses a type inference system, resulting in different performance performance on the same code.

Beyond the Browser: JavaScript in the Real WorldBeyond the Browser: JavaScript in the Real WorldApr 12, 2025 am 12:06 AM

JavaScript's applications in the real world include server-side programming, mobile application development and Internet of Things control: 1. Server-side programming is realized through Node.js, suitable for high concurrent request processing. 2. Mobile application development is carried out through ReactNative and supports cross-platform deployment. 3. Used for IoT device control through Johnny-Five library, suitable for hardware interaction.

Building a Multi-Tenant SaaS Application with Next.js (Backend Integration)Building a Multi-Tenant SaaS Application with Next.js (Backend Integration)Apr 11, 2025 am 08:23 AM

I built a functional multi-tenant SaaS application (an EdTech app) with your everyday tech tool and you can do the same. First, what’s a multi-tenant SaaS application? Multi-tenant SaaS applications let you serve multiple customers from a sing

How to Build a Multi-Tenant SaaS Application with Next.js (Frontend Integration)How to Build a Multi-Tenant SaaS Application with Next.js (Frontend Integration)Apr 11, 2025 am 08:22 AM

This article demonstrates frontend integration with a backend secured by Permit, building a functional EdTech SaaS application using Next.js. The frontend fetches user permissions to control UI visibility and ensures API requests adhere to role-base

JavaScript: Exploring the Versatility of a Web LanguageJavaScript: Exploring the Versatility of a Web LanguageApr 11, 2025 am 12:01 AM

JavaScript is the core language of modern web development and is widely used for its diversity and flexibility. 1) Front-end development: build dynamic web pages and single-page applications through DOM operations and modern frameworks (such as React, Vue.js, Angular). 2) Server-side development: Node.js uses a non-blocking I/O model to handle high concurrency and real-time applications. 3) Mobile and desktop application development: cross-platform development is realized through ReactNative and Electron to improve development efficiency.

The Evolution of JavaScript: Current Trends and Future ProspectsThe Evolution of JavaScript: Current Trends and Future ProspectsApr 10, 2025 am 09:33 AM

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.

Demystifying JavaScript: What It Does and Why It MattersDemystifying JavaScript: What It Does and Why It MattersApr 09, 2025 am 12:07 AM

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.

Is Python or JavaScript better?Is Python or JavaScript better?Apr 06, 2025 am 12:14 AM

Python is more suitable for data science and machine learning, while JavaScript is more suitable for front-end and full-stack development. 1. Python is known for its concise syntax and rich library ecosystem, and is suitable for data analysis and web development. 2. JavaScript is the core of front-end development. Node.js supports server-side programming and is suitable for full-stack development.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: How To Unlock Everything In MyRise
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SecLists

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.

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

DVWA

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

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)