https://installed.tistory.com/entry/%EC%95%84%EC%9D%B4%EB%94%94-%EC%A4%91%EB%B3%B5-%EC%B2%B4%ED%81%AC%ED%95%98%EA%B8%B0-%EC%98%88%EC%A0%9C package test.db; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBConnection { public static Connection getCon() throws SQLException{ Connection con=null; try{ Class.forName("oracle.jdbc.OracleDriver"); String url="jdbc:oracle:thin:@168.126.146.45:1521:orcl"; con= DriverManager.getConnection("jdbc:oracle:thin:@168.126.146.45:1521:orcl","20182244","990621"); return con; }catch(ClassNotFoundException ce){ System.out.println(ce.getMessage()); return null; } } } #idcheck{ color:red; font-size:10pt; }

회원가입

------------------------------------------------------------------------------------------------- <%@page import="java.io.PrintWriter"%> <%@page import="java.sql.SQLException"%> <%@page import="test.db.DBConnection"%> <%@page import="test.db.DBConnection"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.PreparedStatement"%> <%@page import="java.sql.Connection"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <% String id=request.getParameter("id"); Connection con=null; PreparedStatement pstmt=null; ResultSet rs=null; boolean result=false; try{ con=DBConnection.getCon(); String sql="select * from member where id=?"; pstmt=con.prepareStatement(sql); pstmt.setString(1, id); rs=pstmt.executeQuery(); if(rs.next()){ result=true; } }catch(SQLException se){ System.out.println(se.getMessage()); }finally{ rs.close(); pstmt.close(); con.close(); } response.setContentType("text/xml;charset=euc-kr"); PrintWriter pw=response.getWriter(); pw.println(""); pw.println(""); pw.println("" + result + ""); pw.println(""); pw.close(); %>