<%@page import=
"org.jdom2.output.XMLOutputter"
%>
<%@page import=
"org.jdom2.Element"
%>
<%@page import=
"org.jdom2.Document"
%>
<%@page import=
"java.sql.ResultSet"
%>
<%@page import=
"java.sql.PreparedStatement"
%>
<%@page import=
"java.sql.Connection"
%>
<%@page import=
"java.sql.DriverManager"
%>
<%@ page language=
"java"
contentType=
"text/xml; charset=UTF-8"
pageEncoding=
"UTF-8"
trimDirectiveWhitespaces=
"true"
%>
<%
String classify = request.getParameter(
"classify"
);
String user_id = request.getParameter(
"userid"
);
String user_pwd = request.getParameter(
"userpwd"
);
String user_name = request.getParameter(
"username"
);
String user_hp = request.getParameter(
"userhp"
);
String user_email = request.getParameter(
"useremail"
);
String user_birth = request.getParameter(
"userbirth"
);
String user_gender = request.getParameter(
"usergender"
);
String user_mode = request.getParameter(
"usermode"
);
if
(user_id ==
null
)
user_id =
""
;
if
(user_pwd ==
null
)
user_pwd =
""
;
String dbUser =
"test"
;
String dbPwd =
"test"
;
String dbUrl =
"jdbc:oracle:thin:@127.0.0.1:1521"
;
Class.forName(
"oracle.jdbc.driver.OracleDriver"
);
Connection conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
String sql =
"select userid from user_ where userid=?"
;
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, user_id);
ResultSet rs = pstmt.executeQuery();
String rtncode =
""
;
String msg =
""
;
if
(rs.next()) {
rtncode =
"100"
;
msg =
"id 중복"
;
}
else
{
String sql2 =
"insert into user_(userid, userpwd, user_name, user_hp, user_email, user_birth, user_gend, user_div) values(?,?,?,?,?,?,?,?)"
;
PreparedStatement pstmt2 = conn.prepareStatement(sql2);
pstmt2.setString(1, user_id);
pstmt2.setString(2, user_pwd);
pstmt2.setString(3, user_name);
pstmt2.setString(4, user_hp);
pstmt2.setString(5, user_email);
pstmt2.setString(6, user_birth);
pstmt2.setString(7, user_gender);
pstmt2.setString(8, user_mode);
ResultSet rs2 = pstmt2.executeQuery();
rtncode =
"200"
;
msg =
"등록 완료 되었습니다."
;
}
Document document =
new
Document();
Element root =
new
Element(
"join"
);
document.setRootElement(root);
Element element =
new
Element(
"result"
);
element.addContent(rtncode);
root.addContent(element);
element =
new
Element(
"msg"
);
element.addContent(msg);
root.addContent(element);
XMLOutputter outputter =
new
XMLOutputter();
String returnxml = outputter.outputString(document);
%>
<%=returnxml%>