Re: [Help] How to solve this problem(Urgent)
Richard Yee <[email protected]> Fri, 1 Jul 2005 06:49:38 -0700
| Newsgroups | gmane.comp.java.sun.servlet |
|---|---|
| Message-ID | <[email protected]> |
Use a source level debugger in an IDE.
At 08:21 PM 6/30/2005, you wrote:
>Hai,
>
>i have a problem like this. In my result the data not display perfect.
>
>in my suspicion
>1. i have a problem in ResultSet
>2. i have problem in StringBuffer
>
>so i test my suspicion in point 1, i remark inside while loop and i place
>breakpoint after function "Proses_Menampilkan_Data". And i get a Result
>
>but when i test my suspicion in point 2, and i get a data, but not a
>perfect. Because Char "A" never been exist in the output, after that when
>i "view Source" from an IE or Mozilla this Word "A</BODY></HTML>" not
>exist to
>
>how can i solve the problem i need your help guys.
>
>This is my partial Code :
>
> String Buffer sbHasil = new
> StringBuffer("<HTML><BODY>").append(NewLine.CodeBreak());
>
> Proses_Menampilkan_Data(puDisplayPage,out,Con);
>
>
> sbHasil.append("A</BODY></HTML>");
> puDisplayPage.DisplayPage(sbHasil.toString(),out);
>
>private void Proses_Menampilkan_Data(PermanentUse puDisplayPage,
> ServletOutputStream out, Connection Con)
> throws SQLException,IOException{
>PreparedStatement pstmtTransLocker =
>Con.prepareStatement(sbSQLStatement.toString());
>
> ResultSet rsTransLocker = pstmtTransLocker.executeQuery();
>
> while (rsTransLocker.next()){
> String BillingIDData =
>rsTransLocker.getString("A.TransLockerID");
> LastBillingID = Integer.parseInt(BillingIDData);
> String FacilityPrice =
>rsTransLocker.getString("A.FacilityPrice");
> String BillingNo = rsTransLocker.getString("A.TransLockerNo");
> String LockerNo = rsTransLocker.getString("B.LockerNo");
> String LoginName = rsTransLocker.getString("C.LoginName");
> String Date = rsTransLocker.getString("DateOut");
> String Time = rsTransLocker.getString("A.TimeOut");
> String MemberNo = rsTransLocker.getString("A.MemberNo");
> double Discount = 0;
> if (0 == rsTransLocker.getDouble("A.DiscountFasilitasMember")){
> Discount =
>rsTransLocker.getDouble("A.DiscountFasilitasUmum");
> }
> if (0 == rsTransLocker.getDouble("A.DiscountFasilitasUmum")){
> Discount =
>rsTransLocker.getDouble("A.DiscountFasilitasMember");
> }
> double DiscountFBMember =
>rsTransLocker.getDouble("A.DiscountFBMember");
> double DiscountFBUmum =
>rsTransLocker.getDouble("A.DiscountFBPublic");
> double DiscountMassageMember =
>rsTransLocker.getDouble("A.DiscountMassageMember");
> double DiscountMassageUmum =
>rsTransLocker.getDouble("A.DiscountMassagePublic");
> String VoucherNo = rsTransLocker.getString("A.VoucherNo");
> double VoucherPrice = rsTransLocker.getDouble("A.VoucherPrice");
> String FreepassNo = rsTransLocker.getString("A.FreepassNo");
> double FreepassPrice =
>rsTransLocker.getDouble("A.FreepassPrice");
> String PembayaranDengan = rsTransLocker.getString("A.PaidWith");
> String KetPembayaran = rsTransLocker.getString("A.KetPaidWith");
> double Bayar = rsTransLocker.getDouble("A.Payment");
>
>
> StringBuffer sbHasil= new StringBuffer("<TR><TD>");
> sbHasil.append("<INPUT TYPE='CHECKBOX'
>NAME='chkcetakbill").append(counterobj).append("'
>VALUE=1>").append("</TD><TD NOWRAP>");
> sbHasil.append(Date).append("</TD><TD>");
> sbHasil.append(BillingNo).append("</TD>");
>
> GetTransaksiMassage(BillingIDData,Con,out);
>
> GetTransaksiRestoran(BillingIDData,Con,out);
>
> GetTransaksiBar(BillingIDData,Con,out);
>
> GetTransaksiSalon(BillingIDData,Con,out);
>
> sbHasil.append(SubTotal());
> sbHasil.append("<TD><INPUT TYPE='TEXT'
>NAME='cetakbill").append(counterobj).append("'
>VALUE='").append(counterobj).append("'></TD>"); //BillingIDData
> sbHasil.append("</TR>").append(NewLine.CodeBreak());
>
> puDisplayPage.DisplayPage(sbHasil.toString(),out);
> counterobj++;
> sbHasil = new StringBuffer(counterobj);
> puDisplayPage.DisplayPage(sbHasil.toString(),out);
> }
>}
>
>TIA,
>
>Andy Susanto
>
>___________________________________________________________________________
>To unsubscribe, send email to [email protected] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html