doctoradvicesearch.java

医院管理系统 压缩包内有比较详尽的安装演示与功能介绍 大家可以放心下载

package src;

import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
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 javax.swing.DefaultComboBoxModel;
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.JTable;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.SpringLayout;
import javax.swing.table.DefaultTableModel;

public class DoctorAdviceSearch extends JPanel {

	private JTextArea textArea_1;
	private JTextArea textArea;
	private JTable table;
	private JTextField textField;
	private JComboBox comboBox;
	private SpringLayout springLayout;
	
	private DefaultTableModel dtm;
	private String[] columnNames={"医嘱代码","病人代码","立嘱医生代码","开医嘱时间","停医嘱时间","停医嘱人"};
	/**
	 * Create the panel
	 */
	public DoctorAdviceSearch() {
		super();
		springLayout = new SpringLayout();
		setLayout(springLayout);

		comboBox = new JComboBox();
		comboBox.addItemListener(new ItemListener() {
			public void itemStateChanged(final ItemEvent e) {
				textField.setText("");
			}
		});
		comboBox.setModel(new DefaultComboBoxModel(new String[] {"病人姓名", "病人代码"}));
		add(comboBox);
		springLayout.putConstraint(SpringLayout.SOUTH, comboBox, 55, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, comboBox, 30, SpringLayout.NORTH, this);

		final JButton button = new JButton();
		button.addMouseListener(new MouseAdapter() {
			public void mouseClicked(final MouseEvent e) {
				int rowcount = dtm.getRowCount() - 1;
				if (rowcount != -1) {
					for (int i = rowcount; i >= 0; i--) {
						dtm.removeRow(i); // 删除Jtable中的所有行
					}
					dtm.setRowCount(0); // 将Jtable中的行数设为零
				}		
				String SelectContent=comboBox.getSelectedItem().toString();
				System.out.println(SelectContent);
				if(SelectContent.equals("病人姓名"))
				{
					String 病人姓名=textField.getText();
					if(病人姓名.equals(""))
					{
						JOptionPane.showMessageDialog(Doctor.frame, "  请输入病人姓名！",
								"注意", JOptionPane.INFORMATION_MESSAGE);
						return;
					}
					System.out.println("病人姓名"+病人姓名+"00000000000");
					String sickNo=GetdocNo(病人姓名);
					System.out.println("docNo="+sickNo);
					String SQL="select Advi_No,Sick_No,Doc_No,Advi_ontime,Advi_outtime,Advi_outpers,Advi_content,Advi_fushu from docAdvice where Sick_No='"+sickNo+"'";
					Search(SQL);
					textField.setText("");
				}
				if(SelectContent.equals("病人代码"))
				{
					String 病人代码=textField.getText();
					if(textField.getText().equals(""))
					{
						JOptionPane.showMessageDialog(Doctor.frame, "  请输入病人代码！",
								"注意", JOptionPane.INFORMATION_MESSAGE);
						return;
					}
					String SQL="select Advi_No,Sick_No,Doc_No,Advi_ontime,Advi_outtime,Advi_outpers,Advi_content,Advi_fushu from docAdvice where Sick_No='"+病人代码+"'";
					System.out.println("病人代码"+病人代码);
					Search(SQL);
					textField.setText("");
				}
			}
		});
		button.setText("查询");
		add(button);
		springLayout.putConstraint(SpringLayout.SOUTH, button, 55, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, button, 0, SpringLayout.NORTH, comboBox);
		springLayout.putConstraint(SpringLayout.EAST, button, 405, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.WEST, button, 325, SpringLayout.WEST, this);

		textField = new JTextField();
		add(textField);
		springLayout.putConstraint(SpringLayout.SOUTH, textField, 55, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, textField, 0, SpringLayout.NORTH, comboBox);
		springLayout.putConstraint(SpringLayout.EAST, textField, 295, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.WEST, textField, 160, SpringLayout.WEST, this);

		final JScrollPane scrollPane = new JScrollPane();
		add(scrollPane);
		springLayout.putConstraint(SpringLayout.EAST, comboBox, 105, SpringLayout.WEST, scrollPane);
		springLayout.putConstraint(SpringLayout.WEST, comboBox, 0, SpringLayout.WEST, scrollPane);
		springLayout.putConstraint(SpringLayout.SOUTH, scrollPane, 135, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, scrollPane, 75, SpringLayout.NORTH, this);

		dtm = new DefaultTableModel(columnNames, 0);
		table = new JTable(dtm);
		scrollPane.setViewportView(table);

		final JLabel label = new JLabel();
		label.setText("医嘱内容");
		add(label);
		springLayout.putConstraint(SpringLayout.SOUTH, label, 30, SpringLayout.SOUTH, scrollPane);
		springLayout.putConstraint(SpringLayout.NORTH, label, 5, SpringLayout.SOUTH, scrollPane);
		springLayout.putConstraint(SpringLayout.EAST, label, 110, SpringLayout.WEST, scrollPane);
		springLayout.putConstraint(SpringLayout.WEST, label, 0, SpringLayout.WEST, scrollPane);

		final JLabel label_1 = new JLabel();
		label_1.setText("附属医嘱");
		add(label_1);
		springLayout.putConstraint(SpringLayout.SOUTH, label_1, 0, SpringLayout.SOUTH, label);
		springLayout.putConstraint(SpringLayout.NORTH, label_1, -25, SpringLayout.SOUTH, label);

		final JScrollPane scrollPane_1 = new JScrollPane();
		add(scrollPane_1);
		springLayout.putConstraint(SpringLayout.EAST, scrollPane, 475, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.WEST, scrollPane, 0, SpringLayout.WEST, scrollPane_1);
		springLayout.putConstraint(SpringLayout.EAST, scrollPane_1, 205, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.WEST, scrollPane_1, 20, SpringLayout.WEST, this);

		textArea = new JTextArea();
		scrollPane_1.setViewportView(textArea);
		textArea.setEditable(false);

		final JScrollPane scrollPane_2 = new JScrollPane();
		add(scrollPane_2);
		springLayout.putConstraint(SpringLayout.EAST, label_1, 115, SpringLayout.WEST, scrollPane_2);
		springLayout.putConstraint(SpringLayout.WEST, label_1, 0, SpringLayout.WEST, scrollPane_2);
		springLayout.putConstraint(SpringLayout.EAST, scrollPane_2, 0, SpringLayout.EAST, scrollPane);
		springLayout.putConstraint(SpringLayout.WEST, scrollPane_2, 285, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.SOUTH, scrollPane_1, 0, SpringLayout.SOUTH, scrollPane_2);
		springLayout.putConstraint(SpringLayout.NORTH, scrollPane_1, 0, SpringLayout.SOUTH, label);
		springLayout.putConstraint(SpringLayout.SOUTH, scrollPane_2, 275, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, scrollPane_2, 0, SpringLayout.SOUTH, label_1);

		textArea_1 = new JTextArea();
		scrollPane_2.setViewportView(textArea_1);
		textArea_1.setEditable(false);
		//
	}
	public void Search(String SQL)
	{
		//+++++++++++++++++++++++
		int rowcount = dtm.getRowCount() - 1;
		if (rowcount != 0) {
			for (int i = rowcount; i >= 0; i--) {
				dtm.removeRow(i); // 删除Jtable中的所有行
			}
			dtm.setRowCount(0); // 将Jtable中的行数设为零
		}
		//+++++++++++++++++++++++	
		Connection conn=null;
	    ResultSet rs=null;
	    int i=1;
	    try{
	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	    }catch(Exception e){
	    System.out.println("Not Found Driver!!!");
	    }
	    try{
	    conn=DriverManager.getConnection("jdbc:odbc:Hospital","","");
	    Statement stmt=conn.createStatement();
	    //按指定的医生名查找docNO
	    rs=stmt.executeQuery(SQL);
	    String[] data = new String[6];
	    while(rs.next())
	    {
	    	i++;
	    	for (int j = 1; j <= 6; j++) {
				data[j - 1] = rs.getString(j); // 取出数据库中的数组装载到数组中
			}
	    	dtm.addRow(data); // 在Jtable中显示取出的数据
	    	textArea.setText(rs.getString(7));
	    	textArea_1.setText(rs.getString(8));
	    }
	    conn.close();
	    }catch(SQLException e){
	       System.out.println("Link Error");
	    }
		//++++++++++++++++++++++++
	    if(i==1)
	    {
	    	JOptionPane.showMessageDialog(Doctor.frame, " 经查询无此人的医嘱！",
					"注意", JOptionPane.INFORMATION_MESSAGE);
	    }
	    //============================
	}
	public String GetdocNo(String sickName)
	{
		String sickNo=null;
		Connection conn=null;
	    ResultSet rs=null;
	    try{
	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	    }catch(Exception e){
	    System.out.println("Not Found Driver!!!");
	    }
	    try{
	    conn=DriverManager.getConnection("jdbc:odbc:Hospital","","");
	    Statement stmt=conn.createStatement();
	    //按指定的医生名查找docNO
	    rs=stmt.executeQuery("select Sick_No from sick where sickName='"+sickName+"'");
	    while(rs.next())
	    {
	    	sickNo=rs.getString(1);  //1代表从数据库中取出第一个字段值
	    }
	    conn.close();
	    }catch(SQLException e){
	       System.out.println("Link Error");
	    }
		return sickNo;
	}
}