zresultsetpicker.java

用Java写的报表.功能如下: 0.内建网络打印,网络预览功能！ 1.文件操作。包括url 指定的文件。 2.全功能打印支持。包括打印预览。 3.Undo 和 redo。 4.合并单元格。 5.Cel

package ezcell;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */
import java.awt.*;
import java.awt.event.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: EZSoft.</p>
 * @author 周文军
 * @version 1.0
 */
import java.sql.*;

import javax.swing.*;


/**
 * DOCUMENT ME!
 *
 * @version $Revision$
 * @author $author$
 */
/**
 * DOCUMENT ME!
 *
 * @version $Revision$
 * @author $author$
 */
public class ZResultSetPicker extends JDialog {
    private JTextField driverText = new JTextField("sun.jdbc.odbc.JdbcOdbcDriver");
    private JTextField urlText = new JTextField("jdbc:odbc:");
    private JTextField userText = new JTextField();
    private JTextField passwordText = new JTextField();
    private JTextField sqlText = new JTextField();
    private JEditorPane sqlEditor = new JEditorPane();
    boolean ok = false;

    /**
     * Creates a new ZJDBCConfigureDialog object.
     */
    public ZResultSetPicker(Frame frame) {
        super(frame, "Configure JDBC ResultSet", true);
        buildUI();
    }

    /**
     * DOCUMENT ME!
     *
     * @throws Exception DOCUMENT ME!
     */
    private void buildUI() {
        JPanel picker = new JPanel();
        JLabel driverLabel = new JLabel("驱动器:");
        JLabel urlLabel = new JLabel("URL:");
        JLabel userLabel = new JLabel("用户名:");
        JLabel passwordLabel = new JLabel("口令:");
        JLabel sqlLabel = new JLabel("SQL:");
        picker.setBorder(BorderFactory.createEmptyBorder(10, 5, 10, 5));
        picker.setLayout(new GridBagLayout());

        GridBagConstraints gbc = new GridBagConstraints();


        //JDBC Driver:
        gbc.gridwidth = 1;
        gbc.fill = gbc.BOTH;
        gbc.insets = new Insets(2, 2, 2, 2);
        picker.add(driverLabel, gbc);
        gbc.gridwidth = gbc.REMAINDER;
        gbc.weightx = 100;
        picker.add(driverText, gbc);
        gbc.weightx = 0;


        //Database URL:
        gbc.gridwidth = 1;
        picker.add(urlLabel, gbc);
        gbc.gridwidth = gbc.REMAINDER;
        picker.add(urlText, gbc);


        //User Name:
        gbc.gridwidth = 1;
        picker.add(userLabel, gbc);
        gbc.gridwidth = gbc.REMAINDER;
        picker.add(userText, gbc);


        //Password:
        gbc.gridwidth = 1;
        picker.add(passwordLabel, gbc);
        gbc.gridwidth = gbc.REMAINDER;
        picker.add(passwordText, gbc);


        //Password:
        gbc.gridwidth = 1;
        picker.add(sqlLabel, gbc);
        gbc.gridwidth = gbc.REMAINDER;
        gbc.weighty = 100;
        picker.add(new JScrollPane(sqlEditor), gbc);

        JPanel commandsPane = new JPanel(new FlowLayout(FlowLayout.RIGHT));
        JButton testButton = new JButton(" 测试 ");
        testButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                test();
            }
        });

        JButton okButton = new JButton(" 确认 ");
        okButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                ok = true;
                setVisible(false);
            }
        });

        JButton cancelButton = new JButton(" 取消 ");
        cancelButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                setVisible(false);
            }
        });

        commandsPane.add(testButton);
        commandsPane.add(okButton);
        commandsPane.add(cancelButton);
        this.getContentPane().add(picker, BorderLayout.CENTER);
        this.getContentPane().add(commandsPane, BorderLayout.SOUTH);
        pack();
    }

    /**
     * DOCUMENT ME!
     */
    public void test() {
        String message = "数据集测试成功";

        try {
            ResultSet rs = getResultSet();
        } catch (Exception ex) {
            message = "数据集测试不成功" + ex.getMessage();
        }

        JOptionPane.showConfirmDialog(null, message);
    }

    /**
     * DOCUMENT ME!
     *
     * @return DOCUMENT ME!
     *
     * @throws Exception DOCUMENT ME!
     */
    ResultSet getResultSet() throws Exception {
        if (!ok && !isVisible()) {
            return null;
        }

        Class.forName(driverText.getText());

        Connection connection = DriverManager.getConnection(urlText.getText(),
                                                            userText.getText(),
                                                            passwordText.getText());
        Statement statement = connection.createStatement();
        ResultSet resultSet = statement.executeQuery(sqlEditor.getText());

        return resultSet;
    }

    /**
     * DOCUMENT ME!
     *
     * @param argv DOCUMENT ME!
     */
    public static void main(String[] argv) {
        JDialog d = new ZResultSetPicker(null);
        d.pack();
        d.show();
    }
}