🚀 go-pugleaf

> ==> Bill_Alan(����*���*��)                  ˵��: 
>     I met a trouble in accessing SYBASE SYSTEM 10.0 with JDBC(in JDK1.1.5).
> can you tell me how to do it?

 
   ���Բ���ǰ��� No .221

   ����ij������������

public void cb_1_actionPerformed( java.awt.event.ActionEvent event )


/*
    Form2.java

    NOTE: This file is a generated file.
          Do not modify it by hand!
*/
import java.awt.Color;
import java.awt.Event;
import java.awt.Font;
import java.awt.FontMetrics;
import java.awt.Rectangle;
import java.awt.Insets;
import java.lang.Math;
import java.lang.String;

// custom imports for Form2
// add your custom import statements here
import java.sql.*;
import java.io.*;


class Form2 extends java.awt.Frame implements 
java.awt.event.WindowListener, java.awt.event.ActionListener
{
    public Rectangle DURectangle( int x, int y, int w, int h )
    {
        String        alphabet = 
"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
        FontMetrics   fm = getFontMetrics( getFont() );
        double        fw = ( fm != null ) ? 
( fm.stringWidth( alphabet ) / alphabet.length() ) : 0;
        double        fh = ( fm != null ) ? ( fm.getHeight() / 2.0 ) : 0.0;

     return new Rectangle( (int) Math.round( ( (double)fw * (double)x ) / 4.0 ),
                       (int) Math.round( ( (double)fh * (double)y ) / 4.0 ),
                       (int) Math.round( ( (double)fw * (double)w ) / 4.0 ),
                       (int) Math.round( ( (double)fh * (double)h ) / 4.0 ) );
    }

public void DUPositionComponent( java.awt.Component comp, 
int x, int y, int w, int h, java.awt.Insets formInsets )
    {
        Rectangle     rect = DURectangle( x, y, w, h );
        if( formInsets != null ) {
             rect.x += formInsets.left;
             rect.y += formInsets.top;
        }
        comp.setBounds( rect );
    }

    public void setMainForm( boolean isMainForm )
    {
        __mainForm = isMainForm;
    }
    public boolean isMainForm()
    {
        return __mainForm;
    }
    public boolean create() throws java.lang.Exception
    {
        setResizable(true);

        setFont( new Font( "Dialog", Font.PLAIN, 12 ) );

        boolean retval = true;
        addNotify();
        Insets formInsets = getInsets();
        setBackground( Color.lightGray );
        setForeground( Color.black );

        powersoft.powerj.ui.ResizePercentLayout
 layout = new powersoft.powerj.ui.ResizePercentLayout();
        setLayout( layout );
        add(texta_1);
        add(cb_1);
        DUPositionComponent( this, 21, 90, 263, 228, null );
        addWindowListener(this);

        DUPositionComponent( texta_1, 5, 40, 245, 165, formInsets );
        texta_1.setBackground( Color.lightGray );
        texta_1.setForeground( Color.black );
        texta_1.setEnabled(true);
        texta_1.setVisible(true);


        cb_1.addActionListener(this);
        DUPositionComponent( cb_1, 20, 10, 100, 20, formInsets );
        cb_1.setBackground( Color.lightGray );
        cb_1.setForeground( Color.black );
        cb_1.setEnabled(true);
        cb_1.setVisible(true);

        cb_1.setLabel("read");


        layout.setResizePercent(texta_1,new java.awt.Rectangle(0,0,0,0));
        layout.setResizePercent(cb_1,new java.awt.Rectangle(0,0,0,0));

        setVisible(true);
        return retval;
    }

    public synchronized boolean destroy()
    {
        if( (java.awt.Container)this instanceof java.awt.Window ) {
            ((java.awt.Window)(java.awt.Container)this).dispose();
        } else {
            removeNotify();
        }
        if( isMainForm() ) {
            System.gc();
            System.runFinalization();
            System.exit(0);
        }
        return true;
    }


    public boolean defaultHandleEvent(java.awt.Event event)
    {
        defaultProcessEvent( new powersoft.powerj.event.AWTEvent( event ) );
        return false;
    }
    public void defaultProcessEvent(java.awt.AWTEvent event)
    {
        super.processEvent(event);
    }

    public void windowClosed( java.awt.event.WindowEvent event )
    {
    }
    public void windowOpened( java.awt.event.WindowEvent event )
    {
    }
    public void windowClosing( java.awt.event.WindowEvent event )
    {
        Object eventTarget = event.getSource();
        if( eventTarget == this ) {
            Form2_windowClosing( event );
        } else {
        unhandledEvent( "java.awt.event.WindowListener", "windowClosing", event );
        }
    }
    public void windowIconified( java.awt.event.WindowEvent event )
    {
    }
    public void windowActivated( java.awt.event.WindowEvent event )
    {
    }
    public void windowDeiconified( java.awt.event.WindowEvent event )
    {
    }
    public void windowDeactivated( java.awt.event.WindowEvent event )
    {
    }

    public void actionPerformed( java.awt.event.ActionEvent event )
    {
        Object eventTarget = event.getSource();
        if( eventTarget == cb_1 ) {
            cb_1_actionPerformed( event );
        } else {
         unhandledEvent( "java.awt.event.ActionListener", "actionPerformed", event );
        }
    }
    public Form2()
    {
        super();
    }
    public void processEvent(java.awt.AWTEvent event)
    {

        defaultProcessEvent(event);
    }
public void unhandledEvent( String listenerName, 
String methodName, java.lang.Object event )
    {

    }
    public boolean Form2_windowClosing(java.awt.event.WindowEvent event)
    {

        setVisible(false);
        destroy();
        return false;
    }
    public void cb_1_actionPerformed( java.awt.event.ActionEvent event )
    {
        try{
            Class.forName("com.sybase.jdbc.SybDriver");
            Connection con=DriverManager.getConnection
("jdbc:sybase:Tds:202.97.228.200:5000/han_db","sa","");
            Statement state=con.createStatement();
            ResultSet rs=state.executeQuery
("select * from hanint order by i2 compute avg(i2) by i2");
            int i1,i2;
            while(rs.next())
            {
                i1=rs.getInt(1);
                i2=rs.getInt(2);
         texta_1.appendText(String.valueOf(i1)+" "+String.valueOf(i1)+"\n");
            }
        }catch(Exception e)
        {
            texta_1.appendText(e.getMessage()+"\n");
        }

    }
    /****************************************
     * data members
     ****************************************/

    boolean __mainForm = false;

    private  java.awt.TextArea  texta_1 = new java.awt.TextArea();
    private  java.awt.Button  cb_1 = new java.awt.Button();

    // add your data members here
}



--
  ��Ī��������룬��Ī��������֪ ��

�� ��Դ: �й�ƴ�BBSվ [bbs.ustc.edu.cn]