大家帮我看一下，为什么不能插入到数据库中呢？？？

stm.executeQuery();
改成：
stm.execute();

解决方案 »

  1.   

    <%@page import="java.util.Date"%>
    <%@page import="java.sql.*"%>
    <html>
    <head>
    <title>insert news</title>
    </head>
    <body><% String remoteAddr=request.getRemoteAddr();
       if (remoteAddr.equals("127.0.0.1"))
        {  
           String news_name=request.getParameter("news_name");
           String title=request.getParameter("title");
           
           if ( (news_name!=null)&&(title!=null))
             {
                try {
                   Date date=new Date();
                   String datetime=" "+(date.getYear()+1900);               
                   Class.forName("org.gjt.mm.mysql.Driver");
                   String url="jdbc:mysql:news";
                   Connection con=DriverManager.getConnection(url,"root","");
                   Statement stmt = con.createStatement();
                   String sql="insert into news values('"+news_name+"','"+datetime+"','"+title+"')";                  
                    try  {
                            stmt.executeQuery(sql);
                          }              
                     catch (Exception e)   { System.out.println("zhi xing cuo wu");  }
                     con.close();
                    }
                 catch (Exception e) { System.out.println("lian jie cuo wu ");  }
                 
    %>
             <jsp:forward page="123.htm" />
    <%        
        }
       else out.println("新闻及标题不能为空");
        
      }
       else out.println("你没有权利添加新闻");
    %>
    </body>
    </html>
      

  2.   

    stm.executeQuery()不对，应该用stm.executeUpdate()