201912G05/src\\BA_Control/Add.java

package BA_Control;

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.Statement;

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

public class Add 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 setName = request.getParameter("setName");
			String setYear = request.getParameter("setYear");
			String setScore = request.getParameter("setScore");

			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);

//			Statement stmt = null; // 表示数据库的更新操作
//			stmt = conn.createStatement();

			//添加
			if(!setYear.equals("")) {
				try {
					ps = conn.prepareStatement("insert into line(name,year,score)values(?,?,?)");
					ps.setString(1,setName);
					ps.setString(2,setYear);
					ps.setString(3,setScore);
					ps.executeUpdate();
				} catch (Exception e) {
					out.print("添加出了点问题");
					e.printStackTrace();
				}
			}
			
			conn.close();

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

	}

}