inputcase.java

一个很好的医院管理软件

package src;

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.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Calendar;

import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.SpringLayout;

public class InputCase extends JPanel {

	private JTextArea textField_6;
	private JTextArea textField_4;
	private JTextArea textField_2;
	private JComboBox comboBox;
	private JTextField textField_7;
	private JTextField textField_5;
	private JTextField textField_3;
	private JTextField textField_1;
	private SpringLayout springLayout;
	
	//private ResultSet rs=null;
	//private Connection conn=null;
	/**
	 * Create the panel
	 */
	public InputCase() {
		super();
		springLayout = new SpringLayout();
		setLayout(springLayout);

		final JLabel label = new JLabel();
		label.setText("诊断医生");
		add(label);
		springLayout.putConstraint(SpringLayout.SOUTH, label, 50, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, label, 30, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.EAST, label, 395, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.WEST, label, 220, SpringLayout.WEST, this);

		final JLabel label_1 = new JLabel();
		label_1.setText("诊断日期");
		add(label_1);

		textField_1 = new JTextField();
		add(textField_1);
		springLayout.putConstraint(SpringLayout.SOUTH, textField_1, 85, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, textField_1, 60, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.SOUTH, label_1, -5, SpringLayout.NORTH, textField_1);
		springLayout.putConstraint(SpringLayout.NORTH, label_1, -25, SpringLayout.NORTH, textField_1);
		springLayout.putConstraint(SpringLayout.EAST, label_1, 155, SpringLayout.WEST, textField_1);
		springLayout.putConstraint(SpringLayout.WEST, label_1, 0, SpringLayout.WEST, textField_1);
		springLayout.putConstraint(SpringLayout.EAST, textField_1, -15, SpringLayout.EAST, this);
		springLayout.putConstraint(SpringLayout.WEST, textField_1, 425, SpringLayout.WEST, this);

		final JLabel label_2 = new JLabel();
		label_2.setText("门诊诊断");
		add(label_2);
		springLayout.putConstraint(SpringLayout.EAST, label_2, 385, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.WEST, label_2, 220, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.SOUTH, label_2, 120, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, label_2, 100, SpringLayout.NORTH, this);

		final JLabel label_3 = new JLabel();
		label_3.setText("出院情况");
		add(label_3);
		springLayout.putConstraint(SpringLayout.SOUTH, label_3, 0, SpringLayout.SOUTH, label_2);
		springLayout.putConstraint(SpringLayout.NORTH, label_3, 0, SpringLayout.NORTH, label_2);
		springLayout.putConstraint(SpringLayout.EAST, label_3, 0, SpringLayout.EAST, textField_1);
		springLayout.putConstraint(SpringLayout.WEST, label_3, 0, SpringLayout.WEST, textField_1);

		textField_3 = new JTextField();
		add(textField_3);
		springLayout.putConstraint(SpringLayout.SOUTH, textField_3, 145, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, textField_3, 0, SpringLayout.SOUTH, label_3);
		springLayout.putConstraint(SpringLayout.EAST, textField_3, 0, SpringLayout.EAST, label_3);
		springLayout.putConstraint(SpringLayout.WEST, textField_3, 0, SpringLayout.WEST, label_3);

		final JLabel label_4 = new JLabel();
		label_4.setText("入院诊断");
		add(label_4);
		springLayout.putConstraint(SpringLayout.EAST, label_4, 385, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.WEST, label_4, 220, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.SOUTH, label_4, 190, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, label_4, 165, SpringLayout.NORTH, this);

		final JLabel label_5 = new JLabel();
		label_5.setText("病人姓名");
		add(label_5);
		springLayout.putConstraint(SpringLayout.SOUTH, label_5, 0, SpringLayout.SOUTH, label_4);
		springLayout.putConstraint(SpringLayout.NORTH, label_5, 170, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.EAST, label_5, 0, SpringLayout.EAST, textField_3);
		springLayout.putConstraint(SpringLayout.WEST, label_5, 0, SpringLayout.WEST, textField_3);

		textField_5 = new JTextField();
		add(textField_5);
		springLayout.putConstraint(SpringLayout.SOUTH, textField_5, 215, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, textField_5, 0, SpringLayout.SOUTH, label_5);
		springLayout.putConstraint(SpringLayout.EAST, textField_5, 0, SpringLayout.EAST, label_5);
		springLayout.putConstraint(SpringLayout.WEST, textField_5, 0, SpringLayout.WEST, label_5);

		final JLabel label_6 = new JLabel();
		label_6.setText("病理诊断");
		add(label_6);
		springLayout.putConstraint(SpringLayout.EAST, label_6, 165, SpringLayout.WEST, label_4);
		springLayout.putConstraint(SpringLayout.WEST, label_6, 0, SpringLayout.WEST, label_4);
		springLayout.putConstraint(SpringLayout.SOUTH, label_6, 260, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, label_6, 235, SpringLayout.NORTH, this);

		final JLabel label_7 = new JLabel();
		label_7.setText("病例代码");
		add(label_7);
		springLayout.putConstraint(SpringLayout.SOUTH, label_7, 0, SpringLayout.SOUTH, label_6);
		springLayout.putConstraint(SpringLayout.NORTH, label_7, 0, SpringLayout.NORTH, label_6);
		springLayout.putConstraint(SpringLayout.EAST, label_7, 0, SpringLayout.EAST, textField_5);
		springLayout.putConstraint(SpringLayout.WEST, label_7, 0, SpringLayout.WEST, textField_5);

		textField_7 = new JTextField();
		add(textField_7);
		springLayout.putConstraint(SpringLayout.EAST, textField_7, 0, SpringLayout.EAST, label_7);
		springLayout.putConstraint(SpringLayout.WEST, textField_7, 0, SpringLayout.WEST, label_7);

		final JButton button = new JButton();
		button.addMouseListener(new MouseAdapter() {
			public void mouseClicked(final MouseEvent e) {				
				//判断输入项都不能为空
				if((textField_2.getText()).equals("") ||
						(textField_4.getText()).equals("") ||
						(textField_6.getText()).equals("")
						)
				{
					JOptionPane.showMessageDialog(Doctor.frame,"请输入完整信息","信息校验",JOptionPane.INFORMATION_MESSAGE);
					System.out.println("表格没有填完整");
					return;
				}
				String 诊断医生=(String)comboBox.getSelectedItem();			
				String 诊断日期=textField_1.getText();
				String 门诊诊断=textField_2.getText();
				String 出院情况=textField_3.getText();
				String 入院诊断=textField_4.getText();
				String 病人姓名=textField_5.getText();
				String 病理诊断=textField_6.getText();
				String 病例代码=textField_7.getText();
				if(!isHaveSickName(病人姓名))
				{
					JOptionPane.showMessageDialog(Doctor.frame,"数据库中无‘"+病人姓名+"’的病人信息","信息校验",JOptionPane.INFORMATION_MESSAGE);
					return;
				}
				//++++++++++++++++++++++++++++++++测试输出到控制台+++++++++++++++++++++++++++++++++++++++++
				System.out.print(诊断医生);
				System.out.print(诊断日期);
				System.out.print(门诊诊断);
				System.out.print(出院情况);
				System.out.print(入院诊断);
				System.out.print(病人姓名);
				System.out.print(病理诊断);
				System.out.println(病例代码);
				//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
				ResultSet rs=null;
				Connection conn=null;
				try{
				    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				    }catch(Exception ButtonEX){
				    System.out.println("Not Found Driver!!!");
				    }
				    try{
				    conn=DriverManager.getConnection("jdbc:odbc:Hospital","","");
				    Statement stmt=conn.createStatement();
				    stmt.executeUpdate("insert into sickcase(docName,DateT,clinic,outhosp,inhosp,sickName,pathology,caseID) values('"+诊断医生+"','"+诊断日期+"','"+门诊诊断+"','"+出院情况+"','"+入院诊断+"','"+病人姓名+"','"+病理诊断+"','"+病例代码+"')");
				    JOptionPane.showMessageDialog(Doctor.frame,"如果想继续插入，请重新选择医生?","插入成功!",JOptionPane.INFORMATION_MESSAGE);