home *** CD-ROM | disk | FTP | other *** search
/ PC Online 1999 November / PCONLINE_11_99.ISO / filesbbs / OS2 / APCHSSL2.ZIP / OS2HTTPD / public / vhostdata / htdocs / mSQL / Select.class (.txt) < prev    next >
Encoding:
Java Class File  |  1999-05-14  |  2.0 KB  |  41 lines
  1. import java.sql.Connection;
  2. import java.sql.DatabaseMetaData;
  3. import java.sql.DriverManager;
  4. import java.sql.ResultSet;
  5. import java.sql.Statement;
  6.  
  7. class Select {
  8.    public static void main(String[] var0) {
  9.       try {
  10.          Class.forName("com.imaginary.sql.msql.MsqlDriver");
  11.          String var1 = "jdbc:msql://dehua:1114/UserBase";
  12.          Connection var2 = DriverManager.getConnection(var1, "dehua", "yangdehua");
  13.          Statement var3 = var2.createStatement();
  14.          ResultSet var4 = var3.executeQuery("SELECT * from userpassword order by Userid");
  15.          var4.getMetaData();
  16.          System.out.println("Got results:");
  17.  
  18.          while(var4.next()) {
  19.             String var5 = var4.getString("Userid");
  20.             String var6 = var4.getString("Password");
  21.             System.out.print(" Userid = " + var5);
  22.             System.out.print(" Pass = " + var6);
  23.             System.out.print("\n");
  24.          }
  25.  
  26.          var3.close();
  27.          DatabaseMetaData var9 = var2.getMetaData();
  28.          var4 = var9.getTables((String)null, (String)null, (String)null, (String[])null);
  29.  
  30.          while(var4.next()) {
  31.             System.out.println("Table: " + var4.getString("TABLE_NAME"));
  32.          }
  33.  
  34.          var2.close();
  35.       } catch (Exception var7) {
  36.          System.out.println(((Throwable)var7).getMessage());
  37.          ((Throwable)var7).printStackTrace();
  38.       }
  39.    }
  40. }
  41.