Servlet工作不正常



我试图从mysql获取数据并使用servlet在浏览器中显示它。下面是我的servlet代码。但是,当我试图执行给定的代码,浏览器打开,但不显示任何东西。我试着改变数据库,表,但没有为我工作。Netbeans也没有给出任何错误

import java.io.*;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
public class Login extends HttpServlet {
       @Override
       public void doGet(HttpServletRequest request, HttpServletResponse response)
                     throws ServletException, IOException
       {

              response.setContentType("text/html");
              PrintWriter out = response.getWriter();        

              Connection con;
              try{
                     Class.forName("com.mysql.jdbc.Driver");
                     con=DriverManager.getConnection("jdbc:mysql://localhost:3306/servlet","root","");               
                     PreparedStatement ps=con.prepareStatement("select * from user");
                     if (con!=null)
                     {
                         out.println("connected");
                  }
                     else{
                         out.println("disconnected");
                     }
                     ResultSet rs=ps.executeQuery();                
                     /* Printing column names */
                     while(rs.next())
                        {
                            out.println(rs.getString(1));
                            out.println(rs.getString(2));
                        }

              }catch (ClassNotFoundException | SQLException e2)
                {
                }
              finally{out.close();
                }
       }
} 

在方法ie的末尾有以下一行。

之前out.close ();
out.flush();

最新更新