OrderItemEntity executeQuery:[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]第 1 行: '=' 附近有语法错误。
源代码: String sql="select id,order_id,product_id,product_num from order_item " +
"where order_id= ? ";
Vector v=new Vector();
ResultSet rs=null;
try{
conn= DriverManager.getConnection(url,"sa","0");
PreparedStatement prepStmt=conn.prepareStatement(sql);
prepStmt.setString(1,orderId);
rs=prepStmt.executeQuery();
}
catch(SQLException ex)
{
System.out.println("OrderItemEntity executeQuery:"+ex.getMessage());
}
while(rs.next())
{
v.add(new OrderItemEntity(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),0));
}
return v;
源代码: String sql="select id,order_id,product_id,product_num from order_item " +
"where order_id= ? ";
Vector v=new Vector();
ResultSet rs=null;
try{
conn= DriverManager.getConnection(url,"sa","0");
PreparedStatement prepStmt=conn.prepareStatement(sql);
prepStmt.setString(1,orderId);
rs=prepStmt.executeQuery();
}
catch(SQLException ex)
{
System.out.println("OrderItemEntity executeQuery:"+ex.getMessage());
}
while(rs.next())
{
v.add(new OrderItemEntity(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),0));
}
return v;
"where order_id= ? ";
你把加号去掉试试呢?