databaseselect.java

一个很好的医院管理软件

package src;

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

import javax.swing.table.DefaultTableModel;

public class DatabaseSelect {

	/**
	 * @param args
	 */
	 public static  DefaultTableModel dtm;
	  private Vector<String> data;
	  private ResultSet rs=null;
	  public DatabaseSelect(String SQL){
	    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(SQL=="费用管理"){
	       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");
		    }
		 }
	  public Vector<String> getData()
	  {
		  return this.data;
	  }
	  private void setData(int num)
	  {
		  int j=0;
		  try{
			  while(rs.next())
			  {
				  for(int i=1;i<=num;i++)
				  {
					//  this.data=rs.getString(i);
				  }
			  }
		  }catch(Exception EX)
		  {
			  System.out.println("设置数据错误");
		  }
	  }
	public static void main(String[] args) {
		// TODO Auto-generated method stub
	}

}