上面的问题解决了,
我有一条sql语句如下:
String sql="select * from DATAK31_FWSQXB,DATAK30_CZCDB";
sql=sql+" and DATAK30_CZZDB.DATAK30_CDBH=DATAK31_FWSQXB.DATAK30_CDBH";
sql=sql+" and DATAK31_FWSQXB.DATAK20_DM='"+name+"'";
sql=sql+" and DATAK31_FWSQXB.DATAK31_QXBZ='1' and DATAK30_CZCDB.DATAK30_CDMK='1'";
vote.executeQuery(sql);
报如下错误:
[Microsoft][ODBC SQL Server Driver][SQL Server]在关键字 'and' 附近有语法错误。
请问大家;错误在哪里????
我有一条sql语句如下:
String sql="select * from DATAK31_FWSQXB,DATAK30_CZCDB";
sql=sql+" and DATAK30_CZZDB.DATAK30_CDBH=DATAK31_FWSQXB.DATAK30_CDBH";
sql=sql+" and DATAK31_FWSQXB.DATAK20_DM='"+name+"'";
sql=sql+" and DATAK31_FWSQXB.DATAK31_QXBZ='1' and DATAK30_CZCDB.DATAK30_CDMK='1'";
vote.executeQuery(sql);
报如下错误:
[Microsoft][ODBC SQL Server Driver][SQL Server]在关键字 'and' 附近有语法错误。
请问大家;错误在哪里????
String name = (String)sess.getAttribute("user");
同理从request里取attribute也是
sql=sql+" where DATAK30_CZZDB.DATAK30_CDBH=DATAK31_FWSQXB.DATAK30_CDBH";
sql=sql+" and DATAK31_FWSQXB.DATAK20_DM='"+name+"'";
sql=sql+" and DATAK31_FWSQXB.DATAK31_QXBZ='1' and DATAK30_CZCDB.DATAK30_CDMK='1'";
vote.executeQuery(sql);
String name=(String)sess.getAttribute();
sql语句缺少where