[23/100] 240514

package com.kosta.sample.jdbc;

 

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.HashMap;

 

public class JDBCCallTest {

static final String DB_URL = "jdbc:oracle:thin:@127.0.0.1:1521:XE";

static final String DB_ID = "it";

static final String DB_PW = "0000";

 

public static void main(String[] args) {

Connection conn = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

 

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

} catch (ClassNotFoundException e) {

 

}

try {

conn = DriverManager.getConnection(DB_URL, DB_ID, DB_PW);

if (conn != null)

System.out.println("연결됨");

else

System.out.println("연결실패");

 

String sql = "select * from emp";

pstmt = conn.prepareStatement(sql);

rs = pstmt.executeQuery();

ArrayList<HashMap> list = new ArrayList<HashMap>();

while (rs.next() == true) {

HashMap<String, Object> map = new HashMap<String, Object>();

int empno = rs.getInt("empno");

String ename = rs.getString("ename");

map.put("empno", rs.getInt("empno"));

map.put("ename", rs.getString("ename"));

list.add(map);

}

System.out.println("리스트" + list);

for (int i = 0; i < list.size(); i++) {

int a = (int) list.get(i).get("empno");

String b = (String) list.get(i).get("ename");

System.out.println(a + " " + b);

}

 

} catch (SQLException e) {

e.printStackTrace();

}

 

}

 

}

 

class SqlVO {

public SqlVO() {

};

 

private String ename;

private int empno;

 

public String getEname() {

return ename;

}

 

public void setEname(String ename) {

this.ename = ename;

}

 

public int getEmpno() {

return empno;

}

 

public void setEmpno(int empno) {

this.empno = empno;

}

 

}

 

오늘은 json형태의 데이터를 다루것에 대한 숙달과 오라클 db와 연결해서 데이터를 핸들링 해보았다.