7/31 복습 보충하기

package prj99;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
 
public class hello {
    public static void main(String[] args) {
 
        System.out.println("호랑이");
        String driver = "oracle.jdbc.driver.OracleDriver";
        
        //로그인을 위한 과정
        Connection con = null;
        
        String dburl = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
        String username = "c##jwh";
        String password = "1";
        
        //문장을 준비하는 객체
        PreparedStatement ps = null;
        
        String sql = "INSERT into banana values('개나리',25,1000,'하회마을')";
        System.out.println(sql);
        
        try {
            System.out.println(Class.forName(driver));
        //로그인
            con = DriverManager.getConnection(dburl, username, password);
        //기계어 번역
            ps = con.prepareStatement(sql);
        //실행
            ps.executeUpdate();
            ps.close();
        }catch(Exception e) {
            e.printStackTrace();
        }
        System.out.println("호랑이");
    }        
}