medlist.java

一个很好的医院管理软件

package src;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;


public class MedList extends JPanel {

	private ResultSet rs=null;  
	private Connection conn=null; 
	private JTable table;
	private DefaultTableModel dtm;
	private String[] columnNames={"药品号","病人姓名","开药医生","帐户","帐户余额","房间号","床位号"};
	
	/**
	 * Create the panel
	 */
	public MedList() {
		super();
		setLayout(null);

		final JLabel label = new JLabel();
		label.setIcon(SwingResourceManager.getIcon(MedList.class, "images/125.gif"));
		label.setBounds(548, -10, 68, 71);
		add(label);

		final JLabel label_1 = new JLabel();
		label_1.setText("药品列表");
		label_1.setBounds(15, 20, 100, 23);
		add(label_1);

		final JScrollPane scrollPane = new JScrollPane();
		scrollPane.setBounds(15, 55, 589, 198);
		add(scrollPane);

		dtm = new DefaultTableModel(columnNames, 0);
		table = new JTable(dtm);
		scrollPane.setViewportView(table);
		//
		connToDatabase();
	}
	public void connToDatabase()
	{
		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(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		    rs=stmt.executeQuery("select distinct foregift.medicalNo,sick.sickName,doctor.docName,foregift.accountNO,foregift.need,sick.roomNo,sick.bedNo from foregift,sick,doctor where foregift.medicalNo=sick.medicalNo and doctor.docNo=sick.docNo");
		    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中显示取出的数据
		    }
		    }catch(SQLException e){
		       System.out.println("Link Error");
		    }
	}

}