html中怎么使用JSP连接Access数据库。

发布网友发布时间：2022-04-11 21:39

共1个回答

热心网友时间：2022-04-11 23:08

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ConnToAccess {
public static void main(String[] args) throws SQLException, InstantiationException, IllegalAccessException {
  String url="jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=db.mdb";
  //           driver:连接类型        DBQ是access的地址
//  String url="jdbc:odbc:test"; //此为dsn
  try {
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   Connection conn=DriverManager.getConnection(url);
   Statement stm=conn.createStatement();
   ResultSet rs=stm.executeQuery("select * from sell");
   while(rs.next())
   {
    System.out.println(rs.getString(3));
   }
   rs.close();
   stm.close();
   conn.close();
  } catch (ClassNotFoundException e) {
   System.out.println(e.getMessage());
  }
}
}