How to connect Java program and Access database

How to connect java program to Access database

【change】

1. Build this class:

import java.sql.*;

public class Conn

{

String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";

String sConnStr="jdbc:odbc:";

Connection connect=null;

ResultSet rs=null;

Statement stmt;

public Object close;

public Conn(String odbc) //Connect to the database: The parameter odbc refers to the data source name

{

try{

Class.forName(sDBDriver);

}catch(Exception e){}

try{

connect=DriverManager.getConnection(sConnStr odbc);

}catch(Exception ex){}

}

public ResultSet Query_Rs(String sql)

{

try{

Statement stmt=connect.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);

rs=stmt.executeQuery(sql);

}catch(SQLException ex){}

return rs;

}

public boolean Query_Cmd(String sql)

{

boolean rlt=false;

try {

Statement stmt = connect.createStatement();

rlt=stmt.execute(sql);

} catch (SQLException ex) {

System.out.println(ex);

}

return rlt;

}

public void closeConn()

{

try

{

this.rs.close() ;

this.stmt.close() ;

this.connect.close() ;

}

catch (Exception e)

{

}

}

}

2. Build the access data source on this machine:

Write a test:

Conn conn = new Conn("your data source");

conn.ResultSet(SQL);//You can query it

conn.Query_Cmd(SQL);//You can delete or modify

javaConnect to Access database

To connect to the database for the login interface, you can first set up a data source

For example, the data source name is: student,

First Connection conn=new Connection("jdbc:odbc:student");

Statement stmt=conn.CreateStatement();

ResultSet rset = stmt.executeQuery("select * from Reader where id=" "'" user "' and pass=" ""'" pass "'"); stu is a table name in Access;

if (rset.next()) {

username = rset.getString("name");

pass=rsetrset.getString("pass");

rset. close();

} else {

JOptionPane.showMessageDialog(this, "This user does not exist");

rset. close();

return;

}

How to connect JAVA eclipse to Access

cn=DriverManager.getConnection("jdbc:odbc:book.mdb"); This sentence is wrong. If book is the name of your odbc database, it should be like this cn=DriverManager.getConnection("jdbc:odbc:book" ");

If you want to connect the access file directly, you should

String dbur1 = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=d://a1.mdb";

Connection conn = DriverManager.getConnection(dbur1, "username", "password");

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