01.try {
02.
03. Connection con = connectionClass.CONN();
04. String query = "select dbo.CustomerShipToAddress.ContactPerson as CustomerName ,dbo.DeliveryAddress.MainTrxNo as MainTrxNo, dbo.DeliveryAddress.ShipToID as ShipToID, dbo.DeliveryAddress.CustomerID as CustomerID, dbo.DeliveryAddress.OrderID as OrderID , dbo.DeliveryHead.DeliveryNo as DeliveryNo, dbo.DeliveryHead.BranchCode as BranchCode from dbo.DeliveryHead,dbo.DeliveryAddress,dbo.CustomerShipToAddress where dbo.DeliveryHead.MessengerID='" + StaffID + "' and dbo.DeliveryHead.DeliveryNo=dbo.DeliveryAddress.DeliveryNo and dbo.DeliveryHead.BranchCode=dbo.DeliveryAddress.BranchCode and dbo.DeliveryAddress.ShipToID=dbo.CustomerShipToAddress.ShipToID and dbo.DeliveryAddress.CustomerID=dbo.CustomerShipToAddress.CustomerID ";
05. Statement stmt = con.createStatement();
06. ResultSet rs = stmt.executeQuery( query );
07.
08. if (rs.next()) {
09.
10. DeliveryNo = rs.getString( "DeliveryNo" );
11. BranchCode = rs.getString( "BranchCode" );
12. OrderID = rs.getString( "OrderID" );
13. MainTrxNo = rs.getString( "MainTrxNo" );
14. ShipToID = rs.getString( "ShipToID" );
15. CustomerID = rs.getString( "CustomerID" );
16. CustomerName = rs.getString( "CustomerName" );
17. textView2.setText("DeliveryNo : " + DeliveryNo + " \n" + "BranchCode : " + BranchCode + " \n" + "OrderID : " + OrderID + " \n" + "CustomerID : " + CustomerID + " \n" + "MainTrxNo : " + MainTrxNo + " \n" + "CustomerName : " + CustomerName );
18.
19. }
20.
21.
22. } catch (SQLException e) {
23. e.printStackTrace();
24. }
