package cn.jl.student.servlet;

import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
import java.io.PrintWriter;

/**
 * Created by IntelliJ IDEA.
 * User: liubing
 * Date: 2008-8-20
 * Time: 18:14:02
 * To change this template use File | Settings | File Templates.
 */
public class StudentDel extends HttpServlet {

    public void doPost(HttpServletRequest request, HttpServletResponse  response){

        response.setContentType("text/html;charset=gbk");
        PrintWriter out = null;
        Context ctx     = null;
        DataSource ds   = null;
        Connection conn = null;
        Statement stmt  = null;

        StringBuffer sqlSb = new StringBuffer();
        String[] delIds = null;

        try{
            out = response.getWriter();

            delIds = request.getParameterValues("delId");

            //連接數(shù)據(jù)庫
            ctx = new InitialContext();
            ds = (DataSource)ctx.lookup("java:comp/env/jdbc/liubdatasource");
            conn = ds.getConnection();
            stmt = conn.createStatement();
            conn.setAutoCommit(false);

            for(int i = 0 ,n = delIds.length ; i < n ; i++){
                sqlSb.append(" delete from studentT where StudentId=" + delIds[i])
                    .append(" delete rom StudentHobbyT where StudentId=" + delIds[i]);
            }

            stmt.executeUpdate(sqlSb.toString());

            conn.commit();

            out.println("<script language='javascript'>");
            out.println("   alert(\"刪除成功！\");");
            out.println("   window.location = \"/stu/StudentList\"; ");
            out.println("</script>");

        } catch (Exception e) {
            try{
                conn.rollback();
            }
            catch(Exception ex){}
            out.println("<script language='javascript'>");
            out.println("   alert(\"刪除失敗！\");");
            out.println("   window.history.back(); ");
            out.println("</script>");
            e.printStackTrace();
        } finally{
            try{
                if(stmt != null) stmt.close();
                if(conn != null) conn.close();
            }
            catch(Exception e){}
        }

    }

}