import java.sql.*;
import javax.swing.*;
import java.io.*;
import java.util.StringTokenizer;


public class daqian {

        static
          {   try
                  {   Class.forName ("COM.ibm.db2.jdbc.app.DB2Driver").newInstance ();
                  }
                  catch (Exception e)
                  {   System.out.println ("\n  Error loading DB2 Driver...\n");
                          System.out.println (e);
                          System.exit(1);
                  }
          }

        public static void main(String[] args) {
                Connection con = null;

                  //  URL is jdbc:db2:dbname
                  String url = "jdbc:db2://192.168.0.101:7000/project";

                  try {
                         if (args.length == 0) {
                                //  connect with default id/password
                                con = DriverManager.getConnection(url);
                                }
                         else if (args.length == 2) {
                                String userid = args[0];
                                String passwd = args[1];

                                //  connect with user-provided username and password
                                con = DriverManager.getConnection(url, userid, passwd);
                                }
                         else {
                                System.out.println("\nUsage: java DB2Appl [username password]\n");
                                System.exit(0);
                         }

                         //  retrieve data from the database
                         String input = JOptionPane.showInputDialog("Restaurant Name:");
                         Statement stmt = con.createStatement();

                         ResultSet rs = stmt.executeQuery("SELECT * from rs.restaurant where name=" + "'" + input + "'");

                         System.out.println("Received results:");

                         //  display the result set
                         //  rs.next() returns false when there are no more rows
                         while (rs.next()) {
                                String str1 = rs.getString(1);
                                String str2 = rs.getString(2);
                                String str3 = rs.getString(3);
                                String str4 = rs.getString(4);
                                String str5 = rs.getString(5);
                                String str6 = rs.getString(6);

                                System.out.println(str1 + " " + str2 + " " + str3 + " " + str4
                                                    + " " + str5 + " " + str6);
                                System.out.print("\n");
                         }

                         rs.close();
                         stmt.close();


                  } catch( Exception e ) {
                         e.printStackTrace();
                  }
           }
}