textpanel.java~1~

使用JBuilder基于Oracle数据库的课程作业

package superframe;

import javax.swing.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.awt.event.ActionListener;
import superframe.link.SQLRunner;

public abstract class TextPanel extends JPanel{// implements ActionListener{
    ResultSet resultSet;
    boolean enable;
    String sql;

    public void initialize(String sql,boolean e){
        enable=e;
        resultSet=SQLRunner.getResult(sql);
        this.sql=sql;
    }

    public void resetSql(String sql){
        this.sql=sql;
        resultSet=SQLRunner.getResult(sql);
        setAllInfo();
    }
    public abstract boolean save();
    public abstract boolean insert();
    public abstract void setAllInfo();
    public abstract void setAllNull();
    void addItem(JComboBox target, String sql, String columnName){
        try {
            target.removeAllItems();
            ResultSet rsex=SQLRunner.getResult(sql);
            while (rsex.next()) {
                target.addItem(rsex.getString(columnName));
            }
        } catch (SQLException ex) {
        }
    }

    public void selectItemAsResult(JComboBox jComboBox,String columnName){
        try {
            jComboBox.setSelectedItem(resultSet.getString(columnName));
            System.out.println(resultSet.getString(columnName));
        } catch (SQLException ex) {
        }
    }

    void addItemFromDic(JComboBox jComboBox,String DicTablebName) {
        addItem(jComboBox,"select * from "+DicTablebName,"value");
    }

    /*void addLinkItems(JComboBox superBox,JComboBox subBox,String sql,String columnName){
        try {
            subBox.removeAllItems();
            if(superBox.getItemCount()==0){
                return;
            }else{
                ResultSet resultSet=JDBC.getResult(sql);
                while (resultSet.next()) {
                    subBox.addItem(resultSet.getString(columnName.trim()));
                }
            }
        }catch (SQLException ex){
            System.out.println(ex.toString());
        }
   }*/

}