在Mysql中
query = "select sum(bz.Fz) from Kh k,Khbz bz where k.KhbzId=bz.Id and k.KhdxId='" + theuserid + "' and year(k.Khdate)='" + year.ToString() + "' and month(k.Khdate)='" + month.ToString() + "'";
这是sql语句,可以正常执行但是
query = "select sum(k.Xs) from Kh k,Khbz bz where k.KhbzId=bz.Id and k.KhdxId='" + theuserid + "' and year(k.Khdate)='" + year.ToString() + "' and month(k.Khdate)='" + month.ToString() + "'";
却提示有错误query = "select sum(bz.Fz) from Kh k,Khbz bz where k.Khbz.Id=bz.Id and k.Khdx.Id='" + theuserid + "' and year(k.Khdate)='" + year.ToString() + "' and month(k.Khdate)='" + month.ToString() + "'";上面是在hibernate里的语法,可以成功执行。
query = "select sum(k.Xs) from Kh k,Khbz bz where k.Khbz.Id=bz.Id and k.Khdx.Id='" + theuserid + "' and year(k.Khdate)='" + year.ToString() + "' and month(k.Khdate)='" + month.ToString() + "'";
却不能正常运行。
query = "select sum(bz.Fz) from Kh k,Khbz bz where k.KhbzId=bz.Id and k.KhdxId='" + theuserid + "' and year(k.Khdate)='" + year.ToString() + "' and month(k.Khdate)='" + month.ToString() + "'";
这是sql语句,可以正常执行但是
query = "select sum(k.Xs) from Kh k,Khbz bz where k.KhbzId=bz.Id and k.KhdxId='" + theuserid + "' and year(k.Khdate)='" + year.ToString() + "' and month(k.Khdate)='" + month.ToString() + "'";
却提示有错误query = "select sum(bz.Fz) from Kh k,Khbz bz where k.Khbz.Id=bz.Id and k.Khdx.Id='" + theuserid + "' and year(k.Khdate)='" + year.ToString() + "' and month(k.Khdate)='" + month.ToString() + "'";上面是在hibernate里的语法,可以成功执行。
query = "select sum(k.Xs) from Kh k,Khbz bz where k.Khbz.Id=bz.Id and k.Khdx.Id='" + theuserid + "' and year(k.Khdate)='" + year.ToString() + "' and month(k.Khdate)='" + month.ToString() + "'";
却不能正常运行。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货