queryget.java

来自「宠物医院管理系统 包含宠物的注册 管理 收费 诊断等一系列过程控制 还包含配应」· Java 代码 · 共 50 行

package yd.pethospital.chargeqerybusiness;

import java.sql.*;
import java.util.*;


import yd.pethospital.chargequery.view.ChargeQueryCondition;
import yd.pethospital.share.SystemShare;

public class QueryGet {
	
	public static  Vector RowData;	
	
	public QueryGet(){
		
		QueryGets();
	}
	
	public void QueryGets(){
		
		try {
			
			SystemShare.SQL="select petcode,chargedate,totalmoney,diagnosedate,inoculatedate,chargeman from ChargeInfo "+ChargeQueryCondition.saveSQL();
			SystemShare.getConnection();
			SystemShare.rs=SystemShare.pst.executeQuery();
			
			RowData=new Vector();
			
			while(SystemShare.rs.next()){
				
				Vector vc=new Vector();
				
				vc.addElement(SystemShare.rs.getString("petcode"));
				vc.addElement(SystemShare.rs.getString("chargedate"));
				vc.addElement(SystemShare.rs.getString("totalmoney"));
				vc.addElement(SystemShare.rs.getString("diagnosedate"));
				vc.addElement(SystemShare.rs.getString("inoculatedate"));
				vc.addElement(SystemShare.rs.getString("chargeman"));
				
				RowData.add(vc);
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		SystemShare.close();
	}
	
}