就语法来说是没有问题,但就意义来说就错了。 String blocksql="select blockid from block where blockname.equals(addblock)"; 上面的这句是sql语句吧?如果是: String blocksql = "select blockid from block where blockname=\"" + addblock + "\"";
aq.executeQuery:[Microsoft][ODBC SQL Server Driver][SQL Server]列名 '333' 无效。改完后怎么有上面这个错误? 333是字段blockname的值
String blocksql = "select blockid from block where blockname='" + addblock + "'";
那看看你的表结构了。 你要查询的是不是符合你的表。比如有没有blickname="333"的内容?
这么来写,试试吧!String blocksql="select blockid from block where blockname.equals('"+addblock+"')";
String blocksql="select blockid from block where blockname.equals('"+addblock+"')";这么写错误提示如下:aq.executeQuery:[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: ')' 附近有语法错误。
String blocksql = "select blockid from block where blockname='" + addblock + "'";这么写错误提示如下: aq.executeQuery:No row count was produced可是这个条件能满足啊where blockname='" + addblock + "'" 其中 String addblock,addbuilding; addblock=(jComboBox1.getSelectedItem()).toString().trim();blockname的类型是char
String blocksql="select blockid from block where blockname.equals(addblock)";
上面的这句是sql语句吧?如果是:
String blocksql = "select blockid from block where blockname=\"" + addblock + "\"";
333是字段blockname的值
你要查询的是不是符合你的表。比如有没有blickname="333"的内容?
aq.executeQuery:No row count was produced可是这个条件能满足啊where blockname='" + addblock + "'"
其中 String addblock,addbuilding;
addblock=(jComboBox1.getSelectedItem()).toString().trim();blockname的类型是char