오라클 DB상에 있는 데이터 XML 문서로 만들기 1

오라클 DB상에 있는 데이터 XML 문서로 만들기

dom을 import

dom4j-1.6.1.jar

dom4j-2.0.1.jar

- 최근 거의 사용하지 않는 듯함

package db;
 
import java.io.*;
import java.util.*;
import java.sql.*;
import org.dom4j.*;
import org.dom4j.io.*;
 
import db.*;
 
 
public class CreateXMLDemo {
    
    //private DBConnectionMgr pool;
    private MakerDTO maker = new MakerDTO();
    private static String jdbcDriver = "oracle.jdbc.driver.OracleDriver";
    private static String jdbcUrl = "jdbc:oracle:thin:@localhost:1521:ORCL";
    private static String userName = "admin";
    private static String userPwd = "1234"; 
 
 
/*    // 생성자 : DB 연결
    public CreateXMLDemo() {
        try {
            pool = DBConnectionMgr.getInstance();
            System.out.println("pool > " + pool);

        } catch (Exception e) {
            System.out.println("DB 연결 실패 > " + e);
        }
    } // 생성자
*/
    
    private static Document createDocument() {
        
        Document document = DocumentHelper.createDocument();
        Element root = document.addElement("markers");
        
        //MakerDAO dao = new MakerDAO();
        ArrayList<MakerDTO> makerList = getMakerList();
        
        try {
            for(int i=0; i<makerList.size(); i++) {
                Element superNod = root.addElement("marker");
                MakerDTO maker = makerList.get(i);
                
                Element element = superNod.addElement("no");
                element.addText(Integer.toString(maker.getNo()));
                
                element = superNod.addElement("name");
                element.addText(maker.getName());
                
                element = superNod.addElement("lat");
                element.addText(Double.toString(maker.getLat()));
                
                element = superNod.addElement("lng");
                element.addText(Double.toString(maker.getLng()));
                
                element = superNod.addElement("addr");
                element.addText(maker.getAddr());
                
                element = superNod.addElement("locno");
                element.addText(maker.getLoctype());
                
            } // for            
            
        }catch(Exception e) {
            System.out.println("createDocument()메서드 에러유발" + e);
        }
        
        return document;
        
    }
    
    
    // 전체 레코드를 가져오는 메서드 호출
    public static ArrayList<MakerDTO> getMakerList() {
        ArrayList<MakerDTO> makerList = new ArrayList<MakerDTO>();
        
        Connection con = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;        
 
        try {
            
            Driver driver = (Driver)Class.forName(jdbcDriver).newInstance();
            con = DriverManager.getConnection(jdbcUrl, userName, userPwd);
            String sql = "select * from marker";
            pstmt = con.prepareStatement(sql);
            rs = pstmt.executeQuery();
 
            while (rs.next()) {
                MakerDTO maker = new MakerDTO();
                maker.setNo(rs.getInt("locnum"));
                maker.setName(rs.getString("locname"));
                maker.setLat(rs.getDouble("lat"));
                maker.setLng(rs.getDouble("lng"));
                maker.setAddr(rs.getString("addr"));
                maker.setLoctype(rs.getString("loctype"));
                
                makerList.add(maker);
 
            }
        } catch (Exception e) {
            System.out.println("getMakerList()메서드 에러유발" + e);
        } 
        return makerList;
    }
 
    
    public static void main(String[] args) {
        Document document;
        try {
            document = createDocument();
            OutputFormat format = new OutputFormat("\t", true);
             
            FileWriter out = new FileWriter("D:/3.jsp/FinalProject/WebContent/xml/output.xml"); // 저장 원하는 위치
            XMLWriter writer = new XMLWriter(out, format);
            writer.write(document);
            out.close();
        } catch (IOException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
 
    
    
}
 

output.xml