 |
|
จริงๆต้องแสดงข้อมูลเป็น 2 รายการ แต่มันแสดงแค่รายการเดียว ใจจริงอยากทำเป็น Listview ด้วยคะ ช่วยด้วยนะคะ ขอบคุณคะ
ส่วนของโค๊ด
try {
Connection con = connectionClass.CONN();
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 ";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery( query );
if (rs.next()) {
DeliveryNo = rs.getString( "DeliveryNo" );
BranchCode = rs.getString( "BranchCode" );
OrderID = rs.getString( "OrderID" );
MainTrxNo = rs.getString( "MainTrxNo" );
ShipToID = rs.getString( "ShipToID" );
CustomerID = rs.getString( "CustomerID" );
CustomerName = rs.getString( "CustomerName" );
textView2.setText("DeliveryNo : " + DeliveryNo + " \n" + "BranchCode : " + BranchCode + " \n" + "OrderID : " + OrderID + " \n" + "CustomerID : " + CustomerID + " \n" + "MainTrxNo : " + MainTrxNo + " \n" + "CustomerName : " + CustomerName );
}
} catch (SQLException e) {
e.printStackTrace();
}
หน้าผลลัพธ์

ดาต้าเบส

Tag : Mobile, Ms SQL Server 2005, Ms SQL Server 2008, Ms SQL Server 2012, Android, Mobile
|
ประวัติการแก้ไข 2016-09-21 13:25:44
|
 |
 |
 |
 |
Date :
2016-09-21 13:25:09 |
By :
aummyasia |
View :
1250 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
 |