<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
Insert title here
<%@ include file="Mini_conn.jsp" %>
<%
String mem_id = request.getParameter("mem_id");
String mem_name = request.getParameter("mem_name");
String mem_pw1 = request.getParameter("mem_pw1");
String mem_pw2 = request.getParameter("mem_pw2");
ResultSet rs = null;
Statement stmt = conn.createStatement();
String sql ="SELECT mem_id FROM member WHERE mem_id = '" + mem_id +"' ";
//
ResultSet rs2 = null;
String sql2 ="INSERT INTO member(mem_id, mem_name, mem_pw)";
sql2 += "VALUES('" + mem_id + "', '" + mem_name + "', '";
sql2 += mem_pw1 + "' )";
//
//rs = stmt.executeQuery(sql);
String mem_id2 ="";
if(mem_id.trim().equals(""))
out.println("");
else if(mem_name.trim().equals(""))
out.println("");
else if(mem_pw1.trim().equals(""))
out.println("");
else if(mem_pw2.trim().equals(""))
out.println("");
else if(mem_pw1.equals(mem_pw2)){
rs = stmt.executeQuery(sql);
while(rs.next()){
mem_id2 = rs.getString("mem_id");
}
if(mem_id.equals(mem_id2))
out.println("");
else if(mem_pw1.equals(mem_pw2)){
stmt.executeUpdate(sql2);
out.println("");
}
else{
out.println("");
stmt.close();
conn.close();
}
}
else
out.println("");
%>