moozi

TIS 정보기술교육센터 회사소개 | 과정소개 | 회사연혁 | Contact 회사소개 TIS 정보기술교육센터는 IT 국비지원 전문교육센터입니다. Tis.Edu. All rights reserved.

html연습문제02

html연습문제01

자바미니프로젝트 학사관리 프로그램 1. 학생관리 - 학생정보 2. 도서관리 - 대출현황 - 대출통계 => 대출통계는 파이차트로 작성. 년도별 분기별 대출횟수. JSP수업 전까지 작성해보세요.

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..

자바연습문제15

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.JScrollPane; import javax.swing.JTextArea; import javax...

정규화

erd

오라클연습문제7

오라클연습문제06

오라클연습문제05

오라클연습문제04

-- 1page select * from( select row_number() over(order by sal desc) as num, empno,ename from emp ) where num>=1 and num=11 and num

오라클연습문제03

정규식 참고 http://regexp.elex.pe.kr/regular-expression

오라클연습문제02

select * from emp; select * from dept; desc dept; select empno,ename from emp; select ename, q'[tom's book]' as col2 from emp; select deptno from emp; select distinct deptno, ename from emp; select ename,job from emp; select ename || '_' || job as name_job from emp; select empno,ename,sal from emp where sal=2000 and sal=5000; select job, sal as sumSalary from emp where sal>2500 group by job; sel..

오라클연습문제01

오라클 DB,사용자,테이블 생성 -- 데이터베이스 생성 create tablespace myts datafile 'C:\app\calss2-00\oradata\myoracle\myts.dbf' size 100M autoextend on next 5M; -- User 생성 create user ora_user identified by hong default tablespace myts temporary tablespace temp; -- 권한설정 grant dba to ora_user; -- 테이블생성 create table student( id int, name varchar(20) ); -- 데이터입력 insert into student values(12345,'홍길동');

자바연습문제14

자바연습문제13

import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.JFrame; import javax.swing.JMenu; import javax.swing.JMenuBar; import javax.swing.JMenuItem; public class MenuEx extends JFrame{ public MenuEx() { this.setTitle("메뉴만들기"); JMenuBar mb=new JMenuBar();//메뉴바 JMenu screenMenu=new JMenu("screen");//메뉴 JMenuItem loadItem=new JMenuItem("Load");//메뉴아이템 loadItem.ad..

자바연습문제12

자바연습문제11 풀이

자바연습문제11

import java.awt.Color; import java.awt.Container; import java.awt.FlowLayout; import java.awt.Font; import javax.swing.ImageIcon; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.SwingConstants; public class JComponentEx extends JFrame{ public JComponentEx() { this.setTitle("컴포넌트 연습"); Container c=getContentPane(); c.setLayout(new FlowLayout())..

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{ public Haksa() { this.setTitle("학사관리 시스템"); this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); Container c=getContentPane(); c.setL..

자바연습문제10