home *** CD-ROM | disk | FTP | other *** search
/ OS/2 Shareware BBS: Java / Java.zip / sampjdbc.zip / LOADFILE1.JAV < prev    next >
Text File  |  2002-10-02  |  6KB  |  180 lines
  1. import java.io.*;
  2. import asjava.uniobjects.*;
  3. import asjava.uniclientlibs.UniTokens;
  4. import asjava.uniclientlibs.*;
  5. import java.util.Vector;
  6. import java.util.Enumeration;
  7. import java.lang.reflect.Field;
  8. /**
  9.  * Title:
  10.  * Description:
  11.  * Copyright:    Copyright (c) 2001
  12.  * Company:
  13.  * @author
  14.  * @version 1.0
  15.  */
  16.  
  17. public class loadFiles {
  18.   public static String userid, password, server, accountpath;
  19.   private UniSession session;
  20.   String tmp = new String("\t");
  21.   private final char TAB = tmp.toCharArray()[0];
  22.   String tmp1 = new String("\n");
  23.   private final char CR  = tmp1.toCharArray()[0];
  24.   String tmp2 = new String(UniTokens.AT_VM);
  25.   private final char FM = tmp2.toCharArray()[0];
  26.  
  27.  
  28.   public loadFiles(String[] args) {
  29.  
  30.     if( args == null || args.length < 4){
  31.         System.out.println("Usage: java loadFiles UserId Password Server AccountPath");
  32.     }else{
  33.         userid      = args[0];
  34.         password    = args[1];
  35.         server      = args[2];
  36.         accountpath = args[3];
  37.         connect();
  38.         createFile();
  39.         loadData();
  40.     }
  41.   }
  42.  
  43.  
  44.   public void loadData(){
  45.     try{
  46.         UniFile file = session.openFile("MUSIC_CAT");
  47.         UniDataSet uset = new UniDataSet();
  48.  
  49.         FileReader fr = new FileReader("music_catalog.u");
  50.         char[] b = new char[1];
  51.         int inc = 0;
  52.         StringBuffer sb = new StringBuffer();
  53.         UniDynArray str = new UniDynArray();
  54.         String id = new String();
  55.         while( fr.read(b) > -1) {
  56.             if( inc == 0 && b[0] ==  TAB  ){
  57. //                System.out.println(inc + ": " + sb.toString());
  58.                 id = sb.toString();
  59.                 inc++;
  60.                 sb = new StringBuffer();
  61.             }else if( inc > 0 && inc < 7 && b[0] == CR ){
  62. //                System.out.println(inc + ": " + sb.toString());
  63.                 str.insert(inc, sb.toString());
  64.                 inc++;
  65.                 sb = new StringBuffer();
  66.             }else if(inc == 7 && b[0] == CR ){
  67. //                System.out.println(inc + ": " + sb.toString());
  68.                 str.insert(inc, sb.toString());
  69.                 inc = 0;
  70.                 file.write(id, str);
  71.                 sb = new StringBuffer();
  72.                 str = new UniDynArray();
  73.             }else{
  74.                 if( b[0] != TAB ){
  75.                      sb.append(b[0]);
  76.                 }
  77.             }
  78.  
  79.         }
  80.  
  81.     }catch(UniFileException f){
  82.       f.printStackTrace();
  83.     }catch(FileNotFoundException f){
  84.       f.printStackTrace();
  85.     }catch(IOException f){
  86.       f.printStackTrace();
  87.     }catch(UniSessionException f){
  88.       f.printStackTrace();
  89.     }
  90.  
  91.   }
  92.  
  93.   public void createFile(){
  94.     try{
  95.       String cmd = "CREATE.FILE MUSIC_CAT 1";
  96.       UniCommand ucmd = session.command();
  97.       ucmd.setCommand(cmd);
  98.       ucmd.exec();
  99.       System.out.println(ucmd.response());
  100.  
  101.       Vector dict = new Vector();
  102.       dict.addElement(new String[]{"STYLE","D","1","","","","S",""});
  103.       dict.addElement(new String[]{"ARTIST","D","2","","","","S",""});
  104.       dict.addElement(new String[]{"TITLE","D","3","","","","S",""});
  105.       dict.addElement(new String[]{"FORMAT","D","4","","","","MV",""});
  106.       dict.addElement(new String[]{"PRICE","D","5","","","","MV",""});
  107.       dict.addElement(new String[]{"DESCRIPTION","D","6","","","","S",""});
  108.       dict.addElement(new String[]{"IMAGE_LOCATION","D","7","","","","S",""});
  109.       setDictionary("MUSIC_CAT", dict);
  110.  
  111.  
  112.     }catch(UniSessionException s){
  113.         s.printStackTrace();
  114.     }catch(UniCommandException s){
  115.         s.printStackTrace();
  116.     }
  117.  
  118.   }
  119.   public void connect(){
  120.       try
  121.       {
  122.               session = new UniSession();
  123.               session.setUserName(userid);
  124.               session.setPassword(password);
  125.               session.setHostName(server);
  126.               session.setAccountPath(accountpath);
  127.               session.connect();
  128.       }
  129.       catch (UniSessionException e)
  130.       {
  131.           e.printStackTrace();
  132.       }
  133.   }
  134.  
  135.   public void finalize(){
  136.     try{
  137.       session.disconnect();
  138.     }catch(UniSessionException e){
  139.         e.printStackTrace();
  140.     }
  141.   }
  142.   public static void main(String[] args) {
  143.     if( args == null || args.length < 4){
  144.         System.out.println("Usage: java loadFiles UserId Password Server AccountPath");
  145.     }else{
  146.         loadFiles loadFiles1 = new loadFiles(args);
  147.     }
  148.  
  149.   }
  150.  
  151.   public void setDictionary(String fileName, Vector vDict)
  152.   {
  153.           Vector vField = new Vector();
  154.           try {
  155.                   UniDictionary udict = session.openDict( fileName ) ;
  156.                   // for each Attribute...
  157.                   for(Enumeration enum = vDict.elements(); enum.hasMoreElements(); )
  158.                   {
  159.                           String[] dict = (String[])enum.nextElement();
  160.                           if( dict != null )
  161.                           {
  162.                                   udict.setRecordID(dict[0]);
  163.                                   udict.setType(dict[1]);
  164.                                   udict.setLoc(dict[2]);
  165.                                   if(dict[3].length() > 0 ){ udict.setConv(dict[3]);}
  166.                                   if(dict[4].length() > 0 ){ udict.setName(dict[4]);}
  167.                                   if(dict[5].length() > 0 ){ udict.setFormat(dict[5]);}
  168.                                   if(dict[6].length() > 0 ){ udict.setSM (dict[6]);}
  169.                                   if(dict[7].length() > 0 ){ udict.setAssoc(dict[7]);}
  170.                           }
  171.                   }
  172.                   udict.close() ;
  173.           } catch ( UniSessionException ue ){
  174.                 ue.printStackTrace();
  175.           } catch ( UniFileException fe ) {
  176.                 fe.printStackTrace();
  177.           }
  178.   }
  179.  
  180. }