jdbc Insert

JDBC(Insert 선언 쪽)

package jdbc;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
 
public class JdbcTest {
    public JdbcTest() {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
 
            System.out.println("Driver Loading Success! ");
 
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
 
//    실제 연결 코드
    public Connection getConnection() {
 
        Connection conn = null;
 
//        New Oracle : 우클릭 프로퍼티 -> 드라이버 프로퍼티 -> Connection Url 복사 
        try {
            conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.2.5:1521:xe", "hr", "hr");
 
            System.out.println("DB Connection Success");
 
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
 
        return conn;
 
    }
 
    public int Insert(String id, String name, int age) {
        // createStatement, preperedStatement
 
        String sql = " INSERT INTO USERDTO(ID, NAME, AGE, JOINDATE) " + " VALUES('" + id + "', '" + name + "', " + age
                + ", SYSDATE) ";
        Connection conn = this.getConnection();
        Statement stmt = null;
 
        int count = 0; // 데이터가 몇개 변경되었는지 확인 변수
 
        System.out.println("sql:" + sql);
 
        try {
            stmt = conn.createStatement(); // 연결부분에 대한 상태를 생성해 준다.
 
            count = stmt.executeUpdate(sql);
 
            System.out.println("성공적으로 추가되었습니다");
 
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            try {
                if (stmt != null) {
 
                    stmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        return count;
    }
}

 

 

메인

package main;
 
import jdbc.JdbcTest;
 
public class mainClass {
 
    public static void main(String[] args) {
        
        JdbcTest jt = new JdbcTest();
        
        int count = jt.Insert("bbb", "일지매", 21);
        
        if(count > 0) {
            System.out.println("정상적으로 추가되었습니다.");
        }
        
    }
 
}