textpanel.java~14~

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

package superframe.factionpanels.textpanel;

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;
    String keyValue;
    public void initialize(boolean e){
        enable=e;
    }

    public void resetSql(String keyvlue){
        this.keyValue=keyvlue;//=createSQL(keyvlue);
        resultSet=SQLRunner.getResult(keyValue);
        setAllInfo();
    }
    //public abstract String createSQL(String keyvlue);
    public abstract boolean delete();
    public abstract boolean update();
    public abstract boolean insert();
    public abstract void setAllInfo();
    public abstract void setAllNull();
    public abstract void setAllNew(String limit);
    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");
    }

}