moozi

jdbc연습문제03

Haksa03

my.ini

haksa menu

import java.awt.Component;import java.awt.Container;import java.awt.Dimension;import java.awt.FlowLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.event.MouseEvent;import java.awt.event.MouseListener;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement; import javax.swing.JButton;import javax.swi..

jdbc연습문제02

import java.awt.Dimension; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.swing.JButton; import javax.swing.JComboBox; import javax.swing.JFrame..

import java.awt.Container; import java.awt.FlowLayout; 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.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JScrollPane; import java..

import java.awt.Container; import java.awt.FlowLayout; 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.JButton; import javax.swing.JComboBox; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JScrollPane; import javax...

jdbc 연습문제01

오라클 jdbc기초

Connection conn = null; // 연결객체 ResultSet rs = null; // select한 결과를 저장하는 객체 Statement stmt = null; // sql을 실행하기 위한 객체 String url = null; // 서버 url String id = "hr"; // ID String pw = "1234"; // PW url ="jdbc:oracle:thin:@localhost:1521:orcl"; try {Class.forName("oracle.jdbc.driver.OracleDriver");// jdbc driver load} catch (ClassNotFoundException e) {e.printStackTrace();} try {conn = DriverManage..

오라클연습문제07

오라클연습문제06

오라클연습문제5

create procedure pro2 as vs_emp_name employees.emp_name%TYPE; vs_dep_name departments.department_name%TYPE; begin dbms_output.enable; select a.emp_name, b.department_name into vs_emp_name, vs_dep_name -- 컬럼의 값을 변수에 각각 저장 from employees a, departments b where a.department_id=b.department_id and a.employee_id=100; -- 출력.app에서는 결과값을 사용 못함. dbms_output.put_line(vs_emp_name || '-' || vs_dep_name); en..

오라클연습문제04

-- 연관성 있는 서브쿼리. Scalar Subquery -- 주쿼리와 서브쿼리가 서로 연결됨 -- join과 유사하게 동작하나, 소량의 데이터에서는 join보다 빠르다고 함. select emp_name, (select department_name from departments d where e.department_id=d.department_id) from employees e; -- 107건 -- 조인과 비교 select e.emp_name, d.department_name from employees e, departments d where e.department_id=d.department_id; -- 106건 -- outer join으로 처리해야 같은 결과를 얻을 수 있음. select e.em..

-- 학생 drop table student; create table student( id char(10) primary key, -- 학번 name varchar(20) not null, -- 이름 departmentId char(3) not null, -- 학과id address varchar(50) not null -- 주소 ); insert into student values('EL20170001','홍길동','EL','서울'); insert into student values('CO20170002','이순신','CO','제주도'); insert into student values('CO20170003','왕건','CO','경기도'); insert into student values('SC2017..

오라클연습문제03

oracle연습문제02

자바연습문제5풀이

오라클 연습문제1

자바연습문제14

import java.awt.Container; import java.awt.FlowLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.JButton; import javax.swing.JComboBox; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JScrollPane; import javax.swing.JTextArea; import javax.swing.JTextField; public class Haksa extends JFrame { Container contentPane; String..

자바연습문제12

자바연습문제11

자바연습문제01풀이

자바연습문제03풀이