Java从入门到精通 - 数据库操作连接ACCESS数据库

来源：互联网发布：大数据挖掘分析平台编辑：程序博客网时间：2024/05/29 08:39

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ConnAccessTest {
Connection con;
String   DBDriver   =   "sun.jdbc.odbc.JdbcOdbcDriver";
String   ConnStr   =   "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E:/workspace/Java从入门到精通/src/第20章数据库操作/db.mdb";
//String   ConnStr   =   "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=E:/workspace/db.mdb";
Connection   conn   =   null;
ResultSet   rs   =   null;
//本篇文章来自<A href='http://www.soidc.net'>IDC专家网</a> 原文链接：http://www.soidc.net/discuss/1/040408/14/329755_1.html
public Connection getConnection()
{
  try
  {
   Class.forName(DBDriver);   //加载数据库驱动程序
   System.out.println("数据库驱动加载成功！");
  }catch(ClassNotFoundException e)
  {
   e.printStackTrace();
  }
  try
  {
   con = DriverManager.getConnection(ConnStr);
  }catch(SQLException e)
  {
   e.printStackTrace();
  }
  return con;
}
/**
* @param args
* @throws SQLException
*/
public static void main(String[] args) throws SQLException {
  // TODO Auto-generated method stub
  ConnAccessTest c = new ConnAccessTest();

  Connection conn=c.getConnection();
  Statement stmt=conn.createStatement();
  ResultSet rs=stmt.executeQuery("select * from test order by 编号 asc");
  try
  {
   while(rs.next()) //列出所有的值
   {
    System.out.println("编号:"+rs.getString("编号"));
   }
  }
  catch(Exception ee)
  {
   System.out.println(ee);
  }
}
}