关于jsp与数据库连接的问题

来源：百度知道 编辑：UC知道 时间：2024/05/25 20:00:34
An error occurred at line: 5 in the jsp file: /s.jsp
The left-hand side of an assignment must be a variable
2: <%@ page language="java" import="java.sql.*" errorPage=""%>
3: <jsp:useBean id="SQEDITBean" scope="page" class="ACFES_Bean.ACFESConnBean"/>
4: <%String date1="";
5: String sql="SELECT * FROM SQBiao WHERE YHM='"sa"'";
6: SQEDITBean.OpenConn();
7: ResultSet rs=SQEDITBean.executeQuery(sql);
第五行到底出了什么问题？虚心请教.

String sql="SELECT * FROM SQBiao WHERE YHM='sa'"; 就可以了，不用加引号

String sql="SELECT * FROM SQBiao WHERE YHM='sa'";
--因为在sql语句中的字符串常量是用单引号''来包括的

String sql="SELECT * FROM SQBiao WHERE YHM='";
sql += sa + "'";

String sql="SELECT * FROM SQBiao WHERE YHM='sa'";