关于访问数据库的

最新推荐文章于 2024-07-22 18:42:29 发布

学生Yahui

最新推荐文章于 2024-07-22 18:42:29 发布

阅读量315

点赞数

文章标签：数据库 string layer list null class

本文链接：https://blog.csdn.net/HANYAHUINO/article/details/6337890

版权

public class han{

public ArrayList<Category> getCategory(String condition)
{
  ArrayList<Category> list=new ArrayList<Category>();

  try{
   con=getConnection();
   pstmt=con.prepareStatement(condition);
   rs=pstmt.executeQuery();
   while(rs.next())
    {//int id=rs.getInt(1);
    String categoryName=rs.getString(0);
    System.out.println(categoryName);
    int parentID=rs.getInt(1);
    int layer=rs.getInt(2);
    String bz=rs.getString(3);
    Category category=new Category();
    //category.setId(id);
    category.setCategoryName(categoryName);
    category.setParentID(parentID);
    category.setLayer(layer);
    category.setBz(bz);
    list.add(category);

    }
   if(rs!=null)rs.close();
   if(pstmt!=null)pstmt.close();
   if(con!=null)con.close();

  }catch(SQLException e)
  {
   e.printStackTrace();

  }
  return list;
}

}

public static void main(String[] args)

{

String condition="select * form category where layer=0";

List h=(list) new han();

h.getCategory(condition);

}

错误是

com.microsoft.sqlserver.jdbc.SQLServerException: 'form' 附近有语法错误。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteQuery(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
at cn.hyh.CategoryDAOImp1.getCategory(CategoryDAOImp1.java:72)
at cn.hyh.CategoryDAOImp1.getCategory(CategoryDAOImp1.java:1)
at org.apache.jsp.Show.categoryList_jsp._jspService(categoryList_jsp.java:70)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)