seenote.java

一个个人信息管理系统

package soft1;

import java.awt.*;

import javax.swing.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.border.TitledBorder;
import javax.swing.BorderFactory;
import soft1Method.*;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

public class SeeNote extends JPanel {
    XYLayout xYLayout1 = new XYLayout();
    JTree jTree1 = new JTree();
    JLabel jLabel1 = new JLabel();
    TitledBorder titledBorder1 = new TitledBorder("");
    JLabel jLabel2 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField jTextField2 = new JTextField();
    JLabel jLabel6 = new JLabel();
    JComboBox jComboBox1 = new JComboBox();
    JLabel jLabel7 = new JLabel();
    JComboBox jComboBox2 = new JComboBox();
    JTextArea jTextArea1 = new JTextArea();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JTreeModel3 jt=new JTreeModel3();
    GetValue gv=new GetValue();
    Dataset2 dt=new Dataset2();
    Icon img1=new ImageIcon("src/Pic/t22.PNG");
    TitledBorder titledBorder2 = new TitledBorder("");
    TitledBorder titledBorder3 = new TitledBorder("");
    TitledBorder titledBorder4 = new TitledBorder("");
    TitledBorder titledBorder5 = new TitledBorder("");
    JLabel jLabel8 = new JLabel();
    public SeeNote() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(xYLayout1);
         setSize(new Dimension(562, 370));
        jTree1=jt.JTreeModel3();
        jTree1.setForeground(Color.gray);
        jTree1.setBorder(titledBorder1);
        jTree1.addMouseListener(new SeeNote_jTree1_mouseAdapter(this));

        jLabel2.setText("标题");
        jLabel4.setText("主体：");
        jLabel5.setText("特别提醒");
        jLabel6.setText("天气");
        jLabel7.setText("心情");
        jTextArea1.setBorder(titledBorder1);
        jButton1.setText("删除");
        jButton1.addActionListener(new SeeNote_jButton1_actionAdapter(this));
        jButton2.setText("修改");
        jButton2.addActionListener(new SeeNote_jButton2_actionAdapter(this));
        jComboBox1.addItem("");
        jComboBox1.addItem("很热");
        jComboBox1.addItem("晴朗");
        jComboBox1.addItem("阴");
        jComboBox1.addItem("小雨");
        jComboBox1.addItem("中雨");
        jComboBox1.addItem("大雨");
        jComboBox1.addItem("随便");

        jComboBox2.addItem("");
        jComboBox2.addItem("好");
        jComboBox2.addItem("很好");
        jComboBox2.addItem("一般");
        jComboBox2.addItem("不好");
        jComboBox2.addItem("很不好");
        jComboBox2.addItem("随便");
        jLabel3.setBorder(BorderFactory.createEtchedBorder());
        jLabel8.setIcon(img1);
        jLabel8.setText("");
        jLabel1.setBorder(BorderFactory.createEtchedBorder());
        jLabel1.setIcon(img1);
        this.add(jTree1, new XYConstraints(3, 28, 116, 332));
        this.add(jLabel2, new XYConstraints(126, 14, 49, 23));
        this.add(jLabel4, new XYConstraints(126, 85, 43, 24));
        this.add(jComboBox1, new XYConstraints(157, 52, 121, 24));
        this.add(jLabel5, new XYConstraints(286, 52, 77, 24));
        this.add(jLabel6, new XYConstraints(126, 52, 56, 24));
        this.add(jComboBox2, new XYConstraints(353, 85, 86, 24));
        this.add(jLabel7, new XYConstraints(286, 84, 62, 24));
        this.add(jTextArea1, new XYConstraints(126, 115, 420, 205));
        this.add(jButton1, new XYConstraints(190, 324, 113, 33));
        this.add(jButton2, new XYConstraints(335, 324, 113, 33));
        this.add(jTextField1, new XYConstraints(157, 14, 204, 23));
        this.add(jTextField2, new XYConstraints(352, 52, 194, 24));
        this.add(jLabel3, new XYConstraints(411, 14, 135, 23));
        this.add(jLabel1, new XYConstraints(367, 8, 32, 32));
        this.add(jLabel8, new XYConstraints(367, 7, 32, 32));
    }

    public void jTree1_mouseClicked(MouseEvent e) throws ClassNotFoundException,
            SQLException {
    Object o= jTree1.getLastSelectedPathComponent();
      String s=String.valueOf(o);
     String s2="select *from NotePad where Caption='"+s+"'and UserName='"+gv.Getvalue()+"'";
     ResultSet rs= dt.Rs(s2);
     while(rs.next()){
      jLabel3.setText(rs.getString("Mydate"));
      jLabel8.setText(rs.getString("ID"));
     jTextField1.setText(rs.getString("Caption"));
     jTextField2.setText(rs.getString("Special"));
     jComboBox1.setSelectedItem(rs.getString("Weather"));
     jComboBox2.setSelectedItem(rs.getString("Motion"));
     jTextArea1.setText(rs.getString("Detail"));

     }

    }

    public void jButton1_actionPerformed(ActionEvent e) {
        try{
             String s="DELETE FROM NotePad where ID="+jLabel8.getText()+"";
             System.out.println(s);
              dt.Update(s);
            /* jTextField1.setText("");
             jComboBox1.setSelectedIndex(0);
             jTextArea1.setText("");
             jTextField1.setText("");*/
              //jt.JtreeRepaind(jdbTree1);
             JOptionPane.showMessageDialog(this,"删除成功","提示",JOptionPane.ERROR_MESSAGE);
           }catch(Exception ex){

             JOptionPane.showMessageDialog(this,"删除失败","提示",JOptionPane.ERROR_MESSAGE);
           }

    }

    public void jButton2_actionPerformed(ActionEvent e) {
        if(jTextField1.getText().equals("")){
      JOptionPane.showMessageDialog(this,"请先输入标题！","提示",JOptionPane.PLAIN_MESSAGE);}
      else{
   String ss="Update NotePad Set Caption='"+jTextField1.getText()+"',Special='"+jTextField2.getText()+"',Weather ='"+jComboBox1.getSelectedItem()+"',"
             +"Motion='"+jComboBox2.getSelectedItem()+"',Detail='"+jTextArea1.getText()+"' where ID="+jLabel8.getText()+"";
    System.out.println(ss);
   dt.Update(ss);
    //queryDataSet1.refresh();
     JOptionPane.showMessageDialog(this,"更新成功！","提示",JOptionPane.PLAIN_MESSAGE);
     //queryDataSet1.refresh();
 }

    }
}


class SeeNote_jButton2_actionAdapter implements ActionListener {
    private SeeNote adaptee;
    SeeNote_jButton2_actionAdapter(SeeNote adaptee) {
        this.adaptee = adaptee;
    }

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


class SeeNote_jButton1_actionAdapter implements ActionListener {
    private SeeNote adaptee;
    SeeNote_jButton1_actionAdapter(SeeNote adaptee) {
        this.adaptee = adaptee;
    }

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


class SeeNote_jTree1_mouseAdapter extends MouseAdapter {
    private SeeNote adaptee;
    SeeNote_jTree1_mouseAdapter(SeeNote adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        try {
            adaptee.jTree1_mouseClicked(e);
        } catch (SQLException ex) {
        } catch (ClassNotFoundException ex) {
        }
    }
}