editstu.java

一个毕业设计的Java学生成绩管理系统

package scoremis;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import java.sql.ResultSet;
import java.util.Vector;
public class editSTU extends JPanel
{
   public editSTU()
    {
       try
        {
          jbInit();
        }
       catch(Exception exception)
        {
           exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception   
        {
          this.setLayout(null);
          jLabel1.setFont(new java.awt.Font("宋体",Font.PLAIN,20));
          bj.addActionListener(new ActionListener()   //复选框班级的事件处理
          {
            public void actionPerformed(ActionEvent e)
              {
                 sgreade.removeAllItems();
                  if(bj.isSelected())
                     try
                      {
                         dbconn db=new dbconn();
                         ResultSet rs=db.Query("select distinct greade from student");
                         sgreade.addItem("  ");
                         while(rs.next())
                            sgreade.addItem(rs.getString(1));
                      }
                       catch(Exception er) 
                      {
                             System.out.println(er.toString());
                      }
              }
          });
    jScrollPanel.setBounds(new Rectangle(65,154,370,161));//设置各个组件的位置字体
    jLabel1.setBounds(new Rectangle(111,13,250,36));
    bj.setBounds(new Rectangle(64,74,65,27));
    xm.setBounds(new Rectangle(259,74,63,27));
    sgreade.setBounds(new Rectangle(132,74,116,23));
    sname.setBounds(new Rectangle(322,74,116,23));
    del.setBounds(new Rectangle(347,112,87,27));
    edit.setBounds(new Rectangle(216,112,87,27));
    query.setBounds(new Rectangle(68,112,87,27));
    model.addColumn("学号");//为表格添加各个列
    model.addColumn("姓名");
    model.addColumn("性别");
    model.addColumn("出生日期");
    model.addColumn("所在班级");
         dbtable.addMouseListener(new MouseAdapter()  //为表格添加监视器
           {
            public void mouseClicked(MouseEvent e)
              {
                 int j=dbtable.getSelectedRow();//统计表格中的信息行数
                 xh1=(String) model.getValueAt(j,0);
                 xm1=(String) model.getValueAt(j,1);
                 xb1=(String) model.getValueAt(j,2);
                 sr1=(java.sql.Date) model.getValueAt(j,3);
                 bj1=(String) model.getValueAt(j,4);
                 del.setEnabled(true);
                 edit.setEnabled(true);
              }
           });
       this.add(jLabel1);//添加各个组件
       this.add(bj);
       this.add(sgreade);
       this.add(xm);
       this.add(sname);
       this.add(query);
       this.add(edit);
       this.add(del);
       this.add(jScrollPanel);
       query.addActionListener(new Handel());//为"查询","删除","修改"按钮添加监视器
       edit.addActionListener(new Handel());
       del.addActionListener(new Handel());
       del.setEnabled(false);// 设初始状态为"删除","编辑"按钮为不可用
       edit.setEnabled(false);
        }
class Handel implements ActionListener//事件处理类
  {
    public void actionPerformed(ActionEvent e)
     {
        dbconn db=new dbconn();
       if(e.getSource()==edit)            //"修改按钮"获得焦点的事件处理
         {
           Toolkit tk=Toolkit.getDefaultToolkit();
           Dimension sSize=tk.getScreenSize();
           int sh=sSize.height;
           int sw=sSize.width;
           StudentQuery sq=new StudentQuery(xm1,xh1,xb1,sr1,bj1,"teacher");//如果编辑按钮获得焦点并且调用StudentQuery的构造方法
           sq.setTitle("修改学生信息");
           sq.setSize(sh/2+100,sh/2);
           sq.setLocation(sh/4,sh/4);
           sq.setVisible(true);
         }
       if(e.getSource()==del)//删除按钮获得焦点的事件处理
        {
          int y=JOptionPane.showConfirmDialot(null,"你确实要删除吗","删除学生对话框",JOptionPane.YES_NO_OPTION,JOptionPane.INFORMATION_MESSAGE);
          String sql="delete * from student where ID='"+xh1+"' and name='"+xm1+"' and sex='"+xb+"' and brithday=#"+sr1+"# and greade='"+bj1+"'";
            if(y==0)
              {
                 int i=db.Update(sql);
                 if(i>0)
                   JOptionPane.showMessageDialog(null,"删除成功");
                 else
                    JOptionPane.showMessageDialog(null,"删除失败");
              }
        }
      else       //处理“查询”事件
       {
            String sbj,sxm;
            String sql="select * from student";
            if(xm.isSelected() && bj.isSelect())
              {
                 sxm=sname.getText();
                 sql=sql+" where greade='" + (String) sgreade.getSelectedItem() +"' and name=' + sxm + "'";
              }
              else if(bj.isSelected())
              {
                 sbj=(String) sgreade.getSelectedItem();
                 sql=sql+" where greade='" + sbj + "'";
              }
              else if(xm.isSelected())
              {
                 sql=sql + " where name='" + (String) sname.getText() +"'";
              }
               int j=model.getRowCount();
               if(j>0)
                {
                  for(int i=0;i<j;i++)
                    model.removeRow(0);
                }
                dbtable.setVisible(true);
              
          try
            {
              ResultSet rs=db.Query(sql);//执行sql语句
                while(rs.next())//在表格中添加各个记录
                 {
                   tempvector=new Vector(1,1);
                   tempvector.add(rs.getString(1));
                   tempvector.add(rs.getString(2));
                   tempvector.add(rs.getString(3));
                   tempvector.add(rs.getDate(4));
                   tempvector.add(rs.getString(5));
                   model.addRow(tempvector);
                 }

            }
          catch(Exception ex)
            {
               System.out.println(er.toStrig());
            }
       }
         
     }
  }
  JLabel jLabel1=new JLabel("学生基本信息管理");   //对学生基本信息管理窗口中的各个组件进行初始化
  JComboBox sgreade=new JComobBox();
  JCheckBox bj=new JComboBox("班级");
  JCheckBox xm=new JCheckBox("姓名");
  JButton query=new JButton("查询");
  JButton del=new JButton("删除");
  JButton edit=new JButton("修改");
  Vector tempvector=new Vector(1,1);
  DefaultTableModel model=new DefaultTableModel();
  JTable dbtable=new JTable(model);
  JScrollPane jScrollPanel=new JScrollPane(dbtable);
  JTextField sname=new JTextField();
  String xh1,xm1,xb1,bj1;
  java.sql.Date sr1; 
}