SELECT c.ITEM_NO, c.item_name, c.NORM, d.name, c.SALES_AMOUNT, c.price, c.BOX_NUMBER, c.WEIGHT, c.VOLUME, c.SUMMARY, item.PRICE as pri
FROM qcy_sales_slip AS b right JOIN qcy_sales_slip_item AS c ON b.id=c.HEADER_ID LEFT JOIN ivt_item_storage as item ON c.ITEM_NO=item.ITEM_NO left JOIN bd_unit AS d ON d.ID=c.UNIT
where c.SALES_AMOUNT>0 AND c.PRICE>0 AND item.WAREHOUSE_ID IN(SELECT ID FROM ivt_warehouse ivt where ivt.BRANCH_ID =1 and ivt.IS_DEFAULT='1') and b.id=40这条sql语句是程序运行后打印出来的,但是在程序中,查询出来的价格(c.price和item.PRICE),都是一样的这是为什么啊?
程序用的是mysql数据库
程序执行方法:
String sql = "SELECT c.ITEM_NO, c.item_name, c.NORM, d.name, c.SALES_AMOUNT, c.price, c.BOX_NUMBER, c.WEIGHT, c.VOLUME, c.SUMMARY, item.PRICE " +
" FROM qcy_sales_slip AS b right JOIN qcy_sales_slip_item AS c ON b.id=c.HEADER_ID " +
" LEFT JOIN ivt_item_storage as item ON c.ITEM_NO=item.ITEM_NO " +
" left JOIN bd_unit AS d ON d.ID=c.UNIT " +
" where c.SALES_AMOUNT>0 AND c.PRICE>0 AND " +
" item.WAREHOUSE_ID IN(SELECT ID FROM ivt_warehouse ivt where ivt.BRANCH_ID ="+pageObject.getBranch().getId()+" and ivt.IS_DEFAULT='1') and b.id=" + pageObject.getId();
List<Object[]> ds = (List<Object[]>) this.getQcySalesSlipDAO().executesqlQuery(sql);调用
public List<Object[]> executesqlQuery(String sql) {
// TODO Auto-generated method stub
return (List<Object[]>)this.createSQLQuery(sql).list();
// executesqlQuery(sql);
}调用
public SQLQuery createSQLQuery(final String sql){
return this.session().createSQLQuery(sql);
}
这是使用Hibernate配置的但是在mysql的工具中查询结果:两个单价是不同的这是为什么啊????????
谢谢啦!!!!!
FROM qcy_sales_slip AS b right JOIN qcy_sales_slip_item AS c ON b.id=c.HEADER_ID LEFT JOIN ivt_item_storage as item ON c.ITEM_NO=item.ITEM_NO left JOIN bd_unit AS d ON d.ID=c.UNIT
where c.SALES_AMOUNT>0 AND c.PRICE>0 AND item.WAREHOUSE_ID IN(SELECT ID FROM ivt_warehouse ivt where ivt.BRANCH_ID =1 and ivt.IS_DEFAULT='1') and b.id=40这条sql语句是程序运行后打印出来的,但是在程序中,查询出来的价格(c.price和item.PRICE),都是一样的这是为什么啊?
程序用的是mysql数据库
程序执行方法:
String sql = "SELECT c.ITEM_NO, c.item_name, c.NORM, d.name, c.SALES_AMOUNT, c.price, c.BOX_NUMBER, c.WEIGHT, c.VOLUME, c.SUMMARY, item.PRICE " +
" FROM qcy_sales_slip AS b right JOIN qcy_sales_slip_item AS c ON b.id=c.HEADER_ID " +
" LEFT JOIN ivt_item_storage as item ON c.ITEM_NO=item.ITEM_NO " +
" left JOIN bd_unit AS d ON d.ID=c.UNIT " +
" where c.SALES_AMOUNT>0 AND c.PRICE>0 AND " +
" item.WAREHOUSE_ID IN(SELECT ID FROM ivt_warehouse ivt where ivt.BRANCH_ID ="+pageObject.getBranch().getId()+" and ivt.IS_DEFAULT='1') and b.id=" + pageObject.getId();
List<Object[]> ds = (List<Object[]>) this.getQcySalesSlipDAO().executesqlQuery(sql);调用
public List<Object[]> executesqlQuery(String sql) {
// TODO Auto-generated method stub
return (List<Object[]>)this.createSQLQuery(sql).list();
// executesqlQuery(sql);
}调用
public SQLQuery createSQLQuery(final String sql){
return this.session().createSQLQuery(sql);
}
这是使用Hibernate配置的但是在mysql的工具中查询结果:两个单价是不同的这是为什么啊????????
谢谢啦!!!!!
解决方案 »
- OcxBean ox = new OcxBean(); ox内存地址如何获得 谢谢
- 发现nutch一个问题,不知道是不是BUG,谁有解决方法?NutchBean.getSummary
- android 音频 大写MID 问题
- 谁告诉我我这hql哪有问题
- 急~~~~求救webservice问题(下午六点前结贴)
- 请教spring学习指南
- 关于hibernate的工具MiddleGen
- java初级问题
- 如果去掉tomcat的启动画面?
- 谁能详细说一下WEBLOGCI中的DataSource和TxDataSource的区别????
- jsp页面输出时间格式转换问题
- 求教各位高人:WARNING: No configuration found for the specified action:
实质就是,程序执行的sql与和mysql工具中执行的相同语句得到的结果集合不同!!