servlet访问数据库

// 注: 在访问数据库的时候需要将数据库的驱动包放在Tomcat工具下的lib包中
// 本例用了JDBC的方式范文数据库
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.util.Properties;
import java.util.logging.Logger;

@WebServlet(urlPatterns = "/testServlet") // 利用servlet3.0的新特性注解方式
public class TestServlet extends HttpServlet { 
   static final String url = "jdbc:mysql://localhost:3306/day04"; // 数据的的访问方式
   static final String user = "root";//数据库名称
   static final String password = "root";//访问数据库密码
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = n