⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 userlistservlet.java

📁 关于servlet的很全的例子,对学习servlet很有帮助的,大家
💻 JAVA
字号:
🔍 
package com.allanlxf.serv.basic;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.allanlxf.jdbc.util.ConnectionFactory;
import com.allanlxf.jdbc.util.JdbcUtil;

public class UserListServlet extends HttpServlet
{
    public void doGet(HttpServletRequest request, HttpServletResponse response)
                        throws IOException, ServletException
    {
        Connection con = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        
        try
        {
            con = ConnectionFactory.getConnection();
            String sql = "select * from user_serv";
            ps = con.prepareStatement(sql);
            rs = ps.executeQuery();
            showUsers(response, rs);
        }catch(Exception e)
        {
            e.printStackTrace();
            throw new ServletException(e.getMessage());
        }finally
        {
            JdbcUtil.close(rs, ps, con);
        }        
    }
    
    public void doPost(HttpServletRequest request, HttpServletResponse response)
                        throws IOException, ServletException
    {
        doGet(request, response);
    }
    
    private void showUsers(HttpServletResponse response, ResultSet rs) throws Exception
    {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        out.println("<html>");
        out.println("<head>");
        out.println("<title>list</title>");
        out.println("</head>");
        out.println("<body>");
        out.println("<h3 align=\"center\">all users</h3>");
        out.println("<hr>");
        out.println("<form method=\"post\" action=\"/serv-app/user/register\">");
        out.println("<table border=\"1\" align=\"center\" width=\"80%\" cellpadding=\"5\" cellspacing=\"0\">");
        out.println("<tr>");
        out.println("<th align=\"center\">no</th>");
        out.println("<th align=\"center\">userName</th>");
        out.println("<th>gender</th>");
        out.println("<th align=\"center\">province</th>");
        out.println("<th>hobbies</th>");
        out.println("</tr>");
        int no = 1;
        while(rs.next())
        {
            out.println("<tr>");
            out.println("<td align=\"center\">" + no + "</td>");
            out.println("<td align=\"center\">" + rs.getString("username") + "</td>");
            out.println("<td align=\"center\">" + rs.getString("gender") + "</td>");
            out.println("<td align=\"center\">" + rs.getString("province") + "</td>");
            out.println("<td align=\"center\">" + rs.getString("hobbies") + "</td>");
            out.println("</tr>");
            no++;
        }
        out.println("</table>");
        out.println("<br>");
        out.println("<div align=\"center\">");
        out.println("<a href=\"/serv-app/static/register.html\">register</a>");
        out.println("</div>");
        out.println("</form>");
        out.println("</body>");
        out.println("</html>");
        out.close();
    }
}

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -