moozi

movie

html연습문제08

영화이미지 영화예고편 영화소개 상영관위치 ©CGV. All rights reserved.

html연습문제07

html연습문제06

html연습문제05

html연습문제04

TIS Edu About | History | Vision | Contact | Board TIS정보기술교육센터 TIS정보기술교육센터는 정부지원 IT전문교육기관입니다. 자바과정 디자인과정 네트워크과정 ©TIS.EDU. All rights reserved.

html연습문제03

html연습문제02

html연습문제01

자바미니프로젝트

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.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sq..

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; import javax.swing.JPanel; public class Haksa extends JFrame{ JPanel panel; // 메뉴별 화면이 출력되는 패널 Haksa(){ setTitle("학사관리시스템"); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//x버튼 누르면 프로그램 종료 JMenuBar bar=new JMenuB..

-- database 생성 create database sampledb; -- database선택 use sampledb; -- 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..

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

자바연습문제18

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.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sq..

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

-- database 생성 create database sampledb; -- database선택 use sampledb; -- 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;

자바연습문제17

my.ini mysql installer로 설치했을 경우는 my.ini경로가 다음과 같다. C:\ProgramData\MySQL\MySQL Server 5.7 --------------------------------------------------------------------------------------- 위 파일을 적용해도 한글이 깨질 경우는, 1. DB생성시 collation을 utf8_general_ci로 설정. 2. jdbc connection string을 다음과 같이 작성. "jdbc:mysql://localhost:3306/sampledb?useSSL=false&useUnicode=true&characterEncoding=UTF-8"

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class JDBC01 { static Connection conn=null; static Statement stmt=null; static ResultSet rs=null; public static void main(String[] args) { try { Class.forName("com.mysql.jdbc.Driver"); Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/sampledb?useSSL=fals..

수업시간sql

오라클연습문제07

PL/SQL 자료

오라클연습문제6

DB모델링

오라클연습문제05