![]()
코드 구현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"; ..
![]()
예시 코드 Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "root", "password"); 예시 코드// 1. MySQL JDBC 드라이버 로드Driver myDriver = new com.mysql.cj.jdbc.Driver();DriverManager.registerDriver(myDriver);-----------------------------------------------------// 2. Oracle JDBC 드라이버 로드Driver myDriver = new oracle.jdbc.OracleDriver();DriverManager.registerDriver(myD..
![]()
import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class JdbcExample { public static void main(String[] args) { String url = "jdbc:mysql://localhost:3306/mydatabase"; String user = "root"; String password = "password"; try { Connection connection = DriverManager.getConnection(url, user, password); ..
