Java tutorial
import com.nhncorp.psinfra.toolkit.SimpleCryptLib; import java.security.Security; import org.bouncycastle.jce.provider.BouncyCastleProvider; import org.bouncycastle.util.encoders.Hex; import java.net.*; import java.io.*; import javax.xml.parsers.*; import java.util.*; import org.xml.sax.InputSource; import org.w3c.dom.NodeList; import java.io.File; import java.io.FileOutputStream; import java.io.InputStream; import java.io.InputStreamReader; import java.io.OutputStream; import java.io.OutputStreamWriter; import java.io.Writer; import java.net.HttpURLConnection; import java.net.URL; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Types; import java.text.SimpleDateFormat; import java.util.List; import java.util.Properties; import java.sql.CallableStatement; import org.jdom.Document; import org.jdom.Element; import org.jdom.Namespace; import org.jdom.input.SAXBuilder; import org.jdom.output.Format; import org.jdom.output.XMLOutputter; import oracle.jdbc.*; import oracle.sql.*; import javax.sql.*; public class NaverCheckOutGetOrder { public static Connection conn = null; private String ORADriver = ""; private String ORAURL = ""; private String ORAUser = ""; private String ORAPass = ""; public void init() { try { //ORADriver = dbProps.getProperty("B2CDB1.ORADriver"); ORADriver = "oracle.jdbc.driver.OracleDriver"; ORAURL = "jdbc:oracle:thin:@10.125.10.128:1521:B2CDB1"; //b2c ORAUser = "KTC_B2C"; ORAPass = "KTC_B2C123"; //Class.forName(ORADriver); Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection(ORAURL, ORAUser, ORAPass); conn.setAutoCommit(false); } catch (Exception e) { System.out.println("init() : " + e.getMessage()); } } public void distroy() { try { this.conn.close(); } catch (Exception e) { System.out.println("distroy() : " + e.getMessage()); } finally { } } private String getFilePrefix() { String result = ""; java.util.Date today = new java.util.Date(); long currDate = today.getTime(); //long addDate = currDate - (24 * (60 * (60 * 1000))); long addDate = currDate; today.setTime(addDate); SimpleDateFormat dateForm = new SimpleDateFormat("yyyyMMdd"); result = dateForm.format(today); //result = "20090912"; return result; } private String getToday() { String result = ""; java.util.Date today = new java.util.Date(); long currDate = today.getTime(); //long addDate = currDate - (24 * (60 * (60 * 1000))); long addDate = currDate - (9 * (60 * (60 * 1000))); // -9 . today.setTime(addDate); SimpleDateFormat dateForm = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'"); result = dateForm.format(today); //result = "2009-09-12"; return result; } private String getYesterday() { String result = ""; java.util.Date today = new java.util.Date(); long currDate = today.getTime(); //long addDate = currDate - (9 * (60 * (61 * 1000))) ; //10 -9 . long addDate = currDate - (33 * (60 * (60 * 1000))) + 1; //10 -9 . //long addDate = currDate; today.setTime(addDate); SimpleDateFormat dateForm = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'"); result = dateForm.format(today); //result = "2009-09-12"; return result; } private String getElementData(Element e, String name) { return getElementData(e, name, ""); } private String getElementData(Element e, String name, String def) { if (e == null) return def; if (name == null) return def; Element tmp = e.getChild(name); if (tmp == null) return def; String retData = tmp.getTextTrim(); if (retData == null) return def; return retData; } private String getTel(String def) { String tel_no = ""; if (def.length() < 10) { tel_no = def.substring(0, 2) + "-" + def.substring(2, 5) + "-" + def.substring(5, 9); } else if (def.length() < 11) { if (def.substring(0, 2).equals("02")) { tel_no = def.substring(0, 2) + "-" + def.substring(2, 6) + "-" + def.substring(6, 10); } else { tel_no = def.substring(0, 3) + "-" + def.substring(3, 6) + "-" + def.substring(6, 10); } } else if (def.length() < 12) { tel_no = def.substring(0, 3) + "-" + def.substring(3, 7) + "-" + def.substring(7, 11); } return tel_no; } private String run2(String OrderID) { String response_type = ""; try { SimpleCryptLib SimpleCryptLib = new SimpleCryptLib(); Security.addProvider(new BouncyCastleProvider()); String accessLicense = "0100010000a3a4a4365b74db9433a0971c8f85f2de07661a6338b6bb9c2155a2fc892d4ff5"; String secretKey = "AQABAADe1F8bpQsO4ORdqfzpIj2Fl5YwstWww9JGEUNLxU78Dg=="; String serviceName = "MallService2"; String id = "wjsgnsvy"; String password = "jhp1229"; String timestamp = null; String signature = null; String data = null; byte[] encryptKey = null; String encryptedData = null; String decryptedData = null; String hashedData = null; String operationName = "PlaceOrder"; //timestamp create timestamp = SimpleCryptLib.getTimestamp(); //generateSign data = timestamp + serviceName + operationName; signature = SimpleCryptLib.generateSign(data, secretKey); //generateKey encryptKey = SimpleCryptLib.generateKey(timestamp, secretKey); //encrypt encryptedData = SimpleCryptLib.encrypt(encryptKey, password.getBytes("UTF-8")); //decrypt decryptedData = new String(SimpleCryptLib.decrypt(encryptKey, encryptedData), "UTF-8"); //sha256 hashedData = SimpleCryptLib.sha256(password); NaverCheckOutGetOrder NaverCheckOutGetOrder = new NaverCheckOutGetOrder(); String orderlist = "<soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:mall=\"http://mall.checkout.platform.nhncorp.com/\" xmlns:base=\"http://base.checkout.platform.nhncorp.com/\">" + "<soapenv:Header/>" + "<soapenv:Body>" + "<mall:PlaceOrderRequest>" + "<base:RequestID>?</base:RequestID>" + "<base:AccessCredentials>" + "<base:AccessLicense>" + accessLicense + "</base:AccessLicense>" + "<base:Timestamp>" + timestamp + "</base:Timestamp>" + "<base:Signature>" + signature + "</base:Signature>" + "</base:AccessCredentials>" + "<base:DetailLevel>Full</base:DetailLevel>" + "<base:Version>2.0</base:Version>" + "<base:OrderID>" + OrderID + "</base:OrderID>" + "</mall:PlaceOrderRequest>" + "</soapenv:Body>" + "</soapenv:Envelope>"; System.out.println("OrderID:**********" + OrderID + "**********"); //Create socket //String hostname = "ec.api.naver.com"; String hostname = "api.naver.com"; int port = 80; InetAddress addr = InetAddress.getByName(hostname); Socket sock = new Socket(addr, port); //Send header String path = "/Checkout/MallService2"; BufferedWriter wr = new BufferedWriter(new OutputStreamWriter(sock.getOutputStream(), "UTF-8")); // You can use "UTF8" for compatibility with the Microsoft virtual machine. wr.write("POST " + path + " HTTP/1.0 \r\n"); wr.write("Host: api.naver.com \r\n"); wr.write("Content-Length: " + orderlist.length() + "\r\n"); wr.write("Content-Type: text/xml; charset=\"UTF-8\"\r\n"); wr.write("SOAPAction: \"http://api.naver.com/Checkout/MallService2\" \r\n"); wr.write("\r\n"); //Send data wr.write(orderlist); System.out.println("orderlist:" + orderlist); wr.flush(); // Response BufferedReader rd = new BufferedReader(new InputStreamReader(sock.getInputStream(), "UTF-8")); String line = ""; String line_total = ""; String tmp = ""; String tmp2 = ""; String newxml = ""; while ((line = rd.readLine()) != null) { if (line.startsWith("<?xml")) { line_total = line_total + line; } } line_total = line_total.replaceAll("n1:", ""); System.out.println(line_total); //xml2 InputStream in = new ByteArrayInputStream(line_total.getBytes("UTF-8")); SAXBuilder builder = new SAXBuilder(); Document document = builder.build(in); Element element = document.getRootElement(); List envel_list = element.getChildren(); List body_list = null; List body_list1 = null; List result_list = null; List result_list1 = null; List result_list2 = null; List result_list3 = null; List result_list4 = null; List result_list5 = null; List info_list = null; List contr_group_list = null; List contr_info_list = null; PreparedStatement pstmt = null; ResultSet rs = null; CallableStatement cStmt = null; System.out.println("DBconnect"); //conn.setAutoCommit(false); long UNIT_ID = 0; long cnt = 0; long interface_seq = 0; long DEL_QTY = 0; long ITEM_ID = 0; String ITEM_NAME = null; System.out.println("envel_list.size:" + envel_list.size()); Element envel_el = (Element) envel_list.get(0); body_list = envel_el.getChildren(); System.out.println("+++++++el.getName() : " + envel_el.getChildren()); System.out.println("body_list.size:" + body_list.size()); Element body_el = (Element) body_list.get(0); response_type = body_el.getChildText("ResponseType"); System.out.println("response_type:" + response_type); String Error = body_el.getChildText("Error"); System.out.println("Error:" + Error); String QuotaStatus = body_el.getChildText("QuotaStatus"); System.out.println("QuotaStatus:" + QuotaStatus); } catch (Exception e) { System.out.println("run() : " + e.getMessage()); } finally { } System.out.println("FINAL response_type:" + response_type); return response_type; } public String run() { String response_type = "FALSE"; try { SimpleCryptLib SimpleCryptLib = new SimpleCryptLib(); Security.addProvider(new BouncyCastleProvider()); // String accessLicense = "0100010000ccc831f99d7d2523deadf954c8459d6b671b20006e221f64c45dea503be632be"; // String secretKey = "AQABAACDZOhE97kLH8iavhKiQCHbCGlfQfqCSGRxDlAV6uddcg=="; String accessLicense = "0100010000a3a4a4365b74db9433a0971c8f85f2de07661a6338b6bb9c2155a2fc892d4ff5"; String secretKey = "AQABAADe1F8bpQsO4ORdqfzpIj2Fl5YwstWww9JGEUNLxU78Dg=="; String serviceName = "MallService2"; String id = "wjsgnsvy"; String password = "jhp1229"; String timestamp = null; String signature = null; String data = null; byte[] encryptKey = null; String encryptedData = null; String decryptedData = null; String hashedData = null; String operationName = "GetPaidOrderList"; //String orderID = "200087036"; //timestamp create timestamp = SimpleCryptLib.getTimestamp(); System.out.println("timestamp:" + timestamp); //generateSign data = timestamp + serviceName + operationName; signature = SimpleCryptLib.generateSign(data, secretKey); //generateKey encryptKey = SimpleCryptLib.generateKey(timestamp, secretKey); //encrypt encryptedData = SimpleCryptLib.encrypt(encryptKey, password.getBytes("UTF-8")); //decrypt decryptedData = new String(SimpleCryptLib.decrypt(encryptKey, encryptedData), "UTF-8"); //sha256 hashedData = SimpleCryptLib.sha256(password); NaverCheckOutGetOrder NaverCheckOutGetOrder = new NaverCheckOutGetOrder(); System.out.println("NaverCheckOutGetOrder.getYesterday():" + NaverCheckOutGetOrder.getYesterday()); System.out.println("NaverCheckOutGetOrder.getYesterday():" + NaverCheckOutGetOrder.getToday()); System.out.println("accessLicense : [" + accessLicense + "]"); System.out.println("secretKey : [" + secretKey + "]"); System.out.println("serviceName : [" + serviceName + "]"); System.out.println("operationName : [" + operationName + "]"); System.out.println("timestamp : [" + timestamp + "]"); System.out.println("signature : [" + signature + "]"); System.out.println("encryptKey : [" + new String(Hex.encode(encryptKey)) + "]"); System.out.println("encryptedData : [" + encryptedData + "]"); System.out.println("decryptedData : [" + decryptedData + "]"); System.out.println("sha256Data : [" + hashedData + "]"); /*String xmldata = "<soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:mall=\"http://mall.checkout.platform.nhncorp.com/\" xmlns:base=\"http://base.checkout.platform.nhncorp.com/\">" + "<soapenv:Header/>" + "<soapenv:Body>" + "<mall:GetOrderInfoRequest>" + "<base:RequestID>?</base:RequestID>" + "<base:AccessCredentials>" + "<base:AccessLicense>"+ accessLicense +"</base:AccessLicense>" + "<base:Timestamp>"+ timestamp +"</base:Timestamp>" + "<base:Signature>"+ signature +"</base:Signature>" + "</base:AccessCredentials>" + "<base:DetailLevel>Full</base:DetailLevel>" + //<!-- value Full, Compact ) "<base:Version>2.0</base:Version>" + "<OrderID>"+ orderID +"</OrderID>" + "</mall:GetOrderInfoRequest>" + "</soapenv:Body>" + "</soapenv:Envelope>";*/ System.out.println("NaverCheckOutGetOrder.getYesterday():" + NaverCheckOutGetOrder.getYesterday()); System.out.println("NaverCheckOutGetOrder.getToday():" + NaverCheckOutGetOrder.getToday()); String orderlist = "<soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:mall=\"http://mall.checkout.platform.nhncorp.com/\" xmlns:base=\"http://base.checkout.platform.nhncorp.com/\">" + "<soapenv:Header/>" + "<soapenv:Body>" + "<mall:GetPaidOrderListRequest>" + "<base:RequestID>?</base:RequestID>" + "<base:AccessCredentials>" + "<base:AccessLicense>" + accessLicense + "</base:AccessLicense>" + "<base:Timestamp>" + timestamp + "</base:Timestamp>" + "<base:Signature>" + signature + "</base:Signature>" + "</base:AccessCredentials>" + "<base:DetailLevel>Full</base:DetailLevel>" + "<base:Version>2.0</base:Version>" + "<base:InquiryTimeFrom>" + NaverCheckOutGetOrder.getYesterday() + "</base:InquiryTimeFrom>" + //NaverCheckOutGetOrder.getYesterday() //2011-05-06T00:00:04.662Z "<base:InquiryTimeTo>" + NaverCheckOutGetOrder.getToday() + "</base:InquiryTimeTo>" + //NaverCheckOutGetOrder.getToday() //2011-05-06T23:00:04.662Z "</mall:GetPaidOrderListRequest>" + "</soapenv:Body>" + "</soapenv:Envelope>"; //2011-07-29T04:33:52.881Z //Create socket //String hostname = "ec.api.naver.com"; String hostname = "api.naver.com"; int port = 80; InetAddress addr = InetAddress.getByName(hostname); Socket sock = new Socket(addr, port); //Send header String path = "/Checkout/MallService2"; BufferedWriter wr = new BufferedWriter(new OutputStreamWriter(sock.getOutputStream(), "UTF-8")); // You can use "UTF8" for compatibility with the Microsoft virtual machine. wr.write("POST " + path + " HTTP/1.0 \r\n"); //wr.write("Host: ec.api.naver.com \r\n"); wr.write("Host: api.naver.com \r\n"); //wr.write("Content-Length: " + xmldata.length() + "\r\n"); wr.write("Content-Length: " + orderlist.length() + "\r\n"); wr.write("Content-Type: text/xml; charset=\"UTF-8\"\r\n"); //wr.write("SOAPAction: \"http://ec.api.naver.com/Checkout/MallService2\" \r\n"); wr.write("SOAPAction: \"http://api.naver.com/Checkout/MallService2\" \r\n"); wr.write("\r\n"); //Send data //wr.write(xmldata); wr.write(orderlist); wr.flush(); // InputStream test = new InputStream(sock.getInputStream(),"UTF-8"); // Response BufferedReader rd = new BufferedReader(new InputStreamReader(sock.getInputStream(), "UTF-8")); String line = ""; String line_total = ""; String tmp = ""; String tmp2 = ""; String newxml = ""; /*while((line = rd.readLine()) != null){ if (line.startsWith("<?xml")){ line = line.replaceAll("
", " "); line_total= line_total + line ; System.out.println(line); } }*/ StringBuffer sf = new StringBuffer(); /* while((line = rd.readLine()) != null){ if (line.startsWith("<?xml")){ sf.append(line+"\n"); // . } }*/ char[] bufferResult = new char[1048576]; int index = -1; while ((index = rd.read(bufferResult)) != -1) { sf.append(bufferResult, 135, index); //response 133 135 } line_total = sf.toString().trim(); System.out.println("%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%"); line_total = line_total.replaceAll("n1:", ""); System.out.println(line_total); //xml2 InputStream in = new ByteArrayInputStream(line_total.getBytes("UTF-8")); SAXBuilder builder = new SAXBuilder(); Document document = builder.build(in); Element element = document.getRootElement(); List envel_list = element.getChildren(); List body_list = null; List body_list1 = null; List result_list = null; List result_list1 = null; List result_list2 = null; List result_list3 = null; List result_list4 = null; List result_list5 = null; List info_list = null; List contr_group_list = null; List contr_info_list = null; StringBuffer selectChk = new StringBuffer(); selectChk.append(" select count(*) cnt \n"); selectChk.append(" from ktc_njoyny_hmall_if \n"); selectChk.append(" where h_order_no = ? and coven_id = 26050 \n"); String getInterfacedata = " select UNIT_ID,ITEM_ID " + " from ( " + " select item_id, " + " UNIT_name, " + " decode(( " + " select count(*) cnt " + " from ktc_unit " + " where item_id = ? " + " group by item_id), 1, UNIT_id, decode(trim(UNIT_NAME) ,trim(?), UNIT_id, '')) UNIT_id " + " from ktc_unit " + " where item_id = ? ) " + " where unit_id is not null "; PreparedStatement pstmt = null; ResultSet rs = null; CallableStatement cStmt = null; System.out.println("DBconnect"); //conn.setAutoCommit(false); long UNIT_ID = 0; long cnt = 0; long interface_seq = 0; long DEL_QTY = 0; long ITEM_ID = 0; String ITEM_NAME = null; System.out.println("envel_list.size:" + envel_list.size()); Element envel_el = (Element) envel_list.get(0); body_list = envel_el.getChildren(); System.out.println("+++++++11+++++++++++el.getName() : " + envel_el.getChildren()); System.out.println("body_list.size:" + body_list.size()); Element body_el = (Element) body_list.get(0); result_list = body_el.getChildren("PaidOrderList"); System.out.println("++++++++22++++++++++el.getName() : " + body_el.getChildren()); for (int h = 0; h < result_list.size(); h++) { System.out.println("$$111$$"); Element body_el1 = (Element) result_list.get(h); System.out.println("$$222$$"); result_list1 = body_el1.getChildren("PaidOrder"); System.out.println("result_list1.size:" + result_list1.size()); System.out.println("$$333$$"); System.out.println("++++++++33++++++++++el.getName() : " + body_el1.getChildren()); for (int i = 0; i < result_list1.size(); i++) { System.out.println("$$4444$$" + result_list1.size()); Element body_el2 = (Element) result_list1.get(i); result_list2 = body_el2.getChildren("Order"); Element body_el3 = (Element) result_list1.get(i); result_list3 = body_el3.getChildren("OrderProductList"); Element body_el4 = (Element) result_list1.get(i); result_list4 = body_el4.getChildren("Shipping"); for (int j = 0; j < result_list2.size(); j++) { Element body_el5 = (Element) result_list2.get(j);// Element body_el7 = (Element) result_list4.get(j);// Element body_el8 = (Element) result_list3.get(j); result_list5 = body_el8.getChildren("OrderProduct");// //result_list5 = (Element) result_list3.get(j);// System.out.println("$$55555$$"); if (body_el5.getChildText("OrderStatusCode").equals("OD0002")) {// pstmt = conn.prepareStatement(selectChk.toString()); pstmt.setString(1, body_el5.getChildText("OrderID")); rs = pstmt.executeQuery(); if (rs.next()) { cnt = rs.getLong("cnt"); } System.out.println(" cnt:" + cnt); if (rs != null) { try { rs.close(); } catch (Exception e) { response_type = "FALSE"; } } if (pstmt != null) { try { pstmt.close(); } catch (Exception e) { response_type = "FALSE"; } } System.out.println("result_list5.size():" + result_list5.size()); for (int k = 0; k < result_list5.size(); k++) { Element body_el9 = (Element) result_list5.get(k); ITEM_NAME = body_el9.getChildText("ProductName"); DEL_QTY = Long.parseLong(body_el9.getChildText("Quantity")); pstmt = conn.prepareStatement(getInterfacedata); System.out.println("body_el9.getChildText:" + body_el9.getChildText("ProductID")); System.out .println("body_el9.getChildText:" + body_el9.getChildText("ProductOption")); pstmt.setLong(1, Long.parseLong(body_el9.getChildText("ProductID"))); pstmt.setString(2, body_el9.getChildText("ProductOption")); pstmt.setLong(3, Long.parseLong(body_el9.getChildText("ProductID"))); rs = pstmt.executeQuery(); if (rs.next()) { UNIT_ID = rs.getLong("UNIT_ID"); ITEM_ID = rs.getLong("ITEM_ID"); //DEL_QTY = rs.getLong("DEL_QTY"); } System.out.println("UNIT_ID:" + UNIT_ID); System.out.println("ITEM_ID:" + ITEM_ID); System.out.println("ITEM_NAME:" + ITEM_NAME); if (rs != null) { try { rs.close(); } catch (Exception e) { response_type = "FALSE"; } } if (pstmt != null) { try { pstmt.close(); } catch (Exception e) { response_type = "FALSE"; } } } // 1 . System.out.println("1111 333331"); String getInterfaceSeq = " select ktc_njoyny_hmall_if_seq.nextval interfaceSeq from dual "; pstmt = conn.prepareStatement(getInterfaceSeq); rs = pstmt.executeQuery(); if (rs.next()) { interface_seq = rs.getLong("interfaceSeq"); } System.out.println("+ interface_seq [" + interface_seq + "]"); if (rs != null) { try { rs.close(); } catch (Exception e) { response_type = "FALSE"; } } if (pstmt != null) { try { pstmt.close(); } catch (Exception e) { response_type = "FALSE"; } } if (cnt == 0) { // .. System.out.println("body_el5.getChildText:" + body_el5.getChildText("OrderID")); if (NaverCheckOutGetOrder.run2(body_el5.getChildText("OrderID")) .equals("SUCCESS")) {// StringBuffer setOrder = new StringBuffer(); setOrder.append(" insert \n"); setOrder.append(" into ktc_njoyny_hmall_if( \n"); setOrder.append(" h_order_no, seq, order_date, recv_date, item_id, \n"); setOrder.append(" unit_id, item_name, price, qty, orderer_name, \n"); setOrder.append( " orderer_phone, orderer_cell_phone, orderer_eng_name, orderer_resi_no, orderer_email, \n"); setOrder.append( " msg_for_mall, del_plan_date, receiver_name, receiver_phone, receiver_cell_phone, \n"); setOrder.append( " receiver_zip_code, receiver_addr1, receiver_addr2, msg_for_outbnd, interface_date, \n"); setOrder.append(" interface_seq, sysregdt, coven_id \n"); setOrder.append(" ) values ( \n"); setOrder.append( " 'naver_'||?, ktc_njoyny_hmall_if_seq.nextval, to_date(?,'yyyy/mm/dd hh24:mi:ss'), sysdate, ?, \n"); setOrder.append(" ?, ?, ?, ?, ?, \n"); setOrder.append(" ?, ?, ?, ?, ?, \n"); setOrder.append(" ?, sysdate+5, ?, ?, ?, \n"); setOrder.append(" ?, ?, ?, ?, sysdate, \n"); setOrder.append(" ?, sysdate, ? \n"); setOrder.append(" ) \n"); pstmt = conn.prepareStatement(setOrder.toString()); int insert_cnt = 0; try { pstmt.clearParameters(); // pstmt.setLong(1, Long.parseLong(body_el5.getChildText("OrderID"))); // h_order_no System.out.println(body_el5.getChildText("OrderID")); pstmt.setString(2, body_el5.getChildText("OrderDateTime").substring(0, 10)); //order_date System.out.println(body_el5.getChildText("OrderDateTime").substring(0, 10)); pstmt.setLong(3, ITEM_ID); // item_id System.out.println(ITEM_ID); pstmt.setLong(4, UNIT_ID); // unit_id System.out.println(UNIT_ID); pstmt.setString(5, ITEM_NAME); // ITEM_NAME System.out.println(ITEM_NAME); pstmt.setLong(6, Long.parseLong(body_el5.getChildText("TotalProductAmount"))); //price -> 0.95 + + System.out.println( Long.parseLong(body_el5.getChildText("TotalProductAmount"))); pstmt.setLong(7, DEL_QTY); //qty System.out.println(DEL_QTY); pstmt.setString(8, new String(SimpleCryptLib.decrypt(encryptKey, body_el5.getChildText("OrdererName")), "UTF-8")); // orderer_name System.out.println(new String(SimpleCryptLib.decrypt(encryptKey, body_el5.getChildText("OrdererName")), "UTF-8")); pstmt.setString(9, NaverCheckOutGetOrder .getTel(new String( SimpleCryptLib.decrypt(encryptKey, body_el5.getChildText("OrdererTel")), "UTF-8"))); //orderer_phone System.out .println( NaverCheckOutGetOrder .getTel(new String( SimpleCryptLib .decrypt(encryptKey, body_el5.getChildText( "OrdererTel")), "UTF-8"))); pstmt.setString(10, NaverCheckOutGetOrder .getTel(new String( SimpleCryptLib.decrypt(encryptKey, body_el5.getChildText("OrdererTel")), "UTF-8"))); // orderer_cell_phone pstmt.setString(11, null); // orderer_eng_name pstmt.setString(12, null); // orderer_resi_no pstmt.setString(13, null); // orderer_email pstmt.setString(14, body_el7.getChildText("ShippingMessage")); // msg_for_mall pstmt.setString(15, new String(SimpleCryptLib.decrypt(encryptKey, body_el7.getChildText("Recipient")), "UTF-8")); // receiver_name System.out.println(new String(SimpleCryptLib.decrypt(encryptKey, body_el7.getChildText("Recipient")), "UTF-8")); pstmt.setString(16, NaverCheckOutGetOrder .getTel(new String( SimpleCryptLib.decrypt(encryptKey, body_el7.getChildText("RecipientTel1")), "UTF-8"))); // receiver_phone System.out .println( NaverCheckOutGetOrder .getTel(new String( SimpleCryptLib.decrypt(encryptKey, body_el7.getChildText( "RecipientTel1")), "UTF-8"))); pstmt.setString(17, NaverCheckOutGetOrder .getTel(new String( SimpleCryptLib.decrypt(encryptKey, body_el7.getChildText("RecipientTel1")), "UTF-8"))); // receiver_cell_phone System.out .println( NaverCheckOutGetOrder .getTel(new String( SimpleCryptLib.decrypt(encryptKey, body_el7.getChildText( "RecipientTel1")), "UTF-8"))); pstmt.setString(18, body_el7.getChildText("ZipCode")); //receiver_zip_code pstmt.setString(19, new String( SimpleCryptLib.decrypt(encryptKey, body_el7.getChildText("ShippingAddress1")), "UTF-8")); //receiver_addr1 System.out.println(new String(SimpleCryptLib.decrypt(encryptKey, body_el7.getChildText("ShippingAddress1")), "UTF-8")); pstmt.setString(20, new String( SimpleCryptLib.decrypt(encryptKey, body_el7.getChildText("ShippingAddress2")), "UTF-8")); //receiver_addr2 System.out.println(new String(SimpleCryptLib.decrypt(encryptKey, body_el7.getChildText("ShippingAddress2")), "UTF-8")); pstmt.setString(21, body_el7.getChildText("ShippingMessage")); // msg_for_outbnd System.out.println(body_el7.getChildText("ShippingMessage")); pstmt.setLong(22, interface_seq); // interface_seq pstmt.setString(23, "26050"); // coven_id pstmt.executeUpdate(); System.out.println("\n+ insert_cnt [" + i + "]\n"); } catch (Exception e) { response_type = "FALSE"; e.printStackTrace(); conn.rollback(); break; } conn.commit(); if (pstmt != null) { try { pstmt.close(); } catch (Exception ex) { response_type = "FALSE"; } } System.out.println(" "); System.out.println("interface_seq:" + interface_seq); // .... cStmt = conn.prepareCall("{ call CREAT_NJOYNY_HMALL_ORDER(?,?,?) }"); cStmt.setLong(1, interface_seq); cStmt.registerOutParameter(2, Types.VARCHAR); cStmt.registerOutParameter(3, Types.VARCHAR); cStmt.executeUpdate(); String r_code = cStmt.getString(2); String r_msg = cStmt.getString(3); System.out.println("++++++++++++++++r_code : " + r_code); System.out.println("++++++++++++++++r_msg : " + r_msg); conn.commit(); System.out.println(" "); if (cStmt != null) { try { cStmt.close(); } catch (Exception e) { response_type = "FALSE"; } } conn.setAutoCommit(true); response_type = "TRUE"; } else { System.out.println(" "); } } else { System.out.println(" =.."); } cnt = 0; // .. } } } } } catch (Exception e) { System.out.println("run() : " + e.getMessage()); response_type = "FALSE"; } finally { } return response_type; } public String execute() { NaverCheckOutGetOrder _CJILR = new NaverCheckOutGetOrder(); _CJILR.init(); String return_type = _CJILR.run(); _CJILR.distroy(); return return_type; } public static void main(String args[]) throws Exception { NaverCheckOutGetOrder _CJILR = new NaverCheckOutGetOrder(); _CJILR.init(); _CJILR.run(); _CJILR.distroy(); } }