package ch03.section05;

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

import ch03.section03.*;

public class PreparedStatementServlet
    extends HttpServlet {
  String sqlStr;
  static final private String CONTENT_TYPE = "text/html; charset=gb2312";
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();
    HttpSession session = request.getSession();
    //利用數據庫連接池新建一個連接
    DBConnectionManager connMgr = DBConnectionManager.getInstance();
    Connection conn = null;
    conn = connMgr.getConnection("access");
    try {
      String studentName = request.getParameter("studentName");
      //防止亂碼
      studentName = new String(studentName.getBytes("8859_1"), "GB2312");
      String studentAge = request.getParameter("studentAge");
      String studentGrade = request.getParameter("studentGrade");
      String studentID = (String) session.getAttribute("studentID");
      //sql語句
      sqlStr = "update ch03section04 " +
          "set studentName = ? ,studentAge = ?,studentGrade = ? where studentID = ? ";
      if (conn == null) {
        System.out.println("數據庫連接不成功！");
      }
      else {
        //新建PreparedStatement對象
        PreparedStatement updateOp = conn.prepareStatement(sqlStr);
        updateOp.setString(1, studentName);
        updateOp.setInt(2, Integer.parseInt(studentAge));
        updateOp.setFloat(3, Float.parseFloat(studentGrade));
        updateOp.setInt(4, Integer.parseInt(studentID));
        updateOp.executeUpdate();
        //將更新的后的數據顯示給用戶
        response.sendRedirect("../servlet/ch03.section05.DBSelectServlet");
        updateOp.close();
        return;
      }
    }
    catch (Exception ex) {
      System.out.println(ex.toString());
    }
    finally {
      //釋放數據庫連接
      connMgr.freeConnection("access", conn);
    }
  }

  public void doPost(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    doGet(request, response);
  }

  public void destroy() {
  }
}