buildpayee.java

通过jsp/servlet实现web打印

package bean;

import java.sql.ResultSet;
import java.util.Vector;

public class BuildPayee {
	String payee;

	public String getPayee() {
		return payee;
	}

	public void setPayee(String payee) {
		this.payee = payee;
	}
	public void gainPayee(){
		
		
		
		DBOperate db = new DBOperate();
		String receiver;
		String[] param1 = new String[] {"是"};
		try {
			//db1.setConnection();
			ResultSet rs1 =db.getResult("select * from Print_payee where active=?", param1);
			//db1.setParam(param1);

			//ResultSet rs1 = db1.getResult();
			while (rs1.next()) {
				 receiver=rs1.getString("payee");
				 this.payee=receiver;
			}
			

		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			db.closeConnection();
		}
		
		
		
	}

}