edit_madicine.java

在个一个诊所系统,实现数据的查询和删除等的操作.

package clinique;

import java.awt.*;

import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.sql.dataset.ConnectionDescriptor;
import com.borland.dx.sql.dataset.Load;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dbswing.JdbTable;
import com.borland.dx.dataset.Column;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.event.AncestorEvent;
import javax.swing.event.AncestorListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.SQLException;
import java.lang.*;
import com.borland.dx.sql.dataset.ConnectionUpdateEvent;
import com.borland.dx.sql.dataset.ConnectionUpdateAdapter;
import java.awt.Font;
import javax.swing.BorderFactory;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class edit_madicine extends JPanel {
    int n;
    int pri;
    String id;
    String p;
    int x=-1;
    public edit_madicine() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        edit_med.setBounds(new Rectangle(419, 335, 89, 23));
        edit_med.setText("提交修改");
        edit_med.addActionListener(new edit_madicine_jButton1_actionAdapter(this));
        quxiao.setBounds(new Rectangle(536, 335, 69, 23));
        quxiao.setText("取消");
        quxiao.addActionListener(new edit_madicine_jButton2_actionAdapter(this));
        med_name.setBounds(new Rectangle(155, 19, 113, 20));
        med_factory.setBounds(new Rectangle(438, 19, 120, 20));
        med_price.setBounds(new Rectangle(155, 61, 91, 20));
        jLabel1.setText("药品名称：");
        jLabel1.setBounds(new Rectangle(66, 20, 73, 15));
        jLabel2.setText("药品厂家：");
        jLabel2.setBounds(new Rectangle(357, 26, 70, 15));
        jLabel3.setText("药品单价：");
        jLabel3.setBounds(new Rectangle(67, 62, 70, 15));
        database1.setConnection(new ConnectionDescriptor(
                "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=clinique",
                "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
        database1.addConnectionUpdateListener(new
                edit_madicine_database1_connectionUpdateAdapter(this));
        queryDataSet1.setQuery(new QueryDescriptor(database1,
                "SELECT * FROM MEDICINE", null, true, Load.ALL));
        jScrollPane1.setBorder(BorderFactory.createEtchedBorder());
        jScrollPane1.setBounds(new Rectangle(8, 11, 630, 193));
        jdbTable1.setDataSet(queryDataSet1);
        jdbTable1.setEditable(false);
        jdbTable1.addMouseListener(new edit_madicine_jdbTable1_mouseAdapter(this));
        jdbTable1.addAncestorListener(new
                                      edit_madicine_jdbTable1_ancestorAdapter(this));
        column1.setColumnName("name");
        column1.setDataType(com.borland.dx.dataset.Variant.STRING);
        column1.setPrecision(50);
        column1.setTableName("medicine");
        column1.setWidth(14);
        column1.setServerColumnName("name");
        column1.setSqlType(1);
        column2.setColumnName("factory");
        column2.setDataType(com.borland.dx.dataset.Variant.STRING);
        column2.setPrecision(50);
        column2.setTableName("medicine");
        column2.setWidth(14);
        column2.setServerColumnName("factory");
        column2.setSqlType(1);
        column3.setColumnName("price");
        column3.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
        column3.setPrecision(19);
        column3.setScale(4);
        column3.setTableName("medicine");
        column3.setWidth(13);
        column3.setServerColumnName("price");
        column3.setSqlType(3);
        column4.setColumnName("medicine_id");
        column4.setDataType(com.borland.dx.dataset.Variant.INT);
        column4.setRowId(true);
        column4.setTableName("medicine");
        column4.setWidth(14);
        column4.setServerColumnName("MEDICINE_ID");
        column4.setSqlType(4);
        jLabel4.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel4.setText("药品信息修改");
        jLabel4.setBounds(new Rectangle(33, 17, 115, 31));
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(8, 229, 630, 94));
        jPanel1.setLayout(null);
        med_number.setBounds(new Rectangle(438, 61, 119, 20));
        jLabel5.setText("药品数量：");
        jLabel5.setBounds(new Rectangle(357, 65, 73, 15));
        jPanel2.setBorder(BorderFactory.createEtchedBorder());
        jPanel2.setBounds(new Rectangle(64, 55, 646, 371));
        jPanel2.setLayout(null);
        lookname.setBounds(new Rectangle(108, 338, 77, 20));
        look.setBounds(new Rectangle(217, 335, 63, 23));
        look.setText("查询");
        look.addActionListener(new edit_madicine_look_actionAdapter(this));
        jLabel6.setText("姓名查询：");
        jLabel6.setBounds(new Rectangle(36, 338, 69, 15));
        show.setBounds(new Rectangle(303, 335, 88, 23));
        show.setText("显示全部");
        show.addActionListener(new edit_madicine_show_actionAdapter(this));
        jLabel7.setText("元");
        jLabel7.setBounds(new Rectangle(250, 64, 24, 15));
        jPanel1.add(med_number);
        jPanel1.add(med_factory);
        jPanel1.add(jLabel2);
        jPanel1.add(jLabel5);
        jPanel1.add(med_name);
        jPanel1.add(med_price);
        jPanel1.add(jLabel3);
        jPanel1.add(jLabel1);
        jPanel1.add(jLabel7);
        jPanel2.add(edit_med);
        jPanel2.add(quxiao);
        jPanel2.add(look);
        jPanel2.add(show);
        jPanel2.add(jScrollPane1);
        jPanel2.add(jLabel6);
        jPanel2.add(lookname);
        jScrollPane1.getViewport().add(jdbTable1);
        jPanel2.add(jPanel1);

        this.add(jLabel4);
        this.add(jPanel2);
        queryDataSet1.setColumns(new Column[] {column4, column1, column2,
                                 column3});
    }

    JButton edit_med = new JButton();
    JButton quxiao = new JButton();
    JTextField med_name = new JTextField();
    JTextField med_factory = new JTextField();
    JTextField med_price = new JTextField();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    Database database1 = new Database();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    JScrollPane jScrollPane1 = new JScrollPane();
    JdbTable jdbTable1 = new JdbTable();
    Column column1 = new Column();
    Column column2 = new Column();
    Column column3 = new Column();
    Column column4 = new Column();
    JLabel jLabel4 = new JLabel();
    JPanel jPanel1 = new JPanel();
    JTextField med_number = new JTextField();
    JLabel jLabel5 = new JLabel();
    JPanel jPanel2 = new JPanel();
    JTextField lookname = new JTextField();
    JButton look = new JButton();
    JLabel jLabel6 = new JLabel();
    JButton show = new JButton();
    JLabel jLabel7 = new JLabel();
    public void jButton3_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }

    public void jdbTable1_ancestorAdded(AncestorEvent event) {

    }

    public void jdbTable1_mouseClicked(MouseEvent e) {
        x=1;
        n=jdbTable1.getSelectedRow();
        id=""+jdbTable1.getValueAt(n,0);
        med_name.setText((String)jdbTable1.getValueAt(n,1));
        med_factory.setText((String)jdbTable1.getValueAt(n,2));
        med_price.setText(""+jdbTable1.getValueAt(n,3));
        med_number.setText(""+jdbTable1.getValueAt(n,4));
    }

   public void jButton1_actionPerformed(ActionEvent e) {
       if(x==-1)
       {
           JOptionPane.showMessageDialog(null,"请选择你要修改的一条数据！");
       }
       else if(med_name.getText().length()==0)
       {
           JOptionPane.showMessageDialog(null,"请填写你要修改药品的名称！");
           med_name.requestFocus();
       }
       else if(med_factory.getText().length()==0)
       {
           JOptionPane.showMessageDialog(null,"请填写你要修改药品的厂家名称！");
           med_factory.requestFocus();
       }
       else if(med_price.getText().length()==0)
       {
           JOptionPane.showMessageDialog(null,"请填写你要修改药品的价格！");
           med_price.requestFocus();
       }
       else if(med_number.getText().length()==0)
       {
           JOptionPane.showMessageDialog(null,"请填写你要修改药品的数量！");
           med_number.requestFocus();
       }
       else if(number()==false)
       {
           JOptionPane.showMessageDialog(null,"你修改的药品数量无效，请重新输入！");
           med_number.setText("");
           med_number.requestFocus();
       }
       else
       {
               edit_medicine();
       }

    }
    public boolean number()
    {
               String s=med_number.getText();
               for (int i = 0; i < s.length(); i++)
               {
                   char ch = s.charAt(i);
                   if (ch < '0' || ch > '9')
                       return false;
               }
               return true;
}
   private void edit_medicine()
    {
        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        } catch (ClassNotFoundException ce) {
            System.out.println(ce);
        }
        try {
            String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=clinique";
            Connection con = DriverManager.getConnection(url,"sa","");
            String sqlStr;
            sqlStr="update medicine set name=\'"+ med_name.getText()+"\',factory=\'"+ med_factory.getText()+"\',price=\'"+
                     med_price.getText()+"\',number=\'"+med_number.getText()+"\' where medicine_id=\'"+id+"\'";
            Statement s = con.createStatement();
            s.executeUpdate(sqlStr);
            JOptionPane.showMessageDialog(null,"药品信息修改成功!");
            med_name.setText("");
            med_factory.setText("");
            med_price.setText("");
            med_number.setText("");
            queryDataSet1.refresh();
            s.close();
            con.close();
            x=-1;
        } catch (SQLException ce) {
            System.out.println(ce);
        }

    }

    public void database1_connectionChanged(ConnectionUpdateEvent
                                            connectionUpdateEvent) {

    }

    public void jButton2_actionPerformed(ActionEvent e) {
        med_name.setText("");
        med_factory.setText("");
        med_price.setText("");
        med_number.setText("");
        x=-1;
    }

    public void look_actionPerformed(ActionEvent e) {
        if(lookname.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请输入你要查询的关键字！");
            lookname.requestFocus();
        }
        else if(!lookname.getText().equals(""))
        {
            queryDataSet1.close();
            queryDataSet1.setQuery(new QueryDescriptor(database1,
                    "select * from medicine where name=\'" +
                    lookname.getText() + "\'", null, true,
                    Load.ALL));
            jdbTable1.setDataSet(queryDataSet1);
            queryDataSet1.refresh();
            if(queryDataSet1.getRowCount()==0)
            {
                JOptionPane.showMessageDialog(null,"你要查询的药品信息不存在");
            }
        }
    }

    public void show_actionPerformed(ActionEvent e) {
        queryDataSet1.close();
        queryDataSet1.setQuery(new QueryDescriptor(database1,
                "select * from medicine" , null, true,Load.ALL));
        jdbTable1.setDataSet(queryDataSet1);
            queryDataSet1.refresh();
    }
}


class edit_madicine_show_actionAdapter implements ActionListener {
    private edit_madicine adaptee;
    edit_madicine_show_actionAdapter(edit_madicine adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.show_actionPerformed(e);
    }
}


class edit_madicine_look_actionAdapter implements ActionListener {
    private edit_madicine adaptee;
    edit_madicine_look_actionAdapter(edit_madicine adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.look_actionPerformed(e);
    }
}


class edit_madicine_jButton2_actionAdapter implements ActionListener {
    private edit_madicine adaptee;
    edit_madicine_jButton2_actionAdapter(edit_madicine adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent actionEvent) {
        adaptee.jButton2_actionPerformed(actionEvent);
    }
}


class edit_madicine_jButton1_actionAdapter implements ActionListener {
    private edit_madicine adaptee;
    edit_madicine_jButton1_actionAdapter(edit_madicine adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
        //     adaptee.jButton1_actionPerformed(e);
    }
}


class edit_madicine_jdbTable1_ancestorAdapter implements AncestorListener {
    private edit_madicine adaptee;
    edit_madicine_jdbTable1_ancestorAdapter(edit_madicine adaptee) {
        this.adaptee = adaptee;
    }

    public void ancestorAdded(AncestorEvent event) {
        adaptee.jdbTable1_ancestorAdded(event);
    }

    public void ancestorRemoved(AncestorEvent event) {
    }

    public void ancestorMoved(AncestorEvent event) {
    }
}


class edit_madicine_jdbTable1_mouseAdapter extends MouseAdapter {
    private edit_madicine adaptee;
    edit_madicine_jdbTable1_mouseAdapter(edit_madicine adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jdbTable1_mouseClicked(e);
    }
}


class edit_madicine_database1_connectionUpdateAdapter extends
        ConnectionUpdateAdapter {
    private edit_madicine adaptee;
    edit_madicine_database1_connectionUpdateAdapter(edit_madicine adaptee) {
        this.adaptee = adaptee;
    }

    public void connectionChanged(ConnectionUpdateEvent connectionUpdateEvent) {
        adaptee.database1_connectionChanged(connectionUpdateEvent);
    }
}