medlistsearchy.java

一个很好的医院管理软件

package src;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.GridLayout;
import java.awt.Insets;
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.JButton;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JSplitPane;
import javax.swing.JTabbedPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.SpringLayout;
import javax.swing.table.DefaultTableModel;

public class MedListSearchY extends JPanel {

	private JTable table;
	private JTextField textField;
	private SpringLayout springLayout;
	private DefaultTableModel dtm;
	/**
	 * Create the panel
	 */
	public MedListSearchY() {
		super();
		 final String[] colHeads = { "药品号", "帐户", "帐户余额", "病人姓名", "开药医生", "房间号","床位号"};
		 dtm = new DefaultTableModel(colHeads, 0);
		springLayout = new SpringLayout();
		setLayout(springLayout);

		final JLabel label = new JLabel();
		label.setText("药品号");
		add(label);
		springLayout.putConstraint(SpringLayout.SOUTH, label, 80, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, label, 45, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.EAST, label, 95, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.WEST, label, 30, SpringLayout.WEST, this);

		textField = new JTextField();
		add(textField);
		springLayout.putConstraint(SpringLayout.SOUTH, textField, 0, SpringLayout.SOUTH, label);
		springLayout.putConstraint(SpringLayout.NORTH, textField, 50, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.EAST, textField, 210, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.WEST, textField, 0, SpringLayout.EAST, label);

		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中的行数设为零
				}		
				ResultSet rs=null;  
				 Connection conn=null;  
				 int i=1;
				 String medicalNo=textField.getText();
				 if ((medicalNo == null)||(medicalNo.equals(""))) {
						JOptionPane.showMessageDialog(Doctor.frame, "  请输入药品号！",
								"注意", JOptionPane.ERROR_MESSAGE);
						return;
					}
				 System.out.println("textField"+medicalNo);
				try{
				    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				    }catch(Exception eX){
				    System.out.println("Not Found Driver!!!");
				    }
				    try{
				    conn=DriverManager.getConnection("jdbc:odbc:Hospital","","");
				    Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
				    rs=stmt.executeQuery("select foregift.medicalNo,foregift.accountNO,foregift.need,sick.sickName,doctor.docName,sick.roomNo,sick.bedNo from foregift,sick,doctor where foregift.medicalNo=sick.medicalNo and doctor.docNo=sick.docNo and foregift.medicalNo='"+medicalNo+"'");
				    String[] data = new String[7];
				    while(rs.next())
				    {
				    	i++;
				    	for (int j = 1; j <= 7; j++) {
							data[j - 1] = rs.getString(j); // 取出数据库中的数组装载到数组中
						}
				    	dtm.addRow(data); // 在Jtable中显示取出的数据
				    }
				    if(i==1)
				    {
				    	JOptionPane.showMessageDialog(Doctor.frame, " 查找的药品号不存在！",
								"注意", JOptionPane.ERROR_MESSAGE);
				    }
				    }catch(SQLException eX){
				       System.out.println("Link Error");
				    }
			}
		});
		button.setText("搜索");
		add(button);
		springLayout.putConstraint(SpringLayout.SOUTH, button, 0, SpringLayout.SOUTH, textField);
		springLayout.putConstraint(SpringLayout.NORTH, button, 0, SpringLayout.NORTH, textField);
		springLayout.putConstraint(SpringLayout.EAST, button, 315, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.WEST, button, 235, SpringLayout.WEST, this);

		final JButton button_1 = new JButton();
		button_1.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中的行数设为零
				}		
			}
		});
		button_1.setText("清空列表");
		add(button_1);
		springLayout.putConstraint(SpringLayout.SOUTH, button_1, 0, SpringLayout.SOUTH, button);
		springLayout.putConstraint(SpringLayout.NORTH, button_1, 0, SpringLayout.NORTH, button);
		springLayout.putConstraint(SpringLayout.EAST, button_1, 440, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.WEST, button_1, 345, SpringLayout.WEST, this);

		final JScrollPane scrollPane = new JScrollPane();
		add(scrollPane);
		springLayout.putConstraint(SpringLayout.EAST, scrollPane, -45, SpringLayout.EAST, this);
		springLayout.putConstraint(SpringLayout.WEST, scrollPane, 50, SpringLayout.WEST, this);
		springLayout.putConstraint(SpringLayout.SOUTH, scrollPane, 280, SpringLayout.NORTH, this);
		springLayout.putConstraint(SpringLayout.NORTH, scrollPane, 100, SpringLayout.NORTH, this);

		table = new JTable(dtm);
		scrollPane.setViewportView(table);
		//
	}

}