DOTA_HERO.rar_hero_hero g3 sqlserv_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; import javax.swing.event.AncestorEvent; import javax.swing.event.AncestorListener; /** * <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); navigatorControl1.addAncestorListener(new heroFrame_navigatorControl1_ancestorAdapter(this)); navigatorControl1.addActionListener(new heroFrame_navigatorControl1_actionAdapter(this)); gridControl1.setDataSet(queryDataSet1); gridControl1.setSelectColumn(false); gridControl1.setSelectRow(false); 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(); } } public void navigatorControl1_actionPerformed(ActionEvent e) { } public void navigatorControl1_ancestorAdded(AncestorEvent event) { } } class heroFrame_navigatorControl1_ancestorAdapter implements AncestorListener { private heroFrame adaptee; heroFrame_navigatorControl1_ancestorAdapter(heroFrame adaptee) { this.adaptee = adaptee; } public void ancestorAdded(AncestorEvent event) { adaptee.navigatorControl1_ancestorAdded(event); } public void ancestorRemoved(AncestorEvent event) { } public void ancestorMoved(AncestorEvent event) { } } class heroFrame_navigatorControl1_actionAdapter implements ActionListener { private heroFrame adaptee; heroFrame_navigatorControl1_actionAdapter(heroFrame adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.navigatorControl1_actionPerformed(e); } }