2020.10.08 자바과제 내코드

 package k_jdbc;

import java.sql.Connection;

import java.sql.Date;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.HashMap;

import e_oop.ScanUtil;

public class Jdbc_3 {

String url = "jdbc:oracle:thin:@localhost:1521:xe"; 

String user = "Aurora"; 

String password = "java"; 

Connection con = null ; 

    PreparedStatement ps = null ; 

    ResultSet rs = null ; 

    

public static void main(String[] args) {

new Jdbc_3().start();

// TODO Auto-generated method stub

}

    void start(){ 

    try {

con = DriverManager.getConnection(url, user, password);

String sql = " insert into TB_JDBC_BOARD  values ( ?, ? , ? , ? , ? ) " ;  

ps = con.prepareStatement(sql); 

ps.setInt(1, 1);

    ps.setString(2, "hello");

    ps.setString(3, "welcometo");

    ps.setString(4, "이루마");

    ps.setDate(5, new Date(new java.util.Date().getTime())); 

int result = ps.executeUpdate(); 

System.out.println("TB_JDBC_BOARD 테이블에" +  result + "개의 행을 생성하겠습니다.");

//CREATE TABLE TB_JDBC_BOARD ( BOARD_NO NUMBER(7) , TITLE VARCHAR2(10) , 

// CONTENT VARCHAR2(10) , USERID VARCHAR2(10) , REG_DATE DATE ) ;

// SELECT NVL ( MAX (BOARD_NO ) , 0 ) + 1 FROM TB_JDBC_BOARD ; -> 게시판 번호 작성하기. 

} catch (SQLException e) {

e.printStackTrace();

} finally { 

if(rs != null) try { rs.close(); } catch(Exception e) { } 

if(ps != null) try { ps.close(); } catch(Exception e) { } 

if(con != null) try { con.close(); } catch(Exception e) { } 

}

    

basic();

    } //void start 애 

    

    

    void basic(){

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

    ArrayList<HashMap<String, Object>> title = new ArrayList<>();

    

    article.put("BOARD_NO", 2); 

    article.put("TITLE", "recommend "); 

    article.put("CONTENT", "near me"); 

    article.put("USERID", "green"); 

    

    

    

    title.add(article);

    

    System.out.println (article); 

    article = new HashMap<>(); 

    

    article.put("BOARD_NO", 3); 

    article.put("TITLE", "salary "); 

    article.put("CONTENT", "nail it"); 

    article.put("USERID", "soul"); 

    title.add(article); 

    

    System.out.println (article); 

    System.out.println(title);

    

   

   

   

   

   

   

   

    System.out.println("---------------------------------------------------------");

    System.out.println("BOARD_NO\t" +  "TITLE\t\t" + "CONTENT\t\t" + "USERID\t\t" );

    System.out.println("---------------------------------------------------------");

    

    for(int i = 0 ; i < title.size() ; i++){ //4

    System.out.println(title.get(i).get("BOARD_NO") + "\t\t " + title.get(i).get("TITLE") + "\t" + title.get(i).get("CONTENT") + "\t\t" + title.get(i).get( "USERID") );  

    }//4

   

    System.out.println("1. 조회 2. 등록  3. 종료");

    System.out.println("원하는 것의 번호를 입력해주세요>" ) ; 

    int putnum = ScanUtil.nextInt();

    

    switch(putnum){ 

    case 1 : 

         view(); 

   

    case 2 :

    insert();

    case 3 :

    System.exit(0);

   

    } //switch 애 

    

    

   

    } // } //void basic 애 

    

    

void insert() {

try {

con = DriverManager.getConnection(url, user, password);

String sql = "insert into TB_JDBC_BOARD values ( ? , ? , ? , ? , ? )";

ps = con.prepareStatement(sql); 

ps.setInt(1, 1);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

} // insert 애

    void view() {

    try {

con = DriverManager.getConnection(url, user, password);

String sql = "select * from TB_JDBC_BOARD"; 

ps = con.prepareStatement(sql); 

rs = ps.executeQuery();

ResultSetMetaData md = rs.getMetaData(); //메타데이터 

int columnCount = md.getColumnCount(); //컬럼 수 

while(rs.next()){ 

for (int i = 1; i <= columnCount; i++){ 

Object value = rs.getObject(i);

System.out.print(value + "\t");

}

System.out.println(); 

} //while의 얘  

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} 

    

/* Object board_no = title.get(putnum-1).get("BOARD_NO"); 

Object in_title = title.get(putnum-1).get("TITLE"); 

Object content = title.get(putnum-1).get("CONTENT"); 

Object userid = title.get(putnum-1).get("USERID");

System.out.println("BOARD_NO : " + board_no );

    System.out.println("TITLE : " + in_title );

    System.out.println("CONTENT : " +  content ); 

    System.out.println("USERID : " + userid ); 

    

    System.out.println("원하는 번호를 입력해 주세요 ");

    System.out.println("1. 수정  2. 돌아가기");

   int twonum = ScanUtil.nextInt(); 

    

   

   switch(twonum){

   

   case 1 : //수정 

   

   

   case 2 : // 돌아가기 

   basic();

   

   

   

   }//switch 괄호

   */

} //view 메소드 

}// 전체클래스