关于JSP的MVC模式

想做一个简易购物车搜索商品的时候报错[Microsoft][ODBC SQL Server Driver][SQL Server]列名 'sting' 无效。。。数据库里是有sting的不知道什么原因。。。关键代码如下：

choiceBuy.jsp

<%@ page contentType="text/html;charset=GB2312" %>
<HTML><BODY bgcolor=cyan><center><Font size=3><table>
   <FORM action="HandleSearch" method="get" name="form">
     <br>输入要查找的商品名：
     <INPUT type="text"  name="keyWord" size=6>
     <INPUT type="submit" value="显示" name="submit">
    </FORM></table></font></center> </BODY></HTML>

showSearch.jsp

<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="mybean.data.SearchGoods" %>
<jsp:useBean id="searchInform" type="mybean.data.SearchGoods" scope="session" />
<Center><HTML><BODY bgcolor=pink><Font size=3>
<jsp:getProperty  name= "searchInform"  property="backNews" />
<table border=2><tr> <th>商品</th><th>简介</th><th>价格</th></tr>
  <jsp:getProperty  name= "searchInform"  property="queryResult" />

</table></Center></BODY></HTML>

SearchGoods.java

package mybean.data;

public class SearchGoods {
    String keyWord,backNews;
    StringBuffer queryResult; 剩下的set get就不粘了。。。
}

HandleSearch.java

package myservlet.control;

import mybean.data.SearchGoods;
import java.sql.*;部分import

public class HandleSearch extends HttpServlet {
    public void init(ServletConfig config) throws ServletException
    { super.init(config);
      try {   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          }
       catch(Exception e){}
    }
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        request.setCharacterEncoding("UTF-8");
        String key = request.getParameter("keyWord");
        SearchGoods search = new SearchGoods();
        HttpSession session = request.getSession(true);
        session.setAttribute("searchInform",search);
        StringBuffer str=new StringBuffer();
        Connection con;
        Statement sql;
        ResultSet rs;
        try
        {  con=DriverManager.getConnection("jdbc:odbc:mymoon","","");
            sql=con.createStatement();
            rs = sql.executeQuery("SELECT * FROM goods Where goodsName ="+key+"");
            if(rs.next()){这部分是建表 }
            con.close();
        }
        catch(Exception e){search.setBackNews("fdzvvz"+e);}
        RequestDispatcher dis = request.getRequestDispatcher("showSearch.jsp");
        dis.forward(request, response);
    }
}
期末作业哇。。。求解答~~~~~ --------------------编程问答-------------------- 通篇就没见到sting,还把建表部分给省了，你这样叫人怎样看啊，至少要看到sting是从哪里来，到哪里去吧。 --------------------编程问答--------------------

sting是查找商品的时候放在输入框里面的是数据库表里面的东西 --------------------编程问答-------------------- sting不是列名，只是一条记录，取数据的时候应该用goodsName --------------------编程问答-------------------- 用的是goodsName 搜索sting的时候显示列名错误。。。。。 --------------------编程问答-------------------- '"+key+"' --------------------编程问答-------------------- 有时候不识别这些编码，查询时永id看看。

补充：Java ,  Web 开发