conecttab.java

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

//连接数据库 读取护士查询，医嘱管理，费用管理中table显示的内容
package src;

import java.sql.*;
import javax.swing.*;
import java.util.*;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;

public class conectTab {
  public static  DefaultTableModel dtm;
  private Vector<String> data;
  private ResultSet rs=null;
  public conectTab(String TName){
    Connection conn=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();
     if(TName=="护士查询"){
       rs=stmt.executeQuery(
       "select distinct bedNo,sickName,medicalNo,content,type,state,startDay,stopDay,doctor.docName from sick,docAdvice,doctor where sick.docNo=doctor.docNo");
       insertTab(9);
       }
     if(TName=="医嘱管理"){
       rs=stmt.executeQuery(
       "select sickName,startDay,adviceNo,content,type,state,doctor.docName,adTime,stopDay,officeNo from docAdvice,sick,doctor,bed where bed.bedNo=sick.bedNo and doctor.docNo=docAdvice.docNo");
        insertTab(10);
      }
     if(TName=="费用管理"){
       rs=stmt.executeQuery(
       "select officeNo,bedNo,sickName,sick.medicalNo,accountNo,hand,cost,leave,need from foregift,sick,room where sick.medicalNo=foregift.medicalNo and sick.roomNo=room.roomNo");
       insertTab(9);
       }
    conn.close();
    }catch(SQLException e){
       System.out.println("Link Error");
    }

 }
 public void insertTab(int num){
    int j=0;
    try{
    while(rs.next()){
      data=new Vector<String>();
      for(int i=1;i<=num;i++) {
       data.add(rs.getString(i));
      }
       dtm.insertRow(j++,data);
     }
    }catch(SQLException e){
       System.out.println("Link Error");
    }
 }
}