Note: sun.tools.javac.Main has been deprecated. /TrainingProject/UpdateOrder.jsp:49: Method getcustomer() not found in class Training.Beans.OrderBean. out.print(OrdBean.getcustomer()); ^ 1 error, 1 warning 为什么会有这样的错误?getcustomer方法在OrderBean中是存在,可在jsp调用时说不存在
try{
String strsql = "select * from table1 where OrderNo='" + OrdNo.trim() + "'";
Training.Beans.DataBase DB = new Training.Beans.DataBase();
ResultSet rs = DB.executeQuery(strsql);
if (rs != null) {
this.orderNo = rs.getstring(1);
this.disposeDate = rs.getString(3);
this.deleted = rs.getString(9);
}
else{
this.orderNo = null;
}
}
catch( SQLException e){
this.orderNo=null;
}
}
其中orderNo,orderdate等都是域
我的主要目地是想用这个构造构函数初始化某一张order
可尽管这张单存在,我想返回orderNo这个域结果总是null;
Training.Beans.DataBase 是我写的一个访问mssql的一个Bean
this.orderNo = rs.getstring(1);
this.disposeDate = rs.getString(3);
this.deleted = rs.getString(9);
}
=>
if (rs.next()) {
this.orderNo = rs.getstring(1);
this.disposeDate = rs.getString(3);
this.deleted = rs.getString(9);
}
rs不滚动当然不能get出来
/TrainingProject/UpdateOrder.jsp:49: Method getcustomer() not found in
class Training.Beans.OrderBean.
out.print(OrdBean.getcustomer());
^
1 error, 1 warning
为什么会有这样的错误?getcustomer方法在OrderBean中是存在,可在jsp调用时说不存在
getcustomer()方法根本在这部分就没被调用
import java.sql.*;
import Training.Beans.*;
import java.util.*;
import java.lang.*;
import java.text.SimpleDateFormat;public class OrderBean{
//域(field)
private String orderNo;
private double fee;
private double discount=1;
private String auditing="0";
private String customer;
private String operator;
private String orderDate = "";
private String disposeDate = "";
private String deleted="0"; //Constructors
public OrderBean() throws SQLException {
java.util.Date dt = new java.util.Date();
SimpleDateFormat formatter1 = new SimpleDateFormat("yy-MM-dd hh:mm:ss");
SimpleDateFormat formatter2 = new SimpleDateFormat("yyMMdd");
SimpleDateFormat formatter3 = new SimpleDateFormat("yyMM");
String orderNoHead_yyMMdd = formatter2.format(dt);
String orderNoHead_yyMM = formatter3.format(dt);
String OrdrNo;
String strsql = "SELECT CAST(RIGHT(OrderNo,8)AS int) AS OrderNo FROM goodsorder WHERE LEFT(orderno,6) = '" +
orderNoHead_yyMMdd + "' ORDER BY OrderNo DESC";
try {
Training.Beans.sql_data DBOper = new Training.Beans.sql_data();
ResultSet rs = DBOper.executeQuery(strsql);
if (rs.next())
OrdrNo = orderNoHead_yyMM + String.valueOf(rs.getInt(1) + 1);
else
OrdrNo = orderNoHead_yyMMdd + "000001";
}
catch (Exception e) {
e.printStackTrace();
} this.fee = 0;
this.discount = 0;
this.auditing= "0";
this.customer = "";
this.operator = "";
this.orderDate = new String();
this.disposeDate = new String();
this.deleted= "0";
}
public OrderBean(String OrdNo) {
try{
String strsql = "select * from GoodsOrder where OrderNo='" + OrdNo.trim() + "'";
Training.Beans.sql_data DBOper = new Training.Beans.sql_data();
ResultSet rs = DBOper.executeQuery(strsql);
if (rs.next()) {
this.orderNo = OrdNo;
this.fee = rs.getDouble(4);
this.auditing = rs.getString(6);
this.discount = rs.getDouble(5);
this.customer = rs.getString(7);
this.operator = rs.getString(8);
this.orderDate = rs.getString(2);
this.disposeDate = rs.getString(3);
this.deleted = rs.getString(9);
}
else
this.orderNo = null;
}
catch( SQLException e){
this.orderNo=null;
}
}
//methods for set
public void setorderNo(String OrdNo) {this.orderNo=OrdNo.trim();}
public void setfee(double f) {this.fee = f;}
public void setdiscount(double dis) {this.discount = dis;}
public void setauditing(boolean aud) {
if(aud==true)
this.auditing ="1";
else
this.auditing = "0";
} public void setoperator(String oper) {this.operator = oper;}
public void setOrderDate(String odt) {this.orderDate = odt;}
public void setdisposeDate(String ddt) {this.disposeDate = ddt;}
public void setCustomer(String strCustomer){this.customer=strCustomer;}
public void setdeleted(boolean del) {
if(del==true)
this.deleted = "1";
else
this.deleted="0";
} //method for get
public String getorderNo() {return orderNo;}
public double getfee() {return fee;}
public double getdiscount() {return discount;}
public boolean isauditing() {
if(auditing=="1")
return true;
else
return false;
} public String getoperator() {return operator;}
public String getorderDate() {return orderDate;}
public String getdisposeDate() {return disposeDate;}
public boolean isdeleted() {
if(deleted=="1")
return true;
else
return false;
}
public String getcustomer(){return this.customer;}
public void saveOrder(){
try{
String strsql = null; if (this.orderNo != null) {
strsql ="insert into GoodsOrder(OrderNo,OrderDate,DisposeDate,Fee,Discount" +
",Auditing,Customer,Operator,Deleted)values('" + this.orderNo +
"','" +
this.orderDate + "','" + this.disposeDate + "'," + this.fee + "," +
this.discount + ",'" + this.auditing + "','" + this.customer + "','" +
this.operator + "','" + this.deleted + "')";
Training.Beans.sql_data DBOper = new Training.Beans.sql_data();
DBOper.execute(strsql);
DBOper=null;
}
}
catch(SQLException e){
System.err.println("SQLError");
}
} public void AuditingOrder(String Auditor){
try{
if (this.Auditable(Auditor) == true) {
String strsql = null;
strsql = "update goodsorder set auditing=1 where OrderNo='" +
this.getorderNo() + "'";
Training.Beans.sql_data DBOper = new Training.Beans.sql_data();
DBOper.execute(strsql);
}
}
catch(SQLException e){ }
}
public boolean Auditable(String Auditor){
if (!Auditor.equals(this.operator) && this.isauditing() == false && this.isdeleted()==false) {
return true;
}
return false;
}
public boolean Updateable(String Oper){
if(Oper.equals(this.operator) && this.isauditing() == false && this.isdeleted()==false){
return true;
}
return false;
}
public void UpdateOrder()throws SQLException{
String strsql="update GoodsOrder set DisposeDate='" + this.disposeDate + "'" +
",Fee=" + this.fee +
",Discount=" + this.discount +
",Customer='" + this.customer +"' where OrderNo='" + this.orderNo + "'";
Training.Beans.sql_data DBOper = new Training.Beans.sql_data();
DBOper.execute(strsql);
DBOper=null;
}
public boolean Deletedable(String Oper){
if(Oper.equals(this.operator) && this.isauditing()== false && this.isdeleted()==false){
return true;
}
return false;
}
public void DeleteOrder(String del){
Training.Beans.sql_data DBOper=new Training.Beans.sql_data();
try{
if(this.orderNo!=null && this.Deletedable(del)){
String strsql="Update GoodsOrder set Deleted=1 where OrderNo='" + this.orderNo + "'";
DBOper.execute(strsql);
}
}
catch(SQLException e){
System.err.print("Err");
}
finally{
DBOper=null;
}
}
public Vector getLineitem(){
Vector VLineitem=new Vector();
try{
String strsql = "select * from OrderLineitem where OrderNo='" + this.orderNo.trim() + "'";
Training.Beans.sql_data DBOper = new Training.Beans.sql_data();
ResultSet rs = DBOper.executeQuery(strsql);
while (rs != null && rs.next()) {
Training.Beans.OrderItemBean Orditem = new Training.Beans.OrderItemBean(rs.getString("LineitemNo"));
VLineitem.addElement(Orditem);
}
DBOper = null;
rs = null;
}
catch(SQLException e){
// VLineitem=null;
}
return VLineitem;
}
}这是我的完整源代码,请大家帮我看看,问题出在哪
import java.sql.*;
import Training.Beans.*;
import java.util.*;
import java.lang.*;
import java.text.SimpleDateFormat;public class OrderBean{
//域(field)
private String orderNo;
private double fee;
private double discount=1;
private String auditing="0";
private String customer="";
private String operator="";
private String orderDate = "";
private String disposeDate = "";
private String deleted="0"; //Constructors
public OrderBean() throws SQLException {
java.util.Date dt = new java.util.Date();
SimpleDateFormat formatter1 = new SimpleDateFormat("yy-MM-dd hh:mm:ss");
SimpleDateFormat formatter2 = new SimpleDateFormat("yyMMdd");
SimpleDateFormat formatter3 = new SimpleDateFormat("yyMM");
String orderNoHead_yyMMdd = formatter2.format(dt);
String orderNoHead_yyMM = formatter3.format(dt);
String OrdrNo;
String strsql = "SELECT CAST(RIGHT(OrderNo,8)AS int) AS OrderNo FROM goodsorder WHERE LEFT(orderno,6) = '" +
orderNoHead_yyMMdd + "' ORDER BY OrderNo DESC";
try {
Training.Beans.sql_data DBOper = new Training.Beans.sql_data();
ResultSet rs = DBOper.executeQuery(strsql);
if (rs.next())
OrdrNo = orderNoHead_yyMM + String.valueOf(rs.getInt(1) + 1);
else
OrdrNo = orderNoHead_yyMMdd + "000001";
}
catch (Exception e) {
e.printStackTrace();
} this.fee = 0;
this.discount = 0;
this.auditing= "0";
this.customer = "";
this.operator = "";
this.orderDate = new String();
this.disposeDate = new String();
this.deleted= "0";
}
public OrderBean(String OrdNo) {
try{
String strsql = "select * from GoodsOrder where OrderNo='" + OrdNo.trim() + "'";
Training.Beans.sql_data DBOper = new Training.Beans.sql_data();
ResultSet rs = DBOper.executeQuery(strsql);
if (rs.next()) {
this.orderNo = OrdNo;
this.fee = rs.getDouble(4);
this.auditing = rs.getString(6);
this.discount = rs.getDouble(5);
this.customer = rs.getString(7);
this.operator = rs.getString(8);
this.orderDate = rs.getString(2);
this.disposeDate = rs.getString(3);
this.deleted = rs.getString(9);
}
else
this.orderNo = null;
}
catch( SQLException e){
this.orderNo=null;
}
}
public String getcustomer(){return this.customer;}
我把主要的贴出来吧,其它方法也报同样的错误