Daily Codig Reminder(80)
-
My batis2
HashMap List list= service.selectAllHashmap(); System.out.println(list); for (HashMap dept : list) { BigDecimal dno = (BigDecimal) dept.get("DEPTNO");//숫자 BigDecimal형태 저장 int deptno= dno.intValue(); String dname= (String) dept.get("DNAME"); String loc=(String) dept.get("LOC"); System.out.println(deptno+"\t"+dname+"\t"+loc); } System.out.println("======================================="); for (Ha..
2023.12.23 -
My Batis
JDBC_MyBatis_Ver_3 import com.dto.Dept; import com.service.OracleMyBatisService; public class OralceMyBatisMain { public static void main(String[] args) { //SqlSession sess = MySqlSessionFactory.getSqlSession(); //System.out.println(sess); OracleMyBatisService service = new OracleMyBatisService(); //int num = service.update(new Dept(99, "영업","서울")); //System.out.println("update 갯수 : "+num); Dept..
2023.12.19 -
JDBC 2
import java.sql.SQLException; import java.util.ArrayList; import com.dto.Dept; import com.exception.RecordNotFoundException; import com.service.OracleTXService; public class OralceTXMain { public static void main(String[] args) { OracleTXService service= new OracleTXService(); //4번 클릭 //service.delete(99); //3번 클릭 Dept xx2 =new Dept(99, "경제", "서울"); try { service.update(xx2); } catch (RecordNotF..
2023.12.19 -
JDBC
오라클 데이터베이스 연동을 위한 4가지 정보를 저장 String driver =”oracle.jdbc.drtiver.OracleDriver”; String url =”jdbc:oracle:thin:@localhost:1521:xe”; String userid =”scott”; String passwd =”tiger”; 2. 드라이버 로딩 Class.forName(driver); 3. Connection 맺기 Connection con = DriverManager.getConnection (url, userid, passwd); 4. SQL문 작성 String query = “SELECT deptno, dname, loc form dept”; 또는 String query = “DELETE FROM dept..
2023.12.14 -
자바 IO
1. 자바의 IO 소스/ 목적지/ 입력/ 출력 2. 표준 입출력 System.in 표준 입력으로서 키보드에서 데이터를 읽어 들일 때 사용한다. import java.awt.im.InputContext; import java.io.IOException; import java.io.InputStream; public class IOTest { public static void main(String[] args) { InputStream is = System.in; try { System.out.println("데이터 입력: "); int n = is.read();//1byte System.out.println((char)n); } catch (IOException e) { e.printStackTrace()..
2023.12.14 -
리스트, 맵
3. Comparator -> ArrayList 정렬 System.out.println("======= itrator 이용 순회"); Iterator ite = list.iterator(); while(ite.hasNext()) { System.out.println(ite.next()); } System.out.println(list.size()); System.out.println(list); for (int i = 0; i < list.size(); i++) { Object o=list.get(i); String s = (String)o; System.out.println(s); } 3 [홍길동, 이순신, 홍길동] 홍길동 이순신 홍길동 System.out.println("길이(크기)"+list.siz..
2023.12.12