bbs5/delete.jsp > JSP

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

<%@ include file="/include/header.jsp" %>

<%

String code=request.getParameter("code");

String uid=request.getParameter("uid");

//검색 관련

String field = request.getParameter("field");

String search = request.getParameter("search");

//날짜 관련

int nYear = Integer.parseInt(request.getParameter("nYear"));

int nMonth = Integer.parseInt(request.getParameter("nMonth"));

//디비 삭제

String sql="delete from "+code+" where uid="+uid;

Connection conn=DriverManager.getConnection(url, user, password);

Statement stmt=conn.createStatement();

stmt.executeUpdate(sql);

stmt.close();

conn.close();

%>

<script>

location.href="list.jsp?code=<%=code%>&field=<%=field%>&search=<%=search%>&nYear=<%=nYear%>&nMonth=<%=nMonth%>";

</script>