为什么我的sql更新语句有问题?请赐教!
有以下代码:
String sql="update table2 set '" + number + "'='"+score+"' where 学号='"+ id +"' and 姓名='" + name + "' and 班级='" + grade + "' " ;
try
{
conn=DriverManager.getConnection(connstr);
Statement stmt=conn.createStatement();
rs=stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ ex.getMessage());
}
其中:number ,score为 int;可是执行是抱错,如下:
E:\\JRun\\servers\\default\\default-app\\wangzhan\\xiugai.jsp:161: Error: The type of the left-hand side in this assignment, "java/sql/ResultSet", is not compatible with the type of the right-hand side expression, "int".
请帮帮我!