jdbc delete

JDBC Test

 
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 Delete(String id) {
        String sql = " DELETE FROM USERDTO"
                + " WHERE ID = '" + id + "'";
        
        Connection conn = getConnection();
        Statement stmt = null;
        
        int count = 0;
        
        System.out.println("sql: " + sql);
        
        try {
            stmt = conn.createStatement();
            
            count = stmt.executeUpdate(sql);
            
        } 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;
    }
}
 
 
 
 
 
 
 
 
 
 
 
 
 
 

 

main 

package main;
 
import jdbc.JdbcTest;
 
public class mainClass {
    public static void main(String[] args) {
        JdbcTest jt = new JdbcTest();
        
        String id = "aaa";
 
        int count = jt.Delete(id);
        if(count > 0) {
            System.out.println("성공적으로 삭제하였습니다.");
        }
    }
}