moozi

haksa

import java.awt.Dimension; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import javax.swing.JComboBox; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.table.DefaultTableModel..

-- table생성 create table student( id char(7) primary key, name varchar(10) not null, dept varchar(20) not null ); -- 데이터입력 insert into student values('1091011','김철수','컴퓨터시스템'); insert into student values('0792012','최고봉','멀티미디어'); insert into student values('0494013','이기자','컴퓨터공학'); select * from student; create table books( no char(6) primary key, -- 책번호 title varchar(50) not null, -- 책이름 author ..