Home > Article > Computer Tutorials > How to connect Java program and 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
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;
}
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!