Question

Java怎样与Access连接？

请详细写出每一行代码的功能～～

Answer 1

你看这个代码是么

import java.sql.*;
public class DataBase
{
private Connection conn;
private Statement stmt;
private ResultSet rs;
public DataBase()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@local:1521","scott","careers");
}catch(ClassNotFoundException e)
{
e.printStackTrace();
}catch(SQLException e)
{
e.printStackTrace();
}
}
public void executeUpdate(String sql)
{
try
{
stmt = conn.createStatement();
stmt.executeUpdate(sql);
}catch(SQLException e)
{
e.printStackTrace();
}
}
public ResultSet executeQuery(String sql)
{
try
{
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}catch(SQLException e)
{
e.printStackTrace();
}
return rs;
}
public void close()
{
try
{
if(rs != null)
{
rs.close();
}
stmt.close();
conn.close();
}catch(SQLException e)
{
e.printStackTrace();
}
}
}

Answer 2

如果不是要连接远程access数据库的话 这里有非常详细的介绍 一看就懂http://blog.csdn.net/guofangsky/archive/2006/11/30/1422038.aspx