将数据库中数据存放到表格中

package test;

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

import javax.swing.JFrame;
import javax.swing.JPanel;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.JTable;

public class Frame1 extends JFrame {
    JPanel contentPane;
    XYLayout xYLayout1 
= new XYLayout();
    JButton jButton1 
= new JButton();

    
public Frame1() {
        
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(xYLayout1);
        setSize(
new Dimension(400300));
        setTitle(
"Frame Title");
        jButton1.setText(
"jButton1");
        jButton1.addActionListener(
new Frame1_jButton1_actionAdapter(this));
        contentPane.add(jButton1, 
new XYConstraints(1022088138));
    }

    
public void jButton1_actionPerformed(ActionEvent e) {
        
try {
            Class.forName(
"sun.jdbc.odbc.JdbcOdbcDriver");

        } 
catch (Exception ex) {
            ex.printStackTrace();
        }
       
// System.out.println("连接成功");
        try {

            String url
="jdbc:odbc:test";
            java.sql.Connection conn
=DriverManager.getConnection(url);
            java.sql.Statement state
=conn.createStatement();
            java.sql.ResultSet rs
=state.executeQuery("select  * from admin");
            Object[][] tables
=new Object[2][2];
            
//int i = 0, j = 0;
            java.sql.ResultSetMetaData rsm = rs.getMetaData();
            data 
= new Object[2][2];
           
int i=0;
            
while (rs.next()) {
                
for (int j = 0; j < rsm.getColumnCount(); j++) {
                   data[i][j]
=rs.getObject(j+1);
                }
                i
++;
            }
            cols
=new Object[]{"id","name"};
            JTable table
=new JTable(data,cols);
            
this.setContentPane(table);
            
this.setSize(new Dimension(100,50));
           
// this.getContentPane().add(table);
            
        } 
catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    Object[][] data;
    Object[] cols;
}


class Frame1_jButton1_actionAdapter implements ActionListener {
    
private Frame1 adaptee;
    Frame1_jButton1_actionAdapter(Frame1 adaptee) {
        
this.adaptee = adaptee;
    }

    
public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值