package main.java.com.study.jdbc.main.dml; import main.java.com.study.jdbc.util.DBConnection2; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class test3 { public static void main(String[] args) { Connection connection = DBConnection2.getInstance().getConnection(); String sql = "select * from study_mst "; try { Prepa..

데이터 베이스 안 여러개의정보 넣기 package main.java.com.study.jdbc.main.dml; import main.java.com.study.jdbc.util.DBConnection2; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import java.util.Scanner; public class test5 { public static void main(String[] args) { Scanner scanner = new Scanner(System.in); List name..

수정하기 package main.java.com.study.jdbc.main.dml; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.Scanner; import main.java.com.study.jdbc.util.DBConnection; public class JdbcUpdate1 { public static void main(String[] args) { Scanner sc = new Scanner(System.in); System.out.print("수정할 계정의 id값을 입력학세요: "); int id = sc.nextInt(); sc.nextLin..

1건 입력 package main.java.com.study.jdbc.main.dml; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.Scanner; import main.java.com.study.jdbc.util.DBConnection; public class jdbcInsert1 { public static void main(String[] args) { Scanner scanner = new Scanner(System.in); System.out.print("등록할 아이디 입력: "); String username = scanner.nextLine(..

package main.java.com.study.jdbc.main; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import main.java.com.study.jdbc.util.DBConnection; /*board_mst 가 나오게끔 해라.*/ public class jdbcTest2 { public static void main(String[] args) { Connection connection = DBConnection.getInstance().getConnection(); String sql = "select * from b..

board 를 불러오세요 package main.java.com.study.jdbc.main; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import main.java.com.study.jdbc.util.DBConnection; /*board_mst 가 나오게끔 해라.*/ public class jdbcTest2 { public static void main(String[] args) { Connection connection = DBConnection.getInstance().getConnection(); String sql = "s..