从ms访问中提取数据

问题描述:

我需要从ms访问中提取特定数据(应该定义行,列)..但是用我的代码我已经提取了所有内容..有人可以告诉我如何从ms访问中提取特定数据吗?

i need to pull specific data from ms access (row,column should be defined).. but with my code i have pulled everything.. can somebody show me how to pull specific data from ms access??

try {
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       String url = "jdbc:odbc:Driver={Microsoft Access Driver " +
           "(*.mdb, *.accdb)};DBQ=C:\\Database\\2010 salary adjustment.accdb";
       Connection con = DriverManager.getConnection(url);
       System.out.println("Connected!");
        Statement stmt = null;
           ResultSet rs = null;
           // SQL query command
           String SQL = "SELECT * FROM Table1";
           stmt = con.createStatement();
           rs = stmt.executeQuery(SQL);
           while (rs.next()) {

               jTextArea1.setText(rs.getString("gender") + ":"
                       + rs.getString("NAME") + ":"
                       + rs. getString("PosTit"));

           }
       con.close();
       } catch (SQLException e) {
           System.out.println("SQL Exception: "+ e.toString());
       } catch (ClassNotFoundException cE) {
           System.out.println("Class Not Found Exception: "+
               cE.toString());
       }

好吧,您正在要求一切

SELECT * FROM Table1

您需要指定要获取的内容

well you are asking for everything

SELECT * FROM Table1

You need to specify what you want to get

SELECT * from Table1<br />
WHERE some criteria




请参见教程 [




see here for tutorial [^]