๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

๊ฐœ๋ฐœ ์ด์•ผ๊ธฐ/์ˆ˜์—… ๋‚ด์šฉ ์ •๋ฆฌ4

jsp ์˜ jdbc - java์™€ DB ์—ฐ๋™ JDBC(Java Database Connectivity)๋Š” Java์—์„œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ์ ‘๊ทผํ•˜๊ธฐ ์œ„ํ•œ API(Application Programming Interface)์ž…๋‹ˆ๋‹ค. ์ด API๋Š” SQL๊ณผ DBMS์— ๋Œ€ํ•œ Java์˜ ํ‘œ์ค€ SQL ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์•ก์„ธ์Šค๋ฅผ ์ œ๊ณตํ•ฉ๋‹ˆ๋‹ค. JDBC๋Š” DBMS ์ข…๋ฅ˜์— ๊ด€๊ณ„ ์—†์ด ๋™์ผํ•œ ์ฝ”๋“œ๋กœ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ๋‹ค๋ฃจ๋Š” ๊ฒƒ์„ ๊ฐ€๋Šฅํ•˜๊ฒŒ ํ•˜๊ธฐ ์œ„ํ•ด, DBMS ์—ฐ๊ฒฐ์„ ์œ„ํ•œ ๋“œ๋ผ์ด๋ฒ„๋ฅผ ์ œ๊ณตํ•ฉ๋‹ˆ๋‹ค. ์ด ๋“œ๋ผ์ด๋ฒ„๋Š” ๊ฐ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋ฒค๋”๊ฐ€ ์ œ๊ณตํ•˜๋ฉฐ, ์‚ฌ์šฉ์ž๋Š” ์ด ๋“œ๋ผ์ด๋ฒ„๋ฅผ ์ด์šฉํ•ด ํ•ด๋‹น DBMS์™€ ์—ฐ๊ฒฐํ•˜๊ณ  ๋ฐ์ดํ„ฐ๋ฅผ CRUD(Create, Read, Update, Delete) ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๋“œ๋ผ์ด๋ฒ„ ๋กœ๋“œ: Class.forName() ๋ฉ”์†Œ๋“œ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ JDBC ๋“œ๋ผ์ด๋ฒ„๋ฅผ ๋กœ๋“œํ•ฉ๋‹ˆ๋‹ค. ๋ฐ์ดํ„ฐ.. 2023. 7. 31.
Java - jsp๋กœ ๋‹ค๋ฅธ ํด๋ž˜์Šค import ํ•˜๊ธฐ ์‘์šฉํ•ด์„œ ๋งŒ๋“  ๋‘ ์ˆ˜์˜ ํ•ฉ์„ ๊ตฌํ•˜๋Š” ํŽ˜์ด์ง€ ์ฝ”๋“œ ์ž…๋ ฅ ํŽ˜์ด์ง€ jsp ๋‘ ์ˆ˜๋ฅผ ์ž…๋ ฅํ•˜์„ธ์š”. ์ˆซ์ž 1 : ์ˆซ์ž 2 : java class package kr.or.ksmart; public class Cal { public int sum(int one, int two) { System.out.println(one+" 2023. 7. 27.
jsp post,GET ๋ฐฉ์‹์œผ๋กœ ๊ฐ’ ๊ฐ€์ ธ์˜ค๊ธฐ client code ํšŒ์›๊ฐ€์ž… ํ™”๋ฉด ์•„์ด๋””: ๋น„๋ฐ€๋ฒˆํ˜ธ: ๊ถŒํ•œ: ์ด๋ฆ„: ์ด๋ฉ”์ผ: java code (post) java code (get) get ๋ฐฉ์‹ ์š”์ฒญ (ํด๋ฆญํ•˜์„ธ์š”) // getParameter ์ธ์ˆ˜๊ฐ’๊ณผ input name ์†์„ฑ๊ฐ’์ด ์ผ์น˜ํ•˜๊ฒŒ ์ž‘์„ฑ String userId = request.getParameter("userId"); String userPw = request.getParameter("userPw"); String userLevel = request.getParameter("userLevel"); String userName = request.getParameter("userName"); String userMail = request.getParameter("userMail"); /* g.. 2023. 7. 26.
Java - setting, getting ์ˆ˜์—… ๋‚ด์šฉ ์ •๋ฆฌ 0. ์™„์„ฑ ์ฝ”๋“œ package kr.or.ksmart.a; // ํšŒ์› ๊ด€๋ฆฌ ํด๋ž˜์Šค ์ตœ์ข… public class User { // ์ „์—ญ ๋ณ€์ˆ˜ (global variable = ํ•„๋“œ (Field) // class block (body) ์•ˆ์ชฝ๊ณผ method block(body) ๋ฐ–์— ์„ ์–ธ๋œ ๋ณ€์ˆ˜ // ์œ ์‚ฌ์šฉ์–ด : ํ”„๋กœํผํ‹ฐ (property) // private = ํด๋ž˜์Šค ๋‚ด์—์„œ๋งŒ ์ ‘๊ทผ ๊ฐ€๋Šฅํ•œ ์ ‘๊ทผ ์ œ์–ด์ž private String uid; private String upw; private String uphone; private char ugender; private int uage; private String ulevel; // 1. uid ์ „์—ญ๋ณ€์ˆ˜์— ๊ฐ’์„ ์…‹ํŒ…ํ•˜๋Š” ๋ฉ”์„œ๋“œ ์„ ์–ธ public void setU.. 2023. 7. 11.