• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

tomcat jsp question to ask

 
albert sie
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
my problem is i have three classes file that all is javabean package file
which is bgoc, common, mrs.
when i run on the tomcat 5.5, error detected on my few of jsp file. the error
detected is like this:
"org.apache.jasper.JasperException: Cannot find any information on property
'EmpName' in a bean of type 'common.InfoBean'"

is it the page cannot get my javabean file? i put the javabean file in the
$CATALINA_HOME$/common/classes is it the right way?
how can i make the system can detect my javabean file?

hope those the expert can give the way to solve this problem.... thank you

regards,
albert
 
Christophe Verré
Sheriff
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Could you please post your jsp:useBean and jsp:getProperty tags ?
(the ones where you are using common.InfoBean)
You may have misstyped EmpName with empName.
 
albert sie
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
<jsp:useBean id="info" class = "common.InfoBean" scope="request"/>
<jsp:getProperty name="info" property="EmpName" />
this is my bean file:
package common;

public class InfoBean {
private String employeeName;
private String onlineMrNo;
private String reqDate;
private String trckDesc;
private String authoriserName;
private String offlineMrNo;

public InfoBean(){}

public String getEmpName(){
return employeeName;
}

public void setEmpName(String employeeName){
this.employeeName = employeeName;
}

public String getAuthoriser(){
return authoriserName;
}

public void setAuthoriser(String authoriserName){
this.authoriserName = authoriserName;
}

public String getTrackDescription(){
return trckDesc;
}

public void setTrackDescription(String trckDesc){
this.trckDesc = trckDesc;
}

public String getReqDate(){
return reqDate;
}

public void setReqDate(String reqDate){
this.reqDate = reqDate;
}

public String getOnlineMR() {
return onlineMrNo;
}

public void setOnlineMr(String onlineMrNo) {
this.onlineMrNo = onlineMrNo;
}

public String getOfflineMR(){
return offlineMrNo;
}
public void setOfflineMR(String offlineMrNo){
this.offlineMrNo = offlineMrNo;
}
}



can you help me to solve out.
another situation all my page i put inside the resin server to run but no such problem occur by using resin server. but the error occur when i using tomcat to run my jsp page. is it something not compatible in tomcat and how to solve it? thank for ur help...

regards,
albert
 
Christophe Verré
Sheriff
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You should access the employee name property via :
<jsp:getProperty name="info" property="empName" />
not
<jsp:getProperty name="info" property="EmpName" />

Try to follow the JavaBeans' naming rules too.
For the sake of readability.
I mean having :
String empName;
String getEmpName();
void setEmpName(String empName);
 
albert sie
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ya, this one solve my problem thank you
but one of my page hav another problem which is:
org.apache.jasper.JasperException: Unable to compile class for JSP

actually what is this error talking about???
 
Christophe Verré
Sheriff
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Could you post the rest of the error message ?
 
albert sie
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i found that three problem of the unable to compile jsp class

that's:An error occurred at line: 219 in the jsp file: /mrs/mr/preview.jsp
Generated servlet error:
The method display_on_mr(String, String, int) in the type dbs_connection is not applicable for the arguments (String, String, int, int, String, String)

An error occurred at line: 219 in the jsp file: /mrs/mr/preview.jsp
Generated servlet error:
The method display_all_on_mr(String, String, String, String) in the type dbs_connection is not applicable for the arguments (String, String, String, String, int, String, String)

An error occurred at line: 290 in the jsp file: /mrs/mr/preview.jsp
Generated servlet error:
The method countForTotalReject(Vector) is undefined for the type dbs_connection

this is my bean file:
package mrs.PrintingManager;
import java.sql.*;
import java.lang.String;
import java.io.*;
import java.util.*;
import java.text.*;

public class dbs_connection{

private Vector group_format_date1 = new Vector();
private Vector group_format_date2 = new Vector();
private Vector group_desc_date = new Vector();
private Vector group_asdesc_date = new Vector();
private Vector group_desc_mr = new Vector();
private Vector group_asdesc_mr = new Vector();

/*****************************************************************************************************************************/
private Vector company = new Vector();
private Vector online = new Vector();
private Vector offline = new Vector();
private Vector sub = new Vector();
private Vector requester = new Vector();
private Vector request_date = new Vector();
private Vector cost = new Vector();
private Vector la = new Vector();
private Vector project = new Vector();

/*****************************************************************************************************************************/
private Vector material = new Vector();
private Vector extra = new Vector();
private Vector quantity =new Vector();
private Vector um =new Vector();
private Vector price = new Vector();
private Vector expect_date = new Vector();
private Vector delivery_date = new Vector();
private Vector purpose = new Vector();
private Vector remark = new Vector();
private Vector store_mat = new Vector();

/*****************************************************************************************************************************/
private Vector approved1 = new Vector();
private Vector approved2 = new Vector();
private Vector approved3 = new Vector();
private Vector bottom = new Vector();

/*****************************************************************************************************************************/

//database connection
public Connection get_connection(){
try{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/mrs";
Connection conn = DriverManager.getConnection(url);
return (conn);
}
catch(Exception e){
System.out.println("Error : " + e.toString() + e.getMessage());
return(null);
}
}

/*****************************************************************************************************************************/

//format asdenc date
public Vector format_date1(){
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String date_format = "SELECT mrh_req_dte FROM mrrqhf WHERE mrh_sts = 'A' GROUP BY mrh_req_dte ORDER BY mrh_req_dte DESC";
ResultSet rs_format_date = stmt.executeQuery(date_format);
String capture_format_date;
while(rs_format_date.next()){
java.util.Date format_date = rs_format_date.getDate("mrh_req_dte");
SimpleDateFormat simple_date = new SimpleDateFormat("dd/MM/yyyy");
capture_format_date = simple_date.format(format_date);
this.group_format_date1.addElement(capture_format_date);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
System.out.println("SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState());
}
return(this.group_format_date1);
}

/*****************************************************************************************************************************/

//retrieve desc date
public Vector date_desc_order(){
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String date_desc = "SELECT mrh_req_dte FROM mrrqhf WHERE mrh_sts = 'A' GROUP BY mrh_req_dte ORDER BY mrh_req_dte DESC";
ResultSet rs_desc_date = stmt.executeQuery(date_desc);
String capture_desc_date;
this.group_desc_date = new Vector();
while(rs_desc_date.next()){
capture_desc_date = rs_desc_date.getString("mrh_req_dte");
this.group_desc_date.addElement(capture_desc_date);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
System.out.println("SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState());
}
return(this.group_desc_date);
}

//retrieve desc MR
public Vector mr_desc_order(){
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String mr_desc = "SELECT mrh_req_num FROM mrrqhf GROUP BY mrh_req_num ORDER BY mrh_req_num DESC";
ResultSet rs_desc_mr = stmt.executeQuery(mr_desc);
String capture_desc_mr;
this.group_desc_mr = new Vector();
while(rs_desc_mr.next()){
capture_desc_mr = rs_desc_mr.getString("mrh_req_num");
this.group_desc_mr.addElement(capture_desc_mr);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
System.out.println("SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState());
}
return(this.group_desc_mr);
}

/*****************************************************************************************************************************/

//2nd part rice
public Vector display_price(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String price = "SELECT mrd_list_prc FROM mrrqdf, mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' ORDER BY mrd_req_ln_num";
ResultSet rs_price = stmt.executeQuery(price);
this.price = new Vector();
while(rs_price.next()){
capture = rs_price.getString("mrd_list_prc");
this.price.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.price);
}
//2nd part elivery date
public Vector display_delivery_date(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String delivery_date = "SELECT mrd_due_dte FROM mrrqdf, mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' ORDER BY mrd_req_ln_num";
ResultSet rs_delivery_date = stmt.executeQuery(delivery_date);
this.delivery_date = new Vector();
while(rs_delivery_date.next()){
java.util.Date del = rs_delivery_date.getDate("mrd_due_dte");
SimpleDateFormat simple2 = new SimpleDateFormat("dd/MM/yyyy");
capture = simple2.format(del);
this.delivery_date.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.delivery_date);
}

//2nd part urpose
public Vector display_purpose(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String purpose = "SELECT mrd_purpose FROM mrrqdf, mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' ORDER BY mrd_req_ln_num";
ResultSet rs_purpose = stmt.executeQuery(purpose);
this.purpose = new Vector();
while(rs_purpose.next()){
capture = rs_purpose.getString("mrd_purpose");
this.purpose.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.purpose);
}

//2nd part:remark
public Vector display_remark(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String remark = "SELECT mrd_rmks FROM mrrqdf, mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' ORDER BY mrd_req_ln_num";
ResultSet rs_remark = stmt.executeQuery(remark);
this.remark = new Vector();
while(rs_remark.next()){
capture = rs_remark.getString("mrd_rmks");
this.remark.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.remark);
}

//2nd part:expected date
public Vector display_expect_date(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String expect_date = "SELECT mrd_delvry_instr FROM mrrqdf, mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts='A' ORDER BY mrd_req_ln_num";
ResultSet rs_expect_date = stmt.executeQuery(expect_date);
this.expect_date = new Vector();
while(rs_expect_date.next()){
capture = rs_expect_date.getString("mrd_delvry_instr");
this.expect_date.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.expect_date);
}

//2nd part:um
public Vector display_um(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String um = "SELECT mrd_um FROM mrrqdf, mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' ORDER BY mrd_req_num";
ResultSet rs_um = stmt.executeQuery(um);
this.um = new Vector();
while(rs_um.next()){
capture = rs_um.getString("mrd_um");
this.um.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.um);
}

//2nd part:extra material
public Vector display_extra(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String extra = "SELECT in_desc_2 FROM mrrqdf, mrrqhf, inmast WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' AND mrd_item_num = in_num ORDER BY mrd_req_ln_num";
ResultSet rs_extra = stmt.executeQuery(extra);
this.extra = new Vector();
while(rs_extra.next()){
capture = rs_extra.getString("in_desc_2");
this.extra.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.extra);
}

//2nd part:quantity
public Vector display_qty(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String qty = "SELECT mrd_qty FROM mrrqhf, mrrqdf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' ORDER BY mrd_req_ln_num";
ResultSet rs_qty = stmt.executeQuery(qty);
this.quantity = new Vector();
while(rs_qty.next()){
capture = rs_qty.getString("mrd_qty");
this.quantity.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.quantity);
}

//2nd part:material
public Vector display_material(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String material = "SELECT in_desc_1 FROM mrrqdf, mrrqhf, inmast WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' AND mrd_item_num = in_num ORDER BY mrd_req_ln_num";
ResultSet rs_material = stmt.executeQuery(material);
this.material = new Vector();
while(rs_material.next()){
capture = rs_material.getString("in_desc_1");
this.material.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.material);
}

/*****************************************************************************************************************************/

//1st part:company name
public String display_company(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String company = "SELECT sdet_alpha_srch FROM mrrqhf, sysdet WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_co_no = sdet_co_no ";
ResultSet rs_company = stmt.executeQuery(company);
while(rs_company.next()){
capture = rs_company.getString("sdet_alpha_srch");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(capture);
}

//1st part ffline Mr
public String display_off_mr(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String offline = "SELECT mrh_mr_num FROM mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' ";
ResultSet rs_offline = stmt.executeQuery(offline);
while(rs_offline.next()){
capture = rs_offline.getString("mrh_mr_num");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//1st part roject description
public String display_proj_desc(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String project = "SELECT ps_desc FROM mrrqhf, poshp WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_proj_cde = ps_cde ";
ResultSet rs_project = stmt.executeQuery(project);
while(rs_project.next()){
capture = rs_project.getString("ps_desc");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//1st part:cost center
public String display_cost(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String cost = "SELECT ps_desc FROM mrrqhf, poshp WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_proj_cde = ps_cde";
ResultSet rs_cost = stmt.executeQuery(cost);
while(rs_cost.next()){
capture = rs_cost.getString("ps_desc");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//1st part:requester
public String display_requester(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String requester = "SELECT em_name FROM mrrqhf, emmast WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_by = em_num";
ResultSet rs_requester = stmt.executeQuery(requester);
while(rs_requester.next()){
capture = rs_requester.getString("em_name");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//1st part:requested date
public String display_req_date(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String request_date = "SELECT mrh_req_dte FROM mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' ";
ResultSet rs_req_date = stmt.executeQuery(request_date);
while(rs_req_date.next()){
java.util.Date req1 = rs_req_date.getDate("mrh_req_dte");
SimpleDateFormat simple = new SimpleDateFormat("dd/MM/yyyy");
capture = simple.format(req1);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//1st part:la no
public String display_la(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String la_no = "SELECT mrh_la_no FROM mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' ";
ResultSet rs_la = stmt.executeQuery(la_no);
while(rs_la.next()){
capture = rs_la.getString("mrh_la_no");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//1st part:sub contractor
public String display_sub(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String sub = "SELECT pv_supl_nme FROM mrrqhf, povend WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_supl_cde = pv_supl_cde ";
ResultSet rs_sub = stmt.executeQuery(sub);
while(rs_sub.next()){
capture = rs_sub.getString("pv_supl_nme");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//1st part nline mr
public Vector display_on_mr(String date1, String date2){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String online = "SELECT mrh_req_num FROM mrrqhf WHERE mrh_sts = 'A' AND mrh_req_dte BETWEEN '"+date1+"' AND '"+date2+"' ORDER BY mrh_req_num ";
ResultSet rs_online = stmt.executeQuery(online);
this.online = new Vector();
while(rs_online.next()){
capture = rs_online.getString("mrh_req_num");
this.online.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (this.online);
}

/*****************************************************************************************************************************/

//request, approved description
public String find1(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String approved = "select dfk_track_desc, em_name, dff_ent_dte from emmast, dftrck, dfdflw, dftran" +
" where dff_track_num != '1' and dff_auth_emp_id = em_num and dft_ref_no = '"+wat+"' and dfk_track_num = dff_track_num and dff_seq_no = dft_ref_no and dff_track_sts = 'A' group by dff_track_num, dff_seq_no";
ResultSet rs_approved1 = stmt.executeQuery(approved);
while(rs_approved1.next()){
capture = rs_approved1.getString("dfk_track_desc");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//approver, request name
public String find2(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String approved = "select dfk_track_desc, em_name, dff_ent_dte from emmast, dftrck, dfdflw, dftran" +
" where dff_track_num != '1' and dff_auth_emp_id = em_num and dft_ref_no = '"+wat+"' and dfk_track_num = dff_track_num and dff_seq_no = dft_ref_no and dff_track_sts = 'A' group by dff_track_num, dff_seq_no";
ResultSet rs_approved2 = stmt.executeQuery(approved);
while(rs_approved2.next()){
capture = rs_approved2.getString("em_name");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//format bottom date
public String format_bottom(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String bot = "select dfk_track_desc, em_name, dff_ent_dte from emmast, dftrck, dfdflw, dftran" +
" where dff_track_num != '1' and dff_auth_emp_id = em_num and dft_ref_no = '"+wat+"' and dfk_track_num = dff_track_num and dff_seq_no = dft_ref_no and dff_track_sts = 'A' group by dff_track_num, dff_seq_no";
ResultSet rs_bottom = stmt.executeQuery(bot);
while(rs_bottom.next()){
java.util.Date bottom_date = rs_bottom.getDate("dff_ent_dte");
SimpleDateFormat simple_bottom = new SimpleDateFormat("dd/MM/yyyy");
capture = simple_bottom.format(bottom_date);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
System.out.println("SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState());
}
return(capture);
}

}
this is the line come out the problem:

get_online = printing.display_on_mr(conditionSelect1,conditionSelect2,condition,curStatus,typeCondition,compemployeeId);
else
get_online = printing.display_all_on_mr(date1,date2,online1,online2,curStatus,typeCondition,compemployeeId);


if(curStatus == 2)// record rejected
countForReject = printing.countForTotalReject(get_online);
else if(curStatus == 5)// record rejected
countForReject = printing.countForTotalReject(get_online);

thank you

regards,
albert
 
albert sie
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i already solve that problem. just the internal problem encounter.
thank you Satou kurinosuke
can u giv me you e-mail and can we be a fren where you come from??
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic