<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="java.io.*" %> <%@ page import="java.sql.*" %> Phone Book Delete <% try{ String name=request.getParameter("name"); System.out.println(name); Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn=DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:xe","hr","1234"); if(conn==null) {System.out.println("DB접속에 실패");} System.out.println("DB접속 성공"); //sql문을 작성해서 conn객체를 이용하여 데이터 베이스에 데이터 가져오기 String sql="select * from phonebook where name=?"; PreparedStatement pstmt=conn.prepareStatement(sql);//위의 sql문을 처리하기 위해 객체 생성 pstmt.setString(1, name); ResultSet rs=pstmt.executeQuery(); if(rs.next()) { %>

Main Menu로 이동

Phone Book 데이터 삭제 하기

disabled type="text" class="form-control" id="no" name="no"> type="hidden" id="no" name="no" >
disabled class="form-control" id="name" name="name">
disabled class="form-control" id="phonenum" name="phonenum">
disabled type="text" class="form-control" id="memo" name="memo">
<%}else{%> <% //response.sendRedirect("print_search.jsp"); } pstmt.close(); conn.close(); }catch(Exception e){} finally{} %>