java servlet练习测试

步骤：

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