heroframe.java~16~

用JAVA做的连接SQLserver 数据库查询器

package dota_hero;

import java.awt.BorderLayout;
import java.awt.Dimension;

import javax.swing.*;
import com.borland.dx.dataset.*;;
import com.borland.dx.sql.dataset.*;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dx.sql.dataset.Database;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import com.borland.dx.sql.dataset.QueryDataSet;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dbswing.JdbLabel;
import com.borland.jbcl.control.LabelControl;
import com.borland.jbcl.control.GridControl;
import com.borland.jbcl.control.NavigatorControl;
import java.awt.GridLayout;
import java.awt.FlowLayout;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class heroFrame extends JFrame {
    JPanel contentPane;
    JLabel statusBar = new JLabel();
    Database database1 = new Database();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    LabelControl labelControl1 = new LabelControl();
    LabelControl labelControl2 = new LabelControl();
    LabelControl labelControl3 = new LabelControl();
    GridControl gridControl1 = new GridControl();
    NavigatorControl navigatorControl1 = new NavigatorControl();
    FlowLayout flowLayout1 = new FlowLayout();
    public heroFrame() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(flowLayout1);
        setSize(new Dimension(400, 300));
        setTitle("JDataStore GUI Demo");
        statusBar.setText(" ");
        labelControl1.setColumnName("PRODUCTID");
        labelControl1.setDataSet(queryDataSet1);
        labelControl1.setText("labelControl1");
        labelControl2.setColumnName("CATEGORY");
        labelControl2.setDataSet(queryDataSet1);
        labelControl2.setText("labelControl2");
        labelControl3.setColumnName("NAME");
        labelControl3.setDataSet(queryDataSet1);
        labelControl3.setText("labelControl3");
        navigatorControl1.setDataSet(queryDataSet1);
        gridControl1.setDataSet(queryDataSet1);
        contentPane.add(navigatorControl1, null);
        contentPane.add(labelControl1, null);
        contentPane.add(labelControl2, null);
        contentPane.add(labelControl3, null);
        contentPane.add(statusBar, null);
        contentPane.add(gridControl1, null);
        openTable();
    }

    private void openTable() throws Exception
    {
        String url = "jdbc:odbc:java";
        String username = "sa";
        String password = "";
        try{
            database1.setConnection(new ConnectionDescriptor(url,username,password,false,"sun.jdbc.odbc.JdbcOdbcDriver"));
            database1.openConnection();
            queryDataSet1.setQuery( new QueryDescriptor(database1,"select * from 学生基本信息表",null,true,Load.ALL));
            queryDataSet1.open();
        }
        finally{
            database1.closeConnection();
        }
    }
}