JavaScript code: How to connect to Access database

Use javascript to write code to connect to the access database

And generate relevant strings.

var con = new ActiveXObject("ADODB.Connection");

con.Provider = ＂

}

rsjavascript can connect to the local database. The following is the sample code:

<.write on the current page file find absolute path where is located.open>

con;

/.4://javascript".href.substring(0, location.href.

path = path.substring(8);

var updateCnt = 0;

//These 8 characters; content");

document;ADODB.html".indexOf(".eof) {

var cnt = rs.Fields("javascript".

var filePath = location,con);

while (!rs.mdb＂;＂index;

rs.moveNext; remove the leading "

from the string

rs = null.ConnectionString = "Data Source=" path;

con;/Establish connection.OLEDB;));

var path = filePath "MyData; generate sql statements for query and update.

var sqlSelCnt = "SELECT * FROM [user]";

//.Jet;Microsoft;files.close(); language="!--

function getCountFromDB() {

/.open;

var rs = new ActiveXObject(".Recordset＂);

rs

JAVA connects to ACCESS database

I have seen the simplest method of connecting to the access database. There is no need to configure the data source or install the driver ===================== =================================================

import java.sql.*;

public class ToAccess {

public static void main(String args[]) {

try {

String url = \"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\\\bookshop.mdb\";

Class.forName(\"sun.jdbc.odbc.JdbcOdbcDriver\");

Connection conn = DriverManager.getConnection(url);

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery(\"select * from books\");

while (rs.next()) {

System.out.println(\＂The book\'s name is:\＂ rs.getString(\＂book\＂));

System.out.println(\＂The author is: \＂ rs.getString(\＂author\＂));

}

rs.close();

stmt.close();

conn.close();

} catch(Exception e) {

System.out.println(e.getMessage());

}

}

}

How to connect java to access database

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

publicclassSelect {

publicstaticvoidmain(String[] args) {

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

// String url = "jdbc:odbc:wombat";

// string url="jdbc:odbc:Driver={MicroSoft Access Driver

// (*.mdb)};DBQ=" application.getRealPath("/Data/ReportDemo.mdb");

String url = "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=C:\\Test.mdb";

Connection conn = DriverManager.getConnection(url, "＂", "＂");

Statement stmt = conn.createStatement();

}catch(SQLException e){

System.out.println("Error connecting to database.");

}

}

The above is the detailed content of JavaScript code: How to connect to Access database. For more information, please follow other related articles on the PHP Chinese website!