jdbc01

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class JDBC01 {

public static void main(String[] args) {
Connection conn=null;
Statement stmt = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "ora_user", "hong");
System.out.println("연결완료");

stmt=conn.createStatement();

//stmt.executeUpdate("insert into student2(id,name,dept) values('1212121','이율곡','전자공학')");

//stmt.executeUpdate("update student2 set dept='철학' where id='1234567'");

String sql="delete from student2"
+ " where id='1234567'";
stmt.executeUpdate(sql);

ResultSet rs=stmt.executeQuery("select * from student2");
while(rs.next()) {
// System.out.println(rs.getString("id"));
// System.out.println(rs.getString("name"));
// System.out.println(rs.getString("dept"));

System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
}

rs.close();
conn.close();


}catch(Exception e) {
e.printStackTrace();
}

}

}

 

--------------------------------------------------------------------------------

 create table student2(
    id char(7) primary key,
    name varchar2(10) not null,
    dept varchar2(20) not null,
    address varchar2(100) null
 );
 insert into student2 values('1234567','홍길동','컴퓨터공학',null);
 insert into student2 values('1243211','이순신','멀티미디어',null);
 insert into student2 values('0034567','김철수','컴퓨터시스템',null);
 
 select * from student2;
 
 commit