步骤:0、首先创建web project,工程名:test_servlet1、编写Servlet,TestServlet.java文件内容:package com.ouyang.servlet;import java.io.IOException;import java.sql. ...
步骤:
0、首先创建web project,工程名:test_servlet
1、编写Servlet,TestServlet.java文件内容:
package com.ouyang.servlet;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import javax.servlet.RequestDispatcher;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;@SuppressWarnings("serial")public class TestServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); String url = "jdbc:mysql://localhost:3306/test01"; String user = "root"; String password = "xxx"; Connection connection = null; PreparedStatement preparedStatement = null; ResultSet resultSet = null; String sql = "select id, name, age from individual_information"; List<List<String>> record = new ArrayList<>(); try { Class.forName("com.mysql.jdbc.Driver"); connection = DriverManager.getConnection(url, user, password); preparedStatement = connection.prepareStatement(sql); resultSet = preparedStatement.executeQuery(); List<String> tmp = new ArrayList<>(); while (resultSet.next()) { tmp.add(resultSet.getString("id")); tmp.add(resultSet.getString("name")); tmp.add(resultSet.getString("age")); record.add(new ArrayList<String>(tmp)); tmp.clear(); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } req.setAttribute("individual_information", record); RequestDispatcher requestDispatcher = req .getRequestDispatcher("get_info.jsp"); requestDispatcher.forward(req, resp); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { this.doGet(req, resp); }}
原标题:java servlet练习测试
关键词:JAVA
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。