帮忙看个JSP页面里的查询语句
sqls= "SELECT price,ticketname,stock,sale FROM tickets as a,prices as b WHERE a.ticketid= "+newticket.getId()+ "and a.ticketid=b.ticketid and b.ticketblock= "+newticket.getTicketbolck()+ " ";
JSP里这样的查数据库语句可以吗，注意WHERE后面的那些 可以查出值吗 引号有没有问题
[解决办法]
没有问题。
只要你的数据类型符合sql标准就行
[解决办法]
SQL里面最后为什么要+ " "?
where的条件值为null怎么办？？？
[解决办法]
有问题的,
sqls= "SELECT price,ticketname,stock,sale FROM tickets as a,prices as b WHERE a.ticketid= "+newticket.getId()+ "and a.ticketid=b.ticketid and b.ticketblock= "+newticket.getTicketbolck()+ " ";
在a.ticketid= "+newticket.getId()+ "and a.ticketid=b.ticketid.
and前面要加个空格.否则就和前面的值连起来了,会报错的.
[解决办法]
楼上说的对,如果不容易看到的话,可以打印sql出来检查一下.比较直观.
[解决办法]
sqls= "SELECT price,ticketname,stock,sale FROM tickets as a,prices as b WHERE a.ticketid= ' "+newticket.getId()+ " ' and a.ticketid=b.ticketid and b.ticketblock= ' "+newticket.getTicketbolck()+ " ' ";
要加空格和 ' ' 这样写就没问题了。
[解决办法]
ticketblock为什么类型，如果为char或者varchar则要用下面的sql
sqls= "SELECT price,ticketname,stock,sale FROM tickets as a,prices as b WHERE a.ticketid= "+newticket.getId()+ "and a.ticketid=b.ticketid and b.ticketblock= ' "+newticket.getTicketbolck()+ " ' ";
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
