White Life Story

<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%
   
    // STEP1: mysql 드라이버 로드
    Class.forName("com.mysql.jdbc.Driver");

    // STEP2: Connection 생성
    Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/whitelife", "whitelife", "whitelife");

    // STEP3: Query 작성
    PreparedStatement preparedStatement = connection.prepareStatement("select * from tb_test where test_no = ?");
   
    // STEP4: 조건 처리
    preparedStatement.setInt(1, 2);

    // STEP5: 실행 -> 결과 값 받기
    ResultSet resultSet = preparedStatement.executeQuery();
   
    // STEP6: 결과 값 보기
    while (resultSet.next()) {
        out.println(resultSet.getInt("test_no"));
        out.println(resultSet.getString("title"));
        out.println(resultSet.getString("content"));
        out.println(resultSet.getString("create_date"));
    };
   
    resultSet.close();
   preparedStatement.close();
   connection.close();

%>

show procedure status where db = 'db_test'

delimiter $$

drop procedure if exists test_procedure $$

create procedure test_procedure(p_test varchar(100), p_test_a varchar(10))
begin

-- 선언 부

declare v_test1 int default 0;

declare v_test2 int default 0;

-- 조회

select

test1,

test2

into v_test1, v_test2

from

tb_test;

-- 등록

insert tb_proc_test (test) values (v_test1);

insert tb_proc_test (test) values (v_test2);

end $$

delimiter;

delimiter $$

drop procedure if exists test_procedure $$

create procedure test_procedure(p_test varchar(100), p_test_a varchar(10))
begin

// process

end $$

delimiter;

call test_procedure('a', 'b');

set @number = 2;

select @number;

select sec_to_time(1500);

00:25:00

select concat ('a', 'b', 'c');