markinfoframe.java

学生信息管理系统

package com.sccp.StudentMS.baseFrame;

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.JOptionPane;
import com.sccp.StudentMS.DBtools.DBtool;
import com.swtdesigner.SwingResourceManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class MarkInfoFrame extends JFrame {

	public JTextField specialty;
	public JTextField math;
	public JTextField total;
	public JTextField english;
	public JTextField philosophy;
	public JTextField id;
	JButton add;
	JButton modify;
	JButton save;
	JButton cancel;
	JButton exit;
	JButton delete;
	JButton see;
	JButton sum;
	JButton people;
	JButton query;
	
	String sql;
	String exeType="";
	ResultSet rs;
	DBtool db=new DBtool();
	/**
	 * Launch the application
	 * @param args
	 */
	public static void main(String args[]) {
		try {
			MarkInfoFrame frame = new MarkInfoFrame();
			frame.setVisible(true);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * Create the frame
	 */
	public MarkInfoFrame() {
		super();
		setForeground(new Color(255, 0, 255));
		setResizable(false);
		setTitle("成绩管理");
		setBounds(100, 100, 689, 540);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		final JPanel panel = new JPanel();
		panel.setLayout(null);
		getContentPane().add(panel, BorderLayout.CENTER);

		  query = new JButton();
		query.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				MarkQueryFrame mqf=new MarkQueryFrame();
				mqf.setVisible(true);
				
			}
		});
		query.setText("查询");
		query.setBounds(142, 106, 90, 23);
		panel.add(query);

		  see = new JButton();
		see.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				sql="select * from studentInfo where ID='"+id.getText()+"'";
				rs=db.getResult(sql);
				try {
					if(rs.next())
					{
						seeInfo();
						//MarkInfoFrame.this.dispose();
					}else
						JOptionPane.showMessageDialog(null, "Sorry!此人信息不存在！");
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
			}
		});
		see.setText("查看资料");
		see.setBounds(266, 106, 89, 23);
		panel.add(see);

		  sum = new JButton();
		sum.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				MarkStatisticFrame msf=new MarkStatisticFrame();
				//MarkInfoFrame.this.dispose();
				msf.setVisible(true);
				msf.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
			}
		});
		sum.setText("成绩统计");
		sum.setBounds(381, 106, 89, 23);
		panel.add(sum);

		 people = new JButton();
		people.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				StudentInfoFrame sif=new StudentInfoFrame();
			    sif.setTextAbled(false);
			    sif.modify.setEnabled(false);
			    sif.delete.setEnabled(false);
			    sif.cancel.setEnabled(false);
			    sif.save.setEnabled(false);
			    
				MarkInfoFrame.this.dispose();
				sif.setVisible(true);
				sif.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
			}
		});
		people.setText("人员管理");
		people.setBounds(489, 106, 89, 23);
		panel.add(people);

		final JLabel label = new JLabel();
		label.setText("学号");
		label.setBounds(148, 233, 60, 15);
		panel.add(label);

		id = new JTextField();
		id.setFont(new Font("", Font.BOLD, 12));
		id.setBounds(214, 231, 95, 20);
		panel.add(id);

		final JLabel label_1 = new JLabel();
		label_1.setText("政治");
		label_1.setBounds(148, 277, 60, 15);
		panel.add(label_1);

		philosophy = new JTextField();
		philosophy.setFont(new Font("", Font.BOLD, 12));
		philosophy.setBounds(214, 275, 95, 20);
		panel.add(philosophy);

		final JLabel label_2 = new JLabel();
		label_2.setText("外语");
		label_2.setBounds(148, 329, 60, 15);
		panel.add(label_2);

		english = new JTextField();
		english.setFont(new Font("", Font.BOLD, 12));
		english.setBounds(214, 327, 95, 20);
		panel.add(english);

		final JLabel label_3 = new JLabel();
		label_3.setText("总分");
		label_3.setBounds(350, 233, 60, 15);
		panel.add(label_3);

		final JLabel label_4 = new JLabel();
		label_4.setText("数学");
		label_4.setBounds(350, 277, 60, 15);
		panel.add(label_4);

		final JLabel label_5 = new JLabel();
		label_5.setText("专业课");
		label_5.setBounds(350, 329, 60, 15);
		panel.add(label_5);

		total = new JTextField();
		total.setFont(new Font("", Font.BOLD, 12));
		total.setBounds(416, 231, 95, 20);
		panel.add(total);

		math = new JTextField();
		math.setFont(new Font("", Font.BOLD, 12));
		math.setBounds(416, 275, 95, 20);
		panel.add(math);

		specialty = new JTextField();
		specialty.setFont(new Font("", Font.BOLD, 12));
		specialty.setBounds(416, 327, 95, 20);
		panel.add(specialty);

		add = new JButton();
		add.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				setTextAbled(true);
				setNull();
				setButton(false,false,false,true,true);
				setExeType("add");
			}
		});
		add.setText("新增");
		add.setBounds(104, 448, 62, 23);
		panel.add(add);

	    modify = new JButton();
	    modify.addActionListener(new ActionListener() {
	    	public void actionPerformed(final ActionEvent e) {
	    		setTextAbled(true);
	    		setButton(false,false,false,true,true);
	    		setExeType("modify");
	    	}
	    });
		modify.setText("修改");
		modify.setBounds(176, 448, 62, 23);
		panel.add(modify);

		delete = new JButton();
		delete.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				sql="select from studentInfo where ID='"+id.getText()+"'";
				if(id.getText().equals(""))
					JOptionPane.showMessageDialog(null,"请输入要删除学生的学号！");
				else
				{
					if(db.executeSql(sql))
					{
						JOptionPane.showMessageDialog(null, "删除信息成功！");
					}else
						JOptionPane.showMessageDialog(null, "删除信息失败！");
				}
			}
		});
		delete.setText("删除");
		delete.setBounds(255, 448, 61, 23);
		panel.add(delete);

		 save = new JButton();
		 save.addActionListener(new ActionListener() {
		 	public void actionPerformed(final ActionEvent e) {
		 		if(philosophy.getText().equals("")||math.getText().equals("")||english.getText().equals("")||specialty.getText().equals(""))
		 		{
		 			JOptionPane.showMessageDialog(null, "请输入成绩！");
		 		}
		 		else
		 		{
		 			
		 		
		 	if(exeType.equals("add"))
		 	{
		 		sql="select * from grade where ID='"+id.getText()+"'";
		 		String sql1="select * from studentInfo where ID='"+id.getText()+"'";
		 		ResultSet rs1=db.getResult(sql1);
		 		rs=db.getResult(sql);
		 	try{
		 		if(rs.next())
		 			{
		 			JOptionPane.showMessageDialog(null, "学号不能为重复");
		 			setNull();
		 			}else if(!(rs1.next()))
		 			{
			 			JOptionPane.showMessageDialog(null, "学生信息中无此学生，请先输入学生的有关信息!");
		 			}
		 		else
		 		{     int sum;
		 		      String s;
		 		      sum=(Integer.parseInt(philosophy.getText())+Integer.parseInt(math.getText())+Integer.parseInt(english.getText())+Integer.parseInt(specialty.getText()));
		 		      s=String.valueOf(sum);
		 		      sql="insert into grade(ID,Total,philosophy,math,english,specialty) values (";
		 			    sql=sql+"'"+id.getText()+"',";
		 			   sql=sql+"'"+s+"',";
						sql=sql+"'"+philosophy.getText()+"',";
						sql=sql+"'"+math.getText()+"',";
						sql=sql+"'"+english.getText()+"',";
						sql=sql+"'"+specialty.getText()+"'";
						sql=sql+")";
						boolean b=db.executeSql(sql);
						if(b)
						{
							JOptionPane.showMessageDialog(null,"添加信息成功！");
				 			setTextAbled(false);
				 			setButton(true,true,true,false,false);
						}else
							{
							JOptionPane.showMessageDialog(null,"添加信息失败！");	
							}						
		 		}
		 	}catch(Exception e1)
		 	{
		 		System.out.println("sql语句出错！");
		 		e1.printStackTrace();
		 	}
		 	} 
		 	else if(exeType.equals("modify"))
		 	{    
		       float  sum= Float.parseFloat(philosophy.getText())+Float.parseFloat( math.getText())+ Float.parseFloat(english.getText())+ Float.parseFloat(specialty.getText());
		       
		 		String sql="update grade set Total = '"+sum+"',";
				sql=sql+"philosophy='"+philosophy.getText()+"',";
				sql=sql+"math='"+math.getText()+"',";
				sql=sql+"english='"+english.getText()+"',";
				sql=sql+"specialty='"+specialty.getText()+"'";
				sql=sql+" where ID='"+id.getText()+"'";
				if(db.executeSql(sql))
				{                                                                                                                                          
					 JOptionPane.showMessageDialog(null,"成功更新信息！");	
					 setButton(true,true,true,false,false);
					 setTextAbled(false);
				}else
					 JOptionPane.showMessageDialog(null,"更新信息失败！");	
		 	}
		 	}
		 	}
		 });
		save.setText("保存");
		save.setBounds(334, 448, 61, 23);
		panel.add(save);

		 cancel = new JButton();
		 cancel.addActionListener(new ActionListener() {
		 	public void actionPerformed(final ActionEvent e) {
		 		  setTextAbled(false);
				  if(exeType.equals("add")) 
				   setNull();
				  setButton(true,true,true,false,false);
		 	}
		 });
		cancel.setText("取消");
		cancel.setBounds(416, 448, 61, 23);
		panel.add(cancel);

		  exit = new JButton();
		exit.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				MarkInfoFrame.this.dispose();
				
			}
		});
		exit.setText("退出");
		exit.setBounds(489, 448, 61, 23);
		panel.add(exit);

		 final JLabel label_6 = new JLabel();
		label_6.setIcon(SwingResourceManager.getIcon(MarkInfoFrame.class, "/images/20070205153903621.gif"));
		label_6.setText("  ");
		label_6.setBounds(0, 0, 700, 140);
		panel.add(label_6);

		final JLabel label_7 = new JLabel();
		label_7.setIcon(SwingResourceManager.getIcon(MarkInfoFrame.class, "/images/a1.gif"));
		label_7.setText(" ");
		label_7.setBounds(229, 157, 195, 39);
		panel.add(label_7);

		final JLabel label_8 = new JLabel();
		label_8.setIcon(SwingResourceManager.getIcon(MarkInfoFrame.class, "/images/gifbj046.gif"));
		label_8.setText(" ");
		label_8.setBounds(37, 132, 100, 120);
		panel.add(label_8);

		final JLabel label_9 = new JLabel();
		label_9.setIcon(SwingResourceManager.getIcon(MarkInfoFrame.class, "/images/gifbj069.gif"));
		label_9.setText(" ");
		label_9.setBounds(551, 135, 100, 120);
		panel.add(label_9);

		final JLabel label_10 = new JLabel();
		label_10.setIcon(SwingResourceManager.getIcon(MarkInfoFrame.class, "/images/gifbj060.gif"));
		label_10.setText(" ");
		label_10.setBounds(310, 233, 100, 120);
		panel.add(label_10);

		final JLabel label_11 = new JLabel();
		label_11.setIcon(SwingResourceManager.getIcon(MarkInfoFrame.class, "/images/ss.gif"));
		label_11.setText(" ");
		label_11.setBounds(176, 381, 324, 17);
		panel.add(label_11);

		final JLabel label_12 = new JLabel();
		label_12.setIcon(SwingResourceManager.getIcon(MarkInfoFrame.class, "/images/20061116112956759.gif"));
		label_12.setText(" ");
		label_12.setBounds(10, 295, 64, 189);
		panel.add(label_12);

		final JLabel label_13 = new JLabel();
		label_13.setIcon(SwingResourceManager.getIcon(MarkInfoFrame.class, "/images/20061116112456547.gif"));
		label_13.setText(" ");
		label_13.setBounds(556, 277, 90, 225);
		panel.add(label_13);

		  final JLabel label_61 = new JLabel();
		 label_61.setIcon(SwingResourceManager.getIcon(MarkInfoFrame.class, "/images/cc.jpg"));
		 label_61.setText(" ");
		 label_61.setBounds(0, 0, 703, 508);
		 panel.add(label_61);
		//
	}
	public void setButton(boolean add1,boolean modify1,boolean delete1,boolean save1,boolean cancel1)
	{
		 add.setEnabled(add1);
		 modify.setEnabled(modify1);
		 delete.setEnabled(delete1);
		 save.setEnabled(save1);
		 cancel.setEnabled(cancel1);		
	}
	 

	public   void setTextAbled(boolean b) {
		// TODO Auto-generated method stub
		id.setEnabled(b);
		philosophy.setEnabled(b);
		english.setEnabled(b);
		total.setEnabled(b);
		math.setEnabled(b);
		specialty.setEnabled(b);
	}
	
	public void setNull()
	{
		id.setText(null);
	    philosophy.setText(null);
	    english.setText(null);
	    total.setText(null);
	    math.setText(null);
	    specialty.setText(null);
	}
	
	public void setExeType(String type)
	{
		exeType=type;
	}
    public void seeGrade( )
  {
     MarkSortTableFrame mstf=new MarkSortTableFrame();
     
	 mstf.setVisible(true);
	 mstf.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);	 
  }
    public void seeInfo()
    {
    	try{
    	StudentInfoFrame sif=new StudentInfoFrame();
    	sif.setTextAbled(false);
    	sif.setButton(true, true, true, false, false);
    	sif.id.setText(rs.getString("ID"));
		sif.name.setText(rs.getString("Name"));
		sif.sex.setText(rs.getString("Sex"));
		sif.home.setText(rs.getString("Home"));
		sif.cName.setText(rs.getString("Class"));
		sif.ethnic.setText(rs.getString("Ethnic"));
		sif.birth.setText(rs.getString("Birth"));
    	sif.setVisible(true);
    	sif.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
        }catch(Exception e)
        {
        	e.printStackTrace();
        }
    }
}