荔园在线
荔园之美,在春之萌芽,在夏之绽放,在秋之收获,在冬之沉淀
[回到开始]
[上一篇][下一篇]
发信人: Qin_Qin@bbs.ustc.edu.cn (云), 信区: Java
标 题: Re: How to access SYBASE SQL Server with JDBC?
发信站: 中国科大BBS站 (Fri Jun 19 02:23:44 1998)
转信站: ShenZhen-University!clinux.ml.org!linux.ustc.edu.cn!ustcnews!ustcbbs
> ==> 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
下面的程序或许对你有帮助:
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]
[回到开始]
[上一篇][下一篇]
荔园在线首页 友情链接:深圳大学 深大招生 荔园晨风BBS S-Term软件 网络书店