<%@page language ="java" contentType="text/html; charset=UTF-8"
pageEncoding = "UTF-8" %>
<%@page import ="java.sql.*"%>
<%@page import ="org.json.simple.*" %>
<%@page import ="java.util.ArrayList" %>

<%
        String PWD = request.getParameter("PWD");
        String ID = request.getParameter("ID");
        String host = "jdbc:mysql://localhost:3306/mainDB?useUnicode=true&characterEncoding=utf8";
        String user =
        String pw =
        Connection conn;
        String sql = "select User_No,E_mail_ID from User where PWD=password('"+PWD+"')";
        boolean ok = true;
        PreparedStatement pstmt;
        Statement stmt;
        String DBmsg;
        ResultSet rs;

        try{
                Class.forName("com.mysql.jdbc.Driver");
                conn = DriverManager.getConnection(host,user,pw);
                stmt = conn.createStatement();
                rs = stmt.executeQuery(sql);
                String chkID ="";
                int no=0;
                if(rs.isBeforeFirst()){
                rs.next();
                chkID = rs.getString(2);
                no = rs.getInt(1);
                if(chkID.equals(ID)){
                JSONObject resultObj = new JSONObject();
                resultObj.put("No",no);
                resultObj.put("result","true");

                out.println(resultObj.toJSONString());
                }else out.println("false");
                }else{
                        out.println("not exist ID");
                }
        }catch(Exception e){
                out.println(e.getMessage());
        }
%>