<%
sql="select * from basket where user_name='"+user_name+"' and basket_check=false";
rs=mdb.executeQuery(sql);
while(rs.next())
{
hw_cashs=rs.getString("hw_cash");
hw_cash=Cint(hw_cashs);
basket_count=rs.getString("basket_count");
count=Cint(basket_count);
hw_name=rs.getString("hw_name");
jiage=hw_cash;
%>
为什么sql、rs、"+user_name+"下面都是红线,错误?
sql="select * from basket where user_name='"+user_name+"' and basket_check=false";
rs=mdb.executeQuery(sql);
while(rs.next())
{
hw_cashs=rs.getString("hw_cash");
hw_cash=Cint(hw_cashs);
basket_count=rs.getString("basket_count");
count=Cint(basket_count);
hw_name=rs.getString("hw_name");
jiage=hw_cash;
%>
为什么sql、rs、"+user_name+"下面都是红线,错误?
<jsp:useBean id="mdb" class="ckstudio.db.faq" scope="page"/>
有这个还要定义
JDBC还是建议不要写在JSP页面上 写个工具类 调试也方便