conectmsg.java

一个很好的医院管理软件

//读取数据库中其他模块指定的数据 用String类型的变量接收 加以区分
package src;

import java.sql.*;
import javax.swing.*;

public class conectMsg{
  public static String bedCost,bedNo,medicalNo,sickName,sex,age,diagnoses,birthday,medTime,docName;
  private String bed;

  public conectMsg(String bed){
    this.bed=bed;
  }
  public int check(){
    Connection conn=null;
    ResultSet rs=null;
    int flag=0;
    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();

    rs=stmt.executeQuery("select bedCost,bed.bedNo,medicalNo,sickName,sex,age,diagnoses,birthday,medTime,docName from bed,sick,doctor  where sick.bedNo='"
                          +bed+"' and bed.bedNo='"+bed+"' and doctor.docNo=sick.docNo");
    if(rs.next()){
        bedCost=rs.getString("bedCost");
        bedNo=bed;//rs.getString("bed.bedNo");
        medicalNo=rs.getString("medicalNo");
        sickName=rs.getString("sickName");
        sex=rs.getString("sex");
        age=rs.getString("age");
        diagnoses=rs.getString("diagnoses");
        birthday=rs.getString("birthday");
        medTime=rs.getString("medTime");
        docName=rs.getString("docName");
        flag=1;
      }
    else {
        bedCost=null;
        bedNo=null;
        medicalNo=null;
        sickName=null;
        sex=null;
        age=null;
        diagnoses=null;
        birthday=null;
        medTime=null;
        docName=null;
    }
      conn.close();
    }catch(SQLException e){
       System.out.println("Link Error");
    }
    return flag;
 }
}