MemFin.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%@ page language = "java" import ="java.text.*, java.sql.*, java.util.ArrayList"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="EUC-KR">
<title>KNU MOVIE_TEAM3</title>
</head>
<body>
<form action = "Mypage_real.jsp" method = "POST">
<%
    String serverIP = "localhost";
    String strSID = "orcl";
    String portNum = "1521";
    String user = "university";
    String pass = "comp322";
    String url = "jdbc:oracle:thin:@"+serverIP+":"+portNum+":"+strSID;

    String last_id = (String)session.getAttribute("memfin_id");
    String sql= "";

    Connection conn = null;
    Statement stmt;
    Class.forName("oracle.jdbc.driver.OracleDriver");
    conn=DriverManager.getConnection(url,user,pass);
 
    try{
    conn.setAutoCommit(false);
    stmt = conn.createStatement();
    sql = "delete from membership where Ac_id = '"+last_id+"'";
    System.out.println(sql);
    ResultSet rs = stmt.executeQuery(sql);
    conn.commit();
    }catch(SQLException ex) {System.out.println(ex.getMessage());}
    finally {
        try {
        	conn.setAutoCommit(false);
    		stmt = conn.createStatement();
            stmt.close();
            conn.close();
          }catch(SQLException ex) {
        }
    }
    session.setAttribute("cus_id", last_id);
    out.println("¸â¹ö½Ê ²÷±â ¿Ï·á");
   %> <br>
   <input type = "submit" value = "Go mypage">
</form>
</body>
</html>