没搞明白 "select type from restruant where foodname='"foodname"'" 这些语句是怎么编译通过的。
String str="insert into V_order_Detail (orderID,foodid,foodname,type,price,number) values('"+orderID+"','"+foodid+"','"+foodname+"','"+type+"','"+price+"','"+number+"')"; temp1=connDB.executeUpdate(str); if(temp1==1){ rs2=connDB.executeQuery("select * from v_order_detail where orderID="+orderID); while(rs2.next()){ orderfoodname=rs2.getString("foodname"); ordernumber=rs2.getInt("number"); type=rs2.getString("type"); rs4=connDB.executeQuery("select tel from restaurant where type='"+type+"'"); if(rs4.next()){ teltel=rs4.getString("tel"); out.println(truename+orderfoodname+teltel); } } 我的代码是这样的,重名的问题数据库里面肯定是不会有的,我现在输出结果饭店名和手机号对应上了,但是不知道为什么,第一个饭店名和手机号会输出两次,而第二个输出一次
String str="insert into V_order_Detail (orderID,foodid,foodname,type,price,number) values('"+orderID+"','"+foodid+"','"+foodname+"','"+type+"','"+price+"','"+number+"')"; temp1=connDB.executeUpdate(str); if(temp1==1){ rs2=connDB.executeQuery("select * from v_order_detail where orderID="+orderID); while(rs2.next()){ orderfoodname=rs2.getString("foodname"); ordernumber=rs2.getInt("number"); type=rs2.getString("type"); rs4=connDB.executeQuery("select * from restaurant where type='"+type+"'"); if(rs4.next()){ teltel=rs4.getString("tel"); out.println(truename+orderfoodname+teltel); } } 代码不清楚,从新上一遍
temp1=connDB.executeUpdate(str);
if(temp1==1){
rs2=connDB.executeQuery("select * from v_order_detail where orderID="+orderID);
while(rs2.next()){
orderfoodname=rs2.getString("foodname");
ordernumber=rs2.getInt("number");
type=rs2.getString("type");
rs4=connDB.executeQuery("select tel from restaurant where type='"+type+"'");
if(rs4.next()){
teltel=rs4.getString("tel");
out.println(truename+orderfoodname+teltel);
}
}
我的代码是这样的,重名的问题数据库里面肯定是不会有的,我现在输出结果饭店名和手机号对应上了,但是不知道为什么,第一个饭店名和手机号会输出两次,而第二个输出一次
temp1=connDB.executeUpdate(str);
if(temp1==1){
rs2=connDB.executeQuery("select * from v_order_detail where orderID="+orderID);
while(rs2.next()){
orderfoodname=rs2.getString("foodname");
ordernumber=rs2.getInt("number");
type=rs2.getString("type");
rs4=connDB.executeQuery("select * from restaurant where type='"+type+"'");
if(rs4.next()){
teltel=rs4.getString("tel");
out.println(truename+orderfoodname+teltel);
}
}
代码不清楚,从新上一遍