opsend.java

很好的东东 本人随便做的 仅供学习之用

package chuyun.operatedata;
import chuyun.form.*;
import java.sql.*;
import java.util.ArrayList;

import chuyun.form.SendForm;
import chuyun.javabeans.*;

import java.sql.*;
import chuyun.operatedata.*;
import java.util.*;
public class Opsend {
	
	private ArrayList temp = new ArrayList ();
	//public Opsend(){}
	//pubic ArrayList
	private ResultSet rs=null;
	private SendForm sd=null;
	 public 	OperateDataBase opdb = new OperateDataBase();
	public Opsend(){
		
		
		
	}
	public ArrayList  querysendBYID(int values) {

		try {

           
			rs = opdb.getMyResultSet("SELECT * from send where orderID="+values);
			 rs.afterLast();
	           			
					while(rs.previous()) {
					 sd=new SendForm();
			sd.setOrderID(rs.getInt(2));
			sd.setSendtime(rs.getString(3));
			sd.setPrincipalID(rs.getInt(4));
			sd.setPrincipal(rs.getString(5));
			sd.setConsignee(rs.getString(6));
			sd.setArrivetime(rs.getString(9));
			sd.setWarehouseID(rs.getInt(11));
			sd.setWarehouse(rs.getString(12));
			temp.add(sd);
					}//if
				}//try

			catch (SQLException ex) {
				ex.printStackTrace();
			}
						
		 catch (Exception ex) {
			//temp3 = null;
			ex.printStackTrace();
		}
		return temp;
	}
	 

}