moozi

-- 오라클문법 with table1 as (select distinct t1.year, goods.name from ( select a.year, a.name, sum(ea) as count from (select to_char(orders.orderdate,'YYYY') year, goods.name, ordersDetail.ea from orders join ordersDetail on orders.ono=ordersDetail.ono join goods on ordersDetail.gno=goods.gno) a group by a.year, a.name order by a.year, a.name) t1 cross join goods order by t1.year, goods.name), table..

자바연습문제풀이

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.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JScrollPane; import javax.swing.JTextArea; import javax.swing.JTextField; public class Haksa extends JFrame{ JTextField tfId=null; JTextF..

import java.awt.Container; import java.awt.FlowLayout; import javax.swing.JButton; 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{ JTextField tfId=null; JTextField tfName=null; JTextField tfDepartment=null; JTextField tfAddress=null; JTextArea taList=null; JButton..

public class foreachEx { public static void main(String[] args) { //int n[]= {1,2,3,4,5}; //String names[]= {"사과","배","바나나","체리","딸기","포도"}; //int sum=0; //for(int k:n) { //System.out.print(k+" "); //sum+=k; //} //for(int k=0;k

public class HelloWorld { public static void main(String[] args) { System.out.println("Hello World"); } }