Insert title here

<%@page import="java.text.DecimalFormat"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.PreparedStatement"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ include file="./dbconfig.jsp" %> <% String idx = request.getParameter("idx"); //String sql = "select * from mall_member where midx=?"; //String sql = "select a.*,sum(b.mall_point) as total from mall_member as a join points as b where a.midx=? and a.mall_id=b.mall_id group by b.mall_id"; //view table로 select 한 상황 String sql = "select * from member_info where midx=?"; PreparedStatement ps = dbcon.prepareStatement(sql); ps.setString(1,idx); ResultSet rs = ps.executeQuery(); rs.next(); /* String sql2 = "select sum(mall_point) as total from points where mall_id=?"; ps = dbcon.prepareStatement(sql2); ps.setString(1, rs.getString("mall_id")); ResultSet rs2 = ps.executeQuery(); rs2 = ps.executeQuery(); rs2.next(); */ //상품 구매내역 추가 String sql3 = "select * from pays where mall_id=?"; ps = dbcon.prepareStatement(sql3); ps.setString(1,rs.getString("mall_id")); ResultSet rs3 = ps.executeQuery(); %> Insert title here

개인정보 상세내역

아이디	<%= rs.getString("mall_id") %>
고객명	<%= rs.getString("mall_name") %>
연락처	[<%= rs.getString("tel_corp") %>] <%= rs.getString("tel_no") %>
이메일	<%= rs.getString("mall_email") %>
주소	(<%= rs.getString("mall_post") %>) <%= rs.getString("mall_road") %> <%= rs.getString("mall_addr") %>
광고수신(SMS)	<%= rs.getString("ad_sms") %>
광고수신(email)	<%= rs.getString("ad_email") %>
가입일자	<%= rs.getString("mall_join") %>
포인트(적립금)	<% DecimalFormat df = new DecimalFormat("###,###"); out.print(df.format(rs.getInt("total"))); %>
상품구매 리스트	<% while(rs3.next()){ %> 구매 코드 : <%=rs3.getString("pcode") %> 결제 금액 : <%=rs3.getString("pay_money") %> 결제 일시 : <%=rs3.getString("pay_date") %> <% } %>

<% rs.close(); ps.close(); dbcon.close(); %>