showreceiptitem.java

通过jsp/servlet实现web打印

package bean;

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


public class ShowReceiptItem {
	
	public ShowReceiptItem(){}
	
private Vector<Vector> receiptitem = new Vector<Vector>();
private Vector<Vector> receiptpeople = new Vector<Vector>();
	
	public void getReceiptitemData() {
		ResultSetMetaData meta;
		DBOperate db = new DBOperate();
		String[] param2 = new String[] { "1" };
		try {
			this.receiptitem.removeAllElements();
			ResultSet rs2 = db.getResult("select * from Print_item where 1=?",param2);
			meta = rs2.getMetaData();
			while (rs2.next()) {
				Vector<String> Ainfo =new Vector<String>();
	            for(int i = 1 ;i<=meta.getColumnCount();i++){
	            		Ainfo.add(rs2.getString(i));
	                    }
	            receiptitem.add(Ainfo);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			db.closeConnection();
		} 

	}

	public boolean execInsetdata(String parm1,String parm2,String parm3){
		String sql = "insert into Print_item (itemName,itemFee,active) values( '"+parm1+" ', cast('"+parm2+"' as smallmoney),'"+parm3+"' ) ";
		DBOperate dbc = new DBOperate();
	    boolean sussess = dbc.setDataInfo(sql);
	    return sussess;
		
	}
	
	public boolean execSqlUpdata(int id,String rowname,String rowvalue ){
		if(rowname.contains("itemFee")){
			String sql = "UPDATE Print_item SET "+rowname+"=cast('"+rowvalue+"' as smallmoney) where id="+id;
			DBOperate dbc = new DBOperate();
		    boolean sussess = dbc.setDataInfo(sql);
		    return sussess;
			
		}else{
		String sql = "UPDATE Print_item SET "+rowname+"='"+rowvalue+"' where id="+id;
		DBOperate dbc = new DBOperate();
	    boolean sussess = dbc.setDataInfo(sql);
	    return sussess;
		}
		
	}
	
	public boolean execSqlUpdataPay(String peoplename){
		
			String sql = "UPDATE Print_payee SET payee='"+peoplename+"' where id=1";
			DBOperate dbc = new DBOperate();
		    boolean sussess = dbc.setDataInfo(sql);
		    return sussess;
		
	}
	
	public void getPeopleData() {
		ResultSetMetaData meta;
		DBOperate db = new DBOperate();
		String[] param2 = new String[] { "1" };
		try {
			this.receiptpeople.removeAllElements();
			ResultSet rs2 = db.getResult("select * from Print_payee where 1=?",param2);
			meta = rs2.getMetaData();
			while (rs2.next()) {
				Vector<String> pay_people =new Vector<String>();
	            for(int i = 1 ;i<=meta.getColumnCount();i++){
	            		pay_people.add(rs2.getString(i));
	                    }
	            receiptpeople.add(pay_people);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			db.closeConnection();
		} 

	}
	
	public boolean execDelectdata(String id){
			int ids = Integer.valueOf(id);
			String sql = "delete from Print_item where id="+ids;
			DBOperate dbc = new DBOperate();
		    boolean sussess = dbc.setDataInfo(sql);
		    return sussess;
		
	}
	
	public int checkArrayNull(String []parameter){
		if(parameter.equals(null))
			return 0;
		else
			return 1;
		
	}
	public Vector<Vector> getReceiptitem() {
		return receiptitem;
	}


	public void setReceiptitem(Vector<Vector> receiptitem) {
		this.receiptitem = receiptitem;
	}

	public Vector<Vector> getReceiptpeople() {
		return receiptpeople;
	}

	public void setReceiptpeople(Vector<Vector> receiptpeople) {
		this.receiptpeople = receiptpeople;
	}

}