tasklist（mysql连接测试）

package com.example.mysql;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class for Servlet: MySqlExample
 * 
 */
public class MySqlExample extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet
{
    static final long serialVersionUID = 1L;

    /*
     * (non-Java-doc)
     * 
     * @see javax.servlet.http.HttpServlet#HttpServlet()
     */
    public MySqlExample()
    {
	super();
    }

    /*
     * (non-Java-doc)
     * 
     * @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request,
     *      HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
    {
	// TODO Auto-generated method stub
	Connection connect = null;
	Statement statement = null;
	PreparedStatement preparedStatement = null;
	ResultSet resultSet = null;
	String sql;
	String op = request.getParameter("op");
	String value = null;
	if (op.equals("add"))
	{
	    value = request.getParameter("value");
	}

	try
	{
	    Class.forName("com.mysql.jdbc.Driver");
	}
	catch (ClassNotFoundException e)
	{
	    // TODO Auto-generated catch block
	    e.printStackTrace();
	}
	try
	{
	    connect = DriverManager.getConnection("jdbc:mysql://localhost/feedback?" + "user=root&password=root");
	}
	catch (SQLException e)
	{
	    // TODO Auto-generated catch block
	    e.printStackTrace();
	}

	if (op.equals("add"))
	{
	    sql = "insert into test(id) values(" + value + ")";
	    try
	    {
		statement = connect.createStatement();
		statement.execute(sql);
		response.getWriter().println("success");
	    }
	    catch (SQLException e)
	    {
		// TODO Auto-generated catch block
		response.getWriter().println("error");
		e.printStackTrace();
	    }
	}
	else {
	    PrintWriter out = response.getWriter();
	    sql = "select * from test";
	    try
	    {
		statement = connect.createStatement();
		resultSet = statement.executeQuery(sql);
		while (resultSet.next()) {
		    out.println(resultSet.getInt("id"));
		}
	    }
	    catch (SQLException e)
	    {
		// TODO Auto-generated catch block
		e.printStackTrace();
	    }
	    
	}
    }

    /*
     * (non-Java-doc)
     * 
     * @see javax.servlet.http.HttpServlet#doPost(HttpServletRequest request,
     *      HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
    {
	// TODO Auto-generated method stub
	doGet(request, response);
    }
}