set_subject.java

用来管理在校学生的出勤．作息等的管理系统

/*
 * @author 黎龙飞 , 创建日期 2008-5-20
 *
 * Blog : http://lilongfei1030.blog.163.com
 */
package stu.view;

import java.awt.Dimension;
import java.awt.Font;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.sql.Connection;
import java.sql.SQLException;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.border.TitledBorder;
import javax.swing.table.TableModel;

import stu.util.ConnectDatabase;
import stu.util.getResults;

public class Set_subject extends JFrame {

	private JTable table;

	private JTextField textField_1;

	private JTextField textField;

	private static final long serialVersionUID = -1458028083212791258L;

	public Set_subject() {
		super();
		setTitle("课程信息设置");
		getContentPane().setLayout(null);
		setBounds(100, 100, 500, 267);
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		setResizable(false);

		final Dimension screen = Toolkit.getDefaultToolkit().getScreenSize();
		final Dimension my = this.getSize();
		setLocationByPlatform(true);
		setLocation((screen.width - my.width) / 2,
				(screen.height - my.height) / 2);
		setVisible(true);

		final JLabel label = new JLabel();
		label.setFont(new Font("", Font.PLAIN, 14));
		label.setText("课程号:");
		label.setBounds(27, 63, 46, 18);
		getContentPane().add(label);

		final JLabel label_1 = new JLabel();
		label_1.setFont(new Font("", Font.PLAIN, 14));
		label_1.setText("课程名:");
		label_1.setBounds(27, 123, 46, 18);
		getContentPane().add(label_1);

		textField = new JTextField();
		textField.setBounds(79, 62, 125, 22);
		getContentPane().add(textField);

		textField_1 = new JTextField();
		textField_1.setBounds(79, 122, 125, 22);
		getContentPane().add(textField_1);

		final JLabel label_2 = new JLabel();
		label_2.setBorder(new TitledBorder(null, "课程信息设置",
				TitledBorder.DEFAULT_JUSTIFICATION,
				TitledBorder.DEFAULT_POSITION, null, null));
		label_2.setBounds(11, 24, 221, 150);
		getContentPane().add(label_2);

		final JScrollPane scrollPane = new JScrollPane();
		scrollPane.setBorder(new TitledBorder(null, "课程表",
				TitledBorder.DEFAULT_JUSTIFICATION,
				TitledBorder.DEFAULT_POSITION, null, null));
		scrollPane.setBounds(249, 24, 221, 150);
		getContentPane().add(scrollPane);

		String sql = "select * from 课程表";
		try {
			TableModel tableModel = new getResults().Results(sql);

			table = new JTable(tableModel);
			scrollPane.setViewportView(table);

			table.addMouseListener(new MouseAdapter() {
				public void mouseClicked(MouseEvent e) {
					int currow = table.getSelectedRow();
					textField.setText((String) table.getValueAt(currow, 0));
					textField_1.setText((String) table.getValueAt(currow, 1));
				}
			});
		} catch (Exception e1) {
			// e1.printStackTrace();
		}

		final JButton button = new JButton();
		button.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				textField.setText("");
				textField_1.setText("");

				TableModel tableModel;
				try {
					tableModel = new getResults().Results("select * from 课程表");
					table = new JTable(tableModel);

					table.addMouseListener(new MouseAdapter() {
						public void mouseClicked(MouseEvent e) {
							int currow = table.getSelectedRow();
							textField.setText((String) table.getValueAt(currow,
									0));
							textField_1.setText((String) table.getValueAt(
									currow, 1));
						}
					});
					scrollPane.setViewportView(table);
				} catch (Exception e1) {
					e1.printStackTrace();
				}
			}
		});
		button.setText("刷新");
		button.setBounds(54, 188, 60, 28);
		getContentPane().add(button);

		final JButton button_1 = new JButton();
		button_1.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				String sql = "delete from 课程表  where  课程号='"
						+ textField.getText().trim() + "'";
				String sql2="delete from 授课关系表 where 课程名='"+textField_1.getText().trim()+"'";
				String sql3="delete from 考勤表 where 课程名='"+textField_1.getText().trim()+"'";
				String sql4="delete from 成绩表 where 课程名='"+textField_1.getText().trim()+"'"; 
				
				Connection con = new ConnectDatabase().getResultString();

				int result = JOptionPane.showOptionDialog(null, "是否删除该课程信息?",
						"系统提示", JOptionPane.YES_NO_OPTION,
						JOptionPane.QUESTION_MESSAGE, null, new String[] { "是",
								"否" }, "否");
				if (result == JOptionPane.OK_OPTION) {
					try {

						con.createStatement().execute(sql);
						con.createStatement().execute(sql2);
						con.createStatement().execute(sql3);
						con.createStatement().execute(sql4);
						// System.out.println("sql = " + sql);
						String infoStr = "删除";
						if (textField.getText().trim().equals(""))
							JOptionPane.showMessageDialog(null, "没有你要"
									+ infoStr + "的数据!!!", "系统提示",
									JOptionPane.INFORMATION_MESSAGE);
						else
							JOptionPane.showMessageDialog(null, infoStr
									+ "数据成功!!!", "系统提示",
									JOptionPane.INFORMATION_MESSAGE);
						textField.setText("");
						textField_1.setText("");

						TableModel tableModel;
						try {
							tableModel = new getResults()
									.Results("select * from 课程表");
							table = new JTable(tableModel);

							scrollPane.setViewportView(table);
						} catch (Exception e1) {
							// e1.printStackTrace();
						}
					} catch (SQLException e1) {
						 //e1.printStackTrace();
					}
				} else {
				}
			}
		});
		button_1.setText("删除");
		button_1.setBounds(144, 188, 60, 28);
		getContentPane().add(button_1);

		final JButton button_2 = new JButton();
		button_2.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {

				String Sub_id = textField.getText();
				String Sub_name = textField_1.getText();
				if (Sub_id.equals(""))
					JOptionPane.showMessageDialog(null, "请输入课程号!", "系统提示",
							JOptionPane.INFORMATION_MESSAGE);
				else if (Sub_name.equals(""))
					JOptionPane.showMessageDialog(null, "请输入课程名!", "系统提示",
							JOptionPane.INFORMATION_MESSAGE);
				else {
					String sql = "insert into 课程表 values ( '" + Sub_id.trim()
							+ "','" + Sub_name.trim() + "')";
					Connection con = new ConnectDatabase().getResultString();
					try {
						con.createStatement().execute(sql);
						// System.out.println("sql = " + sql);
						String infoStr = "添加";
						JOptionPane.showMessageDialog(null,
								infoStr + "数据成功!!!", "系统提示",
								JOptionPane.INFORMATION_MESSAGE);

						textField.setText("");
						textField_1.setText("");

						TableModel tableModel;
						try {
							tableModel = new getResults()
									.Results("select * from 课程表");
							table = new JTable(tableModel);

							table.addMouseListener(new MouseAdapter() {
								public void mouseClicked(MouseEvent e) {
									int currow = table.getSelectedRow();
									textField.setText((String) table
											.getValueAt(currow, 0));
									textField_1.setText((String) table
											.getValueAt(currow, 1));
								}
							});
							scrollPane.setViewportView(table);
						} catch (Exception e1) {
							// e1.printStackTrace();
						}
					} catch (SQLException e2) {

						JOptionPane.showMessageDialog(null, "数据已经存在!!!",
								"系统提示", JOptionPane.WARNING_MESSAGE);
					}
				}
			}
		});
		button_2.setText("添加");
		button_2.setBounds(288, 188, 60, 28);
		getContentPane().add(button_2);

		final JButton button_3 = new JButton();
		button_3.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				dispose();
			}
		});
		button_3.setText("退出");
		button_3.setBounds(379, 188, 60, 28);
		getContentPane().add(button_3);
		//
	}

}