lprod_id값을 2개 입력 받아서 두 값중 작은 값부터 큰 값사이의 자료를 출력

package kr.or.didt.basic;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

// 문제) lprod_id값을 2개 입력 받아서 
//      두 값중 작은 값부터 큰 값사이의 자료를 출력하시오.

public class jdbcTest03 {

	public static void main(String[] args) {


		//사용자로부터 값을 입력 받기위함
		Scanner scan = new Scanner(System.in);
		
		//db작업을 위해 필요한 것들
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		
		//미리 입력받기
				System.out.println("Lprod_id첫번째 값 입력 : ");
				int num1 = scan.nextInt();
				System.out.println("Lprod_id두번째 값 입력 : ");
				int num2 = scan.nextInt();

				int max = Math.max(num1, num2);
				int min = Math.min(num1, num2); 
	
				if(num1>num2){
					max=num1;
					min=num2;
				}else{
					max=num2;
					min=num1;
				}
				
		try {
			
            Class.forName("oracle.jdbc.driver.OracleDriver");
			
			conn = DriverManager.getConnection(
					"jdbc:oracle:thin:@localhost:1521:xe",
					"JSG99","java");
			

			String sql = " select * from lprod where lprod_id >=" + min +"and lprod_id <="+ max;
			//String sql = "select * from lprod where LPROD_ID between" + min +  "and" + max;
			
			stmt = conn.createStatement();
			
			rs = stmt.executeQuery(sql);
			
			System.out.println();
			System.out.println("   =========결과 출력==========    ");
			while(rs.next()){
				System.out.println("lprod_id : "+rs.getInt("lprod_id"));
				System.out.println("lprod_gu : "+rs.getString("lprod_gu"));
				System.out.println("lprod_nm : "+rs.getString("lprod_nm"));
				System.out.println("-------------------------------------");
				
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		}finally{
			if(rs != null) try {rs.close();} catch (SQLException e2) {}
			if(stmt != null) try {stmt.close();} catch (SQLException e2) {}
			if(conn != null) try {conn.close();} catch (SQLException e2) {}
		}
		
	}

}