综合包com amaker导入java sql答案paydaoimpl.pdfVIP

packagecom.amaker.dao.impl;

importjava.sql.Connection;

importjava.sql.PreparedStatement;

importjava.sql.ResultSet;

importjava.sql.SQLException;

importjava.util.ArrayList;

importjava.util.List;

importcom.amaker.dao.PayDao;

importcom.amaker.entity.QueryOrder;

importcom.amaker.entity.QueryOrderDetail;

importcom.amaker.util.DBUtil;

/**

*@author

*DAO

*/

publicclassPayDaoImplimplementsPayDao{

//

publicQueryOrdergetOrderById(intid){

//SQL

Stringsql=selectot.`orderTime`,+

ut.`name`,+

ot.`Num`,+

ot.`tableId`+

fromorderTblasot+

leftjoinuserTblasutonot.`userID`=ut.id+

whereot.`id`=?;

//

DBUtilutil=newDBUtil();

//

Connectionconn=util.openConnection();

try{

//

PreparedStatementpstmt=conn.prepareStatement(sql);

//ò

pstmt.setInt(1,id);

//в

ResultSetrs=pstmt.executeQuery();

//ж

if(rs.next()){

//ö

StringorderTime=rs.getString(1);

StringuserName=rs.getString(2);

intNum=rs.getInt(3);

inttableId=rs.getInt(4);

QueryOrderqo=newQueryOrder();

qo.setName(userName);

qo.setOrderTime(orderTime);

qo.setNum(Num);

qo.setTableId(tableId);

returnqo;

}

}catch(SQLExceptione){

e.printStackTrace();

}finally{

util.closeConn(conn);

}

returnnull;

}

//б

publicListgetOrderDetailList(intid){

//SQL

Stringsql=selectmt.`name`,+

mt.`price