ÈçºÎÖªµÀaccess±í¸ñÖÐÓжàÉÙÊý¾Ý£¬ - Java / Web ¿ª·¢

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

  Connection con = DriverManager.getConnection("jdbc:odbc:webde", "", "");

  Statement stmt = con.createStatement();

  ResultSet rs = stmt.executeQuery("SELECT * from export");
  ResultSetMetaData rsmd = rs.getMetaData();
  int clmCnt = rsmd.getColumnCount();

ͨ¹ýÉÏÃæµÄÄÜÖªµÀÁÐÊý£¬ÎÒÈçºÎÖªµÀÐÐÊý£¬Ò²¾ÍÊÇÓжàÉÙ¸öÊý¾Ý¡£

---

select count(1) from export

---

²»¶®£¬ÎÒÏëÖªµÀÓжàÉÙÊý¾Ý£¬¶àÉÙÐÐÊý

---

ResultSet rs = stmt.executeQuery("SELECT count(*) from export");
int rowCount = rs.getInt(1,1);

---

ÓÃcountÈö