package BA_Control;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

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

public class Delete extends HttpServlet {
	public static final String DBURL = "jdbc:mysql://localhost:3306/kui?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=UTF-8";
	public static final String DBUSER = "root";
	public static final String DBPASS = "001011";
	@Override
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;UTF-8");
		// 输出流
		PrintWriter out = response.getWriter();
		// 数据库连接代码
		try {
			//删除
			String delName = request.getParameter("delName");
			String delYear = request.getParameter("delYear");

			Connection conn = null; // 表示数据库的连接的对象
			PreparedStatement ps = null;

			// 1、使用Class类加载驱动程序
			try {
				Class.forName("com.mysql.jdbc.Driver");
			} catch (ClassNotFoundException e) {
				out.print("找不到driver");
				e.printStackTrace();
			}

			// 2、连接数据库
			conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);

			//添加
			if(!delName.equals("")) {
				try {
					String sql = "delete from line where name =\"" + delName + "\" and year = " + delYear;
					ps = conn.prepareStatement(sql);
					ps.executeUpdate();
				} catch (Exception e) {
					out.print("删除出了点问题");
					e.printStackTrace();
				}
			}
			
			conn.close();

		} catch (Exception e) {
			e.printStackTrace();
		}
			out.flush();
			out.close();

	}

}