diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/stored/ensyu02.sql b/stored/ensyu02.sql deleted file mode 100644 index 5bb3054..0000000 --- a/stored/ensyu02.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX nmrt_contract_detail_idx_01 ON nmrt_contract_detail(contract_no); diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/stored/ensyu02.sql b/stored/ensyu02.sql deleted file mode 100644 index 5bb3054..0000000 --- a/stored/ensyu02.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX nmrt_contract_detail_idx_01 ON nmrt_contract_detail(contract_no); diff --git a/stored/ensyu03.sql b/stored/ensyu03.sql deleted file mode 100644 index e5e5e14..0000000 --- a/stored/ensyu03.sql +++ /dev/null @@ -1,3 +0,0 @@ -SELECT * -FROM nmrm_car_model -WHERE car_model_id IN ('000001', '000002', '000003', '000005'); diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/stored/ensyu02.sql b/stored/ensyu02.sql deleted file mode 100644 index 5bb3054..0000000 --- a/stored/ensyu02.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX nmrt_contract_detail_idx_01 ON nmrt_contract_detail(contract_no); diff --git a/stored/ensyu03.sql b/stored/ensyu03.sql deleted file mode 100644 index e5e5e14..0000000 --- a/stored/ensyu03.sql +++ /dev/null @@ -1,3 +0,0 @@ -SELECT * -FROM nmrm_car_model -WHERE car_model_id IN ('000001', '000002', '000003', '000005'); diff --git a/stored/ensyu04.sql b/stored/ensyu04.sql deleted file mode 100644 index 4a9ce0a..0000000 --- a/stored/ensyu04.sql +++ /dev/null @@ -1,11 +0,0 @@ -SELECT - t1.contract_no, - t2.contract_detail_no, - t1.car_management_no, - t1.member_id -FROM nmrt_contract t1 -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t2.contract_no) -WHERE t1.ins_date >= CONVERT(DATETIME, '2018/05/09 15:00:00', 120) - AND t1.ins_date <= CONVERT(DATETIME, '2018/05/09 18:00:00', 120) - AND t1.total_price > 10000 / 1.08; diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/stored/ensyu02.sql b/stored/ensyu02.sql deleted file mode 100644 index 5bb3054..0000000 --- a/stored/ensyu02.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX nmrt_contract_detail_idx_01 ON nmrt_contract_detail(contract_no); diff --git a/stored/ensyu03.sql b/stored/ensyu03.sql deleted file mode 100644 index e5e5e14..0000000 --- a/stored/ensyu03.sql +++ /dev/null @@ -1,3 +0,0 @@ -SELECT * -FROM nmrm_car_model -WHERE car_model_id IN ('000001', '000002', '000003', '000005'); diff --git a/stored/ensyu04.sql b/stored/ensyu04.sql deleted file mode 100644 index 4a9ce0a..0000000 --- a/stored/ensyu04.sql +++ /dev/null @@ -1,11 +0,0 @@ -SELECT - t1.contract_no, - t2.contract_detail_no, - t1.car_management_no, - t1.member_id -FROM nmrt_contract t1 -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t2.contract_no) -WHERE t1.ins_date >= CONVERT(DATETIME, '2018/05/09 15:00:00', 120) - AND t1.ins_date <= CONVERT(DATETIME, '2018/05/09 18:00:00', 120) - AND t1.total_price > 10000 / 1.08; diff --git a/stored/ensyu05.sql b/stored/ensyu05.sql deleted file mode 100644 index 14c2b57..0000000 --- a/stored/ensyu05.sql +++ /dev/null @@ -1,10 +0,0 @@ -SELECT - m1.car_management_no, - t1.contract_no, - t2.contract_detail_no, - (SELECT shop_name FROM nmrm_shop m2 WHERE m1.shop_id = m2.shop_id AND m2.shop_name LIKE '�L%') -FROM nmrm_rent_car m1 -INNER JOIN nmrt_contract t1 - ON (m1.car_management_no = t1.car_management_no) -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t1.contract_no); diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/stored/ensyu02.sql b/stored/ensyu02.sql deleted file mode 100644 index 5bb3054..0000000 --- a/stored/ensyu02.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX nmrt_contract_detail_idx_01 ON nmrt_contract_detail(contract_no); diff --git a/stored/ensyu03.sql b/stored/ensyu03.sql deleted file mode 100644 index e5e5e14..0000000 --- a/stored/ensyu03.sql +++ /dev/null @@ -1,3 +0,0 @@ -SELECT * -FROM nmrm_car_model -WHERE car_model_id IN ('000001', '000002', '000003', '000005'); diff --git a/stored/ensyu04.sql b/stored/ensyu04.sql deleted file mode 100644 index 4a9ce0a..0000000 --- a/stored/ensyu04.sql +++ /dev/null @@ -1,11 +0,0 @@ -SELECT - t1.contract_no, - t2.contract_detail_no, - t1.car_management_no, - t1.member_id -FROM nmrt_contract t1 -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t2.contract_no) -WHERE t1.ins_date >= CONVERT(DATETIME, '2018/05/09 15:00:00', 120) - AND t1.ins_date <= CONVERT(DATETIME, '2018/05/09 18:00:00', 120) - AND t1.total_price > 10000 / 1.08; diff --git a/stored/ensyu05.sql b/stored/ensyu05.sql deleted file mode 100644 index 14c2b57..0000000 --- a/stored/ensyu05.sql +++ /dev/null @@ -1,10 +0,0 @@ -SELECT - m1.car_management_no, - t1.contract_no, - t2.contract_detail_no, - (SELECT shop_name FROM nmrm_shop m2 WHERE m1.shop_id = m2.shop_id AND m2.shop_name LIKE '�L%') -FROM nmrm_rent_car m1 -INNER JOIN nmrt_contract t1 - ON (m1.car_management_no = t1.car_management_no) -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t1.contract_no); diff --git a/stored/ensyu06.sql b/stored/ensyu06.sql deleted file mode 100644 index dfbbfbc..0000000 --- a/stored/ensyu06.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE PROCEDURE change_car_model_name(@before_name VARCHAR(32), @after_name VARCHAR(32)) -AS -BEGIN - UPDATE nmrm_car_model - SET car_model_name = @after_name - WHERE car_model_name = @before_name; -END; diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/stored/ensyu02.sql b/stored/ensyu02.sql deleted file mode 100644 index 5bb3054..0000000 --- a/stored/ensyu02.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX nmrt_contract_detail_idx_01 ON nmrt_contract_detail(contract_no); diff --git a/stored/ensyu03.sql b/stored/ensyu03.sql deleted file mode 100644 index e5e5e14..0000000 --- a/stored/ensyu03.sql +++ /dev/null @@ -1,3 +0,0 @@ -SELECT * -FROM nmrm_car_model -WHERE car_model_id IN ('000001', '000002', '000003', '000005'); diff --git a/stored/ensyu04.sql b/stored/ensyu04.sql deleted file mode 100644 index 4a9ce0a..0000000 --- a/stored/ensyu04.sql +++ /dev/null @@ -1,11 +0,0 @@ -SELECT - t1.contract_no, - t2.contract_detail_no, - t1.car_management_no, - t1.member_id -FROM nmrt_contract t1 -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t2.contract_no) -WHERE t1.ins_date >= CONVERT(DATETIME, '2018/05/09 15:00:00', 120) - AND t1.ins_date <= CONVERT(DATETIME, '2018/05/09 18:00:00', 120) - AND t1.total_price > 10000 / 1.08; diff --git a/stored/ensyu05.sql b/stored/ensyu05.sql deleted file mode 100644 index 14c2b57..0000000 --- a/stored/ensyu05.sql +++ /dev/null @@ -1,10 +0,0 @@ -SELECT - m1.car_management_no, - t1.contract_no, - t2.contract_detail_no, - (SELECT shop_name FROM nmrm_shop m2 WHERE m1.shop_id = m2.shop_id AND m2.shop_name LIKE '�L%') -FROM nmrm_rent_car m1 -INNER JOIN nmrt_contract t1 - ON (m1.car_management_no = t1.car_management_no) -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t1.contract_no); diff --git a/stored/ensyu06.sql b/stored/ensyu06.sql deleted file mode 100644 index dfbbfbc..0000000 --- a/stored/ensyu06.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE PROCEDURE change_car_model_name(@before_name VARCHAR(32), @after_name VARCHAR(32)) -AS -BEGIN - UPDATE nmrm_car_model - SET car_model_name = @after_name - WHERE car_model_name = @before_name; -END; diff --git a/stored/ensyu07.sql b/stored/ensyu07.sql deleted file mode 100644 index 791f05e..0000000 --- a/stored/ensyu07.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE PROCEDURE delete_car_model(@del_car_model_name VARCHAR(32)) -AS -BEGIN - DELETE FROM nmrm_car_model - WHERE car_model_name = @del_car_model_name; -END; diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/stored/ensyu02.sql b/stored/ensyu02.sql deleted file mode 100644 index 5bb3054..0000000 --- a/stored/ensyu02.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX nmrt_contract_detail_idx_01 ON nmrt_contract_detail(contract_no); diff --git a/stored/ensyu03.sql b/stored/ensyu03.sql deleted file mode 100644 index e5e5e14..0000000 --- a/stored/ensyu03.sql +++ /dev/null @@ -1,3 +0,0 @@ -SELECT * -FROM nmrm_car_model -WHERE car_model_id IN ('000001', '000002', '000003', '000005'); diff --git a/stored/ensyu04.sql b/stored/ensyu04.sql deleted file mode 100644 index 4a9ce0a..0000000 --- a/stored/ensyu04.sql +++ /dev/null @@ -1,11 +0,0 @@ -SELECT - t1.contract_no, - t2.contract_detail_no, - t1.car_management_no, - t1.member_id -FROM nmrt_contract t1 -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t2.contract_no) -WHERE t1.ins_date >= CONVERT(DATETIME, '2018/05/09 15:00:00', 120) - AND t1.ins_date <= CONVERT(DATETIME, '2018/05/09 18:00:00', 120) - AND t1.total_price > 10000 / 1.08; diff --git a/stored/ensyu05.sql b/stored/ensyu05.sql deleted file mode 100644 index 14c2b57..0000000 --- a/stored/ensyu05.sql +++ /dev/null @@ -1,10 +0,0 @@ -SELECT - m1.car_management_no, - t1.contract_no, - t2.contract_detail_no, - (SELECT shop_name FROM nmrm_shop m2 WHERE m1.shop_id = m2.shop_id AND m2.shop_name LIKE '�L%') -FROM nmrm_rent_car m1 -INNER JOIN nmrt_contract t1 - ON (m1.car_management_no = t1.car_management_no) -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t1.contract_no); diff --git a/stored/ensyu06.sql b/stored/ensyu06.sql deleted file mode 100644 index dfbbfbc..0000000 --- a/stored/ensyu06.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE PROCEDURE change_car_model_name(@before_name VARCHAR(32), @after_name VARCHAR(32)) -AS -BEGIN - UPDATE nmrm_car_model - SET car_model_name = @after_name - WHERE car_model_name = @before_name; -END; diff --git a/stored/ensyu07.sql b/stored/ensyu07.sql deleted file mode 100644 index 791f05e..0000000 --- a/stored/ensyu07.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE PROCEDURE delete_car_model(@del_car_model_name VARCHAR(32)) -AS -BEGIN - DELETE FROM nmrm_car_model - WHERE car_model_name = @del_car_model_name; -END; diff --git a/stored/ensyu08.sql b/stored/ensyu08.sql deleted file mode 100644 index 113a919..0000000 --- a/stored/ensyu08.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE PROCEDURE plus(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - SET @ans = @num1 + @num2; -END; diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/stored/ensyu02.sql b/stored/ensyu02.sql deleted file mode 100644 index 5bb3054..0000000 --- a/stored/ensyu02.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX nmrt_contract_detail_idx_01 ON nmrt_contract_detail(contract_no); diff --git a/stored/ensyu03.sql b/stored/ensyu03.sql deleted file mode 100644 index e5e5e14..0000000 --- a/stored/ensyu03.sql +++ /dev/null @@ -1,3 +0,0 @@ -SELECT * -FROM nmrm_car_model -WHERE car_model_id IN ('000001', '000002', '000003', '000005'); diff --git a/stored/ensyu04.sql b/stored/ensyu04.sql deleted file mode 100644 index 4a9ce0a..0000000 --- a/stored/ensyu04.sql +++ /dev/null @@ -1,11 +0,0 @@ -SELECT - t1.contract_no, - t2.contract_detail_no, - t1.car_management_no, - t1.member_id -FROM nmrt_contract t1 -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t2.contract_no) -WHERE t1.ins_date >= CONVERT(DATETIME, '2018/05/09 15:00:00', 120) - AND t1.ins_date <= CONVERT(DATETIME, '2018/05/09 18:00:00', 120) - AND t1.total_price > 10000 / 1.08; diff --git a/stored/ensyu05.sql b/stored/ensyu05.sql deleted file mode 100644 index 14c2b57..0000000 --- a/stored/ensyu05.sql +++ /dev/null @@ -1,10 +0,0 @@ -SELECT - m1.car_management_no, - t1.contract_no, - t2.contract_detail_no, - (SELECT shop_name FROM nmrm_shop m2 WHERE m1.shop_id = m2.shop_id AND m2.shop_name LIKE '�L%') -FROM nmrm_rent_car m1 -INNER JOIN nmrt_contract t1 - ON (m1.car_management_no = t1.car_management_no) -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t1.contract_no); diff --git a/stored/ensyu06.sql b/stored/ensyu06.sql deleted file mode 100644 index dfbbfbc..0000000 --- a/stored/ensyu06.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE PROCEDURE change_car_model_name(@before_name VARCHAR(32), @after_name VARCHAR(32)) -AS -BEGIN - UPDATE nmrm_car_model - SET car_model_name = @after_name - WHERE car_model_name = @before_name; -END; diff --git a/stored/ensyu07.sql b/stored/ensyu07.sql deleted file mode 100644 index 791f05e..0000000 --- a/stored/ensyu07.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE PROCEDURE delete_car_model(@del_car_model_name VARCHAR(32)) -AS -BEGIN - DELETE FROM nmrm_car_model - WHERE car_model_name = @del_car_model_name; -END; diff --git a/stored/ensyu08.sql b/stored/ensyu08.sql deleted file mode 100644 index 113a919..0000000 --- a/stored/ensyu08.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE PROCEDURE plus(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - SET @ans = @num1 + @num2; -END; diff --git a/stored/ensyu09.sql b/stored/ensyu09.sql deleted file mode 100644 index 265b94d..0000000 --- a/stored/ensyu09.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE PROCEDURE multiple(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - DECLARE @cnt INT; - - SET @ans = 0; - SET @cnt = 0; - - WHILE @cnt < @num2 - BEGIN - EXECUTE plus @ans, @num1, @ans OUTPUT; - SET @cnt = @cnt + 1; - END -END; diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/stored/ensyu02.sql b/stored/ensyu02.sql deleted file mode 100644 index 5bb3054..0000000 --- a/stored/ensyu02.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX nmrt_contract_detail_idx_01 ON nmrt_contract_detail(contract_no); diff --git a/stored/ensyu03.sql b/stored/ensyu03.sql deleted file mode 100644 index e5e5e14..0000000 --- a/stored/ensyu03.sql +++ /dev/null @@ -1,3 +0,0 @@ -SELECT * -FROM nmrm_car_model -WHERE car_model_id IN ('000001', '000002', '000003', '000005'); diff --git a/stored/ensyu04.sql b/stored/ensyu04.sql deleted file mode 100644 index 4a9ce0a..0000000 --- a/stored/ensyu04.sql +++ /dev/null @@ -1,11 +0,0 @@ -SELECT - t1.contract_no, - t2.contract_detail_no, - t1.car_management_no, - t1.member_id -FROM nmrt_contract t1 -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t2.contract_no) -WHERE t1.ins_date >= CONVERT(DATETIME, '2018/05/09 15:00:00', 120) - AND t1.ins_date <= CONVERT(DATETIME, '2018/05/09 18:00:00', 120) - AND t1.total_price > 10000 / 1.08; diff --git a/stored/ensyu05.sql b/stored/ensyu05.sql deleted file mode 100644 index 14c2b57..0000000 --- a/stored/ensyu05.sql +++ /dev/null @@ -1,10 +0,0 @@ -SELECT - m1.car_management_no, - t1.contract_no, - t2.contract_detail_no, - (SELECT shop_name FROM nmrm_shop m2 WHERE m1.shop_id = m2.shop_id AND m2.shop_name LIKE '�L%') -FROM nmrm_rent_car m1 -INNER JOIN nmrt_contract t1 - ON (m1.car_management_no = t1.car_management_no) -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t1.contract_no); diff --git a/stored/ensyu06.sql b/stored/ensyu06.sql deleted file mode 100644 index dfbbfbc..0000000 --- a/stored/ensyu06.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE PROCEDURE change_car_model_name(@before_name VARCHAR(32), @after_name VARCHAR(32)) -AS -BEGIN - UPDATE nmrm_car_model - SET car_model_name = @after_name - WHERE car_model_name = @before_name; -END; diff --git a/stored/ensyu07.sql b/stored/ensyu07.sql deleted file mode 100644 index 791f05e..0000000 --- a/stored/ensyu07.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE PROCEDURE delete_car_model(@del_car_model_name VARCHAR(32)) -AS -BEGIN - DELETE FROM nmrm_car_model - WHERE car_model_name = @del_car_model_name; -END; diff --git a/stored/ensyu08.sql b/stored/ensyu08.sql deleted file mode 100644 index 113a919..0000000 --- a/stored/ensyu08.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE PROCEDURE plus(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - SET @ans = @num1 + @num2; -END; diff --git a/stored/ensyu09.sql b/stored/ensyu09.sql deleted file mode 100644 index 265b94d..0000000 --- a/stored/ensyu09.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE PROCEDURE multiple(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - DECLARE @cnt INT; - - SET @ans = 0; - SET @cnt = 0; - - WHILE @cnt < @num2 - BEGIN - EXECUTE plus @ans, @num1, @ans OUTPUT; - SET @cnt = @cnt + 1; - END -END; diff --git a/stored/ensyu10.sql b/stored/ensyu10.sql deleted file mode 100644 index d41611f..0000000 --- a/stored/ensyu10.sql +++ /dev/null @@ -1,51 +0,0 @@ -CREATE PROCEDURE change_navi_and_etc -AS -BEGIN - DECLARE @car_management_no char(6); - DECLARE @car_navigation char(1); - DECLARE @etc char(1); - - DECLARE rentCarList CURSOR FOR - SELECT - car_management_no, - car_navigation, - etc - FROM nmrm_rent_car - WHERE car_navigation = '0' AND etc = '1' - OR car_navigation = '1' AND etc = '0'; - - OPEN rentCarList; - - FETCH NEXT FROM rentCarList - INTO @car_management_no, - @car_navigation, - @etc; - - WHILE @@FETCH_STATUS = 0 - BEGIN - IF @car_navigation = '1' - BEGIN - UPDATE nmrm_rent_car - SET car_navigation = '0', - etc = '1' - WHERE car_management_no = @car_management_no; - END - ELSE - BEGIN - BEGIN - UPDATE nmrm_rent_car - SET car_navigation = '1', - etc = '0' - WHERE car_management_no = @car_management_no; - END - END - - FETCH NEXT FROM rentCarList - INTO @car_management_no, - @car_navigation, - @etc; - END - - CLOSE rentCarList; - DEALLOCATE rentCarList; -END; diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/stored/ensyu02.sql b/stored/ensyu02.sql deleted file mode 100644 index 5bb3054..0000000 --- a/stored/ensyu02.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX nmrt_contract_detail_idx_01 ON nmrt_contract_detail(contract_no); diff --git a/stored/ensyu03.sql b/stored/ensyu03.sql deleted file mode 100644 index e5e5e14..0000000 --- a/stored/ensyu03.sql +++ /dev/null @@ -1,3 +0,0 @@ -SELECT * -FROM nmrm_car_model -WHERE car_model_id IN ('000001', '000002', '000003', '000005'); diff --git a/stored/ensyu04.sql b/stored/ensyu04.sql deleted file mode 100644 index 4a9ce0a..0000000 --- a/stored/ensyu04.sql +++ /dev/null @@ -1,11 +0,0 @@ -SELECT - t1.contract_no, - t2.contract_detail_no, - t1.car_management_no, - t1.member_id -FROM nmrt_contract t1 -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t2.contract_no) -WHERE t1.ins_date >= CONVERT(DATETIME, '2018/05/09 15:00:00', 120) - AND t1.ins_date <= CONVERT(DATETIME, '2018/05/09 18:00:00', 120) - AND t1.total_price > 10000 / 1.08; diff --git a/stored/ensyu05.sql b/stored/ensyu05.sql deleted file mode 100644 index 14c2b57..0000000 --- a/stored/ensyu05.sql +++ /dev/null @@ -1,10 +0,0 @@ -SELECT - m1.car_management_no, - t1.contract_no, - t2.contract_detail_no, - (SELECT shop_name FROM nmrm_shop m2 WHERE m1.shop_id = m2.shop_id AND m2.shop_name LIKE '�L%') -FROM nmrm_rent_car m1 -INNER JOIN nmrt_contract t1 - ON (m1.car_management_no = t1.car_management_no) -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t1.contract_no); diff --git a/stored/ensyu06.sql b/stored/ensyu06.sql deleted file mode 100644 index dfbbfbc..0000000 --- a/stored/ensyu06.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE PROCEDURE change_car_model_name(@before_name VARCHAR(32), @after_name VARCHAR(32)) -AS -BEGIN - UPDATE nmrm_car_model - SET car_model_name = @after_name - WHERE car_model_name = @before_name; -END; diff --git a/stored/ensyu07.sql b/stored/ensyu07.sql deleted file mode 100644 index 791f05e..0000000 --- a/stored/ensyu07.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE PROCEDURE delete_car_model(@del_car_model_name VARCHAR(32)) -AS -BEGIN - DELETE FROM nmrm_car_model - WHERE car_model_name = @del_car_model_name; -END; diff --git a/stored/ensyu08.sql b/stored/ensyu08.sql deleted file mode 100644 index 113a919..0000000 --- a/stored/ensyu08.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE PROCEDURE plus(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - SET @ans = @num1 + @num2; -END; diff --git a/stored/ensyu09.sql b/stored/ensyu09.sql deleted file mode 100644 index 265b94d..0000000 --- a/stored/ensyu09.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE PROCEDURE multiple(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - DECLARE @cnt INT; - - SET @ans = 0; - SET @cnt = 0; - - WHILE @cnt < @num2 - BEGIN - EXECUTE plus @ans, @num1, @ans OUTPUT; - SET @cnt = @cnt + 1; - END -END; diff --git a/stored/ensyu10.sql b/stored/ensyu10.sql deleted file mode 100644 index d41611f..0000000 --- a/stored/ensyu10.sql +++ /dev/null @@ -1,51 +0,0 @@ -CREATE PROCEDURE change_navi_and_etc -AS -BEGIN - DECLARE @car_management_no char(6); - DECLARE @car_navigation char(1); - DECLARE @etc char(1); - - DECLARE rentCarList CURSOR FOR - SELECT - car_management_no, - car_navigation, - etc - FROM nmrm_rent_car - WHERE car_navigation = '0' AND etc = '1' - OR car_navigation = '1' AND etc = '0'; - - OPEN rentCarList; - - FETCH NEXT FROM rentCarList - INTO @car_management_no, - @car_navigation, - @etc; - - WHILE @@FETCH_STATUS = 0 - BEGIN - IF @car_navigation = '1' - BEGIN - UPDATE nmrm_rent_car - SET car_navigation = '0', - etc = '1' - WHERE car_management_no = @car_management_no; - END - ELSE - BEGIN - BEGIN - UPDATE nmrm_rent_car - SET car_navigation = '1', - etc = '0' - WHERE car_management_no = @car_management_no; - END - END - - FETCH NEXT FROM rentCarList - INTO @car_management_no, - @car_navigation, - @etc; - END - - CLOSE rentCarList; - DEALLOCATE rentCarList; -END; diff --git a/stored/ensyu11.sql b/stored/ensyu11.sql deleted file mode 100644 index aa13753..0000000 --- a/stored/ensyu11.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE FUNCTION change_date_yyyymmdd(@date DATE) RETURNS CHAR(8) -AS -BEGIN - RETURN CONVERT(CHAR(8), @date, 112); -END; diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/stored/ensyu02.sql b/stored/ensyu02.sql deleted file mode 100644 index 5bb3054..0000000 --- a/stored/ensyu02.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX nmrt_contract_detail_idx_01 ON nmrt_contract_detail(contract_no); diff --git a/stored/ensyu03.sql b/stored/ensyu03.sql deleted file mode 100644 index e5e5e14..0000000 --- a/stored/ensyu03.sql +++ /dev/null @@ -1,3 +0,0 @@ -SELECT * -FROM nmrm_car_model -WHERE car_model_id IN ('000001', '000002', '000003', '000005'); diff --git a/stored/ensyu04.sql b/stored/ensyu04.sql deleted file mode 100644 index 4a9ce0a..0000000 --- a/stored/ensyu04.sql +++ /dev/null @@ -1,11 +0,0 @@ -SELECT - t1.contract_no, - t2.contract_detail_no, - t1.car_management_no, - t1.member_id -FROM nmrt_contract t1 -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t2.contract_no) -WHERE t1.ins_date >= CONVERT(DATETIME, '2018/05/09 15:00:00', 120) - AND t1.ins_date <= CONVERT(DATETIME, '2018/05/09 18:00:00', 120) - AND t1.total_price > 10000 / 1.08; diff --git a/stored/ensyu05.sql b/stored/ensyu05.sql deleted file mode 100644 index 14c2b57..0000000 --- a/stored/ensyu05.sql +++ /dev/null @@ -1,10 +0,0 @@ -SELECT - m1.car_management_no, - t1.contract_no, - t2.contract_detail_no, - (SELECT shop_name FROM nmrm_shop m2 WHERE m1.shop_id = m2.shop_id AND m2.shop_name LIKE '�L%') -FROM nmrm_rent_car m1 -INNER JOIN nmrt_contract t1 - ON (m1.car_management_no = t1.car_management_no) -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t1.contract_no); diff --git a/stored/ensyu06.sql b/stored/ensyu06.sql deleted file mode 100644 index dfbbfbc..0000000 --- a/stored/ensyu06.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE PROCEDURE change_car_model_name(@before_name VARCHAR(32), @after_name VARCHAR(32)) -AS -BEGIN - UPDATE nmrm_car_model - SET car_model_name = @after_name - WHERE car_model_name = @before_name; -END; diff --git a/stored/ensyu07.sql b/stored/ensyu07.sql deleted file mode 100644 index 791f05e..0000000 --- a/stored/ensyu07.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE PROCEDURE delete_car_model(@del_car_model_name VARCHAR(32)) -AS -BEGIN - DELETE FROM nmrm_car_model - WHERE car_model_name = @del_car_model_name; -END; diff --git a/stored/ensyu08.sql b/stored/ensyu08.sql deleted file mode 100644 index 113a919..0000000 --- a/stored/ensyu08.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE PROCEDURE plus(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - SET @ans = @num1 + @num2; -END; diff --git a/stored/ensyu09.sql b/stored/ensyu09.sql deleted file mode 100644 index 265b94d..0000000 --- a/stored/ensyu09.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE PROCEDURE multiple(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - DECLARE @cnt INT; - - SET @ans = 0; - SET @cnt = 0; - - WHILE @cnt < @num2 - BEGIN - EXECUTE plus @ans, @num1, @ans OUTPUT; - SET @cnt = @cnt + 1; - END -END; diff --git a/stored/ensyu10.sql b/stored/ensyu10.sql deleted file mode 100644 index d41611f..0000000 --- a/stored/ensyu10.sql +++ /dev/null @@ -1,51 +0,0 @@ -CREATE PROCEDURE change_navi_and_etc -AS -BEGIN - DECLARE @car_management_no char(6); - DECLARE @car_navigation char(1); - DECLARE @etc char(1); - - DECLARE rentCarList CURSOR FOR - SELECT - car_management_no, - car_navigation, - etc - FROM nmrm_rent_car - WHERE car_navigation = '0' AND etc = '1' - OR car_navigation = '1' AND etc = '0'; - - OPEN rentCarList; - - FETCH NEXT FROM rentCarList - INTO @car_management_no, - @car_navigation, - @etc; - - WHILE @@FETCH_STATUS = 0 - BEGIN - IF @car_navigation = '1' - BEGIN - UPDATE nmrm_rent_car - SET car_navigation = '0', - etc = '1' - WHERE car_management_no = @car_management_no; - END - ELSE - BEGIN - BEGIN - UPDATE nmrm_rent_car - SET car_navigation = '1', - etc = '0' - WHERE car_management_no = @car_management_no; - END - END - - FETCH NEXT FROM rentCarList - INTO @car_management_no, - @car_navigation, - @etc; - END - - CLOSE rentCarList; - DEALLOCATE rentCarList; -END; diff --git a/stored/ensyu11.sql b/stored/ensyu11.sql deleted file mode 100644 index aa13753..0000000 --- a/stored/ensyu11.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE FUNCTION change_date_yyyymmdd(@date DATE) RETURNS CHAR(8) -AS -BEGIN - RETURN CONVERT(CHAR(8), @date, 112); -END; diff --git a/stored/ensyu12.sql b/stored/ensyu12.sql deleted file mode 100644 index e599459..0000000 --- a/stored/ensyu12.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE FUNCTION change_time_to_minutes(@date TIME) RETURNS INT -AS -BEGIN - DECLARE @HOURS INT; - DECLARE @MINUTES INT; - - SET @HOURS = CONVERT(INT, FORMAT(@date, 'hh')); - SET @MINUTES = CONVERT(INT, FORMAT(@date, 'mm')); - - RETURN @HOURS * 60 + @MINUTES; -END; diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/stored/ensyu02.sql b/stored/ensyu02.sql deleted file mode 100644 index 5bb3054..0000000 --- a/stored/ensyu02.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX nmrt_contract_detail_idx_01 ON nmrt_contract_detail(contract_no); diff --git a/stored/ensyu03.sql b/stored/ensyu03.sql deleted file mode 100644 index e5e5e14..0000000 --- a/stored/ensyu03.sql +++ /dev/null @@ -1,3 +0,0 @@ -SELECT * -FROM nmrm_car_model -WHERE car_model_id IN ('000001', '000002', '000003', '000005'); diff --git a/stored/ensyu04.sql b/stored/ensyu04.sql deleted file mode 100644 index 4a9ce0a..0000000 --- a/stored/ensyu04.sql +++ /dev/null @@ -1,11 +0,0 @@ -SELECT - t1.contract_no, - t2.contract_detail_no, - t1.car_management_no, - t1.member_id -FROM nmrt_contract t1 -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t2.contract_no) -WHERE t1.ins_date >= CONVERT(DATETIME, '2018/05/09 15:00:00', 120) - AND t1.ins_date <= CONVERT(DATETIME, '2018/05/09 18:00:00', 120) - AND t1.total_price > 10000 / 1.08; diff --git a/stored/ensyu05.sql b/stored/ensyu05.sql deleted file mode 100644 index 14c2b57..0000000 --- a/stored/ensyu05.sql +++ /dev/null @@ -1,10 +0,0 @@ -SELECT - m1.car_management_no, - t1.contract_no, - t2.contract_detail_no, - (SELECT shop_name FROM nmrm_shop m2 WHERE m1.shop_id = m2.shop_id AND m2.shop_name LIKE '�L%') -FROM nmrm_rent_car m1 -INNER JOIN nmrt_contract t1 - ON (m1.car_management_no = t1.car_management_no) -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t1.contract_no); diff --git a/stored/ensyu06.sql b/stored/ensyu06.sql deleted file mode 100644 index dfbbfbc..0000000 --- a/stored/ensyu06.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE PROCEDURE change_car_model_name(@before_name VARCHAR(32), @after_name VARCHAR(32)) -AS -BEGIN - UPDATE nmrm_car_model - SET car_model_name = @after_name - WHERE car_model_name = @before_name; -END; diff --git a/stored/ensyu07.sql b/stored/ensyu07.sql deleted file mode 100644 index 791f05e..0000000 --- a/stored/ensyu07.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE PROCEDURE delete_car_model(@del_car_model_name VARCHAR(32)) -AS -BEGIN - DELETE FROM nmrm_car_model - WHERE car_model_name = @del_car_model_name; -END; diff --git a/stored/ensyu08.sql b/stored/ensyu08.sql deleted file mode 100644 index 113a919..0000000 --- a/stored/ensyu08.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE PROCEDURE plus(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - SET @ans = @num1 + @num2; -END; diff --git a/stored/ensyu09.sql b/stored/ensyu09.sql deleted file mode 100644 index 265b94d..0000000 --- a/stored/ensyu09.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE PROCEDURE multiple(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - DECLARE @cnt INT; - - SET @ans = 0; - SET @cnt = 0; - - WHILE @cnt < @num2 - BEGIN - EXECUTE plus @ans, @num1, @ans OUTPUT; - SET @cnt = @cnt + 1; - END -END; diff --git a/stored/ensyu10.sql b/stored/ensyu10.sql deleted file mode 100644 index d41611f..0000000 --- a/stored/ensyu10.sql +++ /dev/null @@ -1,51 +0,0 @@ -CREATE PROCEDURE change_navi_and_etc -AS -BEGIN - DECLARE @car_management_no char(6); - DECLARE @car_navigation char(1); - DECLARE @etc char(1); - - DECLARE rentCarList CURSOR FOR - SELECT - car_management_no, - car_navigation, - etc - FROM nmrm_rent_car - WHERE car_navigation = '0' AND etc = '1' - OR car_navigation = '1' AND etc = '0'; - - OPEN rentCarList; - - FETCH NEXT FROM rentCarList - INTO @car_management_no, - @car_navigation, - @etc; - - WHILE @@FETCH_STATUS = 0 - BEGIN - IF @car_navigation = '1' - BEGIN - UPDATE nmrm_rent_car - SET car_navigation = '0', - etc = '1' - WHERE car_management_no = @car_management_no; - END - ELSE - BEGIN - BEGIN - UPDATE nmrm_rent_car - SET car_navigation = '1', - etc = '0' - WHERE car_management_no = @car_management_no; - END - END - - FETCH NEXT FROM rentCarList - INTO @car_management_no, - @car_navigation, - @etc; - END - - CLOSE rentCarList; - DEALLOCATE rentCarList; -END; diff --git a/stored/ensyu11.sql b/stored/ensyu11.sql deleted file mode 100644 index aa13753..0000000 --- a/stored/ensyu11.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE FUNCTION change_date_yyyymmdd(@date DATE) RETURNS CHAR(8) -AS -BEGIN - RETURN CONVERT(CHAR(8), @date, 112); -END; diff --git a/stored/ensyu12.sql b/stored/ensyu12.sql deleted file mode 100644 index e599459..0000000 --- a/stored/ensyu12.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE FUNCTION change_time_to_minutes(@date TIME) RETURNS INT -AS -BEGIN - DECLARE @HOURS INT; - DECLARE @MINUTES INT; - - SET @HOURS = CONVERT(INT, FORMAT(@date, 'hh')); - SET @MINUTES = CONVERT(INT, FORMAT(@date, 'mm')); - - RETURN @HOURS * 60 + @MINUTES; -END; diff --git a/stored/ensyu13.sql b/stored/ensyu13.sql deleted file mode 100644 index 82d409c..0000000 --- a/stored/ensyu13.sql +++ /dev/null @@ -1,13 +0,0 @@ -CREATE FUNCTION div_time(@time1 CHAR(5), @time2 CHAR(5)) RETURNS INT -AS -BEGIN - DECLARE @timeInt1 INT; - DECLARE @timeInt2 INT; - - SET @timeInt1 = dbo.change_time_to_minutes(CONVERT(TIME, @time1)); - SET @timeInt2 = dbo.change_time_to_minutes(CONVERT(TIME, @time2)); - - RETURN ABS(@timeInt1 - @timeInt2); -END; - -drop function div_time; diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/stored/ensyu02.sql b/stored/ensyu02.sql deleted file mode 100644 index 5bb3054..0000000 --- a/stored/ensyu02.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX nmrt_contract_detail_idx_01 ON nmrt_contract_detail(contract_no); diff --git a/stored/ensyu03.sql b/stored/ensyu03.sql deleted file mode 100644 index e5e5e14..0000000 --- a/stored/ensyu03.sql +++ /dev/null @@ -1,3 +0,0 @@ -SELECT * -FROM nmrm_car_model -WHERE car_model_id IN ('000001', '000002', '000003', '000005'); diff --git a/stored/ensyu04.sql b/stored/ensyu04.sql deleted file mode 100644 index 4a9ce0a..0000000 --- a/stored/ensyu04.sql +++ /dev/null @@ -1,11 +0,0 @@ -SELECT - t1.contract_no, - t2.contract_detail_no, - t1.car_management_no, - t1.member_id -FROM nmrt_contract t1 -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t2.contract_no) -WHERE t1.ins_date >= CONVERT(DATETIME, '2018/05/09 15:00:00', 120) - AND t1.ins_date <= CONVERT(DATETIME, '2018/05/09 18:00:00', 120) - AND t1.total_price > 10000 / 1.08; diff --git a/stored/ensyu05.sql b/stored/ensyu05.sql deleted file mode 100644 index 14c2b57..0000000 --- a/stored/ensyu05.sql +++ /dev/null @@ -1,10 +0,0 @@ -SELECT - m1.car_management_no, - t1.contract_no, - t2.contract_detail_no, - (SELECT shop_name FROM nmrm_shop m2 WHERE m1.shop_id = m2.shop_id AND m2.shop_name LIKE '�L%') -FROM nmrm_rent_car m1 -INNER JOIN nmrt_contract t1 - ON (m1.car_management_no = t1.car_management_no) -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t1.contract_no); diff --git a/stored/ensyu06.sql b/stored/ensyu06.sql deleted file mode 100644 index dfbbfbc..0000000 --- a/stored/ensyu06.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE PROCEDURE change_car_model_name(@before_name VARCHAR(32), @after_name VARCHAR(32)) -AS -BEGIN - UPDATE nmrm_car_model - SET car_model_name = @after_name - WHERE car_model_name = @before_name; -END; diff --git a/stored/ensyu07.sql b/stored/ensyu07.sql deleted file mode 100644 index 791f05e..0000000 --- a/stored/ensyu07.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE PROCEDURE delete_car_model(@del_car_model_name VARCHAR(32)) -AS -BEGIN - DELETE FROM nmrm_car_model - WHERE car_model_name = @del_car_model_name; -END; diff --git a/stored/ensyu08.sql b/stored/ensyu08.sql deleted file mode 100644 index 113a919..0000000 --- a/stored/ensyu08.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE PROCEDURE plus(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - SET @ans = @num1 + @num2; -END; diff --git a/stored/ensyu09.sql b/stored/ensyu09.sql deleted file mode 100644 index 265b94d..0000000 --- a/stored/ensyu09.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE PROCEDURE multiple(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - DECLARE @cnt INT; - - SET @ans = 0; - SET @cnt = 0; - - WHILE @cnt < @num2 - BEGIN - EXECUTE plus @ans, @num1, @ans OUTPUT; - SET @cnt = @cnt + 1; - END -END; diff --git a/stored/ensyu10.sql b/stored/ensyu10.sql deleted file mode 100644 index d41611f..0000000 --- a/stored/ensyu10.sql +++ /dev/null @@ -1,51 +0,0 @@ -CREATE PROCEDURE change_navi_and_etc -AS -BEGIN - DECLARE @car_management_no char(6); - DECLARE @car_navigation char(1); - DECLARE @etc char(1); - - DECLARE rentCarList CURSOR FOR - SELECT - car_management_no, - car_navigation, - etc - FROM nmrm_rent_car - WHERE car_navigation = '0' AND etc = '1' - OR car_navigation = '1' AND etc = '0'; - - OPEN rentCarList; - - FETCH NEXT FROM rentCarList - INTO @car_management_no, - @car_navigation, - @etc; - - WHILE @@FETCH_STATUS = 0 - BEGIN - IF @car_navigation = '1' - BEGIN - UPDATE nmrm_rent_car - SET car_navigation = '0', - etc = '1' - WHERE car_management_no = @car_management_no; - END - ELSE - BEGIN - BEGIN - UPDATE nmrm_rent_car - SET car_navigation = '1', - etc = '0' - WHERE car_management_no = @car_management_no; - END - END - - FETCH NEXT FROM rentCarList - INTO @car_management_no, - @car_navigation, - @etc; - END - - CLOSE rentCarList; - DEALLOCATE rentCarList; -END; diff --git a/stored/ensyu11.sql b/stored/ensyu11.sql deleted file mode 100644 index aa13753..0000000 --- a/stored/ensyu11.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE FUNCTION change_date_yyyymmdd(@date DATE) RETURNS CHAR(8) -AS -BEGIN - RETURN CONVERT(CHAR(8), @date, 112); -END; diff --git a/stored/ensyu12.sql b/stored/ensyu12.sql deleted file mode 100644 index e599459..0000000 --- a/stored/ensyu12.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE FUNCTION change_time_to_minutes(@date TIME) RETURNS INT -AS -BEGIN - DECLARE @HOURS INT; - DECLARE @MINUTES INT; - - SET @HOURS = CONVERT(INT, FORMAT(@date, 'hh')); - SET @MINUTES = CONVERT(INT, FORMAT(@date, 'mm')); - - RETURN @HOURS * 60 + @MINUTES; -END; diff --git a/stored/ensyu13.sql b/stored/ensyu13.sql deleted file mode 100644 index 82d409c..0000000 --- a/stored/ensyu13.sql +++ /dev/null @@ -1,13 +0,0 @@ -CREATE FUNCTION div_time(@time1 CHAR(5), @time2 CHAR(5)) RETURNS INT -AS -BEGIN - DECLARE @timeInt1 INT; - DECLARE @timeInt2 INT; - - SET @timeInt1 = dbo.change_time_to_minutes(CONVERT(TIME, @time1)); - SET @timeInt2 = dbo.change_time_to_minutes(CONVERT(TIME, @time2)); - - RETURN ABS(@timeInt1 - @timeInt2); -END; - -drop function div_time; diff --git a/stored/ensyu14.sql b/stored/ensyu14.sql deleted file mode 100644 index c8eca41..0000000 --- a/stored/ensyu14.sql +++ /dev/null @@ -1,13 +0,0 @@ -CREATE FUNCTION count_car_model(@car_model_name VARCHAR(32)) RETURNS INT -AS -BEGIN - DECLARE @cnt INT; - - SELECT @cnt = COUNT(m1.car_management_no) - FROM nmrm_rent_car m1 - INNER JOIN nmrm_car_model m2 - ON (m1.car_model_id = m2.car_model_id) - WHERE m2.car_model_name = @car_model_name; - - RETURN @cnt; -END; diff --git a/mssql-jdbc-9.4.1.jre8.jar b/mssql-jdbc-9.4.1.jre8.jar new file mode 100644 index 0000000..6ac99e8 --- /dev/null +++ b/mssql-jdbc-9.4.1.jre8.jar Binary files differ diff --git a/stored/ensyu01.sql b/stored/ensyu01.sql deleted file mode 100644 index c6c27ee..0000000 --- a/stored/ensyu01.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT * -FROM nmrm_price_structure -WHERE car_class_id = 'KA-1' - AND price_kbn = '1' - AND option_id = '*' - AND lending_time_kbn = '0001'; diff --git a/stored/ensyu02.sql b/stored/ensyu02.sql deleted file mode 100644 index 5bb3054..0000000 --- a/stored/ensyu02.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX nmrt_contract_detail_idx_01 ON nmrt_contract_detail(contract_no); diff --git a/stored/ensyu03.sql b/stored/ensyu03.sql deleted file mode 100644 index e5e5e14..0000000 --- a/stored/ensyu03.sql +++ /dev/null @@ -1,3 +0,0 @@ -SELECT * -FROM nmrm_car_model -WHERE car_model_id IN ('000001', '000002', '000003', '000005'); diff --git a/stored/ensyu04.sql b/stored/ensyu04.sql deleted file mode 100644 index 4a9ce0a..0000000 --- a/stored/ensyu04.sql +++ /dev/null @@ -1,11 +0,0 @@ -SELECT - t1.contract_no, - t2.contract_detail_no, - t1.car_management_no, - t1.member_id -FROM nmrt_contract t1 -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t2.contract_no) -WHERE t1.ins_date >= CONVERT(DATETIME, '2018/05/09 15:00:00', 120) - AND t1.ins_date <= CONVERT(DATETIME, '2018/05/09 18:00:00', 120) - AND t1.total_price > 10000 / 1.08; diff --git a/stored/ensyu05.sql b/stored/ensyu05.sql deleted file mode 100644 index 14c2b57..0000000 --- a/stored/ensyu05.sql +++ /dev/null @@ -1,10 +0,0 @@ -SELECT - m1.car_management_no, - t1.contract_no, - t2.contract_detail_no, - (SELECT shop_name FROM nmrm_shop m2 WHERE m1.shop_id = m2.shop_id AND m2.shop_name LIKE '�L%') -FROM nmrm_rent_car m1 -INNER JOIN nmrt_contract t1 - ON (m1.car_management_no = t1.car_management_no) -INNER JOIN nmrt_contract_detail t2 - ON (t1.contract_no = t1.contract_no); diff --git a/stored/ensyu06.sql b/stored/ensyu06.sql deleted file mode 100644 index dfbbfbc..0000000 --- a/stored/ensyu06.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE PROCEDURE change_car_model_name(@before_name VARCHAR(32), @after_name VARCHAR(32)) -AS -BEGIN - UPDATE nmrm_car_model - SET car_model_name = @after_name - WHERE car_model_name = @before_name; -END; diff --git a/stored/ensyu07.sql b/stored/ensyu07.sql deleted file mode 100644 index 791f05e..0000000 --- a/stored/ensyu07.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE PROCEDURE delete_car_model(@del_car_model_name VARCHAR(32)) -AS -BEGIN - DELETE FROM nmrm_car_model - WHERE car_model_name = @del_car_model_name; -END; diff --git a/stored/ensyu08.sql b/stored/ensyu08.sql deleted file mode 100644 index 113a919..0000000 --- a/stored/ensyu08.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE PROCEDURE plus(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - SET @ans = @num1 + @num2; -END; diff --git a/stored/ensyu09.sql b/stored/ensyu09.sql deleted file mode 100644 index 265b94d..0000000 --- a/stored/ensyu09.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE PROCEDURE multiple(@num1 INT, @num2 INT, @ans INT OUTPUT) -AS -BEGIN - DECLARE @cnt INT; - - SET @ans = 0; - SET @cnt = 0; - - WHILE @cnt < @num2 - BEGIN - EXECUTE plus @ans, @num1, @ans OUTPUT; - SET @cnt = @cnt + 1; - END -END; diff --git a/stored/ensyu10.sql b/stored/ensyu10.sql deleted file mode 100644 index d41611f..0000000 --- a/stored/ensyu10.sql +++ /dev/null @@ -1,51 +0,0 @@ -CREATE PROCEDURE change_navi_and_etc -AS -BEGIN - DECLARE @car_management_no char(6); - DECLARE @car_navigation char(1); - DECLARE @etc char(1); - - DECLARE rentCarList CURSOR FOR - SELECT - car_management_no, - car_navigation, - etc - FROM nmrm_rent_car - WHERE car_navigation = '0' AND etc = '1' - OR car_navigation = '1' AND etc = '0'; - - OPEN rentCarList; - - FETCH NEXT FROM rentCarList - INTO @car_management_no, - @car_navigation, - @etc; - - WHILE @@FETCH_STATUS = 0 - BEGIN - IF @car_navigation = '1' - BEGIN - UPDATE nmrm_rent_car - SET car_navigation = '0', - etc = '1' - WHERE car_management_no = @car_management_no; - END - ELSE - BEGIN - BEGIN - UPDATE nmrm_rent_car - SET car_navigation = '1', - etc = '0' - WHERE car_management_no = @car_management_no; - END - END - - FETCH NEXT FROM rentCarList - INTO @car_management_no, - @car_navigation, - @etc; - END - - CLOSE rentCarList; - DEALLOCATE rentCarList; -END; diff --git a/stored/ensyu11.sql b/stored/ensyu11.sql deleted file mode 100644 index aa13753..0000000 --- a/stored/ensyu11.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE FUNCTION change_date_yyyymmdd(@date DATE) RETURNS CHAR(8) -AS -BEGIN - RETURN CONVERT(CHAR(8), @date, 112); -END; diff --git a/stored/ensyu12.sql b/stored/ensyu12.sql deleted file mode 100644 index e599459..0000000 --- a/stored/ensyu12.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE FUNCTION change_time_to_minutes(@date TIME) RETURNS INT -AS -BEGIN - DECLARE @HOURS INT; - DECLARE @MINUTES INT; - - SET @HOURS = CONVERT(INT, FORMAT(@date, 'hh')); - SET @MINUTES = CONVERT(INT, FORMAT(@date, 'mm')); - - RETURN @HOURS * 60 + @MINUTES; -END; diff --git a/stored/ensyu13.sql b/stored/ensyu13.sql deleted file mode 100644 index 82d409c..0000000 --- a/stored/ensyu13.sql +++ /dev/null @@ -1,13 +0,0 @@ -CREATE FUNCTION div_time(@time1 CHAR(5), @time2 CHAR(5)) RETURNS INT -AS -BEGIN - DECLARE @timeInt1 INT; - DECLARE @timeInt2 INT; - - SET @timeInt1 = dbo.change_time_to_minutes(CONVERT(TIME, @time1)); - SET @timeInt2 = dbo.change_time_to_minutes(CONVERT(TIME, @time2)); - - RETURN ABS(@timeInt1 - @timeInt2); -END; - -drop function div_time; diff --git a/stored/ensyu14.sql b/stored/ensyu14.sql deleted file mode 100644 index c8eca41..0000000 --- a/stored/ensyu14.sql +++ /dev/null @@ -1,13 +0,0 @@ -CREATE FUNCTION count_car_model(@car_model_name VARCHAR(32)) RETURNS INT -AS -BEGIN - DECLARE @cnt INT; - - SELECT @cnt = COUNT(m1.car_management_no) - FROM nmrm_rent_car m1 - INNER JOIN nmrm_car_model m2 - ON (m1.car_model_id = m2.car_model_id) - WHERE m2.car_model_name = @car_model_name; - - RETURN @cnt; -END; diff --git a/stored/ensyu15.sql b/stored/ensyu15.sql deleted file mode 100644 index 5b6eb3d..0000000 --- a/stored/ensyu15.sql +++ /dev/null @@ -1,56 +0,0 @@ -CREATE FUNCTION remove_equipment() -RETURNS @equipment_table TABLE ( - car_navigation_cnt INT NOT NULL, - etc_cnt INT NOT NULL -) -AS -BEGIN - DECLARE @get_car_navigation_cnt INT; - DECLARE @set_car_navigation_cnt INT; - DECLARE @remainder_car_navigation_cnt INT; - DECLARE @get_etc_cnt INT; - DECLARE @set_etc_cnt INT; - DECLARE @remainder_etc_cnt INT; - - -- ���O���J�[�i�r�̑䐔 - SELECT @get_car_navigation_cnt = COUNT(car_management_no) - FROM nmrm_rent_car - WHERE smoking_kbn = '1' - AND car_navigation = '1'; - - -- �J�[�i�r�̎��t���ΏۂƂȂ�Ԃ̑䐔 - SELECT @set_car_navigation_cnt = COUNT(car_management_no) - FROM nmrm_rent_car - WHERE smoking_kbn = '2' - AND car_navigation = '0'; - - -- �J�[�i�r���i���ҁ��։��ԂɈڂ������̃J�[�i�r�̎c�� - SET @remainder_car_navigation_cnt = @get_car_navigation_cnt - @set_car_navigation_cnt; - IF @remainder_car_navigation_cnt < 0 - BEGIN - SET @remainder_car_navigation_cnt = 0; - END - - -- ���O��ETC�̑䐔 - SELECT @get_etc_cnt = COUNT(car_management_no) - FROM nmrm_rent_car - WHERE smoking_kbn = '1' - AND etc = '1'; - - -- ETC�̎��t���ΏۂƂȂ�Ԃ̑䐔 - SELECT @set_etc_cnt = COUNT(car_management_no) - FROM nmrm_rent_car - WHERE smoking_kbn = '2' - AND etc = '0'; - - -- ETC���i���ҁ��։��ԂɈڂ�������ETC�̎c�� - SET @remainder_etc_cnt = @get_etc_cnt - @set_etc_cnt; - IF @remainder_etc_cnt < 0 - BEGIN - SET @remainder_etc_cnt = 0; - END - - INSERT INTO @equipment_table VALUES(@remainder_car_navigation_cnt, @remainder_etc_cnt); - - RETURN; -END;