JDBC stands for Java Database Connectivity!
Java JDBC Tutorial
JDBC stands for Java Database Connectivity. JDBC is a Java API to connect and executes the query with the database. It is a part of JavaSE (Java Standard Edition).
JDBC API uses JDBC drivers to connect with the database.
JDBC ๋ ์๋ฐ์ ๋ฐ์ดํฐ๋ฒ ์ด์ค ์ฐ๊ฒฐ์ ์๋ฏธํ๋ค. ๋ค์ ๋งํด JDBC ๋ ๋ฐ์ดํฐ๋ฒ ์ด์ค์ ์ฟผ๋ฆฌ์ ๊ด๋ จ๋ ์ ๋ฌด๋ฅผ ์คํํ ์ ์๋ API ๋ผ๊ณ ์ผ์ปฌ์ ์ ์์ ๊ฒ์ด๋ค. JAVA API ๋ JDBC ๋ฅผ ์ฌ์ฉํด ๋ฐ์ดํฐ ๋ฒ ์ด์ค์ ์ฐ๊ฒฐ ํ ์ ์๋ค.
To explain tactics way, we can bring two different examples.
The first example is communicating and executing between the front end & back end based on the data collected by only two of the system. However, the second photo (below) can show the different data flow by adding of JDBC.
์กฐ๊ธ ๋ ์ฌ์ด ์ค๋ช ์ ์ํด ๋๊ฐ์ง ์์ ๋ฅผ ๋ค ์ ์์ ๊ฒ์ด๋ค. ์ฒซ๋ฒ์งธ ์์ ๋ ์ค์ง ํ๋ก ํธ, ๋ฐฑ์ค๋ ์์คํ ์์์ ์ทจํฉ๋ ๋ฐ์ดํฐ ๋ฒ ์ด์ค๋ก ์์คํ ์ด ์ด์๋๊ณ ์๋ค. ๋ฐ๋ฉด JDBC ๋ฅผ ์ถ๊ฐํจ์ผ๋ก์ ๋ค๋ฅธ ๋ฐ์ดํฐ ํ๋ก์ฐ๋ฅผ ์ค๋ช ํ ์๋ค.
<Applied JDBC can help login process smoothly between front/backend side and deliver directly the data from a database of the oracle>
JDBC ๊ฐ ์ ์ฉ๋ ํํ๋ ์ค๋ผํด๋ก๋ถํฐ ํธ์ถ ๋ ๋ฐ์ดํฐ๋ฅผ ์ง์ ํธ์ถ ํด ํ๋ก ํธ, ๋ฐฑ์ค๋ ์ฌ์ด์ ๋ก๊ทธ์ธ ํ๋ก์ค์ธ์ค๋ฅผ ์กฐ๊ธ๋ ์ํํ๊ฒ ๋์์ค๋ค.
Step 1- DAO) Create a connection on DAO to connect directly database of oracle to Data Assess Object(DAO)
public connection openConnection() {
connection connection = null;}
**catch (ClassNotFoundException e )
even if an exception case happens, coding will keep running.
์์ธ๋ฐฉ์ง ์ฅ์น๋ฅผ ์ถ๊ฐ.
Step 2) Declare DOA as a new object in the Auth to apply JDBC so that brings out the database directly to Auth & Taskmanager
Step 3) Method, convertToBool
A method of converToBool Converts a specified value to an equivalent Boolean value.
The data summoned from the database to DAO is a type of number, we need to convert it into a boolean type (True/False), Method "CovertToBool" will be used for it.
Comments
Post a Comment