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