<%@ page contentType="text/html;charset=euc-kr"%> <%@ page import="java.util.*"%> <%@ page import="java.sql.*"%> <%@ page import="bbsComm.*"%> <% Statement st = null; ResultSet rs = null; String sql = null; Connection conn = null; WebCommon WebComm = new WebCommon(); //String [] sa_temp = new String[] { "","","","","","","","","","","","","","","","","","","","","","","","","","","","",""} ; String personNum = request.getParameter("personNum") == null ? "" : request.getParameter("personNum"); String Name = WebComm.uni2Ksc (request.getParameter("Name") == null ? "" : request.getParameter("Name") ); int i =0; Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Properties prop = new Properties(); prop.put("user", "ksd"); prop.put("password", "ksd"); prop.put("databasename", "ksd"); conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433", prop); st = conn.createStatement(); if (!(personNum.equals("") &&Name.equals("") )) { try { //실제 데이터 가져오기 sql = "select 주민번호 , 성명 from admin_helpUser where 주민번호 = '"+personNum+"' and 성명='"+Name+"' "; rs = st.executeQuery(sql); if (!rs.next()) { out.print("") ; } else { sql = " delete FROM admin_helpuser where 주민번호 = '"+personNum+"' and 성명='"+Name+"' "; i = st.executeUpdate(sql); } if(rs!=null) rs.close(); if(st!=null) st.close(); if(conn!=null) conn.close(); } catch(SQLException e) { if(rs!=null) rs.close(); if(st!=null) st.close(); //if(conn!=null) connMgr.freeConnection("scott", conn); if(conn!=null) conn.close(); out.println("SQLException : "+e.toString()); } catch(Exception e) { conn.rollback(); if(rs!=null) rs.close(); if(st!=null) st.close(); //if(conn!=null) connMgr.freeConnection("scott", conn); if(conn!=null) conn.close(); System.out.println("Exception : "+e.toString()); } finally { if(rs!=null) rs.close(); if(st!=null) st.close(); if(conn!=null) conn.close(); } } %> <%if (personNum.equals("") &&Name.equals("") ) {%> <% }else if (i>0) {%> <%}%>

발전 후원회 탈퇴 화면입니다. 성명과 주민등록번호를 입력하여주십시오
주민번호:
성명 :