7.6在hive数据库增加的servlet配置Addser

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet("/addser")
public class Addser extends HttpServlet {
    private static final long serialVersionUID = 1L;

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        List<String> users = new ArrayList<>();
        request.setCharacterEncoding("utf-8");
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter writer = response.getWriter();
        writer.println("插入成功");
        String a = request.getParameter("a");
        String b = request.getParameter("b");
        String c = request.getParameter("c");
        try {
            Class.forName("org.apache.hive.jdbc.HiveDriver");
            // 创建连接
            Connection conn = DriverManager.getConnection("jdbc:hive2://192.168.88.151:10000/itheima", "root", "");
            // 创建SQL执行器
            Statement st = conn.createStatement();
            // 执行SQL语句，得到结果集
            PreparedStatement statement = conn.prepareStatement("INSERT INTO t_2(id,name,age) VALUES (?,?,?)");
            //执行mysql语句
            statement.setString(1, a);
            statement.setString(2, b);
            statement.setString(3, c);
            statement.executeUpdate();
//            String sql ="INSERT INTO t_2 (id,name, age) VALUES ('" + 114+ "', " + 115+ ",'" + 116 + "')";
//
//            st.executeUpdate(sql);

            st.close();
            conn.close();
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
//        request.setAttribute("users", users);
//        request.getRequestDispatcher("index.jsp").forward(request, response);
    }
}