PC Online 1999 November/PCONLINE_11_99.ISO/filesbbs/OS2/APCHSSL2.ZIP/OS2HTTPD/public/vhostdata/htdocs/MySQL/Select.class

Java Class File | 1999-05-18 | 2.3 KB | 46 lines

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Hashtable;
import java.util.Properties;

class Select {
   public static void main(String[] var0) {
      try {
         Class.forName("org.gjt.mm.mysql.Driver");
         String var1 = "jdbc:mysql://dehua:3306/test";
         Properties var2 = new Properties();
         ((Hashtable)var2).put("UID", "dehua");
         ((Hashtable)var2).put("PWD", "yangdehua");
         Connection var3 = DriverManager.getConnection(var1, (String)((Hashtable)var2).get("UID"), (String)((Hashtable)var2).get("PWD"));
         Statement var4 = var3.createStatement();
         ResultSet var5 = var4.executeQuery("SELECT * from test");
         var5.getMetaData();
         System.out.println("Got results:");

         while(var5.next()) {
            String var6 = var5.getString("name");
            String var7 = var5.getString("number");
            System.out.print(" name = " + var6);
            System.out.print(" number = " + var7);
            System.out.print("\n");
         }

         var4.close();
         DatabaseMetaData var10 = var3.getMetaData();
         var5 = var10.getTables((String)null, (String)null, (String)null, (String[])null);

         while(var5.next()) {
            System.out.println("Table: " + var5.getString("TABLE_NAME"));
         }

         var3.close();
      } catch (Exception var8) {
         System.out.println(((Throwable)var8).getMessage());
         ((Throwable)var8).printStackTrace();
      }
   }
}