![]()
create database mydb;use mydb;-- 테이블 생성 create table student( student_id int, name varchar(50) not null, grade int not null, major varchar(50) not null);select * from student;desc student;-- 과목 테이블 생성 create table subject( subject_id int, subject_name varchar(50) not null, credit int not null, department varchar(5), professor char(50) not null);select * from subject;..
![]()
코드 구현package ch03;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class UpdateExample { public static void main(String[] args) { String url; String user; String password; // Connection 객체를 얻어서 insert 구문을 직접 만들어 보세요. url = "jdbc:mysql://localhost:3306/mydb2?s..
![]()
코드 연습package ch02;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class MySQLJdbcExample { public static void main(String[] args) { // 준비물 String url = "jdbc:mysql://localhost:3306/mydb2?serverTimezone=Asia/Seoul"; String user = "root"; // 상용서비스에서 절대 루트 계정 사용 금지 String password = "asd123"; ..
![]()
MySQL Connector 다운로드 주소 MySQL :: Download Connector/JMySQL Connector/J is the official JDBC driver for MySQL. MySQL Connector/J 8.0 and higher is compatible with all MySQL versions starting with MySQL 5.7. Additionally, MySQL Connector/J 8.0 and higher supports the new X DevAPI for development with MySQL Serdev.mysql.com Oracle JDBC 드라이버 다운로드 주소 JDBC and UCP Downloads pageOracle JDBC Driver Imp..
